In the current scenario most of the people taking loans. in fact, in the current world, no business can survive without a loan. For ta...
In the current scenario most of the people taking loans. in fact, in the current world, no business can survive without a loan.
For taking loan we do many exercises making project report, compiling our ITR returns, property data, financial books, bank statements etc.
In this post, we are giving an easy to use EMI calculator in excel free download.
in this excel file, you just put
- Loan Amount
- Interest Rate
- Loan Period (Year)
- Loan EMI Start Date
- It will give you EMI amount, Total Interest Amount and total amount paid.
- It will also give a summary EMI, Interest, Principal and balance year wise
- You can see the Emi Schedule at Emi Schedule Sheet.
Assumptions made in this Utility.
- EMI due at the starting of the Month
- Any lumpsum Payment in the middle of the loan period is not considered.
- The utility can work for up to 20 years of Period and 12 months in a year