Pro models

Real Estate Acquisition and Development Model in Excel, Pro Edition

A monthly ground-up development model over 60 months: S-curve costs, a fixed funding order, senior and mezzanine loans, a bulk sale or unit sales, and a JV waterfall. New in version 1.2: an Acquisition tab for a standing, leased property. 42 built-in checks.

Get this model inside the course: $149 instead of $99

Real Estate Modeling includes this model, with the course case on both the Acquisition and the development tabs, plus a 32-page Course Book, an Excel workbook that checks your answers and a 160-question quiz with a final exam. For $50 more than the model alone, you learn the whole analysis behind it.

Get the course with the model, $149 → · Try a module free

Enter your land, budget, timing, exit and capital stack. The workbook spends the budget month by month, funds it in a fixed order, runs the exit and splits the profit between the investor and the developer.

60-second preview, sound off: press play. Watch the full five-minute demo with narration.

Real Estate Acquisition and Development Model, Pro Edition: $99

One zip file: the model with a worked example, a blank copy and a 16-page PDF user guide. Single-user license.

Buy now, $99 →

Secure checkout by Stripe. Also in the Pro Models Bundle, $199 for the three Pro models. Want to try the method first? The free residual land valuation template stays free.

Watch the five-minute demo

  1. 0:00 Intro: a development model with no circular reference
  2. 0:27 Inputs: land, timing, exit, capital stack
  3. 1:12 Budget: hard costs on S-curves, soft costs by timing
  4. 1:48 Financing: equity, mezzanine, senior loan
  5. 2:27 Exit and returns: yield on cost, margin, IRR
  6. 3:13 JV waterfall: pref and promote
  7. 3:41 Scenarios, exit comparison, sensitivity
  8. 4:28 33 integrity checks
  9. 4:49 What you get

The example project is fictitious. AI-generated voice over real captures of the workbook. Not investment advice.

Dashboard of the Real Estate Acquisition and Development Model, Pro Edition: master check, key outputs and scenario comparison for the worked example
The Dashboard: status, key outputs, scenarios, exit strategies and JV split.

What the model does, tab by tab

The tabs run from inputs to outputs. Blue text on a pale yellow fill marks an input; every other cell is a formula.

Cover
What the model does, the color code, how to use it, conventions, financing logic, limitations, version and license.
Dashboard
Model status and master check, key outputs, scenario comparison, exit strategy comparison, JV split, sources of funds, two charts.
Acquisition
New in version 1.2. A standing, leased property on one sheet: rent roll of up to 8 tenants (NNN, base-year or gross recoveries), rollover to market with a renewal probability, NOI, a loan sized by the smallest of LTV, DSCR and debt yield, the sale at the exit cap rate, unlevered and levered IRR, and an exit cap rate sensitivity.
Inputs
Project, land, timing, contingencies, exit strategy and its assumptions, financing, JV terms; then about 35 derived settings.
Budget
Eight hard cost lines (amount, start, duration, S-curve steepness) and eight soft cost lines (fixed and/or % of hard costs, timing), with status flags.
Scenarios
The active scenario selector and the Base, Downside and Upside shifts.
Costs
Land, each hard cost line by month, contingency, each soft cost line, totals and construction progress.
Revenue
The bulk sale block (lease-up, rents, NOI, sale), the unit sales block (closings, prices, carrying costs) and the active block.
Financing
Unlevered cash flow, fees, senior and mezzanine schedules, and the funding of each month.
Cash Flow
Unlevered, equity and lender cash flows; sources and uses with two monthly proofs.
JV Waterfall
Hurdle account, tier 1, catch-up, tier 2, promote, flows by partner.
Returns
Cost, profit, metrics, returns and the JV table by partner.
Sensitivity
Equity IRR and margin on cost for 25 combinations of hard cost change and exit price change.
Checks
The master check, then 42 controls with value, rule, PASS or FAIL and what each tests.
Engine
Thirty compact replicas of the monthly model, for the scenarios, the two exit strategies and the grid. No inputs.
Monthly cash flow sheet of the Real Estate Acquisition and Development Model, Pro Edition: costs, funding and equity flows month by month
The monthly cash flow: costs, funding order and equity flows.

The worked example

The example is Maple Grove Apartments, a fictitious 200-unit rental building on a $9.0 million site: 6 months of pre-development, 22 months of construction, then lease-up and a bulk sale. Base case, amounts in $000:

MeasureValue
Development budget before financing72,684
Total development cost81,218
Development profit15,367
Margin on cost18.9%
Yield on cost6.14% (+89 bps over a 5.25% exit cap)
Unlevered IRR / multiple13.4% / 1.33x
Equity IRR / multiple17.3% / 1.56x
Peak equity27,462
LP IRR / developer IRR15.6% / 31.0%

Selling the units one by one instead of the building earns an equity IRR of 12.9% here, because the slower sell-out carries the loans longer. In the Downside (hard costs +5.0%, rents -3%, cap +25 bps, senior rate +100 bps, a 3-month delay) the equity IRR falls to 4.6%. In the grid, a 10% hard cost overrun brings it to 10.1%, a 10% lower exit price to 7.5%: the scheme is more sensitive to the exit price than to hard costs. The example and every figure in it are fictitious and illustrative.

New in version 1.2: the Acquisition tab

The example on the Acquisition tab is Harbor Point Building A, a fictitious 450,000 sq ft multi-tenant warehouse bought at a 5.25% cap rate: the loan is sized by DSCR, and the tab shows NOI year by year, the coverage path, the sale and an 8.55% unlevered and 10.60% levered IRR. It is the running case of the Real Estate Modeling course.

Acquisition tab of the Real Estate Acquisition and Development Model, Pro Edition: key outputs and inputs for a leased warehouse
The Acquisition tab: key outputs, then the inputs and the rent roll.

Who it is for

What you receive

Checks sheet of the Real Estate Acquisition and Development Model, Pro Edition: the development controls and the master check
The Checks sheet: the master check and the controls (version 1.2 adds nine for the Acquisition tab, 42 in all).

Technical notes

Questions people ask about it

Does the development model need iterative calculation?

No. The senior and mezzanine commitments are sized on the budget before financing, and interest is charged on opening balances, so there is no circular reference and no macro.

Can it model a condo sell-out as well as a build-to-rent sale?

Yes. It always calculates both exits: a bulk sale of the stabilized building at the exit cap rate, and unit sales at a monthly pace. A switch picks the one that drives financing and returns, and the Dashboard compares the two.

How is it different from the free residual land valuation template?

The free template works one development appraisal back to land value. The Pro Edition is a monthly cash flow model for a whole scheme: S-curve spending, the funding order, senior and mezzanine loans, two exit strategies, a JV waterfall, scenarios, an Acquisition tab and 42 controls. The free template stays free.

Does it work in Google Sheets?

Yes. Upload the file and open it: every function used is supported. The first recalculation can take a few seconds.

What does the model leave out?

Tax, depreciation, hedging, presales and deposits, refinancing at stabilization and a multi-tier promote. It holds up to 8 hard and 8 soft cost lines over 60 months. The guide lists every simplification.

Can I use it on a real project?

Yes, the blank copy is built for that. The license is single-user, the example project is fictitious, and nothing in the model is investment advice.

Get the Real Estate Acquisition and Development Model, Pro Edition

$99, single-user license. Download right after checkout. Digital download: no refunds once the file has been downloaded.

Buy now, $99 →

Start free with the free residual land valuation template, or read The Real Estate Development Manager, the book behind it.

Other Pro models