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:

  1. Loan Amount
  2. Annual Interest Rate
  3. Loan Period in Years
  4. Number of Payments per Year
  5. Date

Now you can view total, principal and interest payments. Also you can make extra payments each period.

Excel Template: Loan Calculator (260 Kb)