What is Cap Rate Formula?

The formula for the Cap Rate or Capitalization Rate is straightforward. One may calculate by dividing the net operating income by the asset’s current market value and percentage. Investors use it to evaluate real estate investment based on one year’s return and to help decide whether a property is a good deal.

Mathematically, one may represent the Cap Rate formula as:

Cap Rate Formula = Net Operating Income / Current Market Value of The Asset

You are free to use this image on you website, templates, etc., Please provide us with an attribution linkHow to Provide Attribution?Article Link to be HyperlinkedFor eg:Source: Cap Rate Formula (wallstreetmojo.com)

Explanation

You can do the calculation in the following three simple steps: –

  • Firstly, one must estimate the real estate property’s rental income correctly. Based on that, the net operating income calculation Net Operating Income CalculationNet Operating Income (NOI) is a measure of profitability representing the amount earned from its core operations by deducting operating expenses from operating revenue. It excludes non-operating costs such as loss on sale of a capital asset, interest, tax expenses.read more is done, which is the annual income generated by the real estate property minus all the expenses incurred during the operations, which include tasks like managing the property, paying taxes, insurance, etc.Secondly, the property’s current market value must be appropriately assessed, preferably by a reputed valuation professional. The current market value of the property is its worth in the marketplace.Finally, one can calculate the Cap Rate by dividing the net operating income by the current market value of the investment propertyThe Investment PropertyInvestment property refers to the real estate acquired to earn returns on the investment through rental income, royalties, dividends or future appreciation, usually in the name of an individual investor, a group of investors or an investment company for a short-term or a long-term investment.read more.

Examples of Cap Rate Formula (with Excel Template)

Let us see some simple to advanced cases to understand them better.

Example #1

Let us assume that an investor plans to buy a real estate property. The investor intends to decide on an effective metric for evaluating real estate properties based on the Cap Rate. The investor finds three properties with their respective annual income, expenses, and market values, as mentioned below: –

Now, let us do the calculation of the Cap Rate for the respective properties,

Property A

So, Cap Rate for property A = ($150,000 – $15,000) ÷ $1,500,000

= 9%

Property B

So, Cap Rate for property B = ($200,000 – $40,000) * 100% ÷ $4,500,000

= 3.56%

Property C

So, Cap Rate for property C = ($300,000 – $50,000) * 100% ÷ $2,500,000

= 10.00%

Therefore, the investor should buy property C since it offers the highest Cap Rate of 10%.

Example #2

Let us assume that another investor wants to buy a real estate property, and the investor has the below-mentioned information. The investor will invest in the property only if the Cap Rate is 10% or higher.

We have calculated the following values based on the above information, which we may use further to calculate the Cap Rate.

Annual Gross Revenue-

Annual Expense

Net Operating Income

In the below-given template, we have used the calculation of the Cap Rate equation.

So the calculation will be –

Now, investors can invest in the concerned real estate property since the calculated cap rate is higher than the investor’s target rate (10%). Therefore, based on the calculated rate, one can infer that they will recover the entire investment in = 100.00% ÷ 12.38% = 8.08 years.

Cap Rate Formula Calculator

You can use the following calculator.

Relevance and Uses

  • The principal use of a Cap Rate is to distinguish different real estate investment opportunities. Let us assume that a real estate investment offers around 4% in return while another property has a cap of about 8%. Then, the investor will most likely focus on the property with a higher return. Moreover, it can also show the trend for the property, which will indicate if there is a need for an adjustment based on the estimated rental income.From a real estate investor’s point of view, a cap is an essential tool as it enables an investor to evaluate a real estate property based on its current market value and net operating income. It helps in arriving at the initial return on an investment property.For an investor, a rising Cap Rate for a property can indicate a rise in rental income vis-à-vis the property’s price. On the other hand, the investor can see a fall in this rate as lower rental income relative to the property’s price. It can be a critical factor for an investor to decide whether the property is worth buying.Further, it can also indicate the time a real estate will take to recover the entire investment in that real estate property. Let us assume that a property offers a Cap Rate of around 10%, which means it will take ten years (= 100% ÷ 10%) for the investor to recover the entire investment.

This article is a guide to the Cap Rate Formula. Here, we discuss a cap rate example to understand the cap rate equation, calculator, and Excel template. You can learn more about financial analysis from the following articles: –

  • Beneish M-ScoreBeneish M-ScoreBeneish M score refers to a mathematical model that Professor Messod Beneish formulated to determine the manipulations done by a company in its earnings, with the help of the various financial ratios and the eight different indices used together.read moreRate Formula in ExcelRate Formula In ExcelRate function in excel is used to calculate the rate levied on a period of a loan. The required inputs for this function are number of payment periods, pmt, present value and future value.read moreReal Estate vs. Stock InvestmentReal Estate Vs. Stock InvestmentReal estate investment is the long-term investment of a property or tangible and real assets, which is a time-consuming and illiquid process. Stock investment, on the other hand, refers to investing money into one or more companies and profiting from it.read moreTriple Net LeaseTriple Net LeaseTriple Net Lease is a type of lease agreement in which the lessee (tenant) agrees to also pay for other property-related expenses such as insurance of the building, maintenance of the building, property taxes in addition to the rent.read moreDifferences between Leasehold and FreeholdDifferences Between Leasehold And FreeholdIn the case of a lease, the property is given on lease to the lessee with various restrictions on its use by the property owner. In the case of a freehold, the owner has complete ownership with no restrictions on transfer, modification, or construction.read more