Home About Us Contact Us Blog
Calculators Mortgage Calculator Compound Interest ROI & Investment Debt Payoff Savings Goal Currency Converter Retirement Planning Net Worth & Wealth Tracker Debt Free Calculator 50/30/20 Budget
Spreadsheet Store 🛒 View All Products Mortgage Amortization & Payoff Planner Compound Interest & Investment Growth Planner ROI & Investment Performance Tracker Debt Freedom & Payoff Planner Savings Goals & Wealth Building Planner Multi-Currency Budget Planner 50/30/20 Budget Planner Debt-Free Journey Planner Net Worth & Wealth Tracker Retirement Wealth Planner
Financial Planning System

Mortgage Amortization & Payoff Planner

Own Your Home Sooner. Pay Less Interest.

A complete planning system that shows you exactly how your mortgage amortizes — and exactly how much extra payments can save you in time and interest.

New
$14.99

One-time payment — lifetime access & updates

Instant download Excel & Google Sheets Works on all devices
Add to Cart ⚡ Buy Now — $14.99 Try the free mortgage calculator →

⭐ Save even more with the bundle

Build your financial toolkit — save up to 40% →
Amortization ScheduleFull month-by-month breakdown for up to 30 years
Principal & InterestExactly how much of each payment goes where
Extra Payment ModellerSee how extra payments cut years off your loan
Running Balance TrackerWatch your remaining balance shrink over time
Interest Saved CalculatorThe exact amount you save by paying extra
Visual Payment ChartsBalance-over-time and interest-vs-principal charts
Smart DashboardKPI cards, 4 interactive charts, FinanceKit Intelligence™ insights and achievement badges
Preview & User GuideA read-only sample filled with illustrative data, plus a step-by-step guide and FAQs
28% Affordability CheckSee whether your payment fits the common guideline of 28% of gross monthly income
  • Full amortization schedule — month-by-month for any loan term up to 30 years
  • Monthly principal & interest breakdown with running balance
  • Extra payment scenario — model an extra monthly payment and see your new payoff date
  • Interest saved & time saved calculator when paying down extra
  • Visual charts — loan balance over time and interest vs principal split
  • Loan comparison — compare two loan scenarios side by side (rate, term or extra payment)
  • Works for any loan amount and interest rate, with loan terms from 1 to 30 years
  • Compatible with Microsoft Excel 2016+ and Google Sheets (free)
  • Works on all devices — open it on your laptop, tablet or phone
  • Instant recalculation — change any input and see results update instantly
  • Smart dashboard — KPI cards, 4 interactive charts, FinanceKit Intelligence™ insights, achievement badges and a detailed summary on one sheet
  • Built-in Preview sheet and user guide — a read-only sample filled with illustrative data, plus a step-by-step guide with FAQs
  • 28% affordability check — compare your monthly payment with the common guideline of 28% of your gross monthly income
  • Instant download — start planning your mortgage payoff today

This spreadsheet is for anyone with a mortgage — or about to take one out — who wants full visibility into how their loan amortizes over time. Whether you're comparing loan offers, deciding if refinancing makes sense, or exploring whether extra payments are worth it, this gives you the exact numbers.

It's especially valuable for homeowners considering bi-weekly or extra monthly payments, anyone comparing 15-year vs 30-year terms, and first-time buyers who want to understand exactly where their monthly payment goes.

Step 1 — Enter Your Loan Details

On the Loan Setup sheet, enter your loan amount (the original principal borrowed), your annual interest rate, your loan term in years (1 to 30) and your start date. The spreadsheet automatically calculates your fixed monthly payment and builds the full amortization schedule from these numbers.

Step 2 — Review Your Amortization Schedule

The schedule breaks down every single payment over the life of the loan — showing exactly how much goes to principal and how much goes to interest each month, along with your running remaining balance. Early in the loan, a larger share of each payment goes toward interest; this shifts toward principal as the balance decreases.

Step 3 — Model an Extra Payment Scenario

Enter an optional extra monthly payment on the Loan Setup sheet. The spreadsheet recalculates your entire payoff timeline instantly, showing your new payoff date, the total interest saved, and how many months or years you cut off the loan.

Step 4 — Compare Visual Charts

