Quire Paper / Finance & money math / Loan Amortization Calculator
For Excel & Google Sheets

See exactly what your loan costs — and how to beat it.

Enter five numbers and get your monthly payment, payoff date, and the full month-by-month schedule — plus what an extra $100 a month actually saves you.

Available soon See what's inside
Instant .xlsx downloadWorks in Excel & Google SheetsAny fixed-rate loan
Loan Amortization Calculator cover

Your lender knows these numbers by heart.
Now you do too.

How it works

Five inputs. The whole picture.

No formulas to write, no setup — the workbook is finished. You just type in your loan.

01

Enter your loan

Amount, rate, term, and first payment date — four blue cells. Add an optional extra monthly payment as the fifth.

02

Read your numbers

Monthly payment, total interest, total cost, months to pay off, and your payoff date — computed instantly.

03

See every month

A full amortization schedule: interest, principal, extra, and remaining balance for every single payment.

04

Test extra payments

Type in $50 or $200 extra and watch the interest saved and the years cut off your loan — the schedule reshapes itself.

05

No loose ends

The final payment adjusts itself to land the balance on exactly zero, and the schedule ends where your loan does.

06

Use it forever

Mortgage today, auto loan next year — one file handles any fixed-rate loan up to 40 years. No subscription.

What's inside

One clean workbook, ready to use.

  • Dashboard calculator sheetA clean dark dashboard: input and results cards, a totals ribbon, and a full 480-payment schedule with pinned headers and banded rows.
  • Locked down like softwareOnly the five blue input cells are editable — a stray click can't break a formula. Want to customize? The unlock password is in the guide.
  • Extra-payment savingsDedicated readouts for interest saved and time saved ("6 yr 2 mo") so the trade-off is obvious.
  • Verified math + how-to guideFormulas cross-checked against standard amortization math to the cent, plus a one-page tab with quick-start steps and Google Sheets instructions.
Inside Loan Amortization Calculator
Get it now
$9 · one-time

Loan Amortization Calculator

One workbook for mortgages, auto loans, student loans — any fixed-rate loan. Download once, use it for every loan you ever have.

Available soon
Instant download · Personal-use license · A planning tool, not financial advice — confirm exact figures with your lender.
More from Quire Paper

You might also like