Articles

Trended vs untrended yield on cost (worked example)

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.

The two definitions

One speculative warehouse, five suites, $000.
MeasureUntrendedTrended
Stabilized NOI1,912.52,069.3
Total development cost31,634.131,634.1
Yield on cost6.05%6.54%
Spread over a 5.25% exit cap rate80 bps129 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.

Which one to use

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.

Model the whole development, month by month: 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 →

How to calculate both

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.

What else to check

Sources

  1. Julian R. Sterling, Real Estate Modeling (course, 2026): running case Harbor Point Logistics Park
  2. Julian R. Sterling, The Real Estate Development Manager

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 is untrended yield on cost?

Stabilized NOI at today's market rents divided by total development cost, with no rent growth assumed.

What is trended yield on cost?

Stabilized NOI including the rent growth expected until the building stabilizes, divided by total development cost.

What is a good development spread?

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.

Does yield on cost include financing costs?

Total development cost should include interest and loan fees; otherwise the yield is overstated.

Read the whole case

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.

Also on this site

All 1908 articles →