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
| A | B | C | D | E | F | G | H | I | J | K | L | M | N | O | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | Assumptions | ||||||||||||||
| 2 | $m unless stated. Area in thousand sq ft; rents and costs in $ per sq ft a year. | ||||||||||||||
| 4 | Year | Unit | Y0 | Y1 | Y2 | Y3 | Y4 | Y5 | Y6 | Y7 | Y8 | Y9 | Y10 | Y11 | |
| 5 | Timing | ||||||||||||||
| 6 | Year | # | 0 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | |
| 7 | Hold period | years | 10 | Whole years, 1 to 10. Sold at the end of this year on the next year’s NOI. | |||||||||||
| 8 | Hold period used | years | 10 | The input, rounded and held within 1 to 10. Checks flag any difference. | |||||||||||
| 9 | Owned during the year | flag | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | |
| 10 | Sale year | flag | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | |
| 12 | Acquisition and operating assumptions | ||||||||||||||
| 13 | Purchase price | $m | 92.0 | Paid at closing, the start of Year 1 (Year 0 column). | |||||||||||
| 14 | Closing costs, % of purchase price | % | 2.0% | ||||||||||||
| 15 | Other income, Year 1 | $/sf/yr | 1.50 | Parking and storage, on total area. Grows at the market rate. | |||||||||||
| 16 | General vacancy and credit loss, % of gross income | % | 3.0% | On rent, other income and recoveries. In addition to downtime at expiry. | |||||||||||
| 17 | Recoverable operating expenses, Year 1 | $/sf/yr | 9.00 | On total area. Grows at the market rate. | |||||||||||
| 18 | Expense recoveries, % of recoverable expenses | % | 60.0% | Share of operating expenses billed back to tenants. | |||||||||||
| 19 | Management fee, % of effective gross income | % | 3.0% | ||||||||||||
| 20 | Capital reserve, Year 1 | $/sf/yr | 0.50 | Below NOI. On total area; grows at the market rate. | |||||||||||
| 21 | Growth in market rent, expenses and other income, % a year | % | 3.0% | ||||||||||||
| 22 | Contractual rent increases on in-place leases, % a year | % | 2.5% | Applies to contractual rent until each lease expires. | |||||||||||
| 24 | Debt financing | ||||||||||||||
| 25 | Maximum loan to value (LTV) | % | 65.0% | On the purchase price. | |||||||||||
| 26 | Minimum debt service coverage ratio (DSCR) | x | 1.3x | Year 1 NOI / annual debt service. | |||||||||||
| 27 | Minimum debt yield | % | 8.0% | Year 1 NOI / loan amount. | |||||||||||
| 28 | Interest rate, % a year | % | 5.5% | ||||||||||||
| 29 | Amortisation period | years | 30 | ||||||||||||
| 30 | Origination fee, % of loan | % | 1.0% | Deducted from loan proceeds at closing. | |||||||||||
| 32 | Exit assumptions | ||||||||||||||
| 33 | Exit cap rate | % | 6.5% | Applied to NOI for the year after the sale year. | |||||||||||
| 34 | Selling costs, % of sale price | % | 1.5% | ||||||||||||
| 36 | Equity waterfall | ||||||||||||||
| 37 | Sponsor co-investment, % of equity | % | 10.0% | Treated as investor capital in tiers 1 and 3. | |||||||||||
| 38 | Preferred return, % a year, compounding | % | 8.0% | Accrues on unreturned capital and unpaid preferred return. | |||||||||||
| 39 | Sponsor 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.
- Browse without an accountPreview every model online, sheet by sheet, with its outputs and checks.
- 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.
- 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.
- 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.
Rent roll
Every lease, year by year, with expiries priced in
Tenants, rows 6–15 · Rent Roll, rows 6–8 · Rent Roll, rows 11–24 · Rent Roll, rows 27–29
NOI build
Gross rent to net operating income
Assumptions, rows 13–22 · NOI, rows 6–10 · NOI, rows 13–16 · NOI, rows 19–21
Loan sizing: LTV, DSCR and debt yield
The lender lends to the tightest of three constraints
Assumptions, rows 25–30 · Debt, rows 6–15
Mortgage debt schedule
Constant payment, interest, principal, balloon
Debt, rows 18–25
Property returns
Unlevered and levered IRR, multiple, cash-on-cash, exit cap sensitivity
Assumptions, rows 6–10 · Assumptions, rows 33–34 · Returns, rows 6–9 · Returns, rows 12–17 · Returns, rows 20–26 · Returns, rows 29–37
Equity waterfall: preferred return, catch-up, promote
How the levered cash is split between investors and sponsor
Assumptions, rows 37–39 · Waterfall, rows 6–8 · Waterfall, rows 11–16 · Waterfall, rows 19–21 · Waterfall, rows 24–26 · Waterfall, rows 29–36
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.
Build · Lab · ~12 min
Rent Roll Underwriting
Turn a rent roll into income, read mark to market and the reversion, price the first lease expiry with downtime and leasing costs probability-weighted, and state the WALT.
Read · Guide · 13 min
Real Estate Financial Modelling: Why Corporate Finance Mechanics Break Here
Read · Guide · 11 min
Credit and Covenant Modelling: What a Lender Actually Tests
Read · Guide · 11 min
Financial Modelling Best Practices: The Conventions That Make a Model Auditable
Apply · Skill
Model Audit
Find the errors in a financial model before someone senior does.
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
Real estate · Advanced
Real estate development model
Budget, construction loan, lease-up, refinance, development spread
Real estate · Core
REIT model: FFO, AFFO and NAV
FFO, AFFO, NAV per share and the cost of new equity
Infrastructure and project finance · Advanced
Project finance model
Sculpted debt, reserves, lock-up, coverage ratios
Questions about this model
Discussions open here soon.