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)
Reports
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:
- Preferred Return Non-Compounded Annual
- Preferred Return Non-Compounded Annual Solution
- Preferred Return Compounded Monthly
- Preferred Return Compounded Monthly Solution
- 3-Tier Annual Waterfall with Look-Back
- Double-Promote Profit Sharing
- Double-Promote Monthly Waterfall # 1 with Look-Back
- Exercise – Rebuild Tier #3
- Double-Promote Monthly Waterfall #2 with Look-Back
- Double Promote Returns Summary Exhibit
- Alternate Compounding Periods
- Sample Partnership Structure 1
- Sample Partnership Structure 2
- Sample Partnership Structure 3
- Claw-Back.