Cap Rate Calculator

Looking for a sharable cap rate calculator? The cap rate is a commonly used metric in commercial real estate. It can be easily calculated using our cap rate calculator and shared with others on your team.

About Our Cap Rate Calculator

Our cap rate calculator is a simple tool that is designed to help you calculate the cap rate for commercial real estate properties on a back of the envelope basis. The capitalization rate is a widely used metric in the commercial real estate industry. It is often used by investors to determine the potential profitability of an investment, and by appraisers to estimate the value of a property. With our cap rate calculator, you can quickly and easily calculate the cap rate for any commercial property.

The calculator is designed to be simple and easy to use. It allows you to calculate the potential gross income, which is the primary potential source of income a property could generate if it were 100% occupied. The inputs required for this calculation include the property value, total rentable square feet, and average rent per square foot. Once you enter this information, the calculator will instantly show you the potential gross income calculation.

Next we have inputs for the vacancy & credit loss, and other income. Once you enter this data, then you will be shown the effective gross income for the property. This is the amount of income expected to be collected after considering tenant turnover and any other income from the property, such as vending, parking, events, etc.

The cap rate calculator also has an expense section that includes inputs for property taxes, insurance, maintenance, management fee, reserves for replacement, and other expenses. By entering this information, you will then get a net operating income (NOI) calculation. This is the amount of income that is generated by the property after all expenses have been taken into account. This figure is then divided by the property value that you entered, which provides you with the cap rate. The cap rate is the ratio of net operating income to the property’s value.

One of the most significant advantages of our cap rate calculator is its simplicity. Unlike many other financial tools, our calculator is easy to use and requires only a few inputs to generate accurate results. This makes it an ideal tool for a quick back of the envelope analysis. By using our calculator, you can quickly and easily determine the potential profitability of any commercial property.

Another advantage of our calculator is that it can be shared. Once you are done with your analysis, just click the share button and you will be able to copy a link that you can send to anyone else on your team.

Our cap rate calculator is a simple tool that can help you make better investment decisions in commercial real estate. With its easy to use interface and simple inputs, it provides you with a quick cap rate calculation that can then be shared with anyone. Whether you are a seasoned investor or a beginner, our calculator can help you determine the potential profitability of any commercial property, allowing you to make informed investment decisions.

Cap Rate Calculator in Excel

To help you quickly calculate the cap rate using various cap rate calculation methods, we’ve also created a handy cap rate calculator in Excel.

How to Use The Excel Cap Rate Calculator

Here is how you can use this cap rate calculator, step by step.

1. Download the cap rate calculator using the form above.
2. Choose the cap rate calculation method you prefer by selecting a spreadsheet tab. Methods of cap rate calculations include the cap rate ratio, band of investment, or the gordon model.
3. Enter the assumptions on the selected tab/method.
4. View the calculated cap rate.

As you can see, we’ve made it simple to use our cap rate calculator.

Cap Rate Calculator in Excel Example #1

Let’s walk through a simple ratio example using this cap rate calculator. Suppose we have an NOI of $750,000 and a property value of $10,000,000. Here’s how we can calculate the simple cap rate ratio:

As shown above, we can enter a few basic assumptions about the property to build a year 1 proforma. Then we’ll have our net operating income automatically calculated, along with the cap rate, which in this case is 7.5%.

Cap Rate Calculator in Excel Example #2

Now suppose we want to find the property value, but we don’t know what the appropriate cap rate should be. In this case, we can use the band of investment method to calculate a market-based cap rate.

The band of investment cap rate calculation method takes market-based commercial loan assumptions as well as investor rate of return requirements. Using this data, we can calculate a cap rate by taking a weighted average of the mortgage constant and the investor’s required rate of return for a project similar to the one we are evaluating. This cap rate calculator produces a cap rate that comes from the weighted average.

Cap Rate Calculator in Excel Example #3

We can also calculate the cap rate using the gordon growth model popular with valuing stocks. Since the cap rate is simply the discount rate minus the growth rate, if we know 2 out of three variables, then we can easily solve for the remaining unknown. For example, suppose we know that the discount rate (required return) is 10% and our NOI is expected to grow at a constant rate of 1%. That means our cap rate is simply 10%-1%, or 9%. If our NOI is $100,000 then that means our property value is $1,111,111.