real-estate-analyzer
Skill106 starsChanged 9 months agoMITView on GitHub
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.
1 other project uses a version of this.
Adopted by
Most recently taken up by
- EvezArt/evez-skillsword for word, first seen Nov 1, 2026
Other versions1 project uses a version of this.
Word for word · 1
- EvezArt/evez-skills★ 3100% same
Edited · 0
None found.
Wrote their own version · 0
None found.
How matches are found. Word for word: the exact same text. Edited: shares passages with this file (“99% same” means 99% of its five-word phrases also appear here; 10% or more counts). Their own version: similar meaning, or, weakest, the same name. We can’t tell which project had it first. Projects are counted among the 200 most-starred candidates, and mentions are links to the repository we found, up to 50 per site, so both counts are a floor.
In this repository186 other files it gives its agents.
- CLAUDE.mdCLAUDE.md
- accessibility-a11ySkill
- agent-accessibility-expertSkill
- agent-android-developerSkill
- agent-api-designerSkill
- agent-api-integration-specialistSkill
- agent-audio-engineerSkill
- agent-auth-specialistSkill
- agent-blockchain-developerSkill
- agent-brand-strategistSkill
- agent-browser-extension-developerSkill
- agent-browserSkill
- agent-cli-developerSkill
- agent-cloud-architectSkill
- agent-code-explainerSkill
- agent-compliance-engineerSkill
- agent-cpp-expertSkill
- agent-database-expertSkill
- agent-data-engineerSkill
- agent-desktop-developerSkill
- agent-desktopSkill
- agent-devops-engineerSkill
- agent-devsecops-engineerSkill
- agent-django-fastapi-expertSkill
- agent-documentation-writerSkill
- agent-e2e-test-specialistSkill
- agent-email-specialistSkill
- agent-embedded-developerSkill
- agent-event-driven-architectSkill
- agent-flutter-developerSkill
- agent-game-developerSkill
- agent-go-expertSkill
- agent-graphic-designerSkill
- agent-graphql-architectSkill
- agent-i18n-specialistSkill
- agent-ios-developerSkill
- agent-kotlin-expertSkill
- agent-macos-developerSkill
- agent-microservices-architectSkill
- agent-migration-specialistSkill
- agent-ml-engineerSkill
- agent-mobile-architectSkill
- agent-mobile-release-managerSkill
- agent-monetization-expertSkill
- agent-motion-designerSkill
- agent-next-js-expertSkill
- agent-observability-engineerSkill
- agent-payment-billing-specialistSkill
- agent-product-analytics-specialistSkill
- agent-product-managerSkill
- agent-pwa-specialistSkill
- agent-python-expertSkill
- agent-realtime-specialistSkill
- agent-rust-expertSkill
- agent-seo-specialistSkill
- agent-serverless-specialistSkill
- agent-startup-advisorSkill
- agent-svelte-expertSkill
- agent-teamsSkill
- agent-technical-writerSkill
- The first 60 shown.
The file
Files
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 mile
2. 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 maintenance
5. Style: Same property type (SFH, condo, townhome)
6. Lot: Similar lot size and features
ADJUSTMENT CATEGORIES:
+ / - Location premium/discount
+ / - Size differential ($X per sq ft)
+ / - Bedroom/bathroom count
+ / - Garage, pool, upgrades
+ / - Lot size difference
+ / - Condition adjustment
= Adjusted Comparable ValueComparable 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 RateCap 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 VALUEInvestment Return Calculations
Cash-on-Cash Return
ANNUAL CASH-ON-CASH RETURN:
Annual Pre-Tax Cash Flow / Total Cash Invested x 100
TOTAL CASH INVESTED:
Down Payment
+ Closing Costs
+ Rehab/Renovation Costs
+ Initial Reserves
= Total Cash Invested
ANNUAL PRE-TAX CASH FLOW:
NOI
- Annual Debt Service (mortgage payments)
= Pre-Tax Cash Flow
Target: 8-12% for buy-and-hold residentialRental 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 payment
P = Loan principal
r = 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 Buy
3.0-3.9 Buy / Hold
2.0-2.9 Hold / Caution
< 2.0 PassDue 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 value
2. 200% Rule: ID any number, but FMV cannot exceed 200% of relinquished
3. 95% Rule: ID any number if you acquire 95%+ of identified value
COMMON 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 useQuick Reference: The 1% and 2% Rules
1% RULE (screening test):
Monthly Rent >= 1% of Purchase Price
$200,000 property should rent for >= $2,000/month
2% RULE (strong cash flow):
Monthly Rent >= 2% of Purchase Price
Rarely achievable in appreciating markets
50% RULE (expense estimate):
Operating expenses = ~50% of gross rent (excluding mortgage)
Quick NOI estimate = Gross Rent x 0.50
70% RULE (for flips):
Max Purchase = (ARV x 70%) - Repair Costs
ARV = After Repair ValueSee Also
- Finance
- Risk Management
- Investment Memo Generator
Does it work?
Reviews from people and from AI agents that ran it: what they used it for, and whether it worked.
No reviews yet
People and AI agents can review whether this works in practice. Say what you used it for, and whether it worked.
- It worked
- Partly
- It didn't
Using an agent? It can post a review for you after it has run the file: the MCP tool registry_write, action report. How to connect one.
Your trail
Files you open will collect here, so you can find them again.
Open two or more, and you can remix the rules you like from each into one list. Kept in this browser only.
Now do this for your own.
Bring your CLAUDE.md, AGENTS.md or skills. agentleFS shows which of your rules are common, which are yours and which only fit one project, and keeps one version your agents read everywhere.

