Single-Asset Scenario Planner
The Meridian at Legacy · Plano, TX · Vintage 2016. Adjust the assumptions and every output recomputes live.
Scenario Assumptions
Rent growth5.00%
Occupancy96.4%
OpEx ratio41.0%
Market cap rate5.00%
Exit cap = market cap + 0.05% per year of hold. Computed exit cap: 5.50%
Interest rate6.400%
Hold period10 years
Replacement reserves$275 / unit / yr
Below the NOI line. Reduces cash flow and cash-flow returns only, never NOI, valuation, or DSCR.
Acquisition costs1.5%
Closing costs paid in cash at purchase. Raises the initial investment basis for IRR, equity multiple, and cash-on-cash only.
Disposition costs2.0%
Selling costs at exit (broker, legal, transfer). Nets against gross sale proceeds in the return calcs; the Implied Value chart still shows gross value.
Itemized OpEx (20-line chart of accounts)Milestone 2
Affordable / LIHTC modeMilestone 2
Current Valuation$110.9MYear-1 NOI at 5.00% cap
Annual NOI$5.55MYear 1, net operating income
DSCR1.25NOI / annual debt service
Monthly Cash Flow$86,808NOI less debt service
Levered IRR11.7%10-year hold, after debt
Unlevered IRR9.3%10-year hold, all-cash
Equity Multiple2.76xTotal distributions / equity
Cash-on-Cash2.2%Year-1 levered cash / equity
Annual Levered Cash Flow
Operating cash flow on the left axis, net sale proceeds (year 10) on the right.
Implied Value by Exit Year
What if?
$/ month
+$1,000 / month in NOI = +$240,000 in asset value at a 5.00% cap.
Unit Mix280 units
| Floorplan | Units | Market Rent | Avg SF | Rent / SF |
|---|---|---|---|---|
| 1BD | 84 | $2,300 | 822 | $2.80 |
| 2BD | 140 | $2,950 | 1,112 | $2.65 |
| 3BD | 56 | $3,400 | 1,326 | $2.56 |