Real Estate Deal Analyzer
Know Which Deals Win Before You Invest
What You Can Do
Analyze any real estate deal like a seasoned investor and get precise financial projections, comprehensive risk scoring, and a clear investment recommendation backed by data. You'll calculate every metric that matters (cap rates, cash flow, IRR, equity multiples), identify hidden risks before they cost you money, and compare deals side-by-side to rank your best opportunities. Make confident acquisition decisions instead of guessing.
Features
Automated calculations for rental income, expenses, debt service, cap rates, cash-on-cash returns, IRR, and break-even analysis across multiple holding periods.
Quantifies opportunity strength across 15+ financial and market factors into a single investment score (1-10 scale) so you know immediately if a deal is worth pursuing.
Identifies vulnerabilities in market conditions, tenant credit, property condition, financing, and exit strategies. Highlights deal-killers before you commit capital.
5-30 year forecasts showing monthly and annual returns under base case, upside, and downside scenarios. Models interest rate changes, rent growth, and market shifts.
Benchmarks your deal against comparable properties in the market and your existing portfolio. Shows whether you're getting market rate pricing and competitive returns.
Calculates all KPIs investors care about: ROI, IRR, cap rate, debt service coverage ratio, equity multiple, cash-on-cash return, and payback period.
Provides a clear recommendation with detailed reasoning, threshold analysis, and decision justification based on your investment criteria.
Models what happens if the market downturn, interest rates rise, tenants leave, or rehab costs overrun. Shows your true downside risk and break-even points.
Example Output
Residential Rental Analysis Example
Property: 4-Bed Single Family Home, Denver CO Purchase: $425,000 (80% LTV, 7.5% rate, 30-year)
| Metric | Value |
|---|---|
| Monthly Rent | $2,200 |
| Annual Operating Expenses | $9,240 (35%) |
| Monthly Debt Service | $3,110 |
| Monthly Cash Flow | ($1,610) |
| Cap Rate | 3.2% |
| Deal Score | 3.2/10 |
| Recommendation | HOLD - Do Not Acquire |
Risk: Negative cash flow requires 4%+ annual rent growth to break even by Year 5.
Commercial Property Decision Matrix
Property: 25,000 sq ft Office Building, Austin TX Price: $2.95M | Market Cap Rate: 5.8%
| Factor | Score | Status |
|---|---|---|
| Cash Flow Performance | 8/10 | Strong |
| Tenant Quality (60% leased to Fortune 500) | 9/10 | Excellent |
| Market Growth (Austin tech expansion) | 9/10 | Excellent |
| Interest Rate Risk | 5/10 | Moderate |
| Exit Liquidity | 7/10 | Good |
| Overall Score | 7.8/10 | STRONG BUY |
| 5-Year IRR | 11.2% | |
| Equity Multiple | 1.6x |
Key Upside: 2 vacant spaces can command $45/sq ft (currently $38). 5% annual rent growth expected.
Fix-and-Flip Risk Analysis
Deal: Purchase $185K, Rehab $75K, Target ARV $295K, 6-month hold
Stress Testing Results:
- Base Case (80% probability): $48K profit
- Downside (15% probability): $8K profit
- Worst Case (5% probability): $22K loss
Top Risks: Market timing (Phoenix cooling), rehab overruns, selling delays. Margin is tight; monitor comps weekly.
What's Included
- Complete Deal Analysis Template: Structured format that captures all deal data and runs full financial analysis without requiring spreadsheet expertise.
- Financial Modeling Framework: Automated calculations for every metric: P&L, cash flow forecasts, debt service, tax implications, and long-term wealth building.
- Risk Scoring Methodology: Evaluation rubric that identifies deal-killers, red flags, and vulnerabilities across market, property, and financing dimensions.
- Investment Decision Workflow: Step-by-step guidance from initial screening through final recommendation with decision thresholds and go/no-go criteria.
- Market Comparison Database: Reference metrics for different property types, markets, and investment strategies to benchmark your opportunities accurately.
- Example Deal Packages: 3 fully-worked analyses (residential rental, commercial building, fix-and-flip) showing the complete analysis in action.
Who It's For
- Active Real Estate Investors
- Commercial Real Estate Analysts
- Property Flippers and Fix-and-Flip Entrepreneurs
- Real Estate Agents Advising Investment Clients
- First-Time Real Estate Buyers
Best For
- Evaluating Residential Rental Property ROI
- Commercial Property Acquisition Analysis
- Fix-and-Flip Project Profitability Assessment
- Portfolio Diversification and Growth Decisions
- Comparing Multiple Investment Opportunities
You might also like
You can generate detailed budget breakdowns tailored to independent film production realities, including realistic contingencies, cost-optimization strategies, and investor-friendly categorization. The skill handles incomplete crew information, creative role combinations, and multi-source financing scenarios—producing budgets that lenders and equity investors trust for securing financing packages.
You can convert creative briefs into 3-5 distinct visual direction options complete with mood boards, color palettes, and art direction specifications within 48-72 hours. The skill helps you reconcile conflicting stakeholder preferences, establish design hierarchies that reinforce brand messaging, and identify practical production constraints before costly set construction begins. You'll generate presentation-ready assets that demonstrate how product placement, lighting, set dressing, and color strategy work together to achieve commercial objectives.
You can generate comprehensive series bibles tailored to specific streaming platforms (Netflix, Apple TV+, Amazon Prime, HBO Max) that position your concept for acquisition while maintaining creative authenticity. The skill accounts for binge-watching patterns, platform-specific content policies, algorithmic hooks, and compressed greenlight timelines that distinguish streaming development from traditional broadcast.
You can feed Claude any commercial script and receive a complete production breakdown that coordinates all departments while respecting budget and timeline constraints. Claude identifies every shot requirement, location need, talent direction, and scheduling opportunity—systematically flagging production challenges and cost-saving strategies that maintain creative impact. This eliminates manual breakdown work and ensures nothing falls through the cracks in compressed pre-production windows.
You'll design quick-change costumes that balance theatrical artistry with mechanical precision, creating specifications for Velcro placement, breakaway techniques, and layer sequencing. Claude helps you document exact dresser choreography, troubleshoot change failures during tech week, and develop backup plans for understudies—ensuring seamless transformations that keep performers safe and the production moving.
You can synthesize disparate documentary source materials—interview transcripts, archival notes, and footage descriptions—into organized narrative structures. The skill identifies thematic patterns across interviews, diagnoses pacing gaps between segments, reveals missing perspectives or unexplained concepts, and generates multiple narrative approaches before you commit to final assembly. You'll receive actionable editorial recommendations on interview clip prioritization, archival material placement, and optimal reveal sequencing.
Develop detailed visual concepts and design languages for commercial productions by transforming creative briefs and research into structured, actionable documentation. You'll generate mood boards with thematic coherence, establish color strategies aligned with brand guidelines, and produce specification documents that guide set dressing, prop sourcing, and lighting design—reducing revision cycles and ensuring departmental alignment within compressed commercial timelines.
You can rapidly conduct script breakdowns that isolate key production needs, anticipate scheduling bottlenecks, and identify directorial challenges specific to episodic television timelines. This skill translates script analysis into clear technical and creative briefs for your department heads, ensuring alignment on blocking, special requirements, and shot prioritization before principal photography begins.