Articles

How to learn real estate financial modeling: the eight skills, in order

Learn the rent roll and NOI first, then value, debt and returns, and only then development and joint venture waterfalls: each skill uses the previous one.

Learn real estate financial modeling in eight steps, in this order: rent roll and NOI, value, debt, acquisition returns, the exit, development, the joint venture waterfall, and asset management. Each step uses the numbers of the previous one, so practice all eight on one property: a model built on a single case teaches more than ten disconnected exercises.

Most people start with the IRR formula or a waterfall template. That is backwards. An IRR is only as good as the NOI behind it, and a waterfall only splits the cash a model has already produced. The sequence below is the one deal teams use, shown on one fictional logistics park so every figure can be checked.

The eight skills of a real estate model, in order

Each skill on the same case: Harbor Point Logistics Park (fictional).
SkillWhat you learn, on the case
1. Rent roll and NOITurn leases into net operating income: rent, recoveries under NNN, base-year and gross leases, vacancy, expenses. On the case, four tenants in 450,000 sq ft produce year-1 NOI of $2,388k. Read more.
2. ValueDivide stabilized NOI by a cap rate, then check it with a DCF. At 5.25%, the case's NOI is worth $45.5m, $101.11 per sq ft. Read more.
3. DebtSize the loan as the smallest of loan-to-value, DSCR and debt yield. Here DSCR binds: $25.28m, 55.6% LTV, not the 60% the lender allows. Read more.
4. Acquisition returnsBuild unlevered and levered cash flows over the hold: here 8.55% unlevered, 10.60% levered, a 2.52x equity multiple. Read more.
5. Sale and exit valueValue the sale on next year's NOI at an exit cap rate, less selling costs: $69.0m gross at 5.75%. About 65% of the value comes from the sale, so this is the assumption to test first. Read more.
6. DevelopmentSpread a budget on S-curves, fund it with equity then a construction loan, capitalize interest, and judge it on yield on cost: 6.05% untrended on a $31.6m warehouse. Read more.
7. Joint venture waterfallSplit distributions between a capital partner and the sponsor: return of capital, a preferred return, a catch-up and a promote. Read more.
8. Asset management and valuationCompare actuals with the budget, test the assumptions that move the return, and value the equity every quarter as value less debt. Read more.

Why NOI comes first

Value, debt and returns are all multiples or yields of NOI. If the NOI is wrong by 5 per cent, so is the value and so is the loan. On the case, in-place rents average $6.45 per sq ft against a $7.00 market rent: modeling each rollover to market is what makes the NOI grow faster than the market, and that is a rent roll skill, not a spreadsheet trick.

Learn the eight skills on one case: 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 long it takes

With Excel already familiar, the eight skills take five to ten hours of focused work on a single case, then practice on your own deals. The trap is speed without checks: every model should prove that sources equal uses, that the loan is repaid, and that levered cash flow equals unlevered cash flow less the lender's flows. A model that cannot show those three proofs is not ready to show anyone.

The trap: copying a template and changing the inputs. You learn the inputs, not the logic, and the first deal that does not fit the template breaks the model.

Free and paid ways to learn

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 should I learn first in real estate modeling?

The rent roll and NOI. Value, debt and returns are all built on NOI, so errors there flow through the whole model.

Do I need to know Excel well to learn real estate modeling?

Basic Excel is enough to start: IRR, SUMPRODUCT, MIN and MAX cover most of a property model. The hard part is the logic, not the functions.

How long does it take to learn real estate financial modeling?

Five to ten hours of focused work on one complete case teaches the eight core skills; fluency comes from building models on real deals afterwards.

Is acquisition or development modeling harder?

Development, because costs, financing and interest move month by month and interact. Learn acquisitions first.

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 →