EMI Calculator in Excel In the current scenario most of the people taking loans. in fact, in the current world, no business can survive without a loan
EMI Calculator in Excel
In the current scenario, most people taking loans. in fact, in the current world, no business can survive without a loan.For taking loans we do many exercises making project reports, 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 for free download.
in this excel file, you just put
- Loan Amount
- Interest Rate
- Loan Period (Year)
- Loan EMI Start Date
- It will give you the EMI amount, Total Interest Amount and total amount paid.
- It will also give a summary of EMI, Interest, Principal and balance year wise
- You can see the Emi Schedule at Emi Schedule Sheet.
Assumptions made in this Utility.
- EMI is due at the start of the Month
- Any lump sum 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
COMMENTS