real-estate-analyzer
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.
By travisjneuman · 374 installs
npx skills add travisjneuman/.claude --skill real-estate-analyzer
Source repository · Upstream listing
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 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.
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.
Investment Return Calculations
Cash on Cash Return
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
Mortgage Payment Framework
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
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
Quick Reference: The 1% and 2% Rules
See Also
[Finance](../finance/SKILL.md)
[Risk Management](../risk management/SKILL.md)
[Investment Memo Generator](../investment memo generator/SKILL.md)