Community Feasibility Model
A ten-year financial model for a founding group: land, build, financing, buy-ins, dues, reserves, and what happens when two households leave in year three.
What you get
- Downloadable spreadsheet (XLSX)
- Sources and uses breakdown
- Capital stack analysis
- 10-year monthly and annual cash flow projections
- Occupancy ramp modeling
- DSCR and breakeven household calculations
- Reserve balance tracking
- Sensitivity tables: land cost, construction cost, occupancy rate, dues, and interest rate
- Two-household-exit stress case built in
- Assumptions page with version number
Inputs you provide
Land price, acres, closing and predevelopment costs, sitework, utilities, septic and water, unit count, cost per unit, common building cost, contingency percent, financing type, debt amount, interest rate, amortization period, construction start date, occupancy ramp months, target households, buy-in amount, monthly dues, rental income, operating cost categories, reserve percent, and inflation rate.