Courses · Real estate

Real Estate Modeling: underwrite, develop and share the profits of a commercial property

A complete course on the work of a real estate investment analyst, built around one logistics park: rent roll and NOI, value, the acquisition loan, levered returns, a ground-up development and its construction loan, the joint venture waterfall, and quarterly valuation.

$149, with the Real Estate Acquisition and Development Model, Pro Edition ($99 on its own)

Eight modules in a 32-page Course Book, an Excel workbook that checks your answers, a 160-question quiz app with a timed final exam and a certificate, and the full Pro model with the course case. Download right after payment.

Get the course, $149 →

Secure checkout by Stripe. Managing several properties in a fund? add the Real Estate Fund Model, Pro Edition for $80 more ($229 in total). Not sure yet? Try a free module and ten quiz questions below.

Most real estate courses stop at a single spreadsheet of one building. This one follows a property the way a deal team does: is the income real, what is it worth, how much can we borrow, what do we earn and from what, does building beat buying, who earns what in the partnership, and what is it worth every quarter after closing.

What you will be able to do

The program

Each module has objectives, the lesson, a worked example step by step, the classic mistakes, a summary, three practice questions, one exercise tab and twenty quiz questions.

Try it free

A full module. Module 4, on sizing the acquisition loan, as it appears in the Course Book: download the free sample (PDF).

Ten quiz questions. Click an answer: it turns green or red and the explanation appears. The questions use the running case:

Harbor Point Logistics Park, Building A (fictional): 450,000 sq ft, four tenants, year-1 NOI $2.388m, bought for $45.5m at a 5.25% cap rate. Loan at 6.00%, 30-year amortization; lender limits: 60% LTV, 1.30x DSCR, 8.0% debt yield. Building B: a 250,000 sq ft warehouse built next door.

Module 1

1. Building A's year-1 NOI is $2.388m. At a 5.25% going-in cap rate, what is it worth?

Answer: $45.48m. Value = NOI / cap rate = $2.388m / 5.25% = $45.48m. Capitalizing EGR instead of NOI overstates the value.

Module 2

2. What is year-1 NOI?

Answer: $2,387.7k. EGR $3,556.6k less total operating expenses $1,168.9k = $2,387.7k. Capital reserves are below NOI.

Module 3

3. Year-11 NOI is $3.966m. At a 5.75% exit cap rate, what is the gross sale price?

Answer: $68.98m. $3.966m / 5.75% = $68.98m. Year-10 NOI is the trailing year; the buyer pays for the next one.

Module 4

4. What is the debt constant of a 6.00% loan amortizing over 30 years with annual payments?

Answer: 7.265%. 6.00% / (1 - 1.06^-30) = 7.265%. Rate + 1/30 overstates it: principal grows over time.

Module 4

5. What is the maximum loan from a 1.30x DSCR on year-1 NOI of $2.388m?

Answer: $25.28m. $2.388m / (1.30x x 7.265%) = $25.28m. Sizing on interest only ($30.61m) ignores amortization.

Module 4

6. Which limit binds, and what is the loan?

Answer: DSCR, $25.28m. The loan is the smallest of the three limits.

Module 4

7. What is the debt yield at closing?

Answer: 9.44%. $2.388m / $25.281m = 9.44%.

Module 5

8. What is the levered IRR?

Answer: 10.60%. IRR of minus the equity, the cash flows after debt service and the sale net of the loan repayment.

Module 6

9. What is Building B's trended yield on cost (forward NOI at the sale)?

Answer: 6.54%. $2,069k / $31,634k = 6.54%. Use the total cost including financing. Untrended, on today's rents, it is 6.05%.

Module 7

10. What is the GP's promote?

Answer: $1,721k. 50% x $1,435k + 20% x $5,015k = $1,721k, 20% of the profit.

Inside the course

