Free Loan Instalment Planner Spreadsheet (Excel)
What this is
An Excel planner that calculates a monthly loan instalment and total interest from the loan amount, rate and term. For freelancers planning equipment or business borrowing.
Free in full — download it and use it on your own freelance work.
User manual
- Enter the loan amount, annual interest rate and number of months in the yellow input cells.
- Read the monthly instalment, total paid and total interest, all calculated by formula.
- Check the schedule sheet for the first 12 months of payments.
- Change any input to see the instalment update instantly.
- Use it to compare terms before agreeing to a loan.
Requirements
Microsoft Excel, Google Sheets or LibreOffice Calc.
Download details
Format: XLSX
What is inside: Instructions sheet, Planner sheet with PMT formulas, 12-month payment schedule.
Download free — loan-instalment-planner.xlsx (6.5 KB)
- README.txt — 876 B
- loan-instalment-planner.xlsx — 6.5 KB
Questions
What formula does it use?
The standard PMT formula: monthly payment from rate, term and loan amount, with interest and principal split in the schedule.
Is this financial advice?
No. It is a planning calculator only. Check the actual terms with your lender.