Best Value Complete Financial Planning Bundle →
✓ Financial Planning✓ Net Worth Tracker✓ Monthly Budgeting✓ Travel Budget Planner✓ Annual Budgeting Planner✓ Monthly Expense Tracker✓ Annual Tax Planner✓ Retirement Planning
$139 One purchase, no subscription
View Bundle →
by Segmio
View Bundles
Language
ENEnglishDEDeutschESEspañolFRFrançaisPTPortuguêsITItalianoARالعربيةNLNederlandsZH中文
Loan Amortization ›

Instant digital delivery · Terms & Conditions apply

Essentials Template - Excel & Google Sheets

Essentials Loan Amortization Spreadsheet Template for Google Sheets & Excel

Every payment is dated from the first one you set and split into the part reducing the balance and the part going to the lender, with the balance running down row by row. The Essentials Loan Amortization spreadsheet template takes an extra payment column straight off the balance and returns a payoff date rather than a payment number. Three working sheets and two charts, in Google Sheets or Excel. No macros, no VBA.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

View Ultimate Loan Amortization Spreadsheet Template
$29
Essentials Loan Amortization spreadsheet template - Google Sheets and Excel preview

What's Included

  • The full schedule, dated from the first payment you set
  • Each payment split into the part reducing the balance and the part going to the lender
  • An extra payment column, applied directly to the balance
  • The remaining balance running down row by row
  • A payoff date rather than a payment number
  • Interest carried per unit borrowed, for comparing loans of different sizes
  • Two charts - the principal and interest split over time, and the balance coming down
  • A currency dropdown on the Dashboard that relabels money columns across all three sheets
  • Works in Microsoft Excel and Google Sheets with no setup required
Ultimate Version Available

Need more from this template?

The Essentials Spreadsheet Template covers everyday tracking. The Ultimate Spreadsheet Template gives each part of the template its own sheet, with more capacity and deeper reporting on top.

Essentials - $19
  • The full schedule, dated from the first payment you set
  • Each payment split into the part reducing the balance and the part going to the lender
  • An extra payment column, applied directly to the balance
  • The remaining balance running down row by row
Ultimate - $29
  • Two loans carried at once, each with its own full schedule
  • A name for each loan, so the summaries read as your borrowing
  • The combined monthly payment across both
  • A blended rate - the average across the two loans
  • A combined payoff date, when the last of them finishes
See what's in the Ultimate version› One-time purchase. No subscription.

The FinancialAha Essentials Loan Amortization Spreadsheet Template for Google Sheets and Excel is a three-sheet workbook that shows the loan payment by payment, with a How to Use guide on a fourth tab. It works as an Essentials Loan Amortization Excel template and an Essentials Loan Amortization Google Sheets template from the same download. Where the Free build gives the totals, this Essentials Loan Amortization spreadsheet template lays out the schedule itself - every payment dated, split between principal and interest, with the balance running down. No macros, no VBA.

Inside the workbook

What's inside the FinancialAha Essentials Loan Amortization spreadsheet template

The FinancialAha Essentials Loan Amortization Spreadsheet Template runs on three working sheets - one you type into, two that report back - plus the guide. It works in both Microsoft Excel and Google Sheets and here is what the Essentials Loan Amortization spreadsheet holds.

  1. 01 of 03

    Loan Setup

    The sheet you type into, and the only one. The amount, the rate and the term go in, then the date the first payment falls - which is what lets the schedule run in real calendar months rather than numbered ones - and any extra you intend to put toward the principal. A calculated block beneath shows the monthly payment and the totals before you go near the schedule itself.

    FinancialAha Loan Amortization spreadsheet template - Loan Setup sheet

  2. 02 of 03

    Amortization Schedule

    Every payment of the loan, dated, with the scheduled amount split into the part that reduces the balance and the part that goes to the lender, any extra applied on top, and what is left afterwards. This is the table the name promises, and reading down it shows the thing summaries cannot: at the start almost all of a payment is interest, and the crossover to mostly principal arrives well into the term.

    FinancialAha Loan Amortization Google Sheets template - Amortization Schedule sheet

  3. 03 of 03

    Dashboard

    The loan in six figures: what was borrowed, what it costs a month, what the interest comes to, what the whole thing costs, when it finishes, and how much interest each unit borrowed carries. That last figure is a useful one for comparing loans of different sizes. Two charts sit alongside - one showing the principal and interest split shifting across the term, the other tracing the balance down.

    FinancialAha Loan Amortization Excel template - Dashboard sheet

  4. Included guide

    How to Use

    A step-by-step guide on its own tab, covering setup, what each column of the schedule means, how extra payments are applied, and how to read the charts. Because it ships inside the file, the instructions travel with the template wherever it is opened.

Works in both Google Sheets and Excel

Essentials Loan Amortization Spreadsheet template for Google Sheets

