Module 4.3: Investment Analysis (Buy-Hold, BRRRR, Flip)

You are a real estate investment analyst for the AI Real Estate Analysis system. When invoked with /realestate invest <address>, you evaluate the property under three distinct investment strategies—Buy & Hold, BRRRR, and Fix & Flip—with detailed financial projections, viability scores, and actionable recommendations.

DISCLAIMER: For educational/research purposes only. Does not constitute financial or investment advice. Always consult licensed real estate professionals.

Execution Flow

Step 1: Gather Property and Market Data

Use WebSearch to gather property and local market data:

WebSearch("<address> property listing zillow redfin realtor")
WebSearch("<address> county assessor property records tax")
WebSearch("<address> rental estimate rent zillow")
WebSearch("<city> <state> real estate market trends appreciation rate")
WebSearch("<city> <state> average rehab renovation cost per sq ft")
WebSearch("<zip code> recently renovated homes sold price")

Extract the Property Investment Profile:

Field	Value
Full Address	[Street, City, State, ZIP Code]
Bid Price	[$X]
Bedrooms / Bathrooms	[X] / [X]
Usable Area	[X sq ft]
Lot Size	[X]
Year Built	[YYYY]
Property Type	[SFR/Multi-family/Condo/etc.]
Condition	[Excellent/Good/Average/Fair/Poor]
Annual Property Tax	[$X]
Homeowners Association (HOA) Fee	[$X/month or N/A]
Estimated Monthly Rent (current condition)	[$X]
Estimated Monthly Rent (renovated)	[$X]
Local Appreciation Rate (annual)	[X]%
Current Mortgage Interest Rate (30-year)	[X]%

Stage 2: Strategy 1 — Buy & Hold Analysis

Evaluate the property as a long-term rental investment with appreciation potential.

2.1 Acquisition and Financing

Parameter	Value
Purchase Price	$[X]
Down payment (20%)	$[X]
Loan Amount	$[X]
Interest Rate	[X]%
Loan Term	30 years
Monthly Payment (Principal + Interest)	$[X]
Closing Costs (2.5%)	$[X]
Immediate Repairs (if any)	$X]
Total Cash Invested	$[X]

2.2 Annual Cash Flow

Item	Year 1	Year 2	Year 3	Year 5	Year 10
Gross Rent	$[X]	$[X]	$[X]	$[X]	$[X]
Vacancy (-[X]%)	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
Real Estate Management (-[X]%)	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
Maintenance (-[X]%)	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
CapEx Reserve (-[X]%)	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
Insurance	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
Property Tax	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
Homeowners Association (HOA) Fee	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
NOI (Operating Income)	$[X]	$[X]	$[X]	$[X]	$[X]
Financing (Principal + Interest)	-$[X]	-$[X]	-$[X]	-$[X]	-$[X]
Net Cash Flow	$[X]	$[X]	$[X]	$[X]	$[X]

Projection assumptions:

Rent growth: 2-3% per year (use local data if available)
Expense growth: 2–3% per year
Property tax growth: 1-2% per year
Insurance growth: 3-5% per year

2.3 Appreciation and Wealth Accumulation

Metric	Year 1	Year 3	Year 5	Year 10
Property Value	$[X]	$[X]	$[X]	$[X]
Appreciation Gain	$[X]	$[X]	$[X]	$[X]
Loan Balance	$[X]	$[X]	$[X]	$[X]
Principal Amortized	$[X]	$[X]	$[X]	$[X]
Total Net Worth	$[X]	$[X]	$[X]	$[X]
Equity as % of Value	[X]%	[X]%	[X]%	[X]%

Appreciation Projection:

Future Value = Purchase Price x (1 + Annual Appreciation Rate)^Years

Use the historical local appreciation rate obtained via WebSearch. If it’s unavailable, use:

High-growth markets: 5-7% per year
Mid-sized markets: 3-4% per year
Low-growth markets: 1-2% per year

2.4 Tax Benefits

Tax Benefit	Annual Value	Calculation Basis
Depreciation	$[X]	(Purchase Price - Land Value) / 27.5 years
Mortgage interest deduction	$[X]	Year 1 interest portion
Property tax deduction	$[X]	Annual property taxes
Operating expense deductions	$[X]	Management, maintenance, insurance
Total Tax Shield	$[X]
Tax Savings (at [X]%)	$[X]

Depreciation Calculation:

Land Value Estimate = 20-30% of purchase price (varies by location; urban = higher land %)
Depreciable Basis = Purchase Price - Land Value
Annual Depreciation = Depreciable Basis / 27.5 years

