Use this spreadsheet to calculate Cap Rate on a rental property.
And see the impact of improving various inputs to calculating Cap Rate and the effect they have on Cap Rate.
It allows you to see how Cap Rate is calculated and how changes you might make would impact your Cap Rate.
Since many multi-family properties are valued using the income approach, improving Cap Rate can increase the value of the a property.
License
This spreadsheet—and all the others on this website unless explicitly stated otherwise—is provided to current, active subscribers under the very limited Don’t Steal My Stuff license. Basically, you can use it for your own personal use only.
Spreadsheet Download
Download the latest version of the Visual Cap Rate Calculator for Rental Property™ below.
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.