IMOpen the Calculator
← Back to examples
ExampleFictional example for demonstration — not a live listing. Numbers are illustrative.
Phoenix, AZ·garden

Sunbelt Trails

5600 W Camelback Rd, Phoenix, AZ 85031

Units88
Year built2005
Asking price$15,840,000
Price / unit$180,000
Data sourceMANUAL

Operating snapshot (as reported, before your assumptions)

Gross scheduled income$1,320,000
Other income$40,000
Vacancy5.0%
Effective gross income$1,294,000
Operating expenses$520,000
Expense ratio40%
Net operating income$774,000
Going-in cap rate4.9%

Model this deal

Adjust financing and growth assumptions below. Changes affect only your analysis — the underlying listing is never modified.

Assumptions

Adjust any input — results update instantly.

Property
Financing
Cash invested & reserves

Closing costs, upfront improvements, and initial reserves are added to total cash invested (they raise the cash-on-cash denominator). The annual capex reserve reduces cash flow but not NOI or cap rate — a common convention is $250–$300 per unit per year (≈ $24,200/yr here). It defaults to $0.

Growth
Model improvements (value-add)

Renovation rent premium, operational uplift, and general market-rent growth are counted separately — never combined. A large current-to-proposed rent gap is an assumption to confirm, not proof.

Downside scenario

A scenario, not a forecast.

Cap Rate4.9%
Cash-on-Cash-10.4%
DSCR0.76
Debt Yield5.7%
NOI$774,000Before reserves & debt service
Cash Flow (after reserves)i-$247,220After $0/yr reserve ($0/unit)
Monthly Debt Service$85,102
Break-even Occupancy113%
Price / Unit$180,000
Total Cash Invested$2,376,000
Loan Amount$13,464,000
Balloon at Maturity$12,173,643Due in year 7

5-year projection

Cash flow is after debt service and the annual capex reserve. Debt service is held at the current payment; the loan balloon is due in year 7.

YearNOICash Flow
Year 1$774,000-$247,220
Year 2$819,230-$201,990
Year 3$866,755-$154,464
Year 4$916,686-$104,534
Year 5$969,136-$52,083

What the numbers say

An assessment of how this deal reads under the assumptions above — not an endorsement, recommendation, or suitability determination.

Current incomeConcern

Weak for current income — cash flow does not cover debt service (DSCR 0.76). It would need a lower price, more equity, or higher income to work under these assumptions.

  • • Annual cash flow after reserves: -$247,220.
Value-add potentialNot assessed

Not yet modeled. Open “Model improvements” and add renovation scope, costs, and target rents to assess the upside.