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.
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.
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
| Limit | Maximum loan |
|---|---|
| 60% loan-to-value | 27.30 |
| 1.30x DSCR on a 6.00%, 30-year payment (debt constant 7.265%) | 25.28 |
| 8.0% debt yield | 29.85 |
| Loan: the smallest | 25.28 |
DSCR binds, so the loan is 55.6% of the price. Equity at closing is $21.15m.
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).
| Year | Before debt | Debt service | Levered |
|---|---|---|---|
| 1 | 2,343 | 1,517 | 826 |
| 2 | 2,422 | 1,517 | 905 |
| 3 | 2,504 | 1,517 | 987 |
| 4 | 1,610 | 1,837 | -227 |
| 5 | 2,726 | 1,837 | 889 |
| 6 | 2,517 | 1,837 | 681 |
| 7 | 3,168 | 1,837 | 1,332 |
| 8 | 1,659 | 1,837 | -177 |
| 9 | 3,493 | 1,837 | 1,657 |
| 10 | 2,869 | 1,837 | 46,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.
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.
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.
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.
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).
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.
The NOI of the year after the sale, because the buyer pays for the income it will receive.
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.
Leasing costs of a rollover, downtime and the start of amortization can exceed the cash left after debt service.
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.