Free Excel templates

A free real estate financial model template for a single asset

Rent roll, operating cash flow, debt sized on LTV, interest cover and debt yield, unlevered and levered returns, and an exit yield sensitivity: an empty model with the architecture already built.

Most property models fail in the same places: dates typed into formulas, a rent roll that does not tie to the area, an exit value nobody can trace to the income that supports it. This template is the empty version of a model built to avoid those failures. The structure, the formulas and the checks are in place; the property is yours to type in.

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.

Property_Model_Template.xlsx (24 KB) · a copy for Google Sheets

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 Real Estate Financial Modeling. The book explains every assumption, every sheet and the decision the numbers support, 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.

Go further: Real Estate Modeling, the course

Eight modules on one logistics park: rent roll and NOI, cap rate and DCF, LTV, DSCR and debt yield, levered returns, a development with its construction loan, the JV waterfall and quarterly NAV. Excel exercises that check your answers, a 160-question quiz and the Real Estate Acquisition and Development Model, Pro Edition included ($149).

Try module 4 and ten quiz questions, free →

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 →

What is in the file

Eight sheets. Time runs across the columns and line items run down the rows, on every sheet, so a year means the same column everywhere.

Summary
Built last, read first: the checks, the unlevered and levered IRR and equity multiple, and a three-sentence recommendation box.
Assumptions
Every input with a label a non-modeller can read, a unit, a value and a column for the source.
Rent Roll
One row per lease: area, passing rent, rent per square metre against market rent (ERV), years to expiry and the gap to market, with one example row filled in.
Cash Flow
A header block of periods and hold flags first, then contracted rent, occupancy, recoveries, operating and void costs, net operating income and its margin, building capex, tenant improvements and commissions.
Debt
The loan sized on all three tests (loan-to-value, interest cover, debt yield), the binding one named, and both covenants tested every year.
Returns
Unlevered and levered cash flows, IRR and equity multiple side by side, exit on forward income.
Sensitivity
The levered return against the exit yield, and the break-even exit yield.

The defaults it ships with

The money inputs are empty. The ratios carry sensible starting values so the model is usable as soon as a price and a rent are typed in:

InputDefault
Acquisition costs6.5%
Disposal costs1.5%
Hold period5 years
Rental growth2.0%
Cost inflation2.5%
Loan-to-value limit55%
Interest rate5.0%
Minimum interest cover1.30x
Minimum debt yield9.0%
Exit yield6.0%

Two defaults are there to make a point. Cost inflation starts above rental growth, because a model that lets rents outrun costs for ten years is flattering itself. And the Summary tests that the net operating income margin sits inside a normal band, so a missing cost line shows up before it reaches the return.

How to fill it in

  1. Assumptions: area, price, market rent, the operating costs, the debt terms and the exit yield. Write the source of each number in the last column.
  2. Rent Roll: one row per lease. The check on Summary confirms occupied plus vacant equals the total area.
  3. Read Cash Flow line by line for the first two years before trusting year five.
  4. Summary last: quote the unlevered and the levered return together, never the levered one alone.

If you want to see the same architecture filled in, the companion files for the book include a complete worked model of an office building, Meridian House, built on these sheets.

Questions people ask about it

Is there a filled-in example?

The template carries one example rent roll row. The full worked example, Meridian House, is in the book's companion files, free.

Why both unlevered and levered returns?

The unlevered return tells you about the building. The levered return adds the financing. A deal that only works levered is a financing trade, and you should know that before you buy it.

Does it handle monthly periods?

It is annual. For a single stabilised asset that is usually the right grain; development and value-add schemes need the monthly models in the same companion set.

Does it work in Google Sheets?

Yes. There are no macros and nothing is locked. A ready-made Google Sheets copy is also available from the download box above.

The rest of the files

This template is one of the companion files for Real Estate Financial Modeling: the full set adds the complete Meridian House model, a model-review checklist and the one-page investment summary. 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 Real Estate Financial Modeling. 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.