Real Estate Financial Planner™

Real Estate Financial Planner™

Share this post

Real Estate Financial Planner™
Real Estate Financial Planner™
Rental Portfolio Cap Rates Spreadsheet

Rental Portfolio Cap Rates Spreadsheet

Easily track the cap rate of your properties.

James Orr's avatar
James Orr
Dec 29, 2022
∙ Paid
2

Share this post

Real Estate Financial Planner™
Real Estate Financial Planner™
Rental Portfolio Cap Rates Spreadsheet
Share

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.

Already a paid subscriber? Sign in
© 2025 James Orr
Privacy ∙ Terms ∙ Collection notice
Start writingGet the app
Substack is the home for great culture

Share