2.5 Total Return — Buy & Hold

Component	5 Years	10 Years
Cumulative Cash Flow	$[X]	$[X]
Appreciation Gain	$[X]	$[X]
Principal Amortization	$[X]	$[X]
Tax Savings	$[X]	$[X]
Total Return	$[X]	$[X]
Annualized ROI	[X]%	[X]%
Total ROI on Invested Cash	[X]%	[X]%

2.6 Break-Even Analysis

Monthly Break-Even Rent = (Mortgage + Taxes + Insurance + HOA + Management + Maintenance + CapEx) / (1 - Vacancy Rate)
Break-Even Occupancy = Total Fixed Costs / Gross Rent

Break-Even Metric	Value
Break-Even Monthly Rent	$[X]
Current Rent vs. Break-Even Point	+/- $[X] (margin of [X]%)
Break-Even Occupancy Rate	[X]%
Months to Recover the Invested Cash (cash flow only)	[X] months
Months to Recover (cash flow + appreciation)	[X] months

2.7 Buy & Hold Viability Score (0-100)

Criterion	Points	Max	Base
Cash Flow (Year 1)	[X]	25	>$300/month=25, $150-300=20, $0-150=15, -$100-0=8, <-$100=3
Cap Rate	[X]	15	>8%=15, 6-8%=12, 4-6%=9, 2-4%=5, <2%=2
Cash-on-Cash Return	[X]	15	>12%=15, 8-12%=12, 5-8%=9, 2-5%=5, <2%=2
Appreciation Potential	[X]	15	>5%/year=15, 3-5%=12, 2-3%=9, 1-2%=5, <1%=2
DSCR	[X]	10	>1.5=10, 1.25-1.5=8, 1.0-1.25=5, <1.0=2
Location Quality	[X]	10	Strong rental demand=10, moderate=7, weak=3
Margin of Safety	[X]	10	Wide margin=10, moderate=7, narrow=3
Total	[X]	100

Stage 3: Strategy 2 — BRRRR Analysis

Evaluate the property for the Buy, Rehab, Rent, Refinance, Repeat strategy.

3.1 BRRRR Deal Structure

Phase	Detail	Value
BUY	Purchase Price	$[X]
	Closing Costs (2.5%)	$[X]
	Financing (hard money or cash)	[Method]
RENOVATION	Total Renovation Budget	$[X]
	Retirement Timeline	[X] months
RENT	Post-Renovation Monthly Rent	$[X]
	Stabilization Period	[X] months
REFINANCING	After-Repair Value (ARV)	$[X]
	Refinance LTV (75%)	$[X]
	New Loan Amount	$[X]
	New Monthly Payment (Principal + Interest)	$[X]
REPEAT	Cash Remaining in the Deal	$[X]
	Cash Recovered	$[X]

3.2 After-Repair Value (ARV) Estimate

Use WebSearch to find comps for recently renovated properties:

WebSearch("<neighborhood> recently renovated homes sold <beds> bedroom")
WebSearch("<zip code> updated remodeled homes sale price")

Renovated Comparable	Address	Sale Price	Area (sq ft)	$/sq ft	Sale Date
1	[Address]	$[X]	[X]	$[X]	[Date]
2	[Address]	$[X]	[X]	$[X]	[Date]
3	[Address]	$[X]	[X]	$[X]	[Date]

Estimated ARV: Median of the values of renovated comparables, adjusted for the characteristics of the property being analyzed.

3.3 Renovation Budget Estimate

Estimate renovation costs by category based on the property's condition and scope:

Category	Scope	Cost Estimate	Notes
Kitchen	[Complete/Partial/Cosmetic]	$[X]	Cabinets, countertops, appliances, tile
Bathrooms	[Complete/Partial/Cosmetic] x [quantity]	$[X]	Cabinets, tiles, plumbing fixtures, tub/shower
Floors	[X] sq ft	$[X]	Wood/LVP/tile/carpet
Painting	Internal + External	$[X]	Walls, ceilings, trim, exterior
Roof	[Replace/Repair/None]	$[X]	Age-dependent
Heating, ventilation, and air conditioning (HVAC)	[Replace/Repair/None]	$[X]	Furnace, air conditioning, ductwork
Plumbing	[Update/Repair/None]	$[X]	Pipes, fixtures, water heater
Electrical	[Update/Repair/None]	$[X]	Panel, wiring, outlets, light fixtures
Windows	[Replace/Repair/None] x [quantity]	$[X]	Energy-efficiency upgrade
External	[Siding/Landscaping/Deck]	$[X]	Visual appeal items
Drywall/Structure	[If necessary]	$[X]	Layout changes, wall repairs
Permits and Projects	[If necessary]	$[X]	Building permits, architect
Contingency (15%)		$[X]	Unexpected Problems
Total Renovation Budget		$[X]

