Templates
Finance template · Free

Loan Amortization Schedule

Enter a loan once and get the payment, total interest and a full payment schedule.

Preview of Loan Amortization Schedule

Functions inside

PMTEDATEROUNDSUM

What you get

  • Excel workbook (.xlsx) with an Instructions tab
  • Sample data you can replace
  • Unlocked formulas you can change
  • Upload to Google Drive to use in Google Sheets