Untrended yield on cost divides NOI at today's rents by total cost; trended uses the NOI expected when the building stabilizes. On one warehouse they give 6.05% and 6.54%.
Yield on cost is stabilized NOI divided by total development cost. Untrended yield on cost uses NOI at today's market rents; trended yield on cost uses the NOI expected at stabilization, after rent growth during construction and lease-up. On a 250,000 sq ft warehouse costing $31.6m, untrended is 6.05% and trended 6.54%: a 80 or 129 basis point spread over a 5.25% cap rate.
| Measure | Untrended | Trended |
|---|---|---|
| Stabilized NOI | 1,912.5 | 2,069.3 |
| Total development cost | 31,634.1 | 31,634.1 |
| Yield on cost | 6.05% | 6.54% |
| Spread over a 5.25% exit cap rate | 80 bps | 129 bps |
The untrended NOI is 5 suites at $8.00 per sq ft net, less owner's costs of $0.35. The trended NOI is the forward year after the sale in month 31, with rents growing 3.0% a year from day one.
Developers usually quote their hurdle, often 100 to 150 basis points over the cap rate, on an untrended basis, because rent growth is the uncertain part. On that basis this building falls short: rents must be 3.4% higher today for an untrended spread of 100 basis points. Trended, it clears 129. The difference is a bet on rent growth during construction, which the committee should take knowingly rather than inside a single number.
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).
Untrended yield on cost = NOI at today's rents / total development cost = 1,912.5 / 31,634.1 = 6.05%
Trended yield on cost = NOI at stabilization / total development cost = 2,069.3 / 31,634.1 = 6.54%
Total development cost includes land (3,552), hard costs (22,050), soft costs (4,074) and interest and fees (1,958).
The trap: comparing a trended yield on cost with an untrended hurdle, or with the cap rate of an older building. Say which basis you use, and compare like with like.
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).
Stabilized NOI at today's market rents divided by total development cost, with no rent growth assumed.
Stabilized NOI including the rent growth expected until the building stabilizes, divided by total development cost.
Developers commonly target 100 to 150 basis points of untrended yield on cost over the cap rate at which the finished building would sell; the right figure depends on risk.
Total development cost should include interest and loan fees; otherwise the yield is overstated.
The Real Estate Development Manager 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.