Rental Property Analyzer
Make smarter real estate investment decisions. Enter a property's purchase price, rent, and expenses to instantly see cap rate, cash-on-cash return, DSCR, and the 1% rule. The deal analyzer gives a clear BUY/MAYBE/PASS verdict based on your criteria. Includes a full 30-year amortization schedule, 10-year cash flow projection with adjustable growth rates, and a portfolio tracker for managing multiple properties.
Loading spreadsheet preview…
Deal analyzer with automatic BUY/MAYBE/PASS verdict based on cap rate, cash-on-cash, and DSCR
Full 30-year amortization schedule with extra payment scenarios
10-year cash flow projection with adjustable rent growth and expense growth rates
Portfolio tracker for up to 10 properties with weighted average metrics
All key metrics calculated: cap rate, cash-on-cash return, 1% rule, gross rent multiplier, DSCR
Input cells clearly marked yellow, calculated cells in green so you know what to edit
What is included in the Rental Property Analyzer?
The Rental Property Analyzer is a professional Google Sheets template with 6 tabs. Deal analyzer with automatic BUY/MAYBE/PASS verdict based on cap rate, cash-on-cash, and DSCR. Full 30-year amortization schedule with extra payment scenarios. All formulas are pre-built and auto-calculate when you enter your data.
How do I get my copy of the Rental Property Analyzer?
Click the "Copy to Google Sheets" button on this page. Google Sheets will open and prompt you to "Make a copy." Your personal copy appears in your Google Drive instantly, ready to customize with your own data.
Can I preview the Rental Property Analyzer before copying?
Yes. The live preview above shows the full spreadsheet exactly as you will receive it. You can scroll through all 6 tabs, see every formula, and explore the dashboard before making your copy.
What does the Rental Property Analyzer cost?
The Rental Property Analyzer is currently $17.99 (49% off the regular price of $34.99). This is a one-time purchase, no subscription, no recurring fees. You get lifetime access and free updates.
12-Week Year Planner
Compress annual goals into 12-week sprints with weekly scorecards, progress dashboards, and end-of-cycle reviews.
ADHD-Friendly Daily Planner
A planner built for how ADHD brains actually work, Top 3 priorities, energy tracking, dopamine menu, and no shame spirals.
Budget by Paycheck, Gig Workers Edition
Budget template designed for irregular income, allocate every payment as it arrives, in priority order.
Ready to get started?
Get instant access to this template and start using it today.
Copy to Google Sheets, $17.99Source: IRS recordkeeping guidance for small businesses, 2026.