From grimoire
Calculates total real estate ROI including cash flow, appreciation, leverage, and tax benefits. Useful for evaluating rental properties or comparing real estate to other investments.
How this skill is triggered — by the user, by Claude, or both
Slash command
/grimoire:calculate-real-estate-roiThe summary Claude sees in its skill listing — used to decide when to auto-load this skill
Compute the true all-in return on a real estate investment by combining cash flow, appreciation, leverage, and tax benefits into a single annualized ROI.
Compute the true all-in return on a real estate investment by combining cash flow, appreciation, leverage, and tax benefits into a single annualized ROI.
Adopted by: Every sophisticated real estate investor and private equity real estate firm (Blackstone, Starwood, Prologis) uses multi-component return analysis. The CCIM Institute (Certified Commercial Investment Member) teaches comprehensive ROI calculation as their core curriculum. BiggerPockets' property analysis tools use this framework for millions of investor evaluations. Impact: Investors who evaluate only cap rate or cash-on-cash return systematically undercount real estate's total return — especially the compounded effect of leverage and depreciation tax benefits. Conversely, investors who count appreciation as guaranteed overcount. Full ROI transparency prevents both over-investment (paying too much based on hoped-for appreciation) and under-investment (dismissing a deal with thin cash flow but strong total returns). Why best: Real estate generates returns through four simultaneous mechanisms (cash flow, appreciation, loan paydown, tax benefits) — only the all-in analysis reveals whether the investment beats alternatives. Each component can be material; ignoring any one distorts the decision.
Calculate cash-on-cash return (Year 1) — Annual Pre-Tax Cash Flow ÷ Total Cash Invested
Pre-tax cash flow = Gross rent − vacancy − operating expenses − debt service.
Total cash invested = down payment + closing costs + initial repairs.
Benchmark: 6–10% cash-on-cash is strong; < 4% is marginal unless appreciation is expected.
Calculate net operating income (NOI) — Gross Rent × (1 − Vacancy Rate) − Operating Expenses
Operating expenses include: property management (8–12%), taxes, insurance, maintenance (1% of value/year), CapEx reserve (5–10% of rent). Do NOT include debt service in NOI.
NOI is the pre-leverage return; important for comparing properties regardless of financing.
Calculate the cap rate — NOI ÷ Purchase Price
Measures unlevered yield. Benchmark varies by market: primary markets (NYC, SF) 3–4%; secondary (Denver, Austin) 5–6%; tertiary 7–9%.
Model leverage effect — Real estate ROI is amplified by leverage. Example: $100k property bought with $20k down (80% LTV). Property appreciates 5% → $5,000 gain on $20k investment = 25% ROI from appreciation alone, despite 5% gross appreciation. Leverage multiplies all returns (positive and negative).
Add principal paydown — Each mortgage payment contains principal reduction that builds equity. Year 1 principal paydown = typically 10–20% of mortgage payment in early amortization. Add to annual return.
Calculate depreciation tax benefit — Residential property depreciates over 27.5 years (IRS). Depreciable basis = purchase price − land value (land is not depreciable). Annual depreciation = depreciable basis ÷ 27.5. Tax saving = annual depreciation × marginal tax rate. A $300k property with $250k depreciable basis saves: $9,091/year × 32% marginal rate = $2,909/year in tax savings.
Compile all-in annual return — Total ROI = (Cash Flow + Appreciation + Principal Paydown + Tax Savings) ÷ Initial Cash Invested
Run 5–10 year IRR — Use internal rate of return (IRR) with projected sale price in year 5 or 10, accounting for: appreciation (use conservative 3% base case), selling costs (6–8% of sale price), remaining loan balance at sale, depreciation recapture tax at sale (25% of total depreciation taken).
Single-family rental, Midwest market: Purchase: $200k (20% down = $40k, closing costs $4k → $44k invested). Loan: $160k at 7%, P&I = $1,065/month. Gross rent: $1,800/month. Vacancy (5%): −$90. Net rent: $1,710. Expenses: management $171, taxes/insurance $300, maintenance reserve $180 = $651. NOI: $1,059. Debt service: $1,065. Cash flow: −$6/month (near breakeven). Cash-on-cash: (−$72) ÷ $44,000 = −0.2% (nearly flat). Appreciation (3%/year): $6,000. Principal paydown year 1: ~$2,200. Depreciation savings (basis $175k ÷ 27.5 × 25%): $1,591. All-in Year 1 return: ($−72 + $6,000 + $2,200 + $1,591) ÷ $44,000 = 22.1%.
Finance disclaimer: This skill encodes professional best practices for educational purposes. It is not financial advice. Consult a licensed financial advisor before making investment decisions.
npx claudepluginhub jeffreytse/grimoire --plugin grimoireEvaluates residential or commercial rental properties by calculating gross and net rental yield for investment comparison.
Quick-turn underwriting for single-asset CRE deals: computes cap rates, IRR, DSCR, equity multiple, sensitivity tables, and go/no-go scorecard from purchase price, NOI, and financing terms.
Calculates rental property metrics including NOI, cash-on-cash return, cap rate, ROI, and expense ratios from transaction data. Tracks income/expenses for Schedule E tax prep.