Real estate models

Real estate modelling values a building from its leases rather than from a multiple. An acquisition buys income that already exists: the rent roll is read lease by lease, net operating income is built from it, a loan is sized to the tightest of loan to value, debt service cover and debt yield, and the equity is split through a waterfall. A development creates the income: a budget is drawn over construction, funded equity first and then with a construction loan, the building is let up to stabilisation and refinanced, and the scheme is judged on its development spread, the yield on cost less the cap rate the building would sell at. A listed REIT owns hundreds of such buildings and is priced every day: it is valued on funds from operations and adjusted FFO per share and on its premium or discount to net asset value, the portfolio valued building by building at a cap rate. A hotel is the exception to income locked in by leases: an operating business inside a building, whose rooms are sold again every night, so its income is built from occupancy and the average daily rate through a departmental statement to gross operating profit and NOI after a furniture reserve, and its lenders watch debt yield closely.

By Surojit Chakraverti, founder of L3VLUP and an investor running a long-short healthcare and technology equities strategy.

On this subject: real estate.Updated 22 October 2026

The models

Preview the Hotel underwriting model workbook
Advanced9 sheets~50 minPEIB

Hotel underwriting model

Build a hotel’s revenue from occupancy and ADR, carry it through a departmental operating statement to GOP, EBITDA and NOI after the FF&E reserve, size a senior loan to loan to cost, DSCR and debt yield with a mezzanine layer on top, and read the levered return and its sensitivity to occupancy and the exit cap rate.

Other areas: Core modelling · M&A and private equity · Credit and restructuring · Infrastructure and project finance · Healthcare · Technology · Financial institutions · All 57 models

How to work through it

Start with the rent roll lab, which is the first thing an acquisitions analyst does with any building. Then open the acquisition model to see the same leases carried through a ten-year hold, a loan and a promote. The development model builds the kind of asset the acquisition model buys: change the absorption or the exit cap rate and watch the development spread move. The REIT model then owns a portfolio of them: change the share price and see whether its next acquisition adds to AFFO per share. The hotel model shows what changes when there are no leases: move stabilised occupancy or ADR and watch GOP margin, the loan’s coverage and the levered return respond. Each model has a starter workbook that leaves one schedule for you to build.

The mechanics they share

Each schedule is one reusable calculation, explained on its own page with the rows it occupies in every model that uses it.

Real estate schedules

Rent roll

Every lease, year by year, with expiries priced in

Real estate schedules

NOI build

Gross rent to net operating income

Real estate schedules

Loan sizing: LTV, DSCR and debt yield

The lender lends to the tightest of three constraints

Real estate schedules

Mortgage debt schedule

Constant payment, interest, principal, balloon

Real estate schedules

Property returns

Unlevered and levered IRR, multiple, cash-on-cash, exit cap sensitivity

Real estate schedules

Equity waterfall: preferred return, catch-up, promote

How the levered cash is split between investors and sponsor

Real estate schedules

Development budget and draw profile

Land, hard and soft costs, contingency, fee, S-curve

Project finance schedules

Construction funding

Draws, interest during construction, fees, equity

Real estate schedules

Lease-up and stabilisation

Absorption, occupancy, NOI, TI and commissions

Real estate schedules

Development returns and spread

Yield on cost, development spread, profit on cost, IRR

Real estate schedules

Same-store NOI and portfolio growth

Growth on buildings owned, plus what was bought and sold

Real estate schedules

FFO and AFFO

From net income to the measures REITs are priced on

Real estate schedules

REIT capital allocation

Funding deals, the dividend, leverage and the investment spread

Real estate schedules

REIT net asset value

NAV per share, the premium or discount, the implied cap rate

Real estate schedules

Occupancy, ADR and RevPAR build

Room nights, rate and revenue by department

Real estate schedules

Hotel operating statement: departmental P&L to NOI

Departments, undistributed costs, GOP, fees, EBITDA

Real estate schedules

FF&E reserve

Furniture, fixtures and equipment, set aside before NOI

Transaction schedules

Sources and uses

What the deal costs and who funds it

Practise first

Where this work is done

Infrastructure & Real Assets

Long-dated, cash-yielding assets. Different maths, much longer horizons.

Private Equity

Buy control of established companies using debt, improve them, sell them.

How to get in and prepare
Equity Research

Cover a sector, publish a view, defend it to clients. The best writing training on the map.

How to get in and prepare
Asset Management

Long-only funds against a benchmark. Longer horizons, more process, better hours.

Read

The vocabulary

Questions

How is real estate modelled differently from a company?

There is no revenue line or EBITDA multiple. Income is built lease by lease from the rent roll, with vacancy as an event at each expiry; value is net operating income over a cap rate; and the loan is sized on that income rather than on a leverage multiple. The returns are then split between investors and the sponsor through a waterfall.

What is the difference between an acquisition and a development model?

An acquisition buys existing income and asks what it is worth and what the equity earns on it. A development spends money to create income and asks whether the income will be worth enough more than its cost: the yield on cost against the exit cap rate, which is the development spread.

How is a REIT valued differently from a building?

A building is valued on its own income at a cap rate. A REIT is a company that owns many buildings, so it is valued on earnings per share measures built for real estate (FFO and AFFO, because depreciation makes net income misleading) and against its net asset value, the buildings valued one by one less debt. Whether the shares trade above or below NAV decides whether it can grow by issuing them.

Which numbers do real estate interviews test?

Cap rates and NOI, the three loan-sizing constraints, cash-on-cash and the equity multiple, the waterfall with a preferred return and a promote, for development roles the yield on cost and the spread, and for REIT coverage FFO, AFFO and NAV. The rent roll lab drills the first step, and each model page lists the mistakes a reviewer looks for.