Exercise Workbook, module 4: given data in blue, answers in yellow and automatic Correct checks for the acquisition loan
The Exercise Workbook: one tab per module, your answers in yellow, an automatic check, a hidden solution built with live formulas.
Quiz App: a module 4 question on DSCR loan sizing with the explanation after the answer
The Quiz App: 160 questions with explanations, a timed final exam of 40 questions and a case, and a printable certificate from 70%. It runs offline.
Acquisition tab of the Real Estate Acquisition and Development Model, Pro Edition, with the course case: key outputs and inputs
The new Acquisition tab of the Real Estate Acquisition and Development Model, Pro Edition, included: the course case on one sheet.

What you receive

FileWhat it is
Course_Book.pdfEight modules, 32 pages: lesson, worked example, pitfalls, summary, practice questions, glossary and dated sources.
Exercise_Workbook.xlsxEight exercise tabs, 66 answers checked automatically, eight hidden solution tabs.
Quiz_App.html160 questions, practice by module with explanations, timed final exam, score by module, certificate.
RE_Acquisition_and_Development_Model_ProThe course case workbook (both buildings), the Pro model with its worked example, a blank copy and a 16-page user guide.
Start_Here.pdfThe order to use it all in, on one page.

The running case

Harbor Point Logistics Park is a fictional logistics park near Dallas-Fort Worth. The sponsor buys Building A, a leased warehouse, holds it ten years, and builds Building B on the excess land with a pension plan as partner:

MeasureValue
Building A: price / per sq ft / going-in cap rate$45.5m / $101.11 / 5.25%
Acquisition loan (DSCR binds) / loan-to-value$25.28m / 55.6%
Unlevered IRR / levered IRR / equity multiple8.55% / 10.60% / 2.52x
Building B: total cost / yield on cost, untrended and trended$31.6m / 6.05% and 6.54%
Building B: equity IRR / GP share of profit28.6% / 28.0%

Questions people ask

Who is the course for?

Analysts and associates joining a real estate private equity, REIT, debt fund or development team, brokers and lenders who want to model deals themselves, and students preparing for real estate interviews. You need basic Excel and a first idea of what NOI is.

How long does it take?

Most learners need four to eight hours: about thirty minutes to an hour per module for the reading, the exercise tab and the practice quiz, then the final exam.

Is there video?

No. This edition is a written course with live Excel workbooks and a quiz app.

What do I get exactly?

One zip file: the Course Book (PDF), the Exercise Workbook (Excel), the Quiz App (a single HTML file that runs offline in any browser), the Real Estate Acquisition and Development Model, Pro Edition with the course case workbook, a blank copy and its user guide, and a one-page Start Here guide.

Does it cover acquisitions or developments?

Both, on one fictional logistics park: an existing multi-tenant warehouse bought and held ten years (modules 2 to 5 and 8), then a speculative warehouse built on the excess land in a joint venture (modules 6 and 7).

I already bought the Development Model, Pro Edition. Do I get the new version?

Yes. Version 1.2 adds the Acquisition tab and is the file you now download from your purchase email link. The course adds the book, the exercises, the quiz and the course case workbook.

Which software do I need?

A PDF reader, Excel (LibreOffice and Google Sheets also work) and a web browser. No macros, no add-ins, no account to create.

Is the certificate a professional qualification?

No. The Quiz App prints a certificate of completion when you score 70% or more on the final exam. It shows the work you did, it is not a license or an accredited qualification.

Can I get a refund?

It is a digital download delivered immediately, so the right of withdrawal ends at delivery, as the checkout explains. If a file is faulty, write to [email protected] and it will be fixed or refunded. Details in the terms of sale.

Is it investment advice?

No. The park, its tenants, the sponsor, the partners and every deal are fictional. The course teaches the analysis and the modeling; it does not recommend any investment. It was prepared with AI assistance and every figure is computed and checked by script.

Real Estate Modeling: $149

The course, the exercises, the quiz and the Real Estate Acquisition and Development Model, Pro Edition. Download right after payment.

Get the course, $149 →

With the Real Estate Fund Model, Pro Edition too: $229 in total. Both courses, Real Estate and Private Credit Modeling: $249. Only need the model? $99 on its own.

Related