Articles

Real estate acquisition model, step by step (worked example)

Rent roll to NOI, NOI to price, price and NOI to the loan, then unlevered and levered cash flows and the IRR: here $45.5m, a $25.28m loan and a 10.60% levered IRR.

A real estate acquisition model has six steps: build year-1 NOI from the rent roll, price it at a cap rate, size the loan as the smallest of LTV, DSCR and debt yield, project cash flows with rollovers and capital costs, value the exit on next year's NOI, and compute unlevered and levered IRR. On a 450,000 sq ft warehouse bought for $45.5m, that gives 8.55% unlevered and 10.60% levered.

Step 1: NOI from the rent roll

Scheduled rent of $2,904k plus $688k of recoveries, less 1 per cent vacancy and credit loss, gives effective gross revenue of $3,557k. Operating expenses of $1,169k leave year-1 NOI of $2,388k.

Step 2: the price

Price = NOI / going-in cap rate = $2,388k / 5.25% = $45.5m ($101.11 per sq ft)

Acquisition cost with 1.5% closing costs: $46.18m

Step 3: the loan

Three lender limits, $m.
LimitMaximum loan
60% loan-to-value27.30
1.30x DSCR on a 6.00%, 30-year payment (debt constant 7.265%)25.28
8.0% debt yield29.85
Loan: the smallest25.28

DSCR binds, so the loan is 55.6% of the price. Equity at closing is $21.15m.

Build this model yourself, with checked answers: Real Estate Modeling

A course built on one logistics park, from the rent roll to the loan, the returns, a development, the JV waterfall and quarterly NAV, with Excel exercises, a 160-question quiz and the Real Estate Acquisition and Development Model, Pro Edition included ($149).

Try module 4 and ten quiz questions, free →

Step 4: the cash flows

Cash flow before debt, debt service and levered cash flow, $000.
YearBefore debtDebt serviceLevered
12,3431,517826
22,4221,517905
32,5041,517987
41,6101,837-227
52,7261,837889
62,5171,837681
73,1681,8371,332
81,6591,837-177
93,4931,8371,657
102,8691,83746,381

Two years stand out: the year a large tenant rolls (downtime, free rent, improvements and commissions) and the year amortization starts after 3 years of interest only. In year 4 both happen and the DSCR falls to 1.21x.

Step 5: the exit

Year-11 NOI of $3,966k at a 5.75% exit cap rate gives $69.0m, or $67.9m after 1.5% selling costs. It sits in year 10 of both cash flow lines; the loan balance is repaid from it on the levered side.

Step 6: the returns

Unlevered IRR 8.55%; levered IRR 10.60%; equity multiple 2.52x; year-1 cash-on-cash 3.90%, below the 5.07% all-cash yield: leverage is negative in year 1 and positive over the hold.

The trap: valuing the exit on year-10 NOI. A buyer pays for the income to come, so the exit uses year-11 NOI, which is why a model runs one year past the hold.

Sources

  1. Julian R. Sterling, Real Estate Modeling (course, 2026): running case Harbor Point Logistics Park
  2. Julian R. Sterling, Commercial Real Estate Investing
  3. Free commercial real estate underwriting model (Excel)

Every figure is computed by script from the running case of the Real Estate Modeling course, Harbor Point Logistics Park, a fictional logistics park, and checked on 17 November 2026. For education, not investment advice.

Learn the whole method: Real Estate Modeling

A course built on one logistics park, from the rent roll to the loan, the returns, a development, the JV waterfall and quarterly NAV, with Excel exercises, a 160-question quiz and the Real Estate Acquisition and Development Model, Pro Edition included ($149).

Try module 4 and ten quiz questions, free →

Questions readers ask

What are the steps of a real estate acquisition model?

NOI from the rent roll, price at a cap rate, loan sizing, cash flows with rollovers and capital costs, exit value on next year's NOI, then unlevered and levered IRR.

Which NOI is used for the exit value?

The NOI of the year after the sale, because the buyer pays for the income it will receive.

How is the acquisition loan sized?

As the smallest of loan-to-value, DSCR and debt yield limits; when the cap rate is below the cost of debt, DSCR usually binds.

Why can levered cash flow be negative in some years?

Leasing costs of a rollover, downtime and the start of amortization can exceed the cash left after debt service.

Read the whole case

Commercial Real Estate Investing by Julian R. Sterling takes the method from first principles, with free companion workbooks where every figure is a live formula.

Get the book on Amazon →Free companion files

Prefer a PDF? Get the PDF edition, $19.99

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.

Also on this site

All 1908 articles →