Free Excel templates

A free industrial and logistics development model in Excel

A speculative warehouse scheme in three sheets: the monthly cost of holding it empty, four letting outcomes with their probability, the expected profit and margin, and the land value the scheme really supports at a required margin.

An 18,000 square metre warehouse costs 19,800,000 to build and 142,500 a month to hold empty. Weighted over four letting outcomes it earns 1,186,707, a 6.0% margin on cost. At a 17.5% required margin the land is worth 2,761,027, not the 4,700,000 paid.

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.

Industrial_Development_and_Letting_Model.xlsx (21 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.

The book behind this model

This model goes with Logistics and Industrial Real Estate, which explains the method behind it, chapter by chapter.

Get the book on Amazon → Or the DRM-free PDF edition, $19.99

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 →

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

4 sheets. Inputs can be changed; everything else is a formula, and the last sheet checks the figures against the book.

The carry
What the empty building costs to hold: property taxes, insurance, security and maintenance, and finance.
The letting decision
Four letting outcomes, their probability, the expected net realisation, profit and margin.
Land residual
The land value the scheme supports at a required margin, and its sensitivity to cost and value.
Checks
Every figure the book prints, recomputed.

What the worked case returns

MeasureValue
Floor area (sq m)18,000
Total cost19,800,000
Carry a year1,710,000
Carry a month142,500
Net realisation, let in 6 months23,684,553
Net realisation, sold empty13,225,000
Expected net realisation20,986,707
Expected profit1,186,707
Margin on cost6.0%
Loss in the worst outcome-6,575,000
Land the scheme supports2,761,027

A residual is the difference between two large numbers, so small errors in cost or value move the land figure by a multiple. The land supports the price paid only with a pre-let in hand.

How to use it on your own case

  1. Enter floor area, land, construction and fees, then holding costs and the debt rate on The carry.
  2. Enter the exit yield, purchaser's costs and letting fee on The letting decision.
  3. Set four letting outcomes: months to let, rent, rent-free and probability.
  4. Set the required margin and read the land the scheme supports on Land residual.

Questions people ask about it

What is the carry on a speculative development?

What the finished building costs while it is empty: property taxes, insurance, security and maintenance, plus interest on the cost.

How do you value development land?

With a residual: the value of the completed, let scheme less its costs and a required profit. What is left is what the land can carry.

Why weight letting outcomes?

Because the time to let decides the profit. Weighting a few outcomes by probability gives an expected result and shows the loss if the worst one happens.

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 Logistics and Industrial Real Estate go further: the full companion set, blank models and the worked cases of the book.

See the book and its free files →

Other free templates

This template goes with Logistics and Industrial Real Estate. 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.