loan instalment planner spreadsheet
===================================

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.

WHAT IT IS
Instructions sheet, Planner sheet with PMT formulas, 12-month payment schedule.

HOW TO USE (5 STEPS)
1. Enter the loan amount, annual interest rate and number of months in the yellow input cells.
2. Read the monthly instalment, total paid and total interest, all calculated by formula.
3. Check the schedule sheet for the first 12 months of payments.
4. Change any input to see the instalment update instantly.
5. Use it to compare terms before agreeing to a loan.

REQUIREMENTS
Microsoft Excel, Google Sheets or LibreOffice Calc.

NOTE
No prices and no tiered plans are included. This is a working tool, not a demo.