Panel vintageSeptember 1, 202653 synthetic assetsDemonstration data — no real listings, no addresses
Parcel
Contact the desk

ALH-03

Alhambra · Phoenix, AZ 85017 · Fourplex · 4 doors

ActiveFourplexBuilt 1965
Asking
$512,000
Est. rent / mo
$4,820
Est. cap rate
7.02%
Est. cash-on-cash
4.30%
Est. DSCR
1.20
Rent / price
0.941%
$ / sq ft
$210
Est. cash flow / mo
$505

At the baseline set: 25% down, 6.75%, 30-year amortisation. Estimates.

Representative stock photograph — two-storey walk-up elevation with an exterior stair. Not a photograph of any asset in this panel.
Representative stock photograph — renovated kitchen with quartz counters and vinyl plank flooring. Not a photograph of any asset in this panel.
Representative stock photograph — vacant living area with vinyl plank flooring and a slider to the patio. Not a photograph of any asset in this panel.
Representative stock photograph — renovated bathroom with a tiled tub surround. Not a photograph of any asset in this panel.
Representative stock photograph — exterior condenser units on a gravel pad. Not a photograph of any asset in this panel.

Representative stock photography of Phoenix-metro residential product. These are not photographs of this asset — there is no such asset. This panel publishes a code and a submarket and nothing finer, because a plausible house number on a real street is a real house, and putting an invented price under a photograph of one is the thing this whole demonstration exists to avoid.

The read

Small-unit fourplex, roughly 610 sq ft per door. High rent per square foot, high turnover; the underwriting below runs an 8% vacancy assumption rather than the panel default.

  • Four 1/1 units
  • Owner-paid water
  • Fenced courtyard
  • On-site laundry

Facts

Physical
Property typeFourplex
Units4
Bedrooms / bathrooms4 / 4
Living area2,440 sq ft
Lot9,147 sq ft
Year built1965 (61 yrs)
Stories1
ParkingOpen, 5 spaces
Panel codeALH-03
LocationAlhambra, Phoenix 85017
Carry — estimated
Property tax / yr$2,970
Insurance / yr$2,680
HOA / moNone
Other fixed / yr$1,900
Total est. operating / yr$18,424
HVAC installed2014
Roof installed2015
Water providerCity of Phoenix
FEMA flood zoneZone X

Underwrite it

Every figure below recomputes as you move an input. Nothing is rounded until it is printed, and operating expenses never include debt service — that separation is what makes the cap rate a property of the building and the cash-on-cash a property of your deal. All outputs are estimates.

Purchase & financing
Income
Operating expenses

Monthly cash flow

+$505

after debt service, before tax

Cap rate

7.02%

NOI ÷ purchase price

Cash-on-cash

4.30%

cash flow ÷ cash invested

DSCR

1.20

NOI ÷ annual debt service

Where the gross rent goes

  • Vacancy$3,470
  • Operating$18,424
  • Debt service$29,887
  • Cash flow$6,058
Annual income statement — estimated
Gross scheduled income$57,840
Less vacancy & credit loss−$3,470
Effective gross income$54,370
Less fixed operating−$7,550
Less variable operating−$10,874
Net operating income$35,946
Less annual debt service−$29,887
Pre-tax cash flow$6,058
Loan amount$384,000
Monthly principal & interest$2,491
Cash invested$140,800
Operating expense ratio33.9%
Break-even occupancy83.5%
Gross rent multiplier8.9
Rent-to-price ratio0.941%

Estimated figures produced by a model from the assumptions on the left. Not an offer, an appraisal, a loan quote or investment advice. Taxes, insurance and operating expenses are estimates; verify each before you commit capital.

What it would have to cost

The asking price against three solved thresholds

Rent and every operating line held exactly as stated; only the purchase price moves. Each mark is the price that solves one condition. Nothing here is a price history: this asset has none, and inventing one would be the easiest dishonest thing on the page.

