Real estateCore · ~50 minWorking draft · 9 sheets · 796 formulas

Property acquisition model

Rent roll, NOI, cap rate, three-constraint loan, waterfall. Underwrite an income-producing property from the rent roll to a levered IRR, size the loan to the tightest of three constraints, and run the sponsor’s promote through a waterfall.

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

On this subject: property acquisition model.Updated 30 September 2026

Who builds it, and for whatThe underwriting model behind an acquisition memo at a real estate fund, a REIT or a bank’s real estate lending desk: what the building earns lease by lease, what it is worth at a cap rate, how much a lender will advance against it, and what the equity earns before and after the sponsor’s promote. The logic differs from corporate finance: NOI rather than EBITDA, and a cap rate rather than a multiple.

Every sheet below, in your browser, with its outputs and checks

Starter workbook free with an account. Worked model: one a month with Plus, every one with Pro. Downloads

Inspect the workbook
All checks read zero100%
Every value, every sheet, as the workbook holds it.
ABCDEFGHIJKLMNO
1Assumptions
2$m unless stated. Area in thousand sq ft; rents and costs in $ per sq ft a year.
4YearUnitY0Y1Y2Y3Y4Y5Y6Y7Y8Y9Y10Y11
5Timing
6Year#01234567891011
7Hold periodyears10Whole years, 1 to 10. Sold at the end of this year on the next year’s NOI.
8Hold period usedyears10The input, rounded and held within 1 to 10. Checks flag any difference.
9Owned during the yearflag011111111110
10Sale yearflag000000000010
12Acquisition and operating assumptions
13Purchase price$m92.0Paid at closing, the start of Year 1 (Year 0 column).
14Closing costs, % of purchase price%2.0%
15Other income, Year 1$/sf/yr1.50Parking and storage, on total area. Grows at the market rate.
16General vacancy and credit loss, % of gross income%3.0%On rent, other income and recoveries. In addition to downtime at expiry.
17Recoverable operating expenses, Year 1$/sf/yr9.00On total area. Grows at the market rate.
18Expense recoveries, % of recoverable expenses%60.0%Share of operating expenses billed back to tenants.
19Management fee, % of effective gross income%3.0%
20Capital reserve, Year 1$/sf/yr0.50Below NOI. On total area; grows at the market rate.
21Growth in market rent, expenses and other income, % a year%3.0%
22Contractual rent increases on in-place leases, % a year%2.5%Applies to contractual rent until each lease expires.
24Debt financing
25Maximum loan to value (LTV)%65.0%On the purchase price.
26Minimum debt service coverage ratio (DSCR)x1.3xYear 1 NOI / annual debt service.
27Minimum debt yield%8.0%Year 1 NOI / loan amount.
28Interest rate, % a year%5.5%
29Amortisation periodyears30
30Origination fee, % of loan%1.0%Deducted from loan proceeds at closing.
32Exit assumptions
33Exit cap rate%6.5%Applied to NOI for the year after the sale year.
34Selling costs, % of sale price%1.5%
36Equity waterfall
37Sponsor co-investment, % of equity%10.0%Treated as investor capital in tiers 1 and 3.
38Preferred return, % a year, compounding%8.0%Accrues on unreturned capital and unpaid preferred return.
39Sponsor promote, % of profit%20.0%After capital and preferred return: 100% catch-up, then this split.

Select a cell to see its row, its schedule and the type of cell. Font colours: blue for inputs, black for formulas, green for links to other sheets. Scroll sideways to see every period.

Download

Property acquisition model: the workbook

An Excel workbook with working formulas, no macros and no external links: the same model you can work with on this page.

  1. Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
  2. Free accountWork with every model online: change the inputs, switch the case, see every formula. And every starter workbook, with its key schedules left blank to build.
  3. L3VLUP Plus$4.99/monthEverything in Free, and one worked model each billing month as an Excel file: every schedule built, formulas live, checks at zero, yours to keep.
  4. L3VLUP Pro$25/monthEverything in Plus, every worked model in the library, and the Pro applications.
The worked model
9 sheets and 796 live formulas, all 6 schedules built and linked, every check reading zero. Change an input in Excel and the whole model moves.
The starter
The same inputs and layout with the loan sizing: LTV, DSCR and debt yield and the mortgage debt schedule left blank for you to build, each blank cell marked. The worked model is its answer.

What the base case says

Year 1 NOI
$5.7m
Going-in cap rate
6.2%
Loan amount
$59.8m
Loan to value
65.0%
Unlevered IRR
8.6%
Levered IRR
12.0%
Equity multiple
2.8x
Third-party investor IRR
10.4%

Read from the workbook as served, every input at its default. Periods: Y0, Y1, Y2, Y3, Y4, Y5, Y6, Y7, Y8, Y9, Y10, Y11. The figures are invented and move with whatever you type in.

What this model is

An acquisition model for a multi-tenant office building held for ten years. It builds net operating income (NOI) from a five-lease rent roll and values the sale on forward NOI at an exit cap rate.