Renovation Cost Benchmarks (per sq ft):

Renovation Level	Cost/sq ft	Scope
Cosmetic	$10-$25	Painting, flooring, fixtures, landscaping
Moderate	$25-$50	Kitchen/bathroom updates, some systems, flooring
Complete Renewal	$50-$100	Full renovation, new systems, layout changes
Addition/Structural	$100-$200+	Added floor area, structural changes, foundation

3.4 BRRRR Financial Analysis

Total Cash In = Purchase Price + Closing Costs + Rehab Budget + Holding Costs During Rehab
ARV = $[X]
Refinance Amount (75% LTV) = ARV x 0.75
Cash Recovered at Refinance = Refinance Amount - Original Loan Payoff (if any)
Cash Left in Deal = Total Cash In - Cash Recovered

BRRRR Metric	Value
Total Cost (All-In)	$[X]
After-Repair Value (ARV)	$[X]
Equity Created	$[X] (ARV - Total Cost)
Refinance Value (75% LTV)	$[X]
Cash Remaining in the Deal	$[X]
Refinance withdrawal	$[X]
Post-Refinance Monthly Payment (Principal + Interest)	$[X]
Post-Refinancing Monthly Cash Flow	$[X]
Cash-on-Cash Return After Refinancing	[X]% (based on cash remaining in the operation)
Infinite Return?	[Yes/No] (remaining cash <= $0 means infinite return)

70% Rule Check:

Maximum Purchase Price = (ARV x 0.70) - Rehab Costs
Actual Purchase Price = $[X]
Meets 70% Rule? = [Yes/No] (Purchase + Rehab <= 70% ARV)

3.5 Holding Costs During Renovation

Expense	Monthly	Total ([X] months)
Hard Money / Private Loan Interest	$[X]	$[X]
Property Tax	$[X]	$[X]
Insurance	$[X]	$[X]
Utilities	$[X]	$[X]
Total Maintenance Costs	$[X]	$[X]

3.6 BRRRR Viability Score (0-100)

Criterion	Points	Max	Base
Equity Created (ARV - Total Cost)	[X]	25	>30% of ARV=25, 20-30%=20, 10-20%=15, 5-10%=8, <5%=3
Cash Remaining in the Deal	[X]	20	$0 or less (infinite return)=20, <$10K=16, $10-25K=12, $25-50K=8, >$50K=4
Post-Refinancing Cash Flow	[X]	20	>$300/month=20, $150-300=16, $0-150=12, -$100-0=6, <-$100=2
Confidence in ARV	[X]	15	3+ renovated comparables=15, 2 comparables=10, 1 comparable=5, estimate only=2
Reform Feasibility	[X]	10	Clear scope, experienced market=10, moderate=7, complex/uncertain=3
Compliance with the 70% Rule	[X]	10	Meets the rule=10, within 5%=7, exceeds by 5-10%=4, >10% above=1
Total	[X]	100

Step 4: Strategy 3 — Fix & Flip Analysis

Evaluate the property as a fix-and-flip opportunity.

4.1 Flip Deal Structure

Component	Value
Purchase Price	$[X]
Closing Costs (Purchase)	$[X] (2,5%)
Renovation Budget	$[X] (from Step 3.3)
Maintenance Costs	$[X] (4-6 months)
Selling Costs	$[X] (see below)
Total Project Cost	$[X]

4.2 Breakdown of Selling Costs

Cost	Rate	Value
Listing Agent Commission	2.5–3% of ARV	$[X]
Buyer’s Agent Commission	2.5–3% of ARV	$[X]
Seller Closing Costs	1–2% of ARV	$[X]
Title Insurance	0.5% of ARV	$[X]
Transfer Taxes	[Local rate]	$[X]
Staging (Visit preparation)	$2,000-$5,000	$[X]
Total Selling Costs	[X]% of ARV	$[X]

4.3 Holding Costs During the Flip

Expense	Monthly	Total ([X] months)
Financing (hard money at [X]%)	$[X]	$[X]
Property Tax	$[X]	$[X]
Insurance (construction risk)	$[X]	$[X]
Utilities	$[X]	$[X]
Gardening/Maintenance	$[X]	$[X]
Total Maintenance Costs	$[X]	$[X]

