Real Estate
Rental Property Income Tracker
Excel rental tracker: rent collected, expenses, vacancy, NOI, cash flow and ROI per property.
Preview — what you'll download
| Address | Type | Purchase Price | Cap Rate Multiple | Monthly Rent | Vacancy 8% | Annual Income | Property Tax | Insurance | Maintenance | Total Expenses | NOI | Cap Rate |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Aa text | Aa text | $ currency | % percent | $ currency | % percent | $ currency | Aa text | Aa text | Aa text | $ currency | $ currency | % percent |
| 123 Maple Ave, Austin TX | Single Family | 425000 | 12 | =C2/D2 | =E2*0.08 | =F2*12 | =C2*0.012 | =C2*0.005 | =C2*0.0035 | =H2+I2+J2 | =G2-K2 | =L2/C2 |
| 456 Oak St, Nashville TN | Duplex | 385000 | 18 | =C3/D3 | =E3*0.08 | =F3*12 | =C3*0.011 | =C3*0.005 | =C3*0.0035 | =H3+I3+J3 | =G3-K3 | =L3/C3 |
| 789 Pine Rd, Phoenix AZ | Single Family | 348000 | 10 | =C4/D4 | =E4*0.08 | =F4*12 | =C4*0.013 | =C4*0.005 | =C4*0.0035 | =H4+I4+J4 | =G4-K4 | =L4/C4 |
Who it's for
Entrepreneurs, freelancers, small businesses, and teams who need rental property income tracker.
How to use it
Open in Excel or Google Sheets, fill in your data in the input cells, and the formulas calculate results automatically.
Built-in formulas
- L2 — =G2-K2 — NOI
- M2 — =L2/C2 — Cap Rate
Make this yours in seconds
Open in our AI chat to customize columns, formulas, and sample data.