Investment Analysis

# Cap Rate Calculations

## How do investors determine ROI in an unsteady market?

A capitalization rate is the overall or non-financed return on a real estate investment, akin to the return on total assets in accounting terms. A cap rate is calculated as a mathematical relationship between net operating income and an asset's value. Most commonly cap rates are extracted from transactions of buyers and sellers competing in a marketplace; but they are related to the current state of capital markets as well as the future growth outlook. So how can real estate professionals extract cap rates in today's market, where few sales exist?

Generally, cap rates are derived from real property sales via the formula cap rate (RO) = NOI ÷ value. In first quarter 2008, this cap rate derivation may have sufficed. However, since then, the conclusions would be misstated not only because of changes in time, but also because of the subprime lending crisis' impact and U.S. capital markets' failure. Thus, real estate professionals not only must be able to interpret market data, but they also must understand the capital markets' effect on cap rates - especially in illiquid markets, where sales data is limited.

Credit Crisis and Cap Rates
The relationship between cap rates and their respective capital markets often is overlooked. Leverage, or the effect of borrowed funds on return on investment, is a key component of a cap rate. Leverage generally varies from market to market and is affected by supply and demand as well as interest rates.

As a reminder, it is noteworthy that cap rates and discount rates, or internal rates of return, are not mutually exclusive. A discount rate is a measure of investment performance over a holding period that accounts for risk and return on capital. Cap rates not only account for return on capital, but also return of capital. A discount rate can be built up from a cap rate if income and growth both change at a constant rate. The buildup is derived by the formula Y = R + CR, where Y = discount (yield) rate, R = cap rate, and CR = constant rate of change.

Thus, if a market-extracted cap rate is 7 percent and the market constant rate of change is 3 percent, the discount rate is 10 percent. This calculation represents an investor's yield expectations on investment, but not return of investment. Return of investment must be calculated separately.

Since the 2008 financial meltdown, the commercial mortgage-backed securities market essentially has stopped functioning, halting most available financing for commercial real estate. Thus, how is the lack of leverage in determining a cap rate accounted for and how do the pre-crash cap rates differ from the post-crash cap rates? A look at appraisal mathematicians L.W. Ellwood's and Charles B. Akerson's analyses provides a quantifiable explanation.

The Anatomy of a Cap Rate
Cap rate quantification began with Ellwood, who is credited with developing financial valuation models at a time when appraisers commonly were using physical residual techniques such as land and buildings. In 1959, Ellwood published “Ellwood Tables for Real Estate Appraising and Financing,” which showed that by analyzing market mortgage terms and equity yields for a particular property, an appraiser could identify a suitable cap rate and thus property value. This valuation technique became known as mortgage-equity analysis. Ellwood's method allowed appraisers to incorporate and explain financing's impact on value.