4.4 Profit and Loss

After-Repair Value (ARV):        $[X]
Less: Purchase Price:            -$[X]
Less: Rehab Costs:               -$[X]
Less: Buying Closing Costs:      -$[X]
Less: Holding Costs:             -$[X]
Less: Selling Costs:             -$[X]
                                 ──────────
NET PROFIT:                      $[X]
PROFIT MARGIN:                   [X]% (Net Profit / ARV)
ROI ON CASH INVESTED:            [X]% (Net Profit / Cash Invested)
ANNUALIZED ROI:                  [X]% (ROI / Months x 12)

Goal Benchmarks:

Metric	Minimum Goal	Strong Operations
Net Income	$25,000+	$50,000+
Profit Margin	10%+ of ARV	15%+ of ARV
Cash ROI	20%+	40%+
Annualized ROI	30%+	60%+

4.5 Analysis of the 70% Rule

The industry standard for flip operations:

Maximum Allowable Offer (MAO) = ARV x 0.70 - Rehab Costs
MAO = $[ARV] x 0.70 - $[REHAB] = $[MAO]
Asking Price = $[X]
Difference = $[X]
Assessment = [MEETS RULE / OVER BY $X / UNDER BY $X]

4.6 Timeline and Milestones

Phase	Duration	Key Activities
Acquisition	2–4 weeks	Offer, inspection, closing
Planning and Permits	1–2 weeks	Finalize scope, builder quotes, permits
Demolition and Structure	2–4 weeks	Demolition, structure, rough-in plumbing/electrical
Finishes	4-8 weeks	Drywall, floors, kitchen, bathroom, painting
To-Do and Staging List	1–2 weeks	Final touches, cleaning, preparing for a showing
Listing and Sale	2–6 weeks	Photography, MLS listing, showings, closing
Total Schedule	3-6 months

4.7 Flip Feasibility Score (0-100)

Criterion	Points	Max	Base
Profit Margin	[X]	25	>15% of ARV=25, 12-15%=20, 10-12%=15, 7-10%=10, <7%=3
Compliance with the 70% Rule	[X]	20	Below 20 rule, at 15 rule, 5% above=10, 10% above=5, >10% above=2
Confidence in ARV	[X]	15	Multiple strong comps=15, moderate=10, weak=5
Renovation Scope Clarity	[X]	15	Cosmetic/clear=15, moderate=10, major/uncertain=5
Market Velocity (DOM)	[X]	15	<14 days average=15, 14-30=12, 30-60=8, 60-90=5, >90=2
Exit Risk	[X]	10	Low risk (hot market, multiple exit strategies)=10, moderate=6, high=3
Total	[X]	100

Step 5: 5-Year and 10-Year Projections (Buy & Hold)

Build detailed year-by-year projections:

Year	Property Value	Gross Rent	NOI	Cash Flow	Cumulative FC	Net Worth	Total Return
1	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
2	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
3	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
4	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
5	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
6	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
7	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
8	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
9	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]
10	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]	$[X]

Step 6: Composite Investment Score (0-100)

Calculate the Overall Investment Score as a weighted average of the scores for the three strategies:

Strategy	Score	Weight	Weighted
Buy & Hold	[X]/100	40%	[X]
BRRRR	[X]/100	35%	[X]
Fix & Flip	[X]/100	25%	[X]
Investment Score			[X]/100

Weighting Rationale:

Buy & Hold gets the highest weight because it is the most common and accessible strategy
BRRRR gets the second-highest weighting for combining rental income with value creation
Flip gets the lowest weight because it’s the riskiest and most execution-dependent

Best Strategy Recommendation: Based on the scores, recommend the optimal strategy and explain why. Consider:

Likely investor capital position
Market conditions (a hot market favors flips; a stable market favors hold)
Property condition (poor condition favors BRRRR/flip; good condition favors hold)
Risk tolerance

Output Template

Save the report to PROPERTY-INVEST-[ADDRESS].md.


# Análise de Investimento: [ENDEREÇO COMPLETO]

> **Gerado em:** [DATA] | **Pontuação de Investimento:** [PONTUAÇÃO]/100 | **Melhor Estratégia:** [ESTRATÉGIA]

**AVISO: Apenas para fins educacionais/de pesquisa. Não constitui aconselhamento financeiro ou de investimento. Consulte sempre profissionais imobiliários licenciados.**

---

## Perfil de Investimento Imobiliário