Solved prices, holding rent and operating expenses fixed. At the asking price this asset computes to a 7.02% cap rate, 4.30% cash-on-cash and a DSCR of 1.20.
ConditionPricevs askWhat it means
Current asking price$512,000—The number on the panel. Everything below is measured against it.
DSCR 1.00$616,000+20.3%net operating income exactly covers the mortgage; cash flow is zero
Submarket median cap (5.82%)$617,500+20.6%the price at which this asset yields what its submarket already yields
Leverage turns (5.84%)$616,000+20.3%above this cap rate the loan adds to the return instead of subtracting from it

Asking price carried on the submarket index

The current asking price projected backwards on the Alhambra median-price index. Arithmetic on two synthetic series — not an appraisal, not a price history and not a record of any transaction.

Comparables

Rent is compared per unit, which is the only fair basis across a house and a fourplex. The subject sits 13.9% below the median of its five closest comparables.

Monthly rent per unit

Drawn from the panel itself, ranked by product family, unit size, bedroom count and proximity at the resolution this data has: same submarket, then same city.

  • ALH-03Subjectsubject · 4/4 · 610 sq ft/unit
    $1,205
  • ALH-05Same submarket · 4/4 · 820 sq ft/unit
    $1,485
  • ENC-03Same city · 6/6 · 697 sq ft/unit
    $1,400
  • ALH-04Same submarket · 2/2 · 880 sq ft/unit
    $1,540
  • GLC-06Elsewhere in metro · 8/8 · 640 sq ft/unit
    $1,120
  • WMS-03Elsewhere in metro · 4/4 · 760 sq ft/unit
    $1,330
Table
Monthly rent per unit — full data. Drawn from the panel itself, ranked by product family, unit size, bedroom count and proximity at the resolution this data has: same submarket, then same city.
ComparableDetailRent / unit / mo
ALH-03 (subject)subject · 4/4 · 610 sq ft/unit$1,205
ALH-05Same submarket · 4/4 · 820 sq ft/unit$1,485
ENC-03Same city · 6/6 · 697 sq ft/unit$1,400
ALH-04Same submarket · 2/2 · 880 sq ft/unit$1,540
GLC-06Elsewhere in metro · 8/8 · 640 sq ft/unit$1,120
WMS-03Elsewhere in metro · 4/4 · 760 sq ft/unit$1,330
Price comparables — 4 nearest assets of the same product type
AssetSubmarketProximityAskSq ft$ / sq ft
ALH-03 SubjectAlhambra—$512,0002,440$210
ALH-05AlhambraSame submarket$674,0003,280$205
GLC-04Glendale CentralElsewhere in metro$706,0003,520$201
PRS-03Peoria SouthElsewhere in metro$612,0003,120$196
WMS-03West MesaElsewhere in metro$552,0003,040$182

Sensitivity

What a five-percent move in price or fifty basis points on the rate does to the return. Computed at the baseline assumption set, not at whatever you have set the calculator to — it is a fixed reference.

Sensitivity — cash-on-cash by price and rate

Every other assumption held at the baseline set. A fixed reference, not tied to the calculator above. Estimates.

Cash-on-cash return by purchase price and interest rate
Price \ Rate5.75%6.25%6.75%7.25%7.75%
$471,000−8%8.7%7.6%6.5%5.4%4.3%
$491,500−4%7.5%6.4%5.4%4.3%3.1%
$512,000ask6.4%5.4%4.3%3.2%2.1%
$532,500+4%5.4%4.4%3.3%2.2%1.1%
$553,000+8%4.5%3.5%2.4%1.3%0.2%

Cash-on-cash0.2% → 8.7%

What to check before you commit

  • HVAC

    Condenser installed 2014, 12 years old. Inside normal service life for this climate, so the CapEx reserve carries it rather than a year-one line item.

  • Roof

    Roof dates to 2015, 11 years old — inside the window most carriers will write without a surcharge.

  • Flood

    FEMA Zone X. Outside the mapped special flood hazard area; a lender will not require separate flood coverage.

  • Water allocation

    Served by City of Phoenix. Long-run Colorado River and Central Arizona Project allocation is a genuine risk to price on the metro’s growth edges over a 10-to-20 year hold. It is a discount-rate question, not a next-quarter question.

  • No HOA

    No association. Nothing constrains rental use at the community level, and there is no fixed monthly charge in the expense line.