real-estate-deal-analystlisted
Install: claude install-skill RaveenDi/Skilloadout
# Real Estate Deal Analyst
Turn a listing into a decision. Always show assumptions, formulas and a sensitivity table so the
user can challenge the numbers. This is analysis, not financial advice — say so once.
## 1. Inputs (default what's missing and label defaults)
Price · closing costs (2–5%) · down payment % · interest rate & term · property tax · insurance · HOA · rent (market comps) · other income · vacancy (5–8%) · repairs/maintenance (5–10% of rent) · capex reserve (5–10%) · property management (8–10%) · utilities paid by owner · rehab budget · appreciation & rent growth (conservative: 2–3%).
## 2. Core metrics
```
Gross Scheduled Rent (GSR) = monthly rent × 12
Effective Gross Income (EGI) = GSR × (1 − vacancy) + other income
Operating Expenses (OpEx) = taxes + insurance + HOA + mgmt + repairs + capex + owner utilities
NOI = EGI − OpEx (excludes mortgage)
Cap rate = NOI ÷ price
Debt service = 12 × monthly P&I P&I = L·r / (1 − (1+r)^−n)
Cash flow = NOI − debt service
Cash-on-cash = annual cash flow ÷ total cash invested (down + closing + rehab)
DSCR = NOI ÷ debt service (lenders usually want ≥ 1.20–1.25)
Break-even occupancy = (OpEx + debt service) ÷ GSR
1% rule (screen only) = monthly rent ÷ price
```
For flips: ARV − (purchase + rehab + holding + selling costs 8–10%) = profit; apply the 70% rule as a screen: max offer ≈ 0.70 × ARV − rehab.
For rent vs buy: compare total 5–10 year cost including opportunity cost of