On the Dashboard, the loan-balance chart shows how your remaining balance declines over time, and the principal-vs-interest chart shows how much of what you pay each year goes to principal and how much to interest. Use the Loan Comparison sheet to put two loan scenarios side by side.

Step 5 — Decide if Extra Payments Are Worth It

Compare the interest saved from extra payments against what that money could earn if invested elsewhere instead. As a general rule, if your mortgage rate is higher than your expected investment return, paying down the mortgage faster tends to be the more conservative choice — but consider your own risk tolerance, liquidity needs, and tax situation.

Tips for Paying Off Your Mortgage Faster

Even modest extra payments compound meaningfully over a 30-year term because they reduce principal early, which reduces all future interest calculated on that principal. Common strategies include rounding payments up, making one extra payment per year, or switching to bi-weekly payments (which effectively adds one extra monthly payment annually). Use this spreadsheet to test any strategy before committing to it.

What loan terms does this support?

Any term from 1 to 30 years — 10, 15, 20, 30 or a custom number of years. Simply enter your loan amount, rate, and term, and the full schedule recalculates instantly.

Can I model bi-weekly payments?

Bi-weekly payments add up to roughly one extra monthly payment per year. Divide that extra amount by 12 and enter it as the Extra Monthly Payment on the Loan Setup sheet to see the approximate impact on your payoff date and total interest.

Does this work with Google Sheets?

Yes. Upload the .xlsx file to Google Drive and open it with Google Sheets. All formulas, schedules, and charts are fully compatible at no extra cost.

How do I download after purchase?

Payhip sends an instant download link to your email immediately after payment. You can also access all your purchases anytime through your Payhip account at payhip.com.

Featured Products

Discover the latest additions to the FinanceKit collection

Build Your Financial Toolkit

You've taken the first step. Now choose how far you want to go — these planners are built to work together as one homeownership & debt-freedom system.

Ready When You Are.

Every planner and bundle unlocks instantly at checkout — no waiting, no emails to chase. Grab what fits your goals today, add the rest whenever you're ready.

Get Instant Access →

Editor's Picks

Our top picks to start with

Choose Your Financial Goal

These aren't just discounts — they're complete solutions, each built around a real financial outcome.

What Customer's are Saying about Us

Real feedback from people using our spreadsheets every day

The amortization schedule made it so easy to see how extra payments would actually shorten my loan. Worth every cent.

J
Jordan M.
Homeowner

Clean, no-frills spreadsheet that just works. I compared two scenarios before refinancing and it paid for itself instantly.

R
Rachel T.
First-time Buyer

I run a small property management side business and this keeps every mortgage I track perfectly organized in one place.

D
David K.
Landlord

Switched from a clunky bank calculator to this and immediately understood where my payment was actually going each month.

S
Sofia R.
Homeowner

The extra payment modeller convinced my partner and me to round up our payment every month. Small change, big difference long term.

M
Marcus B.
Homeowner

Opened fine in Google Sheets exactly as described, no formula errors. Appreciated not needing Excel for this.

P
Priya N.
Renter, Future Buyer

Bought this alongside the Net Worth & Wealth Tracker and now my whole financial picture lives in two clean sheets instead of scattered notes.

A
Aaron W.
Homeowner

Used this to compare two lender offers side by side. The difference in lifetime interest was eye-opening and easy to show my spouse.

L
Lena F.
Homeowner

Simple, well laid out, no bloated features I'll never touch. Exactly the tool I needed for my first house purchase.

T
Tariq H.
First-time Buyer

Recalculates instantly whenever I tweak the rate or term, which made it so much easier to plan around different offers.

C
Chloe S.
Homeowner

Customer Reviews

Reviews come from verified buyers only, and the ratings on every card update automatically.

Loading reviews…

Write a review

Bought this planner? Use the email from your order so we can verify your purchase.

⚡

Instant Download

Get your spreadsheet immediately after purchase. No waiting — download and start in minutes.

🔒

Secure Payment

All payments processed securely through Payhip. We never store your payment details.

📊

Works Everywhere

All spreadsheets work with Microsoft Excel 2016+ and Google Sheets. No special software required.

📱

Works on All Devices

Open your planner on a laptop, tablet or phone — in Excel or Google Sheets, wherever you are.

♾

Lifetime Access

Buy once, use forever. All future updates are included at no extra cost.

This page is coming soon