🏠 Rental Property Dashboard

Purchase Price: $ Market Value: $ Appreciation: —
Net Income
—
rent minus selected expenses
Gross Rent Collected
—
total rent received
Total Expenses
—
selected categories only
Cash-on-Cash Return
—
net income ÷ purchase price
Total ROI
—
appreciation + all income ÷ cost
Total Gain
—
appreciation + net income
Vacancy
—
months with $0 rent
📐 Investment Return Breakdown & Formula

Total Gain Calculation

Purchase Price —
Current Market Value —
Appreciation (Market − Purchase) —
+ Cumulative Net Income (all-time) —
= Total Gain —

Total ROI Formula

Total ROI = Total Gain ÷ Purchase Price × 100%
Where Total Gain = Appreciation + Cumulative Net Income
= — ÷ — × 100%
—
Cash-on-Cash Return = Annual Net Income ÷ Purchase Price × 100%
(measures yearly income yield, excluding appreciation)
Toggle Categories — include or exclude from all calculations & charts

Annual Income vs. Expenses vs. Net Income

Income & Expense Breakdown

Monthly Cash Flow

Transaction Ledger  

✓ Month Year Description Category Amount ($)
Income row
Vacancy ($0 rent)
Excluded (greyed out)