Financial modeling
A live, deterministic model
Gross rent to effective gross income to NOI, then debt, returns, and downside. Change any input and the whole model recomputes in exact decimal.
The operating pro forma
Rent and expenses grow on separate curves. Every expense line can carry its own rate, alongside reserves, CapEx, and a per-unit renovation that ramps rents as units turn.
- Line-level control with a formula behind each cell
- Write live formulas: =units * 1500 * 12, =prior * 1.03
- Pin any year or any month; add custom lines
| Line | Yr 1 | Yr 2 | Yr 3 |
|---|---|---|---|
| Gross rent | 4,871 | 5,066 | 5,268 |
| Other income | 198 | 203 | 210 |
| Vacancy | (341) | (355) | (369) |
| Opex | (1,708) | (1,759) | (1,812) |
| NOI | 3,020 | 3,155 | 3,297 |
Debt, returns, and downside
Size debt on LTV, minimum DSCR, or debt yield. Layer senior and mezzanine tranches, an interest-only period, and a bridge to refinance.
- Levered and unlevered IRR, equity multiple, yield on cost
- DSCR and debt yield reported by year
- Base, upside, and downside side by side
Levered IRR
18.0%
Equity multiple
2.19x
Year-1 DSCR
1.31x
Keep exploring
Underwrite your next deal in Altyst
Bring the documents you already have.