Real Estate Investment Analyzer
Real Estate Investment Analyzer
Don't Buy a Property Until You've Run These Numbers
The difference between a great deal and a money pit comes down to math you can do in 5 minutes.
This spreadsheet calculates cash flow, cap rate, cash-on-cash return, and 20+ other metrics — so you can instantly tell if a property is worth your money.
11 Integrated Sheets. 1 Spreadsheet. Every Decision Covered.
Most real estate calculators give you a few metrics on one page. This tool gives you a complete professional-grade analysis suite — from deal screening to BRRRR strategy to scenario modeling — all connected so a single number change updates everything.
📊 Dashboard
Your command center — 8 KPI boxes, a 7-criteria deal scoring system (with green/red pass/fail), overall score, and quick navigation to every sheet.
📝 Deal Calculator
Enter property details, rent, and expenses → instantly see 13 automated calculations: cash flow, cap rate, cash-on-cash return, DSCR, break-even occupancy, GRM, 1%/2%/50% rule checks, and more. Full mortgage payment (PMT) and PITI calculations included.
🔄 BRRRR Analysis
Full Buy-Rehab-Rent-Refinance-Repe breakdown. Track costs for each phase, calculate cash-out at refinance, and see your monthly cash flow and ROI on the strategy.
🏠 Flip Calculator
Detailed rehab cost breakdown (11 line items + 15% contingency), purchase costs with hard money fees, selling costs with agent commission, and a clear profit summary with 70% rule check.
🏦 Mortgage Details
Complete 30-year amortization schedule — all 360 payments showing principal, interest, cumulative interest, and remaining balance. Year-end markers for easy navigation.
📈 5-Year Projections
See how equity builds, rent appreciates, and loan balance decreases over 5 years. Includes rent growth and expense growth assumptions, cumulative cash flow, and an embedded equity build-up chart.
⚖️ Property Compare
Compare up to 3 properties side-by-side on 12+ metrics — purchase price, rent, cash flow, cap rate, cash-on-cash return, and more.
🎯 Scenario Model
Test Best Case / Base Case / Worst Case scenarios. Adjust 8 assumptions (price, rent, vacancy rate, interest rate, etc.) and see how each scenario affects your returns.
📋 Investment Rules Reference
Quick reference for 10 key real estate investing rules (1% rule, 2% rule, 50% rule, 70% rule, cap rate, DSCR, etc.) with your deal's actual pass/fail status.
What Makes This Different
- ✅ 11 integrated sheets — not just one page of numbers
- ✅ 20+ automated calculations — enter data, get answers
- ✅ 360-row amortization schedule — full mortgage breakdown
- ✅ BRRRR + Flip analysis — covers all major strategies
- ✅ Scenario modeling — stress-test your assumptions
- ✅ 3-property comparison — evaluate multiple deals
- ✅ Embedded chart visualization — equity build-up over 5 years
- ✅ Conditional formatting — green/red pass/fail indicators
- ✅ Data validation dropdowns — no typing errors
- ✅ Professional formatting — dark headers, alternating rows, accent colors
- ✅ Cross-sheet references — change one number, everything updates
- ✅ Print-ready — formatted for clean output
Who It's For
Rental property investors, house flippers, BRRRR strategists, and anyone evaluating real estate deals — from first-time buyers to experienced investors who want a professional-grade analysis tool.
Technical Details
- Compatible with Excel, Google Sheets, and LibreOffice
- XLSX format — no special software needed
- All formulas included — just enter your data in yellow cells
- 11 sheets, 41KB — lightweight but comprehensive
Recent Updates
- v2.0 (Apr 2026): Complete overhaul — expanded from basic template to 11 integrated sheets. Added Dashboard with KPI scoring system, Deal Calculator with 13 automated metrics, BRRRR Analysis, Flip Calculator with detailed rehab breakdown, 30-year amortization schedule, 5-Year Projections with chart, Property Compare, Scenario Model with Best/Base/Worst case, Investment Rules reference, and How to Use guide. Added conditional formatting, data validation dropdowns, professional color scheme, and cross-sheet references.
- v1.0 (Jan 2026): Initial release — basic property analysis template.
🛡️ 30-Day Money Back Guarantee
Not the right fit? Full refund, no questions asked.
Instant digital download • Works with Excel, Google Sheets & LibreOffice