Loan Calculator Excel Template
Printer friendly Excel Spreadsheet for creating a loan amortization schedule. The calculator accommodates loans with up to 40 years (or 480 monthly payment periods).
Download a Free Loan Calculator Spreadsheet for creating a payment schedule and a table showing the summary of principal and interest payments, with optional extra payments.
How Loan Calculator with Extra Payments Works?
Simply enter:
- Loan Amount
- Annual Interest Rate
- Loan Period in Years
- Number of Payments per Year
- Date
Now you can view total, principal and interest payments. Also you can make extra payments each period.