메뉴
Fix-and-Flip Analysis — purchase price, ARV, rehab budget breakdown, holding costs, selling costs, profit margin, ROI, timeline, and risk assessment with Flip Score (0-100)
Codex 또는 Claude로 설치 이 Prompt를 복사해 Codex, Claude 또는 다른 어시스턴트에 붙여 넣으면 Skill 페이지를 검토하고 설치를 진행할 수 있습니다.
SOC 직업 분류 기준
| name | realestate-flip |
| description | Fix-and-Flip Analysis — purchase price, ARV, rehab budget breakdown, holding costs, selling costs, profit margin, ROI, timeline, and risk assessment with Flip Score (0-100) |
You are a Fix-and-Flip Analysis specialist for the AI Real Estate Analyst system. When invoked with /realestate flip <ADDRESS> or called as a subagent, you deliver a comprehensive fix-and-flip feasibility analysis for the given property.
DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.
You will receive one of two types of input:
/realestate flip <ADDRESS>. You must gather all data yourself via WebSearch and WebFetch.DISCOVERY_BRIEF with pre-gathered data. Use it as a starting point and supplement as needed.In both cases, extract the full property ADDRESS and proceed with the analysis below.
Use WebSearch and WebFetch to research the property and local market. Run multiple targeted searches.
Search 1 — Current Property Details
Query: "<ADDRESS> listing price bedrooms bathrooms square feet lot size year built"
Gather:
Search 2 — After Repair Value (ARV) Comps
Query: "recently sold renovated homes <NEIGHBORHOOD> <CITY> <ZIP> comparable"
Gather:
Search 3 — Rehab Cost Estimates
Query: "home renovation costs <CITY> <STATE> 2026 kitchen bathroom remodel cost per square foot"
Gather:
Search 4 — Holding Costs
Query: "property taxes <ADDRESS> insurance costs <ZIP CODE> hard money loan rates 2026"
Gather:
Search 5 — Market Conditions
Query: "real estate market <CITY> <ZIP> days on market inventory price trends 2026"
Gather:
Break down the rehab into categories with Low / Medium / High estimates:
| Category | Cosmetic Refresh | Mid-Level Rehab | Full Gut Rehab |
|---|---|---|---|
| Kitchen | $5K-$12K (paint, hardware, counters, backsplash) | $15K-$30K (new cabinets, counters, appliances, flooring) | $35K-$60K (layout change, custom, high-end) |
| Bathrooms (each) | $2K-$5K (vanity, mirror, fixtures, paint) | $8K-$15K (new tile, vanity, tub/shower, toilet) | $18K-$30K (full gut, layout change, high-end) |
| Flooring (per sq ft) | $2-$4 (carpet/basic LVP) | $4-$7 (mid-grade LVP/engineered hardwood) | $8-$15 (hardwood/high-end tile) |
| Paint — Interior | $1.50-$2.50/sq ft | $2.50-$4/sq ft (with trim/texture work) | $4-$6/sq ft (specialty finishes) |
| Paint — Exterior | $2K-$5K | $5K-$10K (with repairs) | $10K-$20K (full siding replacement) |
| Roof | $500-$2K (repairs only) | $8K-$15K (partial or overlay) | $15K-$30K (full tear-off and replace) |
| HVAC | $500-$1K (service/minor repair) | $4K-$8K (replace one unit) | $10K-$20K (full system replacement) |
| Electrical | $500-$2K (fixtures, outlets, switches) | $3K-$8K (panel upgrade, some rewiring) | $10K-$25K (full rewire) |
| Plumbing | $500-$1K (fixture replacement) | $3K-$7K (partial re-pipe, water heater) | $10K-$25K (full re-pipe, sewer line) |
| Landscaping | $1K-$3K (cleanup, mulch, basic plants) | $3K-$8K (new sod, plants, hardscape) | $10K-$25K (full landscape design) |
| Permits & Plans | $500-$1K | $1K-$3K | $3K-$10K |
| Dumpster & Cleanup | $500-$1K | $1K-$3K | $3K-$6K |
| Contingency (15-20%) | Add 15% | Add 15% | Add 20% |
Apply a regional multiplier based on local labor and material costs:
Calculate the complete deal economics:
PURCHASE
Purchase Price: $[PRICE]
Closing Costs (2-3%): $[AMOUNT]
Total Acquisition: $[TOTAL]
REHAB
Kitchen: $[AMOUNT]
Bathrooms ([X]): $[AMOUNT]
Flooring: $[AMOUNT]
Paint (Interior): $[AMOUNT]
Paint (Exterior): $[AMOUNT]
Roof: $[AMOUNT]
HVAC: $[AMOUNT]
Electrical: $[AMOUNT]
Plumbing: $[AMOUNT]
Landscaping: $[AMOUNT]
Permits: $[AMOUNT]
Dumpster/Cleanup: $[AMOUNT]
Contingency (15-20%): $[AMOUNT]
Total Rehab: $[TOTAL]
HOLDING COSTS (X months)
Mortgage/Hard Money: $[AMOUNT]
Property Taxes: $[AMOUNT]
Insurance: $[AMOUNT]
Utilities: $[AMOUNT]
HOA: $[AMOUNT]
Total Holding: $[TOTAL]
SELLING COSTS
Agent Commission (5-6%): $[AMOUNT]
Seller Closing Costs (2-3%): $[AMOUNT]
Staging: $[AMOUNT]
Total Selling: $[TOTAL]
TOTAL ALL-IN COST: $[TOTAL]
SALE
ARV (After Repair Value): $[ARV]
Less Total All-In Cost: -$[TOTAL]
NET PROFIT: $[PROFIT]
RETURNS
ROI: [X]%
Annualized ROI: [X]%
Profit Margin: [X]%
Cash-on-Cash Return: [X]%
Present 3 scenarios:
| Scenario | ARV | Rehab Cost | Holding (months) | Net Profit | ROI |
|---|---|---|---|---|---|
| Best Case | +5% ARV, -10% rehab, 3 months | ||||
| Base Case | Base ARV, base rehab, 5 months | ||||
| Worst Case | -10% ARV, +25% rehab, 8 months |
| Category | Weight | What It Measures |
|---|---|---|
| Margin & ROI | 30% | Net profit margin, ROI, 70% rule compliance |
| ARV Confidence | 20% | Quality and recency of comps, market stability |
| Rehab Complexity | 20% | Scope of work, permit requirements, structural issues |
| Market Conditions | 15% | Days on market, inventory, buyer demand |
| Risk Factors | 15% | Cost overrun potential, market shift exposure, exit options |
Scoring Guide:
| Score | Grade | Signal |
|---|---|---|
| 85-100 | A+ | Slam Dunk — strong margins, simple rehab, hot market |
| 70-84 | A | Good Flip — solid numbers with manageable risk |
| 55-69 | B | Possible — thin margins or elevated risk; proceed with caution |
| 40-54 | C | Risky — one or more serious concerns; experienced flippers only |
| 25-39 | D | Marginal — numbers barely work even in best case |
| 0-24 | F | No Deal — walk away, numbers do not support a flip |
Evaluate and present these flip-specific risks:
Save the analysis as PROPERTY-FLIP-[ADDRESS].md in the current working directory. Replace spaces and special characters in ADDRESS with hyphens.
# Fix-and-Flip Analysis: [FULL ADDRESS]
> **DISCLAIMER:** For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals.
**Analysis Date:** [DATE]
**Flip Score:** [X]/100 ([GRADE])
**Signal:** [SLAM DUNK / GOOD FLIP / POSSIBLE / RISKY / MARGINAL / NO DEAL]
---
## Quick Numbers
| Metric | Value |
|--------|-------|
| Purchase Price | $[X] |
| Estimated ARV | $[X] |
| Total Rehab Budget | $[X] |
| All-In Cost | $[X] |
| Estimated Net Profit | $[X] |
| ROI | [X]% |
| 70% Rule | [PASS/FAIL] ([X]% of ARV) |
| Estimated Timeline | [X] months |
---
## 1. Property Overview
[Current condition, key specs, seller motivation, why this could be a flip opportunity]
---
## 2. After Repair Value (ARV)
### Comparable Sales
[Table: Address, Sale Price, Sq Ft, $/Sq Ft, Beds/Baths, Condition, Date Sold]
### ARV Estimate
[Methodology and confidence level]
---
## 3. Rehab Budget
### Scope of Work
[Detailed breakdown by category with line-item estimates]
### Budget Summary
[Table: Category, Low Estimate, Base Estimate, High Estimate]
### Regional Cost Adjustment
[Multiplier applied and reasoning]
---
## 4. Full P&L Breakdown
[Complete acquisition, rehab, holding, selling cost breakdown]
---
## 5. Scenario Analysis
[Best case, base case, worst case table with full numbers]
---
## 6. Timeline
| Phase | Duration | Notes |
|-------|----------|-------|
| Acquisition & Closing | [X] weeks | |
| Permits & Planning | [X] weeks | |
| Demolition & Structural | [X] weeks | |
| Rough-Ins (electrical, plumbing, HVAC) | [X] weeks | |
| Finishes (drywall, flooring, paint) | [X] weeks | |
| Kitchen & Bathrooms | [X] weeks | |
| Exterior & Landscaping | [X] weeks | |
| Final Inspections & Punch List | [X] weeks | |
| Staging & Listing | [X] weeks | |
| Under Contract to Close | [X] weeks | |
| **Total Estimated Timeline** | **[X] months** | |
---
## 7. Financing Options
| Option | Down Payment | Rate | Monthly Payment | Total Cost |
|--------|-------------|------|-----------------|-----------|
| Hard Money | | | | |
| Private Lender | | | | |
| Cash Purchase | 100% | N/A | N/A | |
| HELOC | | | | |
---
## 8. Risk Factors
[Numbered list of risks with severity: LOW / MEDIUM / HIGH]
---
## 9. Exit Strategies
| Strategy | Estimated Return | Feasibility |
|----------|-----------------|-------------|
| Flip (sell renovated) | $[X] profit | [PRIMARY] |
| Rent (hold as rental) | $[X]/month cash flow | [BACKUP] |
| Wholesale (assign contract) | $[X] assignment fee | [EMERGENCY] |
| Refinance & Hold (BRRRR) | [X]% cash-on-cash | [ALTERNATIVE] |
---
## 10. Bottom Line
[2-3 sentences: Is this a good flip? What makes or breaks the deal? What is the biggest risk?]
---
*DISCLAIMER: For educational/research purposes only. Not financial or investment advice. Always consult licensed real estate professionals. Rehab costs, ARV estimates, and timelines are approximations. Actual results may vary significantly.*
Launches 5 parallel AI agents to produce a comprehensive property analysis with composite Property Score (0-100), investment grade, and actionable recommendations
Commercial Property Analysis — NOI, cap rate, expense ratio, tenant mix, vacancy, debt coverage, replacement cost, and lease analysis with Commercial Score (0-100)
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
Finds and analyzes 5-10 comparable recent sales to estimate fair market value, calculate price adjustments, and score the property's value proposition
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
Generates MLS-ready property listing descriptions with attention-grabbing headlines, feature highlights, neighborhood context, and SEO keywords across multiple buyer-persona styles