A free development appraisal and cost headroom model in Excel
A residential scheme appraised six ways, at the contract sum and at the final account, then solved for the construction cost at which profit falls exactly to target: the real headroom against a cost overrun, in closed form with no Goal Seek.
The scheme sells for 45,312,000 and is appraised at 17.4% profit on cost. At a 15% target, construction can rise only 732,546, 2.8% of the contract sum. The overrun ran to 2,852,261, 3.9 times the headroom, and profit on cost fell to 8.59%.
Get the template
One Excel file, no macros, nothing locked. Free: enter your email address and the download opens at once, along with the other 129 free models.
You join the reader list: one email when a new free model or a new book comes out, and a few notes on using the models. Leave in one click. Already on the list? Enter the same address. How your address is used.
The book behind this model
This model goes with Construction Cost Control, which explains the method behind it, chapter by chapter.
The Financial Model Library: all 130 models from this site in one download, organised by theme, plus two modelling books in DRM-free PDF (Financial Modeling from First Principles and Real Estate Financial Modeling).
This free file stays free. Secure checkout by Stripe.
Not on Amazon: 24 paperbacks by Julian R. Sterling on insurance and retirement, printed on demand and shipped worldwide. Browse the bookshop →
What is in the file
5 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.
Inputs
Units, revenue, land, the contract sum and the final account, fees, sale costs and the facility.
Appraisal
The scheme appraised at the contract sum, at the final account and with the facility stretched to cover the overrun.
Headroom
The construction cost at which profit falls exactly to the target, and the headroom against the contract sum.
Solve
Move the target return, the revenue or the land and watch the headroom move.
Checks
Every figure the book prints, recomputed.
What the worked case returns
Measure
Value
Gross development value
45,312,000
Construction, contract sum
26,301,102
Total cost at the contract sum
38,597,404
Profit on cost at the contract sum
17.40%
Construction, final account
29,153,363
Profit on cost at the final account
8.59%
Profit lost to the overrun
3,131,783
Break-even construction cost at the target
27,033,648
Headroom
732,546
Headroom as a share of the contract sum
2.79%
Fees are a percentage of construction cost and the facility is held at its sized amount, so the break-even construction cost solves algebraically: no iteration and no circular reference. Move the target, the revenue or the land on Solve and the headroom moves with them.
How to use it on your own case
Enter units, revenue per unit, land, contract sum, fee and sale cost percentages on Inputs or Solve.
Enter the loan to cost, drawn share, interest rate, term and target profit on cost.
Read the appraisal at the contract sum and at the final account.
Read the break-even construction cost and the headroom on Headroom.
Questions people ask about it
What is profit on cost in a development appraisal?
The developer's profit divided by the total cost of the scheme, including land, construction, fees, finance and sale costs.
What is cost overrun headroom?
How much construction cost can rise before profit falls to the target return. It is often a small share of the contract sum.
Why no Goal Seek?
Because fees scale with construction cost and the loan is fixed at its sized amount, the break-even cost can be solved with a formula, which stays live when inputs change.
Is this template really free?
Yes. You enter an email address, the download opens at once, and you can leave the reader list in one click.
Go further
The free workbooks of Construction Cost Control go further: the full companion set, blank models and the worked cases of the book.
LCR and NSFR calculatorLiquidity coverage and net stable funding built line by line, with encumbrance and six defensible readings.
Risk-weighted assets (RWA) calculatorStandardised against internal-model RWA, the mortgage loan split, CET1 ratios and the year the output floor binds.
Credit scorecard modelA points scorecard built from counts: bins, weight of evidence, information value and the leaking variable.
Price waterfall analysisList price to pocket price for one account and a whole company: nine leakages, ranked and added up.
If this book helped, or didn’t, a few lines on Amazon are worth more than they look: they are what the next reader goes on. Write a review. The template stays free either way.