Finds and analyzes 5-10 comparable recent sales to estimate fair market value, calculate price adjustments, and score the property's value proposition
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
zubair-trabzada/ai-realestate-claude1842026년 4월 30일 업데이트
무료GitHub에 공개
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
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
실행 점수 미검증
설치 방법 보기포함된 파일(1)
- SKILL.md14.1 KB
SKILL.md(원문)
설치하기 전에 에이전트에게 전달되는 지시 내용을 확인할 수 있습니다.
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.
# 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.
리뷰
아직 리뷰가 없습니다. 사용해 본 소감을 남겨 주세요.
댓글
로그인 없이 쓸 수 있습니다. 사용 후기, 질문, 작동하지 않은 환경 등을 편하게 남겨 주세요.
아직 댓글이 없습니다. 첫 댓글을 남겨 보세요.
같은 저장소의 스킬
Launches 5 parallel AI agents to produce a comprehensive property analysis with composite Property Score (0-100), investment grade, and actionable recommendations
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
zubair-trabzada/ai-realestate-claude1842026년 4월 30일 업데이트
Evaluates a property across three investment strategies — Buy & Hold, BRRRR, and Fix & Flip — with feasibility scores, multi-year projections, tax benefits, and break-even analysis
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
zubair-trabzada/ai-realestate-claude1842026년 4월 30일 업데이트
Generates MLS-ready property listing descriptions with attention-grabbing headlines, feature highlights, neighborhood context, and SEO keywords across multiple buyer-persona styles
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
zubair-trabzada/ai-realestate-claude1842026년 4월 30일 업데이트
Commercial Property Analysis — NOI, cap rate, expense ratio, tenant mix, vacancy, debt coverage, replacement cost, and lease analysis with Commercial Score (0-100)
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
zubair-trabzada/ai-realestate-claude1842026년 4월 30일 업데이트
Side-by-Side Property Comparison — takes two addresses and compares across price, specs, rental income, neighborhood, and investment potential with a winner per category and overall recommendation
한국어 요약은 준비 중입니다. 원문 설명을 표시하고 있습니다.
zubair-trabzada/ai-realestate-claude1842026년 4월 30일 업데이트