Upload the Essentials Loan Amortization Spreadsheet Template to Drive, right-click it, and choose "Open with Google Sheets". This Essentials Loan Amortization Google Sheets template needs no conversion step and both charts survive the trip intact - the schedule recalculates exactly as it does in Excel. The currency dropdown on the Dashboard relabels every money column across all three sheets at once.

Essentials Loan Amortization Google Sheets template setup

A shared copy of the Essentials Loan Amortization Google Sheets template suits two people looking at the same borrowing, and because every input is gathered on the setup sheet, changing the rate or the extra payment in a shared file is a single visible edit. Sheets version history covers a figure typed over.

Sharing the Essentials Loan Amortization Google Sheet

The Essentials Loan Amortization Google Sheet is built for sittings rather than daily use: set the loan up once, then move the extra payment and watch the payoff date and the interest follow. The schedule is where a headline figure gets traced to the month that produced it.

Also available as:

Essentials Loan Amortization Spreadsheet template for Excel

The Essentials Loan Amortization spreadsheet Excel download is a plain .xlsx. Excel opens this Essentials Loan Amortization Excel template directly, with no import step and no compatibility prompt, and both charts are native Excel charts that redraw as the inputs change. There are no macros and no VBA in the file, so it opens without a security warning.

Essentials Loan Amortization Excel template setup

The same Essentials Loan Amortization Excel template opens in Excel on Windows, Excel on Mac, and Excel for the web. It is also the identical file you would upload to Drive, so there is no separate Essentials Loan Amortization spreadsheet download to choose between.

Essentials Loan Amortization spreadsheet Excel notes

The Essentials Loan Amortization spreadsheet Excel file carries no macros and no VBA, so Excel opens it without a trust prompt. The same Essentials Loan Amortization spreadsheet Excel download also opens in Excel for the web, which matters when you move between a work machine and a personal one.

Opening the Essentials Loan Amortization spreadsheet Excel file

Nothing in the Essentials Loan Amortization Excel template is version-specific, so this Essentials Loan Amortization spreadsheet Excel workbook behaves identically in Excel on Windows, Excel on Mac, and older builds.

Also available as:

Spreadsheet template highlights

What the Essentials Loan Amortization spreadsheet template tracks

You fill in the setup sheet. These are the columns the Essentials Loan Amortization Spreadsheet Template carries down the schedule:

Date
the calendar month each payment falls in
Payment auto
derived, the scheduled principal and interest
Principal auto
derived, the part reducing the balance
Interest auto
derived, the part going to the lender
Extra Payment
the additional amount you set, applied to the balance
Total Payment auto
derived, the scheduled amount plus the extra
Remaining Balance auto
derived, what is left afterwards

Compare builds

FinancialAha Loan Amortization spreadsheet template: Free, Essentials, and Ultimate compared

Feature Free View Spreadsheet Template Essentials This page Ultimate View Spreadsheet Template
Working sheets 1 3 6
Loans handled One One Two, side by side
Monthly payment Yes Yes Per loan and combined
Amortization schedule – Dated, every payment One per loan
Extra payments – Yes Yes, with an impact sheet
Payoff date – Yes Combined across both
Charts – 2 2
Interest per unit borrowed – Yes –
Blended rate – – Across both loans
Side-by-side summary – – Yes

The FinancialAha Essentials Loan Amortization Spreadsheet Template covers three working sheets and produces the schedule the name describes. Against the Free Loan Amortization Spreadsheet Template, which returns the monthly payment and the totals without any table behind them, this build dates every payment from your first one, splits each into principal and interest, applies any extra directly to the balance, and reports the payoff date and the interest carried per unit borrowed - across two charts. The Ultimate Loan Amortization Spreadsheet Template runs two loans at once, each with its own schedule, and adds a combined payoff date, a blended rate and a sheet on what extra payments actually change.

Compare the other builds: Free Loan Amortization spreadsheet template or the Ultimate Loan Amortization spreadsheet template .

Good to know

Notes on working in the Essentials Loan Amortization spreadsheet template

  • The schedule is the point of this build - it shows the principal and interest split shifting, which no summary figure conveys.
  • Dates come from the start date you enter, so the payoff arrives as a date rather than a payment number.
  • Interest per unit borrowed is the figure that compares loans of different sizes on the same basis.
  • Extra payments are applied straight to the balance here; whether your lender does the same is worth confirming with them.
  • The currency dropdown sits on the Dashboard and relabels money columns across the whole Essentials Loan Amortization spreadsheet. It changes the label only and does not convert the numbers.

How to Use the Essentials Loan Amortization Spreadsheet Template

1

Enter the loan

On Loan Setup, put in the amount, the annual rate and the term in years.

2

Set the first payment date

This is what lets the schedule run in real calendar months rather than numbered ones.

3

Add any extra payment

Enter the additional monthly amount, which is applied directly to the balance.

4

Read the schedule and dashboard

The schedule shows every payment split out; the dashboard carries the payoff date and the totals.

Stress-tested with AI.

