Loan & EMI Calculator with Repayment Schedule (Excel & Google Sheets)
Work out your monthly loan payment, the total interest, and how much you save by paying a little extra each month.
What's inside:
- Monthly EMI, total interest and total amount paid
- Extra payment option: see months saved and interest saved
- Payoff date
- Full repayment schedule: date, payment, interest, principal and balance
- Balance chart
- Works for loans up to 40 years
Details:
- Standard reducing-balance method with monthly payments; bank figures may differ slightly
- Works in Microsoft Excel and Google Sheets
- Formulas are protected so they can't be broken by accident
Who it's for: business owners and individuals planning a business loan, car loan or home loan.
Licence: for use by one business. Please don't share or resell the file.
Questions? Message me through this shop and I'll help.