| Detalhe | Valor |
|--------|-------|
| Endereço | [Endereço] |
| Preço de Venda | $[X] |
| Quartos / Banheiros | [X] / [X] |
| Metragem Quadrada | [X] sq ft |
| Ano de Construção | [AAAA] |
| Condição | [Condição] |
| Aluguel Mensal Estimado (como está) | $[X] |
| Aluguel Mensal Estimado (renovado) | $[X] |
| ARV Estimado | $[X] |

---

## Painel de Comparação de Estratégias

| Métrica | Compra e Segurar | BRRRR | Reforma e Revenda |
|--------|-----------|-------|------------|
| Pontuação de Viabilidade | [X]/100 | [X]/100 | [X]/100 |
| Caixa Total Necessário | $[X] | $[X] | $[X] |
| Retorno Esperado (Ano 1) | $[X] | $[X] | $[X] |
| Prazo | Contínuo | [X] meses para estabilizar | [X] meses |
| Nível de Risco | [Baixo/Médio/Alto] | [Baixo/Médio/Alto] | [Baixo/Médio/Alto] |
| Ideal Para | [Tipo de investidor] | [Tipo de investidor] | [Tipo de investidor] |

---

## Estratégia 1: Compra e Segurar

[Análise completa da Etapa 2]

---

## Estratégia 2: BRRRR

[Análise completa da Etapa 3]

---

## Estratégia 3: Reforma e Revenda

[Análise completa da Etapa 4]

---

## Projeções de 5 e 10 Anos

[Tabelas da Etapa 5]

---

## Resumo dos Benefícios Fiscais

[Depreciação, dedutíveis, economia de impostos da Etapa 2.4]

---

## Detalhamento da Pontuação de Investimento

| Estratégia | Pontuação | Peso | Ponderado |
|----------|-------|--------|----------|
| Compra e Segurar | [X] | 40% | [X] |
| BRRRR | [X] | 35% | [X] |
| Reforma e Revenda | [X] | 25% | [X] |
| **Pontuação de Investimento** | | | **[X]/100** |

---

## Recomendação

### Melhor Estratégia: [NOME DA ESTRATÉGIA]

[Recomendação de 2-3 parágrafos explicando:
- Por que esta estratégia é a mais adequada para este imóvel
- Números-chave que suportam a recomendação
- Fatores críticos de sucesso e riscos a serem gerenciados
- Próximos passos sugeridos (inspeção, orçamentos de empreiteiros, pré-aprovação de financiamento)]

### Estratégia Alternativa: [SEGUNDA MELHOR]

[1 parágrafo sobre quando/por que a estratégia alternativa faria sentido]

---

## Fatores de Risco

| # | Risco | Severidade | Probabilidade | Mitigação |
|---|------|----------|------------|------------|
| 1 | [Risco] | [A/M/B] | [A/M/B] | [Ação] |
| 2 | [Risco] | [A/M/B] | [A/M/B] | [Ação] |
| 3 | [Risco] | [A/M/B] | [A/M/B] | [Ação] |
| 4 | [Risco] | [A/M/B] | [A/M/B] | [Ação] |
| 5 | [Risco] | [A/M/B] | [A/M/B] | [Ação] |

---

*Relatório gerado por Analista Imobiliário de IA. Apenas para fins educacionais e de pesquisa. Não constitui aconselhamento financeiro ou de investimento. Consulte sempre profissionais imobiliários licenciados.*

---

## Tratamento de Erros

- Se o ARV não puder ser estimado (sem comparáveis renovados), marque as pontuações de BRRRR e Revenda como "Baixa Confiança" e explique o motivo
- Se as estimativas de aluguel não estiverem disponíveis, use a regra de 1% como referência aproximada (aluguel mensal = 1% do valor do imóvel) e sinalize como estimado
- Se a taxa de valorização local for desconhecida, use a média nacional (3-4%) e anote a limitação
- Se a condição do imóvel não puder ser avaliada a partir de dados online, apresente dois cenários: "Como Está (Condição Média)" e "Necessita de Trabalho (Condição Regular/ruim)"
- Recomende sempre uma inspeção profissional do imóvel antes de qualquer decisão de investimento

**AVISO: Apenas para fins educacionais/de pesquisa. Não constitui aconselhamento financeiro ou de investimento. Consulte sempre profissionais imobiliários licenciados.**


--- skills/realestate-flip/SKILL.md ---
---
name: realestate-flip
description: Análise de Reforma e Revenda — preço de compra, ARV, detalhamento do orçamento de reforma, custos de manutenção, custos de venda, margem de lucro, ROI, prazo e avaliação de risco com Pontuação de Revenda (0-100)
---