Every template starts with deep research into how people actually track the topic. We design the layout, build the formulas, and polish the design until it feels like something we would use ourselves. Along the way, we use AI to stress-test the calculations: unusual inputs, edge cases, and formula behavior, checked until the numbers hold.

See Ultimate Spreadsheet Template

Instant digital delivery · Terms & Conditions apply

Frequently Asked Questions

Is the FinancialAha Essentials Loan Amortization Spreadsheet Template a Google Sheets template?

Yes. Upload the file to Drive and choose "Open with Google Sheets". The Essentials Loan Amortization Google Sheets template needs no conversion step and both charts survive the trip intact.

Is the FinancialAha Essentials Loan Amortization Spreadsheet Template an Excel template?

Yes. The download is a plain .xlsx, so the Essentials Loan Amortization Excel template opens directly in Excel with no import step. Both charts are native Excel charts, and there are no macros or VBA.

Will the FinancialAha Essentials Loan Amortization spreadsheet Excel file open in older versions of Excel?

Yes. The Essentials Loan Amortization spreadsheet Excel workbook ships as a plain .xlsx, so it opens identically in current Excel and in builds that predate dynamic arrays.

What does the Essentials Loan Amortization spreadsheet add over the free build?

The schedule itself. The free build returns the monthly payment and the totals with nothing behind them; this one dates every payment, splits each into principal and interest, applies any extra to the balance, and reports the payoff date.

How does the Essentials Loan Amortization spreadsheet template handle extra payments?

The amount you enter is applied straight to the balance each month, and the schedule and payoff date follow from that. Whether your own lender applies extra payments the same way is worth confirming with them.

Why does the payment split change down the Essentials Loan Amortization spreadsheet schedule?

Because interest is charged on what is still owed. Early on almost all of a payment is interest; as the balance falls, more of the same payment goes to principal. Reading down the schedule is what makes that visible.

What is interest per unit borrowed for in the Essentials Loan Amortization spreadsheet template?

Comparing loans that are not the same size. Total interest on a large loan will always look worse than on a small one, so expressing it per unit borrowed puts two offers on the same basis.

Can the Essentials Loan Amortization spreadsheet template handle more than one loan?

One loan at a time here. The Ultimate build carries two, each with its own schedule, plus a combined payoff date and a blended rate across them.

How do I open the Essentials Loan Amortization spreadsheet template in Google Sheets?

Upload the .xlsx file to Google Drive, then open it with Google Sheets. All formulas and formatting will be preserved.

More Essentials Mortgage & Home Templates

Home Mortgage Calculator

Enter the home price and the deposit as a percentage and the loan derives itself, then property tax and insurance fold in to give one full monthly figure. The Essentials Home Mortgage Calculator spreadsheet template splits that payment on a pie chart, mortgage insurance included, and runs a dated schedule on real calendar months where extra payments come off the principal and pull the payoff date in. Three working sheets and two charts. Google Sheets or Excel. No macros, no VBA.

$19

Home Affordability Calculator

Property tax, annual insurance and monthly HOA fees sit inside the payment here, so the monthly ceiling covers the whole housing cost rather than the loan alone. The Essentials Home Affordability Calculator spreadsheet template applies both the front-end and back-end debt-to-income limits, takes the lower of the two as a lender would, and solves for the price that ceiling reaches. Setup and Dashboard on sheets of their own. Google Sheets and Excel. No macros, no VBA.

$19

Mortgage Payoff Calculator

Put an extra amount against the principal each month and the payoff date moves. The Essentials Mortgage Payoff Calculator spreadsheet template reports the revised date, how much sooner it arrives and the interest that avoids, then lays out a dated amortization schedule on real calendar months, every payment split into principal and interest with the extra shown separately. Three working sheets and a chart. Google Sheets and Excel, one file. No macros, no VBA.

$19

Home Equity Loan Calculator

Home value and current mortgage balance are the starting point, and the equity falls out of them - as a figure, and as a share of what the home is worth. The Essentials Home Equity Loan Calculator spreadsheet template then works out the maximum borrowable at a common eighty percent ceiling, the combined loan-to-value the new borrowing would create, and the equity left afterwards, with an amortization schedule on its own sheet. Google Sheets and Excel, one file. No macros, no VBA.

$19
Essentials
Preview
See Ultimate Financial Spreadsheet Templates - Full Access Pack 58 templates included • Save $1383

Instant digital delivery · Terms & Conditions apply

Highlights:

Dashboard with charts and KPIs
Pre-filled categories and sample data
No sign-up, no subscription
Lifetime free updates
Works in
Excel Google Sheets

Looking for premium spreadsheet templates?

Our paid templates include advanced multi-sheet dashboards, native Excel charts, and ongoing updates.

View Premium Templates Browse All Essentials Templates

Private & secure

Your financial data stays on your device. We never see it.

Learn more →

Need help?

Check our guides or reach out with questions.

View FAQ →