Real Estate Portfolio Tracker | Rental Property Spreadsheet (Excel, Google Sheets)

Track up to 50 rental properties and see exactly how each one builds wealth. Real estate makes money four ways: cash flow, appreciation, mortgage paydown and your goals; this tracker measures all four per property and rolls them up across the portfolio. Built with 10 connected tabs and 4,356 live formulas. Works in Excel and Google Sheets, with instant download.

The Cash Flow Engine

For every property it calculates NOI, cap rate, monthly cash flow and cash-on-cash ROI, and screens deals against the 1% rule, so a good investment is obvious at a glance.

Four ways wealth is built

• Cash flow — monthly income after the mortgage and expenses
• Appreciation & CAGR — market value over time with a compound annual growth rate
• Mortgage paydown & equity — loan balance and equity growth year by year
• Goal tracking — portfolio targets for income and equity

What you get

• Excel file with 10 connected tabs and 4,356 live formulas
• Google Sheets compatible
• Capacity for up to 50 properties
• Quick Start Guide PDF
• Free lifetime updates

Inside the system

• Start Here — portfolio settings and assumptions
• Dashboard — portfolio NOI, cap rate, cash-on-cash and equity
• Properties — details and financing per property
• Cash Flow Engine — per-property returns and the 1% rule screen
• Appreciation & CAGR — value growth tracking
• Mortgage Paydown — loan balance and equity over time
• Income & Expenses — rent roll and operating costs
• Goals — portfolio milestones

Who it is for

• Rental property investors and landlords
• House hackers tracking their first door
• Anyone evaluating deals on cap rate and cash-on-cash
• Investors building toward a portfolio target

Instant delivery

Files arrive immediately after purchase: the Excel file (.xlsx), a CSV export and a Quick Start Guide PDF. Works on Mac, Windows, iOS and Android. No subscription, no login.

For personal investment tracking only. This is not investment, real estate or financial advice; figures depend on assumptions you enter. Designed and built by SpendFlow Studio.