From source files to a priced model and live Excel workbook.
Turn the rent roll, T-12 and offering memo into a complete multifamily model. Solve for your target IRR price and export to Excel with working formulas.
Cash flow
7-year hold
Levered IRR
15.0%
Equity multiple
1.9x
Avg cash yield
6.4%
Set your target return. Get your offer price.
Enter your target IRR to solve for the highest purchase price that clears it, or type a price manually and stress-test sensitivities.
- Two-way link between purchase price and levered IRR
- Loans resize to LTV and DSCR at every price
- Sensitivity tables at ±2.5%, ±5% and ±10% steps
- Automatic working capital reserve sizing
Highest price that still hits it
$25.0M
Loan resized to match
Senior, takeout and assumable debt.
Size loans to the lower of LTV and DSCR using live SOFR and US Treasury rates, and view full monthly or annual schedules.
- Sized to the lower of LTV and DSCR
- Originated, permanent takeout and assumable loans
- Live SOFR and 5Y, 7Y and 10Y Treasury rates
- Annual and monthly amortization tables
Loan sizing · Min of LTV / DSCR
Fixed or Floating
Final loan amount
$15.1M
Operations, cash flow and LP/GP waterfall.
All inputs flow into property operations, T-12 vs. forecast cash flows and a four-tier equity promote waterfall across 5-, 7- or 10-year holds.
- Executive summary with key returns and sources & uses
- Six structured input tabs pre-filled from your files
- Nine output tabs with annual and monthly views
- Four-tier IRR waterfall with monthly compounding
Equity waterfall
4 tiers
Investor
14.0% IRR
1.8x multiple · $9.5M in
Sponsor
22.0% IRR
2.5x multiple · $1.1M in
Included with every deal
Pre-filled inputs
Assumptions populate from your files with one-click refresh.
Built-in rent comps
Compare rents by bedroom count against comps imported from the OM.
Renovation schedules
Model unit turns, downtime and rent bumps by floor plan.
Live Excel formulas
Download a complete .xlsx workbook where every output is a real formula.