Mortgage Affordability Worksheet
The applicants and the household's monthly income after tax.
Property Buying and Selling · PB-560 · Planner
Free house deposit savings plan: your own target and date, planned and actual saving each month, running balance and months to go. PDF, Excel and browser.
One page. The A4 and US Letter files are laid out identically, so neither is shrunk to fit.
Print it and write on it
Fillable PDF type and save
Spreadsheet formulas included
The fillable versions have real form fields — open them in any PDF reader, type into them and save. Printing help.
The same sheet, on screen. Totals and figures are worked out as you type, rows can be added or removed, and you can print it or download the completed version as a PDF. Everything stays in your browser — your entries are kept in this browser's own storage on this device, nothing is uploaded, and there is no account.
Build your deposit month by month. Set the target you have chosen, the date you are aiming for and what you plan to put by each month, then record what you actually saved. The sheet keeps a running balance and shows how much is left and how many months that is at your planned rate.
First-time buyers saving for a deposit, alone or as a couple, who want to see whether their saving is keeping pace with the plan they set themselves.
The printable is laid out inside a box that fits both A4 and US Letter, so the two files are identical and neither one is scaled. The fillable PDF has real form fields. The workbook uses plain formulas only — SUM, IF, COUNTIF and the like — so it opens in Excel, LibreOffice and Google Sheets without anything breaking, and every calculated cell is grey so you can see which figures it worked out.
Download the A4 or US Letter file to match the paper in your printer, open it in a PDF reader and print at 100% — not "fit to page", which shrinks the writing space. Both files leave a 14 mm margin, which clears the unprintable edge on home printers. To print the online version with your entries in it, use the Print this sheet button, which prints only the sheet and none of the page around it. More on printing.
That depends on the price range you are looking at and what lenders will offer you. Speak to a lender or broker where you are, then enter the figure you settle on. The sheet does not suggest one.
The amount still to save divided by your planned monthly amount, rounded to one decimal place. It assumes you keep saving at the planned rate and ignores any interest, since that depends on your accounts.
Yes. Enter it in the actual column in the month it arrives, and name the source in the account or notes column. Lenders may ask where deposit money came from, so keep a clear record.
Use one plan for the joint deposit and write whose saving it was in the account or notes column, or keep a copy each and add the balances together.
The applicants and the household's monthly income after tax.
The deposit required and the amount due at exchange.
Every one-off cost of the purchase on its own line.
Printable sheets, workbooks and tools on the same subject.
The big irregular costs — the car service, the insurance renewal, Christmas — broken down into what you need to set aside each month to be ready for them.
A monthly budget that adds up planned against actual, keeps income, outgoings and saving apart, and rolls twelve months into a year view.
Every sheet, binder, game and puzzle on Upkeep Papers is free to download, with no email and no account. Making them is not free: each one takes days of research, design and checking, and the site costs money to run. If something here saved you time, you can buy us a coffee. It is entirely optional: nothing is locked, and nothing changes if you don’t.
Opens PayPal in a new tab. Any amount, and nothing changes if you would rather not.