Finance

Mortgage affordability calculator template

Monthly payment, total interest and the income a lender wants to see. Standard amortization, no add-ins.

How to build this in Numio

How it is wired

Which cell does what, and which worksheets the model reads. These are the assignments you recreate when you import the file.

Cell assignments for the Mortgage affordability template
CellRoleNote
B1InputProperty price
B2InputDeposit
B3InputAnnual rate
B4InputTerm in years
B10ResultAmortized monthly payment
B14ResultGross income under the 28% rule

Functions used

POWERMAXIFROUND

Put this calculator on your site

Change the numbers to yours, then paste it into your own page. It runs in the visitor’s browser and the answers are theirs, not a screenshot of yours.

Embed Mortgage affordability

This template carries example rates, not yours. Paste it as-is and you are quoting our numbers to your customers, and enquiries reach our workspace rather than yours. Copy it into Numio first, change the rates, and publish your own — you get your embed code at the end of that.

Make my own copy
Embed code
<div style="position:relative;overflow:hidden;height:640px;">
  <iframe frameborder="0" style="width:100%;height:100%;" src="https://calc.numioapp.com/calculator/6aa0b2b0e52bf083b27ab6b6"></iframe>
</div>

Set the height to suit your page — the iframe fills whatever container you give it.

Build it in Numio
  1. 1

    Copy it into Numio

    Start from this model rather than a blank sheet. The inputs, the results and any lookup worksheets come with it.

  2. 2

    Put your own rates in

    The prices here are examples. Change them in the Formula view and the calculator follows — no rewiring.

  3. 3

    Publish and paste it in

    Publishing gives you an iframe snippet. Drop it into your own page and enquiries land in your workspace.

Mortgage affordability FAQ

Yes. The formula falls back to dividing the loan by the number of payments, so a 0% rate does not divide by zero.

Add them as two more input cells and include them in the monthly total. Anything you can express in a spreadsheet, Numio will compute.

Other templates

See all templates

Build your first
calculator today.

Start trial