Free Excel templates

A free residual land valuation template, with the four tests that make it a decision

Gross development value less costs and required profit gives the land price. Then the template moves costs, time and value, reverses the calculation and runs the monthly cash flow to peak debt.

A residual appraisal is a small difference between two large numbers. In the worked scheme a value of 100 and costs of 78 support a land price of 6.4. Raise construction by 8.1% and the land value falls 78%, to 1.4. Put three ordinary adverse movements together and it is -7.1: the scheme supports no land price at all. This template computes the residual and then shows how fragile it is.

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.

The_Residual_Appraisal.xlsx (25 KB)

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.

Need the full project or fund? The Pro Editions go further: Development (60 months, S-curves, senior and mezzanine loans, JV waterfall), $99 → · Fund (up to eight assets, European or American waterfall), $129 →

The book behind this model

This file is one worked case from The Real Estate Development Manager. The book explains every assumption, every sheet and the decision the numbers support, chapter by chapter.

Get the book on Amazon →

Also on Amazon UK · Amazon Germany · Amazon France · Amazon Canada.

Want every model at once?

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).

Get the Library, $79 →

Real Estate Fund Model, Pro Edition: a closed-end fund with up to eight assets, fees, European or American waterfall, 30 built-in checks, a blank copy and a 19-page guide. $129 → · See what is inside

REPE Interview Prep Pack: 18 real estate PE interview cases solved step by step, with three Excel models. $129 →

Real Estate Acquisition and Development Model, Pro Edition: monthly ground-up model over 60 months, S-curves, senior and mezzanine loans, bulk or unit sale, JV waterfall, 33 checks, a 14-page guide. $99 → · See what is inside

The Pro Models Bundle: LBO, Development and Fund models, Pro Editions. $199 instead of $327 → · See what is inside

This free file stays free. Secure checkout by Stripe.

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

The worked scheme

LineAmount
Gross development value100
Construction62
Professional fees8
Statutory and planning4
Finance4
Cost excluding land78
Required profit (20% of cost excluding land)15.6
Residual land value6.4

The four tests

The required profit is held at its appraised amount, because it was set as payment for the risk, not as a residual of it.

TestLand value
As appraised6.4
1. Construction cost rises 8 per cent1.4
2. Programme extends nine months2.9
3. Value falls 5 per cent1.4
4. All three together-7.1

Presented alone, 6.4 looks like a price. Presented with these four lines, it is a price with no margin for anything going wrong, and the right responses are visible: pay less, pre-let, fix the construction price, or ask for a higher return.

What is in the file

The residual
The appraisal, the instability shown in one line of arithmetic, and the four tests.
Reverse and resilience
The calculation run backwards: what the assumptions must be for the land price on the table to work, plus the cost overrun and value fall the scheme can absorb.
Cash flow and peak debt
Month by month: the peak debt, how long it is held, and what a six-month delay actually costs, which a summary appraisal buries in one finance line.
Checks
Every figure tested against the book, each with a verdict.

How to use it

  1. Replace the blue cells on The residual with your scheme: value, the cost lines, the profit requirement.
  2. Read the four tests before the land value. If test 4 is negative, the price has no margin.
  3. Use Reverse and resilience when a vendor names a price: it tells you what you would have to believe to pay it.
  4. Take peak debt from the cash flow sheet, not from the summary: it is what the lender and the equity have to fund.

Questions people ask about it

What is a residual land valuation?

The value of the completed scheme, less every cost of building it and the developer's required profit. What is left is what the land can be worth to that scheme.

Why is the residual so sensitive?

Because it is the small difference between two large numbers. A few per cent on value or costs moves the land value by tens of per cent.

Profit on cost or profit on value?

The template takes profit as a share of cost excluding land, and shows what the other convention does to the same scheme.

Is it free?

Yes. It costs nothing: an email address opens the download. It is a companion file to a book on development management.

The rest of the files

This template is one of the companion files for The Real Estate Development Manager: the full set adds the land and cost plan, the pre-letting decision, the risk register and a fully worked scheme. Free, like this one.

Open the companion files →

Worked questions from the same book

Short articles that each answer one question with the arithmetic shown, on the same ground as this model.

Other free templates

This template comes from The Real Estate Development Manager. The book is on Amazon.

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.