I am NOT the biggest fan of Cap Rates; I much prefer Cash on Cash Return on Investment.
Why?
Because Cap Rates do not take into account the financing you can get on a property.
Cash on Cash Return on Investment does take into account the financing.
But, if you’re a Cap Rate guy or gal and want a really simple spreadsheet for keeping track of the Cap Rates of your rental portfolio, you can download the super simple spreadsheet I just made while preparing for an upcoming class.
Paying subscribers can download the Rental Portfolio Cap Rates spreadsheet below for use in Excel or Google Sheets.
Keep reading with a 7-day free trial
Subscribe to Real Estate Financial Planner™ to keep reading this post and get 7 days of free access to the full post archives.