An Excel-based analysis tool for either the development and sale of a single detached housing unit (aka a “spec home”), or the building of a new personal residence. 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
- Persistent calculation checks and data validation protections to prevent faulty inputs
Model Functional Highlights
The model supports the following:
- Distribution of soft cost budget allocations for pre-, during and post-construction periods
- Automated distribution of hard construction costs based on a bell-shaped curve
- Interest-only and construction-to-perm loans.
Model Tabs
1 Assumptions Input
2 Development Sources and Uses of Funds
3 Monthly Cash Flow
4 Hard Costs Budget
5 Soft Costs Budget
6 Monthly Construction Bell Curve Lookup Table
7 Monthly Amortization Schedule
Model Timeline
10 years (expandable)
Reports
Print-ready, brandable reports are included in the model. See the Sample Reports link above.
Included With Purchase
One year of email ticket-based support.