<< All versions
Skill v1.0.1
currentAutomated scan100/100travisjneuman/.claude/real-estate-analyzer
3 files
──Details
PublishedAugust 25, 2026 at 03:29 PM
Content Hashsha256:45b3bed8c6b0ac77...
Git SHAb8b4dd55d61b
Bump Typepatch
──Files
Files (1 file, 12.0 KB)
SKILL.md12.0 KBactive
SKILL.md · 340 lines · 12.0 KB
version: "1.0.1" name: real-estate-analyzer description: Property valuation, market analysis, investment ROI calculations, comparable analysis, and rental yield assessment. Use when evaluating real estate investments, analyzing property markets, or calculating returns.
Real Estate Analyzer
Comprehensive frameworks for property valuation, investment analysis, and market assessment.
Property Valuation Methods
Comparable Sales Approach (CMA)
The most common method for residential properties. Relies on recent sales of similar properties.
COMPARABLE SELECTION CRITERIA:1. Location: Same neighborhood or within 1 mile2. Recency: Sold within last 6 months (3 months preferred)3. Size: Within 10-20% of subject GLA (gross living area)4. Condition: Similar age, updates, and maintenance5. Style: Same property type (SFH, condo, townhome)6. Lot: Similar lot size and featuresADJUSTMENT CATEGORIES:+ / - Location premium/discount+ / - Size differential ($X per sq ft)+ / - Bedroom/bathroom count+ / - Garage, pool, upgrades+ / - Lot size difference+ / - Condition adjustment= Adjusted Comparable Value
Comparable Property Analysis Template
| Factor | Subject | Comp 1 | Adj 1 | Comp 2 | Adj 2 | Comp 3 | Adj 3 | |
|---|---|---|---|---|---|---|---|---|
| Sale Price | -- | |||||||
| Sale Date | -- | |||||||
| Distance (mi) | -- | |||||||
| GLA (sq ft) | ||||||||
| Lot Size | ||||||||
| Year Built | ||||||||
| Bedrooms | ||||||||
| Bathrooms | ||||||||
| Garage | ||||||||
| Condition | ||||||||
| Pool/Upgrades | ||||||||
| Adj. Price | -- | |||||||
| Price/Sq Ft | -- |
Income Approach (Cap Rate)
Primary method for commercial and multi-family investment properties.
NET OPERATING INCOME (NOI):Gross Potential Rent (GPR)+ Other Income (laundry, parking, storage)= Gross Potential Income (GPI)- Vacancy & Credit Loss (typically 5-10%)= Effective Gross Income (EGI)- Operating Expenses- Property taxes- Insurance- Management fees (8-12%)- Maintenance & repairs- Utilities (owner-paid)- Landscaping- Reserves for replacement (3-5%)= NET OPERATING INCOME (NOI)PROPERTY VALUE = NOI / Cap Rate
Cap Rate Calculator
| Property Type | Typical Cap Rate | Risk Profile | |
|---|---|---|---|
| Class A Multifamily | 4.0-5.5% | Low | |
| Class B Multifamily | 5.5-7.0% | Low-Medium | |
| Class C Multifamily | 7.0-9.0% | Medium | |
| Retail (NNN) | 5.0-7.0% | Medium | |
| Office (Class A) | 5.5-7.5% | Medium | |
| Industrial | 5.0-7.0% | Low-Medium | |
| Self-Storage | 5.5-8.0% | Medium | |
| Hotels | 8.0-12.0% | High |
Cost Approach
Used for unique properties, new construction, or insurance purposes.
COST APPROACH:Land Value (from comparable land sales)+ Replacement Cost New (current construction cost)- Depreciation- Physical (age, wear)- Functional (outdated features)- External/Economic (market decline, location)= ESTIMATED PROPERTY VALUE
Investment Return Calculations
Cash-on-Cash Return
ANNUAL CASH-ON-CASH RETURN:Annual Pre-Tax Cash Flow / Total Cash Invested x 100TOTAL CASH INVESTED:Down Payment+ Closing Costs+ Rehab/Renovation Costs+ Initial Reserves= Total Cash InvestedANNUAL PRE-TAX CASH FLOW:NOI- Annual Debt Service (mortgage payments)= Pre-Tax Cash FlowTarget: 8-12% for buy-and-hold residential
Rental Yield Analysis
| Metric | Formula | Good Target | |
|---|---|---|---|
| Gross Yield | Annual Rent / Purchase Price | 8-12% | |
| Net Yield | NOI / Purchase Price | 5-8% | |
| Cap Rate | NOI / Current Market Value | 5-10% | |
| Cash-on-Cash | Cash Flow / Cash Invested | 8-12% | |
| DSCR | NOI / Annual Debt Service | 1.25x+ | |
| Price-to-Rent | Purchase Price / Annual Rent | 10-15x | |
| GRM | Purchase Price / Gross Annual Income | 8-12x |
Full Investment Return Template
PURCHASE ANALYSIS:Purchase Price: $__________Down Payment (___%): $__________Loan Amount: $__________Closing Costs: $__________Renovation Budget: $__________Total Cash Required: $__________MONTHLY INCOME:Gross Monthly Rent: $__________Other Income: $__________Vacancy (___% of GMR): ($__________)Effective Monthly Income: $__________MONTHLY EXPENSES:Mortgage (P&I): $__________Property Tax: $__________Insurance: $__________HOA/Condo Fees: $__________Property Management: $__________Maintenance Reserve: $__________Utilities (owner-paid): $__________Total Monthly Expenses: $__________MONTHLY CASH FLOW: $__________ANNUAL CASH FLOW: $__________CASH-ON-CASH RETURN: ____%5-YEAR PROJECTION:Year 1 Cash Flow: $__________Cumulative CF (5 yr): $__________Equity Built (5 yr): $__________Appreciation (___/yr): $__________Total Return (5 yr): $__________Annualized ROI: ____%
Mortgage Payment Framework
MONTHLY PAYMENT (P&I):M = P [ r(1+r)^n ] / [ (1+r)^n - 1 ]Where:M = Monthly paymentP = Loan principalr = Monthly interest rate (annual / 12)n = Total number of payments (years x 12)AMORTIZATION SNAPSHOT (Year 1 vs Year 15 vs Year 30):| Period | Payment | Principal | Interest | Balance || ------- | ------- | --------- | -------- | --------- || Month 1 | | | | || Year 5 | | | | || Year 10 | | | | || Year 15 | | | | || Year 30 | | | | |
Market Analysis Framework
Market Fundamentals Assessment
| Factor | Metric | Data Source | Signal | |
|---|---|---|---|---|
| Population Growth | Annual % change | Census, BLS | > 1% = good | |
| Job Growth | YoY employment change | BLS, local data | > 2% = good | |
| Median Income Growth | YoY change | Census ACS | > 3% = good | |
| Supply Pipeline | Permits issued | Census, HUD | Monitor | |
| Vacancy Rate | % of units unoccupied | Census, CoStar | < 5% = good | |
| Days on Market | Average DOM | MLS data | < 30 = hot | |
| Price-to-Income | Median Price / Median Income | Zillow, Census | < 4x = affordable | |
| Rent-to-Income | Monthly Rent / Monthly Income | HUD, local data | < 30% = sustainable |
Neighborhood Scoring Matrix
| Category | Weight | Factors to Evaluate | Score (1-10) | |
|---|---|---|---|---|
| Employment | 25% | Job diversity, major employers, growth | ||
| Schools | 20% | Ratings, proximity, district reputation | ||
| Safety | 15% | Crime stats, trends, perception | ||
| Infrastructure | 15% | Transit, roads, walkability, internet | ||
| Amenities | 10% | Retail, dining, parks, healthcare | ||
| Growth Trend | 10% | New development, rezoning, investment | ||
| Affordability | 5% | Price relative to metro, rent trends | ||
| Total Score | 100% |
Investment Property Scorecard
PROPERTY SCORECARD:Score each factor 1-5, multiply by weight.| Factor | Weight | Score | Weighted || -------------------- | ------ | ----- | -------- || Location Quality | 20% | | || Cash Flow Potential | 20% | | || Appreciation Outlook | 15% | | || Condition / CapEx | 15% | | || Tenant Demand | 10% | | || Financing Terms | 10% | | || Management Burden | 10% | | || TOTAL | 100% | | __ / 5.0 |RATING:4.0-5.0 Strong Buy3.0-3.9 Buy / Hold2.0-2.9 Hold / Caution< 2.0 Pass
Due Diligence Checklist
Pre-Offer
- [ ] Run comparable sales analysis (3-6 recent comps)
- [ ] Verify rental income (request rent rolls, leases)
- [ ] Calculate NOI, cap rate, and cash-on-cash return
- [ ] Check zoning and permitted use
- [ ] Review neighborhood crime statistics
- [ ] Confirm flood zone and insurance requirements
- [ ] Estimate renovation/repair costs
Under Contract
- [ ] Order professional inspection (structural, roof, HVAC, plumbing, electrical)
- [ ] Order appraisal
- [ ] Review title report and survey
- [ ] Verify property taxes and assessment history
- [ ] Obtain insurance quotes
- [ ] Review HOA documents (if applicable)
- [ ] Confirm utility costs (12-month history)
- [ ] Environmental assessment (Phase I if commercial)
- [ ] Verify all permits for past renovations
- [ ] Review tenant leases and estoppel certificates
Pre-Closing
- [ ] Final walk-through inspection
- [ ] Confirm financing terms and closing costs
- [ ] Set up property management (if using)
- [ ] Transfer utilities and insurance
- [ ] Prepare lease agreements for vacant units
1031 Exchange Overview
1031 LIKE-KIND EXCHANGE:Defer capital gains tax by reinvesting proceeds into "like-kind" property.KEY RULES:- 45-day identification period (ID up to 3 properties)- 180-day closing deadline- Must use Qualified Intermediary (QI)- Equal or greater value and debt required- Same taxpayer name on both transactions- Cannot receive "boot" (cash or unlike property)IDENTIFICATION RULES:1. Three Property Rule: ID up to 3 properties of any value2. 200% Rule: ID any number, but FMV cannot exceed 200% of relinquished3. 95% Rule: ID any number if you acquire 95%+ of identified valueCOMMON PITFALLS:- Missing the 45-day or 180-day deadline- Touching proceeds (must go through QI)- Attempting related-party exchanges- Not matching debt levels (creates taxable boot)- Mixing personal use with investment use
Quick Reference: The 1% and 2% Rules
1% RULE (screening test):Monthly Rent >= 1% of Purchase Price$200,000 property should rent for >= $2,000/month2% RULE (strong cash flow):Monthly Rent >= 2% of Purchase PriceRarely achievable in appreciating markets50% RULE (expense estimate):Operating expenses = ~50% of gross rent (excluding mortgage)Quick NOI estimate = Gross Rent x 0.5070% RULE (for flips):Max Purchase = (ARV x 70%) - Repair CostsARV = After Repair Value