Residual appraisal, monthly cash flow and development finance for residential schemes
Secure checkout. Your download link is sent as soon as payment clears.
Before you buy a site you need to know three things: how much profit the scheme will make, the most you can afford to pay for the land, and how much of your own money you will need to fund it. This workbook answers all three. You describe the homes you will build and what they will sell for, the site price, every cost and your development finance, and it builds a full month-by-month cash flow – with equity, mezzanine and senior debt, rolled-up interest and fees – then works out profit on GDV and on cost, the residual land value at your target profit, peak debt, the equity you need and your IRR.
See how it works
The sheets you will use most, in the order you will use them – shown with the sample data every workbook comes with.
Step 1
The scheme, site purchase, programme, sales assumptions, development finance and profit target. What you do: fill in every yellow cell.
Step 2
Unit types and the schedule of homes, with the value of each home and when its sale money arrives. What you do: enter the types table and one row per home.
Step 3
Build costs, contingency, fees, irrecoverable VAT, the CIL and warranty calculators and the other development costs with their timing. What you do: fill in the yellow cells.
Step 4
The classic one-page appraisal: GDV, every cost, finance, profit, finance sizing, key results, the residual land value and the tax estimate. What you do: nothing to enter.
Who it is for
Quick start
Your file is only released once payment has cleared.
You are taken to our secure checkout.
Checkout takes a minute and you get a receipt by email.
Your download link arrives as soon as payment clears.
We can adapt any prebuilt solution or build something bespoke, with a lifetime bug-free guarantee.
Part of AML Finance Group
Our sister firm, AML Accountancy Solutions, is an award-winning accountancy practice helping businesses and individuals across the UK with their accounts, tax, bookkeeping and payroll.
Visit AML Accountancy Solutions
