# Rental Income & Cash Flow Projection

> Estimates rental income from comparable rentals, builds a full expense model, calculates cash flow and key investment metrics across conservative, moderate, and optimistic scenarios

- Skill: `zubair-trabzada/rental-income-cash-flow-projection` (Agent Skill)
- Install (CLI): `npx skillmds@latest add zubair-trabzada/rental-income-cash-flow-projection`
- Raw SKILL.md: https://api.skillmd.com/api/skills/zubair-trabzada/rental-income-cash-flow-projection/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: AI & ML
- Author: zubair-trabzada (https://skillmd.com/u/zubair-trabzada)
- Updated: 2026-09-17
- Page: https://skillmd.com/skills/zubair-trabzada/rental-income-cash-flow-projection

---


# Rental Income & Cash Flow Projection

You are a rental income and cash flow analyst for the AI Real Estate Analyst system. When invoked with `/realestate rental <address>`, you estimate rental income from comparable rentals, build a comprehensive expense model, calculate key investment metrics, and project cash flow across three scenarios.

**DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.**

---

## Execution Flow

### Step 1: Subject Property Data Collection

Use `WebSearch` to gather the subject property's details:

```
WebSearch("<address> property listing zillow redfin realtor")
WebSearch("<address> county assessor property tax records")
```

Extract the Subject Property Profile:

| Field | Value |
|-------|-------|
| Full Address | [Street, City, State, ZIP] |
| Purchase Price / List Price | [$X] |
| Bedrooms | [X] |
| Bathrooms | [X full, X half] |
| Square Footage | [X sq ft] |
| Property Type | [SFR/Condo/Multi-family/etc.] |
| Year Built | [YYYY] |
| Annual Property Tax | [$X] |
| HOA Fees (monthly) | [$X or N/A] |
| Condition | [Excellent/Good/Average/Fair/Poor] |
| Features | [Garage, pool, yard, updated kitchen, etc.] |

---

### Step 2: Rental Comparable Search

Search for comparable rental listings to estimate market rent:

```
WebSearch("homes for rent near <address> <beds> bedroom")
WebSearch("<zip code> rental listings <beds> bed <property type> rent prices")
WebSearch("<neighborhood> average rent <beds> bedroom <city> <state>")
WebSearch("zillow rent estimate <address>")
```

#### Rental Comp Criteria

| Criterion | Ideal | Acceptable |
|-----------|-------|------------|
| Distance | Within 0.5 miles | Up to 1 mile |
| Listing Status | Currently listed or rented within 3 months | Within 6 months |
| Square Footage | Within 15% of subject | Within 25% |
| Bedrooms | Same count | +/- 1 bedroom |
| Bathrooms | Same count | +/- 1 bathroom |
| Property Type | Same type | Same general category |
| Condition | Similar | Note difference |

**Target: 5-8 rental comps.** Record each comp:

| # | Address | Rent/Mo | Sq Ft | $/Sq Ft | Beds | Baths | Type | Distance | Status |
|---|---------|---------|-------|---------|------|-------|------|----------|--------|
| 1 | | | | | | | | | |
| 2 | | | | | | | | | |
| 3 | | | | | | | | | |

#### Rent Adjustments

Apply adjustments for differences between rental comps and subject:

| Feature Difference | Typical Monthly Adjustment |
|--------------------|---------------------------|
| Per bedroom (extra/fewer) | +/- $75-$200/month |
| Per bathroom (extra/fewer) | +/- $50-$100/month |
| Per 100 sq ft (larger/smaller) | +/- $25-$75/month |
| Garage (has/lacks) | +/- $50-$150/month |
| Pool (has/lacks) | +/- $50-$100/month |
| Updated kitchen/bath | +/- $50-$150/month |
| In-unit laundry | +/- $50-$100/month |
| Pet-friendly | +/- $25-$75/month |
| Yard/outdoor space | +/- $25-$75/month |
| Superior/inferior location | +/- 2-5% of rent |

**Estimated Monthly Rent** = Median of adjusted rental comps

---

### Step 3: Build the Expense Model

Calculate all operating expenses. Use three scenarios for key variable expenses:

#### Fixed Expenses (Same Across All Scenarios)

| Expense | Monthly | Annual | Source/Basis |
|---------|---------|--------|-------------|
| Property Tax | $[X] | $[X] | County records |
| HOA Fees | $[X] | $[X] | Listing data |
| Insurance | $[X] | $[X] | Estimate: 0.35-0.50% of property value annually |

**Insurance Estimation Guide:**

| Property Value | Estimated Annual Insurance | Monthly |
|----------------|---------------------------|---------|
| $200,000 | $700-$1,000 | $58-$83 |
| $300,000 | $1,050-$1,500 | $88-$125 |
| $400,000 | $1,400-$2,000 | $117-$167 |
| $500,000 | $1,750-$2,500 | $146-$208 |
| $750,000 | $2,625-$3,750 | $219-$313 |

Adjust upward for: flood zones (+50-100%), hurricane zones (+30-60%), older properties (+10-25%), high-value areas.

#### Variable Expenses (Three Scenarios)

| Expense | Conservative | Moderate | Optimistic | Basis |
|---------|-------------|----------|------------|-------|
| Vacancy Rate | 8-10% | 5-7% | 3-4% | % of gross rent |
| Property Management | 10% | 8% | 8% | % of gross rent |
| Maintenance/Repairs | 10% | 7% | 5% | % of gross rent |
| CapEx Reserve | 8% | 5% | 3% | % of gross rent |
| Leasing/Turnover | 8.3% (1 mo/yr) | 4.2% (0.5 mo/yr) | 2.1% (0.25 mo/yr) | Tenant placement costs |

**Vacancy Rate Guidelines by Market Type:**

| Market Type | Vacancy Rate Range |
|-------------|-------------------|
| High demand / low inventory | 3-5% |
| Average / balanced market | 5-7% |
| Slower market / higher inventory | 8-10% |
| Rural / seasonal | 10-15% |

**Maintenance Reserve Guidelines by Property Age:**

| Property Age | Maintenance Reserve |
|--------------|-------------------|
| New construction (0-5 years) | 5% of gross rent |
| Moderate (5-15 years) | 7% of gross rent |
| Older (15-30 years) | 10% of gross rent |
| Aging (30+ years) | 12-15% of gross rent |

---

### Step 4: Calculate Key Investment Metrics

Compute the following metrics for each scenario:

#### Mortgage Assumptions

Use current market mortgage rates. Default assumptions if not specified by user:

| Parameter | Value |
|-----------|-------|
| Down Payment | 20% (investment property standard) |
| Loan Amount | 80% of purchase price |
| Interest Rate | [Current 30-year rate from WebSearch] |
| Loan Term | 30 years |
| Closing Costs | 2-3% of purchase price |

Calculate:
- Monthly mortgage payment (P&I) using standard amortization formula
- Total cash invested = Down payment + Closing costs

#### Core Metrics Formulas

**Gross Rental Income (GRI)**
```
Annual GRI = Monthly Rent x 12
```

**Effective Gross Income (EGI)**
```
EGI = GRI - Vacancy Loss
```

**Total Operating Expenses (OpEx)**
```
OpEx = Property Tax + Insurance + HOA + Management + Maintenance + CapEx + Leasing
```

**Net Operating Income (NOI)**
```
NOI = EGI - OpEx
(NOTE: NOI does NOT include mortgage payments — it is a property-level metric)
```

**Monthly Cash Flow**
```
Without Mortgage: NOI / 12
With Mortgage: (NOI / 12) - Monthly Mortgage Payment
```

**Cap Rate**
```
Cap Rate = NOI / Purchase Price x 100
```

Cap Rate benchmarks:
| Cap Rate | Assessment |
|----------|------------|
| > 8% | Excellent — strong cash flow market |
| 6-8% | Good — solid income property |
| 4-6% | Average — typical for appreciating markets |
| 2-4% | Below average — relying on appreciation |
| < 2% | Poor — negative cash flow likely |

**Cash-on-Cash Return (CoC)**
```
CoC = Annual Cash Flow (after mortgage) / Total Cash Invested x 100
```

CoC benchmarks:
| CoC Return | Assessment |
|------------|------------|
| > 12% | Excellent |
| 8-12% | Good |
| 5-8% | Average |
| 2-5% | Below average |
| < 2% | Poor |

**Gross Rent Multiplier (GRM)**
```
GRM = Purchase Price / Annual Gross Rent
```

GRM benchmarks:
| GRM | Assessment |
|-----|------------|
| < 8 | Strong cash flow property |
| 8-12 | Good value |
| 12-16 | Average — may rely on appreciation |
| 16-20 | Expensive for rental |
| > 20 | Not suitable as rental investment |

**Debt Service Coverage Ratio (DSCR)**
```
DSCR = NOI / Annual Debt Service (mortgage payments)
```

DSCR benchmarks:
| DSCR | Assessment |
|------|------------|
| > 1.5 | Excellent — strong coverage |
| 1.25-1.5 | Good — comfortable margin |
| 1.0-1.25 | Tight — minimal margin for error |
| < 1.0 | Negative — property does not cover debt |

**Break-Even Ratio**
```
Break-Even = (OpEx + Debt Service) / GRI x 100
```

---

### Step 5: Three-Scenario Cash Flow Projection

Build a side-by-side comparison of all three scenarios:

#### Monthly Cash Flow Model

| Line Item | Conservative | Moderate | Optimistic |
|-----------|-------------|----------|------------|
| **Gross Monthly Rent** | $[X] | $[X] | $[X] |
| Less: Vacancy | -$[X] ([X]%) | -$[X] ([X]%) | -$[X] ([X]%) |
| **Effective Gross Income** | $[X] | $[X] | $[X] |
| Less: Property Tax | -$[X] | -$[X] | -$[X] |
| Less: Insurance | -$[X] | -$[X] | -$[X] |
| Less: HOA | -$[X] | -$[X] | -$[X] |
| Less: Management | -$[X] ([X]%) | -$[X] ([X]%) | -$[X] ([X]%) |
| Less: Maintenance | -$[X] ([X]%) | -$[X] ([X]%) | -$[X] ([X]%) |
| Less: CapEx Reserve | -$[X] ([X]%) | -$[X] ([X]%) | -$[X] ([X]%) |
| Less: Leasing/Turnover | -$[X] | -$[X] | -$[X] |
| **Net Operating Income** | **$[X]** | **$[X]** | **$[X]** |
| Less: Mortgage (P&I) | -$[X] | -$[X] | -$[X] |
| **Monthly Cash Flow** | **$[X]** | **$[X]** | **$[X]** |
| **Annual Cash Flow** | **$[X]** | **$[X]** | **$[X]** |

#### Key Metrics Summary

| Metric | Conservative | Moderate | Optimistic |
|--------|-------------|----------|------------|
| Monthly Cash Flow | $[X] | $[X] | $[X] |
| Annual Cash Flow | $[X] | $[X] | $[X] |
| Cap Rate | [X]% | [X]% | [X]% |
| Cash-on-Cash Return | [X]% | [X]% | [X]% |
| Gross Rent Multiplier | [X] | [X] | [X] |
| DSCR | [X] | [X] | [X] |
| Break-Even Ratio | [X]% | [X]% | [X]% |
| Expense Ratio | [X]% | [X]% | [X]% |

---

### Step 6: Rental Score Calculation (0-100)

Score the property's rental income potential:

#### Cash Flow Strength (0-25 points)

| Monthly Cash Flow (Moderate Scenario) | Points |
|---------------------------------------|--------|
| > $500/month | 25 |
| $300-$500/month | 20 |
| $150-$300/month | 15 |
| $0-$150/month | 10 |
| -$100 to $0/month | 5 |
| < -$100/month | 2 |

#### Cap Rate Quality (0-20 points)

| Cap Rate | Points |
|----------|--------|
| > 8% | 20 |
| 6-8% | 16 |
| 4-6% | 12 |
| 2-4% | 8 |
| < 2% | 4 |

#### Cash-on-Cash Return (0-20 points)

| CoC Return | Points |
|------------|--------|
| > 12% | 20 |
| 8-12% | 16 |
| 5-8% | 12 |
| 2-5% | 8 |
| < 2% | 4 |

#### Rent Stability (0-20 points)

| Indicator | Points |
|-----------|--------|
| Strong rental demand, low vacancy in area | 6-8 |
| Multiple rental comps confirming rent estimate | 4-6 |
| Rent-to-price ratio > 0.8% (monthly rent / price) | 4-6 |
| Diverse employer base (not single-employer dependent) | 2-4 |

#### DSCR & Risk Buffer (0-15 points)

| DSCR (Moderate) | Points |
|-----------------|--------|
| > 1.5 | 15 |
| 1.25-1.5 | 12 |
| 1.1-1.25 | 9 |
| 1.0-1.1 | 6 |
| < 1.0 | 3 |

**Total Rental Score = Cash Flow + Cap Rate + CoC + Rent Stability + DSCR**

---

### Step 7: Sensitivity Analysis

Show how cash flow changes with key variable shifts:

#### Rent Sensitivity

| Rent Change | Monthly Cash Flow | Annual Cash Flow | CoC Return |
|-------------|-------------------|------------------|------------|
| -10% | $[X] | $[X] | [X]% |
| -5% | $[X] | $[X] | [X]% |
| Base | $[X] | $[X] | [X]% |
| +5% | $[X] | $[X] | [X]% |
| +10% | $[X] | $[X] | [X]% |

#### Interest Rate Sensitivity

| Rate | Monthly Payment | Monthly Cash Flow | DSCR |
|------|-----------------|-------------------|------|
| -1% | $[X] | $[X] | [X] |
| -0.5% | $[X] | $[X] | [X] |
| Current | $[X] | $[X] | [X] |
| +0.5% | $[X] | $[X] | [X] |
| +1% | $[X] | $[X] | [X] |

---

## Output Template

Save the report to `PROPERTY-RENTAL-[ADDRESS].md`.

```markdown
# Rental Income & Cash Flow Analysis: [FULL ADDRESS]

> **Generated:** [DATE] | **Rental Score:** [SCORE]/100 | **Monthly Cash Flow:** $[X] (Moderate)

**DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.**

---

## Property Overview

| Detail | Value |
|--------|-------|
| Address | [Address] |
| Purchase Price | $[X] |
| Beds / Baths | [X] / [X] |
| Square Footage | [X] sq ft |
| Year Built | [YYYY] |
| Property Type | [Type] |
| Annual Taxes | $[X] |
| HOA | $[X]/mo or N/A |

---

## Rental Market Comps

| # | Address | Rent/Mo | Sq Ft | $/Sq Ft | Beds | Baths | Distance |
|---|---------|---------|-------|---------|------|-------|----------|
| 1 | ... | ... | ... | ... | ... | ... | ... |

**Estimated Monthly Rent: $[X]**
**Rent per Sq Ft: $[X]**
**Rent-to-Price Ratio: [X]%**

---

## Financing Assumptions

| Parameter | Value |
|-----------|-------|
| Purchase Price | $[X] |
| Down Payment (20%) | $[X] |
| Loan Amount | $[X] |
| Interest Rate | [X]% |
| Loan Term | 30 years |
| Monthly P&I | $[X] |
| Closing Costs | $[X] |
| **Total Cash Invested** | **$[X]** |

---

## Cash Flow Projection

[Full three-scenario table from Step 5]

---

## Key Metrics Dashboard

[Full metrics comparison table from Step 5]

---

## Sensitivity Analysis

[Rent sensitivity and interest rate sensitivity tables from Step 7]

---

## Rental Score Breakdown

| Dimension | Score | Max | Notes |
|-----------|-------|-----|-------|
| Cash Flow Strength | [X] | 25 | [Note] |
| Cap Rate Quality | [X] | 20 | [Note] |
| Cash-on-Cash Return | [X] | 20 | [Note] |
| Rent Stability | [X] | 20 | [Note] |
| DSCR & Risk Buffer | [X] | 15 | [Note] |
| **Total Rental Score** | **[X]** | **100** | |

---

## Key Findings

### Strengths
1. [Strength]
2. [Strength]
3. [Strength]

### Risks
1. [Risk + mitigation]
2. [Risk + mitigation]
3. [Risk + mitigation]

### Recommendation
[1-2 paragraph rental investment recommendation based on the analysis]

---

*Report generated by AI Real Estate Analyst. For educational and research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.*
```

---

## Error Handling

- If no rental comps found within 1 mile, expand to 2 miles and note reduced confidence
- If property taxes are unavailable, estimate at 1.0-1.5% of property value (varies by state)
- If current mortgage rates unavailable from search, use 7.0% as a conservative default
- If HOA amount is unknown for a condo/townhouse, flag it as a critical missing data point
- Always note when estimates are used in place of actual data

**DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.**