Strategy · Multifamily · Commercial · Value-Add

Multifamily Workbench

Underwrite a small multifamily or commercial rental like an operator. Build the rent roll, model in-place vs. pro-forma income, size the value-add upside on an exit cap, and project the 30-year hold — with per-unit metrics, DSCR, and a stabilized valuation.
I.

Property

Required
sqft
II.

Purchase & Financing

Required
$
Acquisition price of the building
%
25–35% typical for commercial/MF
%
yrs
$
Title, escrow, lender fees
Common on bridge/value-add debt; leave off for a standard amortizing mortgage
III.

Rent Roll

Required
One row per unit. In-place rent is what the unit collects today; market rent is the stabilized pro-forma rent after the value-add. Uncheck occupied for a vacant unit — vacant units contribute $0 to in-place income but still count toward gross potential.
Unit Beds Baths In-place rent Market rent Occ.
$
Laundry, parking, storage, etc.
%
Applied to gross potential rent
IV.

Operating Expenses

Required
$
$
$
Common-area / owner-paid utilities
$
%
% of effective gross income
%
%
V.

Value-Add & Reposition

Required
%
Market cap on stabilized NOI
$
Cost to reach market rents
VI.

Assumptions & Outlook

Optional
%
%
%
yrs
%
✦ ✦ ✦
Returns Snapshot
Cap rate, cash-on-cash, DSCR, GRM, and per-unit metrics at a glance.
Run Analyze Deal to see the returns snapshot.
✦ ✦ ✦
Rent Roll Summary
In-place vs. pro-forma income: gross scheduled, effective gross, NOI, and economic occupancy.
Run Analyze Deal to see the rent-roll summary.
✦ ✦ ✦
Value-Add Analysis
NOI lift, stabilized value on the exit cap, value created, and yield-on-cost.
Run Analyze Deal to see the value-add upside.
✦ ✦ ✦
Cash Flow & DSCR
Monthly P&L from gross rent down to cash flow after debt service.
Run Analyze Deal to see the monthly cash-flow statement.
✦ ✦ ✦
Cash-to-Close Breakdown
Every dollar of capital required to acquire and reposition the property.
Run Analyze Deal to see the capital breakdown.
✦ ✦ ✦
Risk Analysis
Where does the deal break? Combined-shock scenarios and single-variable break-even thresholds.
Run Analyze Deal to see stress scenarios and break-even thresholds.
✦ ✦ ✦
Long-Term Wealth Projection
30-year wealth build: equity, cumulative cash flow, ROE, and a final-year sale.
Run Analyze Deal to see the wealth-build chart.