Rental Property Cash Flow and CapEx Reserve Planner

Model rental property cash flow, vacancy, maintenance, capital expenses, reserves, and downside scenarios before buying or holding an investment property.

Prompt Template

You are a personal finance educator helping evaluate rental property cash flow and reserve planning. Build a realistic analysis for this property.

**Property type/location:** [single-family, condo, duplex, city/state/country]
**Purchase price or current value:** [amount]
**Down payment/equity:** [amount or percentage]
**Mortgage terms:** [loan amount, interest rate, term, monthly payment]
**Expected monthly rent:** [amount]
**Current or estimated expenses:** [taxes, insurance, HOA, utilities, property management, maintenance]
**Vacancy assumption:** [percentage or local estimate]
**Major upcoming repairs:** [roof, HVAC, appliances, plumbing, exterior, unknown]
**Capital expense reserve preference:** [conservative, moderate, aggressive]
**Local rules/taxes:** [rent control, licensing, short-term rental restrictions, property tax changes]
**Goal:** [buy decision, hold/sell, refinance, reserve target, compare properties]
**Risk tolerance:** [low, medium, high]

Create:
1. **Monthly cash flow table** — rent, vacancy, operating expenses, mortgage, reserves, and net cash flow.
2. **NOI and cap rate estimate** — before debt, with clear assumptions.
3. **CapEx and maintenance reserve plan** — monthly reserve amount, target balance, and likely replacement timeline.
4. **Scenario analysis** — base case, vacancy shock, rent drop, insurance/tax increase, major repair.
5. **Break-even occupancy and rent** — what must be true for the property to avoid negative cash flow.
6. **Red flags** — underfunded reserves, optimistic rent, HOA risk, deferred maintenance, legal/regulatory issues.
7. **Decision framework** — buy/hold/sell questions and what data to verify before acting.
8. **Advisor checklist** — questions for lender, tax professional, insurance agent, property manager, and inspector.

State that this is educational analysis, not financial, tax, legal, or investment advice.

Example Output

Rental Cash Flow Snapshot — Duplex

| Item | Monthly |

|---|---:|

| Gross rent | $2,800 |

| Vacancy reserve (7%) | -$196 |

| Taxes + insurance | -$520 |

| Property management (8%) | -$224 |

| Maintenance reserve | -$200 |

| CapEx reserve | -$250 |

| Mortgage payment | -$1,650 |

| **Estimated net cash flow** | **-$240** |

Base Interpretation

The property may look break-even before reserves, but after realistic vacancy, maintenance, and capital expenses it is negative by about $240/month. That does not automatically mean "bad," but the investor needs a clear reason: appreciation, tax strategy, rent growth, or owner-occupancy benefits.

Stress Scenario

A 2-month vacancy plus a $4,500 HVAC replacement would require roughly $9,100 in reserves to avoid credit-card debt or forced selling.

Verify Before Deciding

- Get local rent comps from at least three sources.

- Ask insurance agent about premium increases and landlord coverage.

- Confirm property taxes after sale, not only current owner taxes.

- Have an inspector estimate remaining life of roof, HVAC, water heater, and major appliances.

Tips for Best Results

  • 💡Model reserves as real monthly expenses; ignoring CapEx is how rentals cosplay as profitable.
  • 💡Use post-sale property tax and insurance estimates, not stale listing numbers.
  • 💡Stress test vacancy and one major repair before deciding the cash flow is safe.
  • 💡Confirm local legal and tax details with qualified professionals before buying or selling.