ALH-01
Alhambra · Phoenix, AZ 85017 · Single-family
- Asking
- $372,000
- Est. rent / mo
- $2,125
- Est. cap rate
- 4.03%
- Est. cash-on-cash
- -6.59%
- Est. DSCR
- 0.69
- Rent / price
- 0.571%
- $ / sq ft
- $246
- Est. cash flow / mo
- -$562
At the baseline set: 25% down, 6.75%, 30-year amortisation. Estimates.
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
Turnkey. Nothing here needs doing, which is exactly why the yield is thin — you are paying the previous owner for the rehab margin.
- Recent full renovation
- New electrical panel (2022)
- Xeriscaped
- No HOA
Facts
| Property type | Single-family |
|---|---|
| Units | 1 |
| Bedrooms / bathrooms | 3 / 2 |
| Living area | 1,512 sq ft |
| Lot | 7,100 sq ft |
| Year built | 1961 (65 yrs) |
| Stories | 1 |
| Parking | 2-car carport |
| Panel code | ALH-01 |
| Location | Alhambra, Phoenix 85017 |
| Property tax / yr | $2,160 |
|---|---|
| Insurance / yr | $1,680 |
| HOA / mo | None |
| Other fixed / yr | $360 |
| Total est. operating / yr | $8,994 |
| HVAC installed | 2022 |
| Roof installed | 2021 |
| Water provider | City of Phoenix |
| FEMA flood zone | Zone 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.
Monthly cash flow
−$562
after debt service, before tax
Cap rate
4.03%
NOI ÷ purchase price
Cash-on-cash
-6.59%
cash flow ÷ cash invested
DSCR
0.69
NOI ÷ annual debt service
Where the gross rent goes
- Vacancy$1,530
- Operating$8,994
- Debt service$21,715
- Cash flow$0
| Gross scheduled income | $25,500 |
|---|---|
| Less vacancy & credit loss | −$1,530 |
| Effective gross income | $23,970 |
| Less fixed operating | −$4,200 |
| Less variable operating | −$4,794 |
| Net operating income | $14,976 |
| Less annual debt service | −$21,715 |
| Pre-tax cash flow | -$6,739 |
| Loan amount | $279,000 |
| Monthly principal & interest | $1,810 |
| Cash invested | $102,300 |
| Operating expense ratio | 37.5% |
| Break-even occupancy | 120.4% |
| Gross rent multiplier | 14.6 |
| Rent-to-price ratio | 0.571% |
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.
| Condition | Price | vs ask | What it means |
|---|---|---|---|
| Current asking price | $372,000 | — | The number on the panel. Everything below is measured against it. |
| DSCR 1.00 | $256,500 | −31.0% | net operating income exactly covers the mortgage; cash flow is zero |
| Submarket median cap (5.82%) | $257,500 | −30.8% | the price at which this asset yields what its submarket already yields |
| Leverage turns (5.84%) | $256,500 | −31.0% | 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.
| Month | Index-adjusted ask |
|---|---|
| Oct 2024 | $360K |
| Nov 2024 | $363K |
| Dec 2024 | $367K |
| Jan 2025 | $370K |
| Feb 2025 | $370K |
| Mar 2025 | $369K |
| Apr 2025 | $366K |
| May 2025 | $362K |
| Jun 2025 | $360K |
| Jul 2025 | $360K |
| Aug 2025 | $362K |
| Sep 2025 | $365K |
| Oct 2025 | $367K |
| Nov 2025 | $368K |
| Dec 2025 | $367K |
| Jan 2026 | $365K |
| Feb 2026 | $363K |
| Mar 2026 | $363K |
| Apr 2026 | $366K |
| May 2026 | $369K |
| Jun 2026 | $372K |
| Jul 2026 | $373K |
| Aug 2026 | $373K |
| Sep 2026 | $372K |
Comparables
Rent is compared per unit, which is the only fair basis across a house and a fourplex. The subject sits 1.6% below the median of its five closest comparables.
| Asset | Submarket | Proximity | Ask | Sq ft | $ / sq ft |
|---|---|---|---|---|---|
| ALH-01 Subject | Alhambra | — | $372,000 | 1,512 | $246 |
| ALH-02 | Alhambra | Same submarket | $328,000 | 1,348 | $243 |
| STM-03 | South Mountain | Same city | $336,000 | 1,355 | $248 |
| MRV-01 | Maryvale | Same city | $312,000 | 1,284 | $243 |
| MRV-04 | Maryvale | Same city | $268,000 | 1,146 | $234 |
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.
| Price \ Rate | 5.75% | 6.25% | 6.75% | 7.25% | 7.75% |
|---|---|---|---|---|---|
| $342,000−8% | -3.2% | -4.2% | -5.3% | -6.4% | -7.5% |
| $357,000−4% | -3.8% | -4.9% | -6.0% | -7.1% | -8.2% |
| $372,000ask | -4.5% | -5.5% | -6.6% | -7.7% | -8.8% |
| $387,000+4% | -5.0% | -6.1% | -7.2% | -8.3% | -9.4% |
| $402,000+8% | -5.6% | -6.6% | -7.7% | -8.8% | -9.9% |
Cash-on-cash-9.9% → -3.2%
What to check before you commit
HVAC
Condenser installed 2022, 4 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 2021, 5 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.