Financial Model
An interactive pro forma for evaluating construction, financing, operations, and sale assumptions over 5, 10, and 15 year hold periods.
Scenario Presets
Use presets to jump between conservative, base, and aggressive assumptions.
View Controls
Switch between hold periods and display granularity.
Model Inputs
Adjust the core development, financing, and operating assumptions.
Assumption Snapshot
- LTC
- 75.0%
- Vacancy
- 8.0%
- Expense ratio
- 25.0%
- Exit recapture
- 65.0%
Equity Invested
$105,000
Total Interest
$186,211
Stabilized NOI
$25,595
Net Sale Proceeds
-$48,650
Total Net Cash Flow
-$80,843
Cash Flow Trends
Net cash flow and cumulative cash flow across the selected timeline.
Exports
Download the currently displayed pro forma data as CSV.
Results Table
Detailed cash flow output for the selected view.
| Period | Phase | Draw | Interest | NOI | Debt Service | Net CF | Cumulative CF |
|---|---|---|---|---|---|---|---|
| Year 1 | construction | $300,000 | $9,141 | $0 | $9,141 | -$84,141 | -$84,141 |
| Year 2 | operations | $50,000 | $19,570 | $19,029 | $19,570 | -$13,041 | -$97,182 |
| Year 3 | operations | $0 | $19,687 | $25,908 | $19,687 | $6,221 | -$90,961 |
| Year 4 | operations | $0 | $19,687 | $26,448 | $19,687 | $6,760 | -$84,201 |
| Year 5 | operations | $0 | $19,687 | $26,990 | $19,687 | $7,303 | -$76,899 |
| Year 6 | operations | $0 | $19,687 | $27,535 | $19,687 | $7,848 | -$69,051 |
| Year 7 | operations | $0 | $19,687 | $28,081 | $19,687 | $8,394 | -$60,657 |
| Year 8 | operations | $0 | $19,687 | $28,629 | $19,687 | $8,941 | -$51,716 |
| Year 9 | operations | $0 | $19,687 | $29,176 | $19,687 | $9,488 | -$42,228 |
| Year 10 | sale | $0 | $19,687 | $29,722 | $19,687 | -$38,616 | -$80,843 |