Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesFinanceLoans & Debt ManagementLoan Amortization Schedule

SpreadsheetLoans & Debt ManagementFree

Loan Amortization Schedule

Every payment for the full term, with extra payments, payoff date and the interest you save.

Shown with sample data

Colour

Loan Amortization Schedule

Every payment for the full term, with extra payments, payoff date and the interest you save.

Monthly payment
$1,539
Before any extra payment
Months to payoff
266
With your extra payment
Total interest
$212,319
With your extra payment
Interest saved
$91,827
Compared with no extra payment
Balance over time
1265

Latest: $1,399.67

Interest per payment
1266

Latest: $7.29

How to use it

  1. 1Enter the loan amount, annual rate (as a decimal), term in months and any extra monthly payment on the Loan sheet.
  2. 2Set the first payment date in the first row of the Schedule sheet.
  3. 3Read the key figures: monthly payment, months to payoff, total interest and interest saved.
  4. 4Try different extra payments to see how much sooner you are debt-free.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Enter the loan amount, rate, term and any extra monthly payment. The full 30-year schedule (360 payments) calculates every payment date, the interest and principal split, the remaining balance and the interest paid to date. It stops as soon as the loan is paid off, so you can see exactly how many months and how much interest an extra payment saves. Works for mortgages, car loans, student loans and business loans.

Who it’s for

  • Seeing how much interest you really pay
  • Planning extra payments and an earlier payoff date
  • Comparing loan offers side by side

What’s included

  • Loan sheet: Loan details. Change any value and the schedule recalculates.
  • Schedule sheet: Every payment for the full term. Rows after the payoff date show zero.

How to use it

  1. 1Enter the loan amount, annual rate (as a decimal), term in months and any extra monthly payment on the Loan sheet.
  2. 2Set the first payment date in the first row of the Schedule sheet.
  3. 3Read the key figures: monthly payment, months to payoff, total interest and interest saved.
  4. 4Try different extra payments to see how much sooner you are debt-free.

Tips

  • An extra principal payment early in the loan saves the most interest.
  • Set the extra payment to 0 to see the standard schedule your lender quotes.
  • Rounding means your lender's final payment may differ by a few cents.

Questions

Is this accurate for my mortgage?

It matches standard fixed-rate amortisation. Property tax, insurance and fees collected in an escrow payment are not included.

How do extra payments work here?

The extra amount is added to every payment and goes straight to principal. The schedule stops when the balance reaches zero.

Can I use it for a shorter loan?

Yes. Enter the term in months (60 for a 5-year car loan); rows after the payoff show zero.

Related searchesamortization scheduleloan schedulemortgageinterestextra paymentspayoff date

Details

Format
Spreadsheet
Category
Loans & Debt Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetLoans & Debt ManagementFree

Loan Amortization Schedule

Every payment for the full term, with extra payments, payoff date and the interest you save.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Loans & Debt Management
Sheets
2
Setup
10 min
Level
Intermediate
Price
Free

Your copy is private to you.

More loans & debt management templates

View all
Debt Snowball Payoff Planner3 sheets

Debt-free in

31

Total interest

$3,458

Total debt today

$36,790

Interest paid by debt
$1,728
$782.68
$666.05
$264.03
$16.56
Student loanPersonal loanCar loanVisa cardStore card
SpreadsheetLoans & Debt Management

Debt Snowball Payoff Planner

A month-by-month payoff plan with roll-over payments, your debt-free date and total interest, snowball or avalanche.

10 min setupPreview
Credit Card Payoff Tracker5 sheets

Total card debt

$18,290

Overall utilisation

51%

Interest this month

$303

ABCD
1CardCredit limitBalanceAPR
2Rewards Visa$8,000$4,85024.5%
3Store card$2,500$1,92030%
4Travel Mastercard$12,000$6,30022%
5Balance-transfer card (0% promo)$7,000$3,4000%
Cards
SpreadsheetLoans & Debt Management

Credit Card Payoff Tracker

Every card’s balance, APR and utilisation, the months and interest to pay it off, and what paying only the minimum costs you.

10 min setupPreview
Debt Avalanche Payoff Planner2 sheets

Total debt

$19,950

Interest this month

$262

Total monthly payment

$820

Balance by debt
$7,600
$5,400
$4,200
$1,850
$900
Car financePersonal loanVisaStore cardOverdraft
SpreadsheetLoans & Debt Management

Debt Avalanche Payoff Planner

Rank debts by interest rate, direct your extra payment to the costliest first and see months to clear each one.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