How to Calculate ROI on a Rental Property (Spreadsheet)
How to calculate rental property ROI in a spreadsheet: cap rate, cash-on-cash return, total return, and the realistic vacancy and expense assumptions that matter.
Investment tracking, returns, and portfolio management. Articles covering investing topics with practical guides, calculators, and spreadsheet templates.
8 articles
How to calculate rental property ROI in a spreadsheet: cap rate, cash-on-cash return, total return, and the realistic vacancy and expense assumptions that matter.
Dividend income tracker in Google Sheets. Holdings, ex-dividend dates, yield on cost, projected annual income, and a year-over-year growth view.
Track investment returns in Google Sheets with TWR and XIRR. Sample portfolio, formulas for both methods, and when each metric is the right answer.
An investment portfolio tracker spreadsheet logs holdings, dividends, and returns across accounts. Includes Excel template, ROI formula, and broker CSV import workflow.
Calculate how Roth IRA contributions grow tax-free over time. See the impact of starting early, maxing out contributions, and decades of compound growth.
Calculate how inflation affects purchasing power over time. See what today's dollars will buy in the future and what past dollars would be worth now.
Calculate expected investment returns with different portfolio allocations, contribution levels, and time horizons. Understand what historical returns actually mean.
Calculate compound interest on investments and savings. See how initial amount, rate of return, time, and contributions affect long-term growth.