ExcelCraft
Open editor

EXCELCRAFT PRO TEMPLATE

Loan amortization
with extra payments.

See every payment until the loan is gone, and what paying a little more does. Add a regular extra or a one-off lump sum and the schedule shows the new payoff date and the interest you save.

See what is inside

Planned pricing: $8 a month or $60 a year. No payment is taken today.

Original ExcelCraft workbook · Pro · Finance & accounting

ExcelCraft / Loan Amortization & Extra PaymentsFictional sample
Loan Amortization & Extra Payments with fictional sample data, shown in the ExcelCraft spreadsheet editor
Pro workbook preview · fictional data

INSIDE THE WORKBOOK

Every sheet
has one job.

Mint cells are where you type. White cells calculate. Instructions inside the file explain each field.

Dashboard
Monthly payment, total interest, payoff date and interest saved, with the balance with and without extras and principal vs interest by year.
Schedule
Every payment: date, opening balance, payment, interest, principal, extra and closing balance, up to 40 years.
Extra Payments
One-off payments with a date, amount and note.
Loan · Checks · Instructions
Amount, rate, term, first payment date and regular extra; checks that the schedule ends at zero.

WHY IT HELPS

Built around
the real task.

Full payment schedule and how much interest and time extra payments save.

  1. The whole schedule

    Every monthly payment split into interest and principal, so you can see how slowly the balance moves at first and how it speeds up.

  2. What-if in seconds

    Change the regular extra or add a lump sum and the payoff date, total interest and interest saved update immediately.

  3. A fair comparison

    Interest saved compares against the same loan with no extras, calculated the same way, payment by payment.

GETTING STARTED

Three steps
to your own version.

The sample shows a working example; the blank version keeps every formula ready for your records.

  1. Enter the loan

    Amount, annual rate, term in years and the first payment date.

  2. Add extras

    Set a regular monthly extra and add one-off payments with their dates.

  3. Compare

    Check the payoff date and interest saved on the Dashboard.

QUESTIONS

Before you begin.

Short answers about how the workbook behaves.

Does it work for mortgages, car loans and student loans?

Any fixed-rate loan with monthly payments. Adjustable rates are not modelled.

Does it include taxes and insurance?

No. It covers principal and interest only. Add escrow items separately.

Why is my lender's figure slightly different?

Lenders round and calculate interest in slightly different ways (for example daily interest). Expect small differences.

Are there penalties for paying early?

Some loans charge for early repayment. Check your loan terms before paying extra.

How do I keep my changes?

Use Download XLSX or PDF in the editor before closing the tab. Nothing is saved to a server automatically, and your workbook never leaves your device while you edit.

Will it work in Excel and Google Sheets?

The files use standard XLSX formulas without macros, pivot tables or external links. They are checked with the ExcelCraft engine; compatibility with every Excel or Google Sheets version is not guaranteed. Review formulas, charts and formatting in your app before relying on important figures.

Can I change the currency?

Amounts use a $ number format. Change the cell format to your currency; the formulas do not convert between currencies.

EXCELCRAFT PRO · EARLY ACCESS

Part of
ExcelCraft Pro.

Pro workbooks cover whole workflows: purchasing to receiving, journal to balance sheet, tasks to portfolio health. Pro is planned to include AI credits for editing through chat. Pro downloads and the AI assistant are not available yet.

  • Every Pro workbook as it is released, with dashboards, checks and instructions
  • Planned: monthly AI credits for editing spreadsheets through chat
  • Planned launch pricing; final terms are not set

$8/ month

or $60 / year · planned launch price

No payment today. We email you once when Pro opens.

How Pro works

RELATED

Works well with.

Separate workbooks for neighbouring jobs. Records do not sync between files.

Your workbook stays in this browser while you edit. Use Download in the editor to keep your work, and review important figures in the saved copy. How local files are handled.

Original ExcelCraft workbook design, formulas and fictional sample data · CC0. Management tool only; not tax, legal or accounting advice.