Free calculator · for borrowers & businesses

See what a loan really costs — every payment, to the dollar.

Enter your loan amount, rate, and term to get your monthly payment and total interest instantly — then get the full month-by-month amortization schedule with the planner.

Done-for-you template

Loan Amortization Schedule

Every payment, interest, and principal — to full payoff.

  • Full month-by-month schedule: payment, interest, principal, balance
  • Monthly payment, total interest, and total cost computed for you
  • Add an extra monthly payment and see interest and time saved
  • Works for any loan — business, auto, personal, or mortgage
  • Assumptions-driven · Excel & Google Sheets · delivered instantly
$29one-time · instant download
↩ 7-day money-back guarantee

🔒 Secure checkout via Stripe · Excel & Google Sheets · instant delivery.

🔒 Secure checkout by StripeInstant download7-day money-back guaranteeExcel & Google Sheets

Questions

What is an amortization schedule?

An amortization schedule is a table showing every payment on a loan, split into how much goes to interest and how much reduces the principal balance, until the loan reaches zero. Early payments are mostly interest; later ones are mostly principal.

How is the monthly payment calculated?

For a fixed-rate loan the payment is calculated so the balance reaches exactly zero at the end of the term. It uses the loan amount, the monthly interest rate (annual rate divided by 12), and the number of payments. The template does this automatically and shows the full breakdown.

What is in the paid schedule?

A ready-to-use spreadsheet (Excel & Google Sheets): the full amortization table, monthly payment, total interest, and an optional extra-payment column showing interest and time saved — delivered instantly after checkout. AI-assisted, human-built; not financial advice.

More on buying & delivery · refund policy

Related tools

More personal finance tools.

$29 one-time · instant
Get the template