Real Estate Financial Modeling Tools

Professional Version: Housing Subdivision Development Pro-Forma Template



Academic / U.S. Military Price

To get discounted pricing, click Credentials Verification in the header and follow the instructions. Once you are approved, the discounted pricing will show.

Download the Assumptions tab in Excel (no formulas)

Download Sample PDF Reports

NOTE: If you only need to model land development and sale of lots to builders, and not vertical construction of houses, you will need this product instead.

SKU: SKU-77 Category:

An Excel-based spreadsheet analysis tool for the contract and/or speculative development and construction of housing subdivisions. The model is monthly in nature, and it is a 100% unlocked Excel file with fully transparent formulas that can be further tailored to suit the particulars of your transactions.

User-friendly Features

  • Compatible with both PC and Mac
  • Includes instructions for use, with detailed annotations tied to select cells
  • Two-page assumptions input and reporting screen optimized for dashboard-style viewing
  • Persistent calculation checks and data validation protections to prevent faulty inputs
  • Hyperlink navigation enables fast, intuitive access to all tabs
  • Institutional-quality print-ready reporting tabs that are brandable to your company
  • S-Curve distribution of Soft Costs by individual line item by each project phase
  • No circular references impacting the calculation of the construction loan size and funded interest.

Functional Highlights

The model supports the following:

  • Up to three separate phases of land development/amenities, vertical construction and sales with phase-by-phase cost and sales price inflation adjustments
  • Land loan
  • Use of pre-sales deposits towards development costs
  • Up to two layers of debt financing – Acquisition Development & Construction loan with accruing Funded Interest Reserve, and Mezzanine loan
  • Up to three joint venture equity partnership players and up to two 5-tier lookback IRR waterfalls.

Model Tabs

1    Back of the Envelope Model
2    Assumptions Input
3    Unit Mix and Pricing Input
4    Capital Structure Exhibit
5    Monthly Sources and Uses of Funds Input
6    Monthly Cash Flow Exhibit
7    Annual Sources and Uses of Funds Summary Exhibit
8    Annual Cash Flow Summary Exhibit
9    Joint Venture Partnership Structure Input
10  Waterfall #1 Exhibit
11  Waterfall #2 Exhibit
12  Joint Venture Returns Summary Exhibit – 3 Players
13  Joint Venture Returns Summary Exhibit – 2 Players
14  Land Acquisition Costs Schedule
15  Land Development Hard Costs Schedule – Phase 1
16  Land Development Hard Costs Schedule – Phase 2
17  Land Development Hard Costs Schedule – Phase 3
18  Land Development Soft Costs Schedule – Phase 1
19  Land Development Soft Costs Schedule – Phase 2
20  Land Development Soft Costs Schedule – Phase 3
21  Soft Costs Schedule – Phase 1
22  Soft Costs Schedule – Phase 2
23  Soft Costs Schedule – Phase 3
24  Vertical Construction Hard Costs Schedule – Phase 1
25  Vertical Construction Hard Costs Schedule – Phase 2
26  Vertical Construction Hard Costs Schedule – Phase 3
27  Gantt Chart Exhibit
28  Construction Bell-Shaped Curve Lookup Table

Model Timeline

30 years (expandable)


Print-ready, brandable reports are included in the model. See the Sample Reports link above.

License Type And Multiple-User Pricing

Licenses are sold on a per-user basis
Multi-user pricing quotes are available here

Included With Purchase

  • Blank template (inputs are all set to zero) and a version of the template with a sample deal loaded in
  • Standard version of the template for crisp presentation of less complex deals
  • 1 year of online ticket-based support

SPECIAL BONUS ($179 value)

Equity Joint Venture Partnership and Waterfall Modeling Bootcamp Video Tutorial included with purchase

Includes the following items, which never expire:

 Online access to an easily navigated 80-minute Video Tutorial, playable on any device including PC, Mac, phones and tablets

 PDF of the 60-slide presentation

 Accompanying fully-unlocked, annotated Excel file, compatible with both PC and Mac, with the following tabs:

  1. Preferred Return Non-Compounded Annual
  2. Preferred Return Non-Compounded Annual Solution
  3. Preferred Return Compounded Monthly
  4. Preferred Return Compounded Monthly Solution
  5. 3-Tier Annual Waterfall with Look-Back
  6. Double-Promote Profit Sharing
  7. Double-Promote Monthly Waterfall # 1 with Look-Back
  8. Exercise – Rebuild Tier #3
  9. Double-Promote Monthly Waterfall #2 with Look-Back
  10. Double Promote Returns Summary Exhibit
  11. Alternate Compounding Periods
  12. Sample Partnership Structure 1
  13. Sample Partnership Structure 2
  14. Sample Partnership Structure 3
  15. Claw-Back.
Don’t need so much horsepower?
Support Level

Standard Support, Priority Support

Registration is open for April Excel Bootcamp Webinars Register Now
left to take 50% off with coupon code: yearend50