Rental Property ROI Calculator
Cap rateCash-on-cashNOIDSCR5-year return
Run the numbers before you make an offer. Cap rate, cash-on-cash return, NOI, DSCR, monthly cash flow and a 5-year total return for rentals up…
$24Excel + Google Sheets
Home / Templates / Real Estate
Real Estate · Excel + Google Sheets
Landlord Income and Expense Tracker
Log rent and expenses for up to 10 rental properties in one ledger. The dashboard shows income vs. expenses by month, and the Schedule E summary is ready at tax time.
What's inside
- 1,000-row transaction ledger with categories that map to IRS Schedule E
- Rent roll with tenants, lease dates, rent due and late payments
- Dashboard by property or all properties: income, expenses, net cash flow, occupancy
- Monthly income vs. expenses chart
- Schedule E summary by property, ready for your tax preparer
- Up to 10 properties
Real screenshots
Try the free rental property calculator
Run a quick version in your browser, then get the template for the full analysis.
Questions
Does it work in Google Sheets?
Yes. Your download includes the Excel file and a PDF with a link that makes your own private Google Sheets copy in one click. Both versions work the same way.
Which version of Excel do I need?
Excel 2016 or later on Windows or Mac, or Excel for the web. No macros, add-ins or subscriptions are needed.
How do I get it after I buy?
You check out on Etsy and download the files right away from your Etsy purchases page. Etsy also emails you the download link.
Is there a Spanish version?
Yes. Control de Ingresos y Gastos para Caseros is the same template, fully in Spanish.
Is this financial advice?
No. The template is an educational tool that organizes and calculates your own numbers.
More real estate templates
BRRRR Deal Analyzer
Cash left in dealCash-out refi70% ruleWhat-if tables
Buy, rehab, rent, refinance, repeat. See how much cash you need, how much comes back at the refinance and how much stays in the deal, with hard…
$17Excel + Google Sheets