From his research, Ellwood created a formula that “builds up” a property's cap rate on the basis of assumptions concerning mortgage and equity requirements. Using Ellwood's formula, a cap rate results through application of an investor's equity yield requirements, structure of debt, total change in income over the projection period, and change in total property value over the projection period. The resulting cap rate is then divided by NOI to produce a value estimate that explicitly reflects the property's financial considerations. (See “Ellwood's Formula.”)

One flaw of Ellwood's formula is its complexity. It not only requires capital markets knowledge, but also algebraic operations. Several years later, Charles Akerson simplified Ellwood's formula by altering the calculations to a series of simple arithmetic steps based on a band of investment calculations in his article “Ellwood Without Algebra,” in the July 1970 issue of The Appraisal Journal. The Akerson formula uses similar components to build up a cap rate; however, it succeeds in simplifying the steps without sacrificing results. (See “Akerson Format.”)

Sensitivity to Leverage
In addition to providing a helpful mortgage-equity valuation technique, Akerson's formula also can be used to illustrate the effects of financial leverage or debt on a particular investment. Leverage can be measured by the loan-to-value ratio (M). An LTV change can increase or decrease the equity return (Ye) depending on the specific terms: The higher the risk to the investor, the higher the equity rate an investor will seek to compensate. Leverage is considered positive when the cap rate is greater than the mortgage cap rate or mortgage constant (Rm), while negative leverage occurs when the cap rate is lower than the mortgage cap rate.

Using the Akerson model, the effect of leverage change on equity yield rates can be illustrated. (See “Akerson Format in Action.”) Assume that NOI is level at \$100,000 and the subject property can be financed with a 75 percent loan paid monthly at 8 percent annual interest over 25 years. The required market return on equity for 75 percent financing is 14 percent, and the property is expected to be sold in year 10, at which time the value is expected to have increased (?) by 10 percent. Thus, M = .75, E = .25, Rm = .092618 (The present value per payment of \$1 at 8 percent annual interest, amortized monthly over 25 years), Ye = .14 and ? = .10. The percentage of loan paid off in the holding period (P) can be determined by dividing the amortization rate of the 8-percent, 25-year full-term loan by the amortization rate of the 8-percent, 10-year holding-period loan. The percentage of loan paid off in the holding period is thus equal to 19.24 percent. The sinking fund factor (the future value per payment of \$1 amortized annually over 10 years at 14 percent equity investment rate) is 0.0517. In applying the Akerson formula, the resulting overall cap rate is .0918 or 9.18 percent. At a level NOI of \$100,000, the value of the subject property is \$1,100,000 rounded. (See chart 5.)

In this example, if the LTV is increased from 75 percent to 80 percent, the equity yield rate will increase as well from 14 percent to 15.09 percent at the same value estimate and at the same cap rate (chart 1). Since there is greater risk when less money is put down, an investor requires a higher equity yield rate for the same return. If the required equity return is unchanged, a higher value will result due to an increase in leverage and a decline in the cap rate (chart 2). Similar relationships exist with changes in the mortgage constant or equity yield rate. Increases in the mortgage constant produce decreases in the equity yield rate. Thus, leverage analysis is important as risk levels directly impact the returns to equity.

Application in 2009
So what does this mean in the current market? Consider this example: Two apartment properties were sold in July 2008 for \$1 million each. The properties sold at cap rates of about 6.50 percent. The properties were financed with new loans at 65 percent of value at interest rates of 6.00 percent for 25 years.

How would these transactions differ if they occurred in June 2009? By example, two lenders still active in the market currently quote 55 to 65 percent LTV ratios with interest rates of 6.50 to 7.50 percent (and rising) for these deals. If investors desire the same equity yields, what are the effects on value?

Based on the transaction terms and cap rates at which the apartments sold in 2008, the respective equity yield rate is about 9.00 percent and the mortgage constant is 7.73 percent at 65 percent LTV, 6.00 percent interest for 25 years, and at a 6.50 percent cap rate, all else remaining constant (chart 3).

In holding the investor's equity yield rate constant in the current credit crisis scenario, an average increase of interest rates by 100 basis points along with a 5 percent LTV ratio decline results in a 68 basis point increase in cap rates to 7.18 percent. The cap rate increase from market conditions results in a June 2009 value of \$900,000 (rounded); a value decline of 10 percent from the pre-credit crisis scenario value of \$1 million in this example (chart 4).

As revealed through dissection of Ellwood's and Akerson's formulas, a cap rate is more than merely the NOI divided by its selling price. As Akerson said in his Appraisal Journal article, “Understanding the composition of the cap rate is the key to understanding and applying mortgage-equity capitalization. Once the anatomy of the capitalization rate is exposed, the rationale of the method becomes apparent.”

By making sense of cap rate sensitivity, one gains a better understanding of how changes in financial markets correspond to changes in investment perceptions of the future, and more importantly, where the market seems to be headed in times of economic turbulence.

Ellwood's Formula

Ro = YE - M (YE + P1/Sn - RM) - DO1/Sn

(1+ DIJ) or (K)

Ro=cap rate that is used to convert income into value
YE =equity discount or yield rate is rate of return on equity capital
M =loan-to-value ratio is ratio between a mortgage loan and a property's value
P = percentage of loan paid off in holding period
1/Sn =sinking fund factor is an element in yield and change formulas that converts the total change in capital value over the projection period into an annual percentage
Rm =mortgage capitalization rate or mortgage constant reflects the relationship between annual debt service to the principal amount of the mortgage loan
?O =change in total property value over the projection period
?I=total change in income over the projection period
J=an income stabilization factor used to convert an income stream changing on a curvilinear basis into its level equivalent
K=an income stabilization factor used to convert an income stream changing at a constant ratio into its stable or level equivalent

Source: The Appraisal of Real Estate, 13th edition

Akerson Format
Loan ratio (M) x annual constant (RM)
+ Equity ratio (1-M) x equity yield rate (YE)
- Loan ratio (M) x % paid off in projection period (P) x 1/Sn
= Basic rate (r)
+ Depreciation or - gain x 1/Sn
= Overall cap rate (RO)

Tables 1 - 5

## Recommended

### Game Changer

September.October.17

Tech-savvy investors have discovered that the relatively new crowdfunding model allows them to pool their resources to reduce risk and boost returns.

### Technology Rules

July.August.17

For decades, the lack of uniformity in commercial real estate data has been the bane of the industry’s existence. To determine a value for a property before deciding to purchase it, potential real estate investors must first collect and extract key financial data from a multitude of disparate files that come in countless formats and file types. Automated data extraction can change that.

Mar.Apr.17

The year is coming to a close. Now is the time to consider charitable donations for today and tomorrow.

Individuals may think about what charities have made a difference in their lives. Or ask themselves what legacy they want to create. Now Alfred Nobel is not remembered as a cannon manufacturer but for funding the prestigious Nobel Prizes.

### Office Outfitter

May.June.17

The year is coming to a close. Now is the time to consider charitable donations for today and tomorrow.

Individuals may think about what charities have made a difference in their lives. Or ask themselves what legacy they want to create. Now Alfred Nobel is not remembered as a cannon manufacturer but for funding the prestigious Nobel Prizes.