🏠 Rental Property Dashboard
Purchase Price:
$
Market Value:
$
Appreciation:
—
Year
All Years ▾
📂 Load Excel
📥 Save Excel
☁️ From Server
💾 Save HTML
⚙️
📁 Data File Settings
✕
Linked Excel file
No file linked
Auto-load on open
—
Storage
File handle stored in browser IndexedDB.
Note: browsers do not expose the full folder path for security reasons — only the filename is shown above.
📂 Change File…
🔗 Unlink File
☁️ Server URL (auto-load on startup)
Save
☁️ Download Now
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
All Years ▾
+ Add Row
✓
Month
Year
Description
Category
Amount ($)
Income row
Vacancy ($0 rent)
Excluded (greyed out)