The loan is sized to the lowest of three limits on Year 1 NOI: loan to value (LTV), debt service coverage ratio (DSCR) and debt yield. The equity requirement follows from the loan.

Outputs are unlevered property returns, levered equity returns, an exit cap rate sensitivity and the split of equity cash flow between investors and the sponsor.

Seats: Private equity, Investment banking.

Careers that do this work: infrastructure & real assets, private equity, equity research, asset management.

How the schedules connect

Every row in the workbook is tagged with the schedule it belongs to; the inspector above shows the tag when you click a row. These are the schedules this model is made of and where each one lives.

What you should be able to explain

  • Why NOI is not EBITDA, and why it is built up from leases rather than down from a growth rate.
  • What the cap rate is (a market input, not an output) and why a 100 basis point move in the exit cap rate is usually the most material sensitivity.
  • Why the loan is the minimum of three constraints, and what each one protects the lender against.
  • How vacancy is an event with downtime and re-letting costs, not a flat percentage.
  • What a preferred return, a catch-up and a promote each do to the split, and why the catch-up is the line first-time models forget.

What a reviewer looks for

  • EBITDA language and an EV/EBITDA multiple on a property, where NOI and a cap rate are the currency.
  • A flat vacancy rate that smooths away the lease expiries where the cash flow actually dips.
  • Sizing the loan to a leverage multiple or a single constraint, when the lender tests three.
  • A waterfall with no catch-up, which understates the sponsor’s promote once returns clear the hurdle.
  • Selling on trailing NOI instead of forward NOI, or forgetting selling costs.

Conventions this workbook uses

Stated on the cover sheet too. A model is only as trustworthy as the decisions it tells you it made.

  • Annual periods. The building is bought at the start of Year 1 and sold at the end of the hold period, an input of 1 to 10 whole years (base case 10). The sale is priced on the next year’s NOI, which is why the sheets run to Year 11; columns after the sale year read zero.
  • Each lease pays contractual rent, with contractual increases, until expiry and market rent after it. In the year after expiry the model deducts downtime, tenant improvements and a leasing commission, each weighted by the probability that the tenant leaves. A general vacancy and credit loss allowance applies on top.
  • NOI is before capital reserves and leasing costs; cash flow before debt service is after them. The cap rates, the loan constraints and the DSCR use NOI.
  • The loan is a constant-payment mortgage: the annual payment is the loan times the mortgage constant, interest is on the opening balance, and principal is the remainder. The balance outstanding is repaid in the sale year.
  • Waterfall terms: the sponsor co-investment is treated as investor capital. Tier 1 pays investors their capital and a compounding preferred return through one hurdle balance. Tier 2 pays the sponsor a 100% catch-up until the sponsor holds its promote share of all profit distributed. Tier 3 splits the remainder at the promote share. Distributions are calculated year by year.

Build it yourself

The starter workbook

The Debt sheet has been cleared: the three sizing constraints, the mortgage constant, the loan amount and the schedule from the opening balance to the balloon. Size the loan to the lowest constraint and build the schedule so that the levered returns and the waterfall calculate again. The Checks sheet shows when the loan meets every constraint and is repaid at sale.

Blanks: Loan sizing: LTV, DSCR and debt yield, Mortgage debt schedule. Download it beside the worked model.

The path around this model

Understand it, drill it, read the build, then apply it to a real company.

Vocabulary: Net Operating Income (NOI), Cap Rate (Capitalisation Rate), Debt Yield, Loan-to-Value (LTV), Cash-on-Cash Return, Equity Multiple, Promote (Real Estate), Rent Roll.

Questions about this model

Why is the cap rate an input?

Because it is what the market pays for a dollar of stabilised NOI, read from comparable transactions, and the model has no way to derive it. The analyst’s job is to defend it. That is why the Returns sheet carries an exit cap rate sensitivity: the exit cap rate is one of the largest uncertainties in the return.

Which constraint binds the loan?

Whichever gives the smallest loan on Year 1 NOI. In the base case it is loan-to-value; lower the NOI, or raise the interest rate, and debt yield or coverage can take over. The Debt sheet identifies the binding constraint.

How does the waterfall handle the sponsor’s own money?

The sponsor’s co-investment is treated as an investor: it earns the preferred return and the tier-three split pro rata with everyone else. The promote is a separate stream, paid in the catch-up and in tier three. The sponsor’s IRR combines the two; the third-party investor IRR is what an LP would quote.

Why probability-weight the lease expiries?

Because underwriting is done before anyone knows whether the tenant renews. Weighting downtime, tenant improvements and commissions by the chance the tenant leaves gives an expected cash flow that reflects the risk without building a scenario for every lease. The renewal odds are inputs, lease by lease.

Related models

Questions about this model

Discussions open here soon.

All discussions

Share your result 📊

𝕏in💬🤖

Instagram and TikTok have no desktop share link, so copy the caption and paste it into the app.