Mortgage Calculator

Principal and interest on a fixed-rate mortgage.

PRINCIPAL & INTEREST - FULL SCHEDULE - RUNS ON YOUR DEVICE

Your figures never leave this tab

  • P & Ionly
  • Fixedrate
  • 1 rowper payment
  • 0data sent
In practice

What you can count on

  • P & Ionly
    • Principal and interest, nothing bundled
    • No taxes, insurance or fees
  • 1row per payment
    • The balance falling to zero
    • Interest and principal each time
  • 0data sent
    • The figures stay in this browser tab
    • Nothing is stored
Specification

Mortgage Calculator at a glance

Inputs
Amount, rate, years, extra
What the payment covers
Principal and interest only
Rate type
Fixed rate only
Output
A printable schedule
Extra payments
Overpayment shortens the table
Price
Free
Account required
No
Where it runs
On your device
How to

How to use Mortgage Calculator

  1. 1

    Enter the mortgage

    Amount borrowed, the annual rate as a percentage, and the term in years.

  2. 2

    Add an overpayment

    A fixed extra amount each month is optional. It clears the balance sooner, so the table ends early.

  3. 3

    Read payment and schedule

    The payment appears with the full table beneath, one row for each repayment.

Questions

Frequently asked questions

Does the payment include taxes and insurance?

No. It covers principal and interest only. Property taxes, insurance and any lender fee sit outside this calculation and have to be added yourself.

Can it handle a rate that changes?

No. The schedule assumes one fixed rate for the whole term. For a later change, run it again using the balance left and the new rate.

Does it show overpayments?

Yes, for a fixed extra amount each month. The table runs out when the balance reaches zero rather than at the end of the term, and the total interest is the lower figure that follows from it.

Where do my figures go?

Nowhere. The calculation happens in this browser tab, and the amount, rate and term are never sent or stored.

I got a message saying the payment does not cover the interest.

Then the balance would grow every month and the schedule would never end. Raise the payment or lower the rate. The table also stops after the term plus 600 rows, so a runaway case cannot hang the page.

Background

What the loan part actually costs

This works out principal and interest at a fixed rate. Property taxes, insurance and any fee a lender adds are not part of it, so the payment shown is the loan alone.

  • Total interest is the sum of the interest column, and it is often close to the amount borrowed.
  • A longer term lowers each payment and raises the total interest paid.
  • The first rows are mostly interest because the balance owed is at its highest then.
  • Anything a lender bundles into a quoted monthly figure sits outside this table.

Full specification

Specification of the Mortgage Calculator tool
InputsAmount borrowed, the annual interest rate, the term in years, and an optional extra payment each month.
What the payment coversPrincipal and interest. Taxes, insurance and lender fees are not included.
Rate typeA fixed rate for the whole term. A rate that changes later is not modeled.
OutputA printable table with one row per payment, down to a zero balance.
Extra paymentsA fixed extra amount each month is supported, and the table stops early once the balance clears.
PriceFree
Account requiredNo
Where it runsIn your browser tab. Nothing is sent anywhere.
Next step

Keep going with the same files

All finance tools: Finance tools on SPOTTOOLS