Articles

Band of investment cap rate vs the cap rate from sales: which should an appraiser use?

The band of investment builds a cap rate from financing terms. Its answer differs from the sales when the mortgage constant counts principal as if it were a cash cost.

Four comparable sales give a cap rate of 7.13% and a value of $21,036,248 on $1,500,000 of net operating income. A band of investment at 65% loan to value, a 6.75% loan over 30 years and an 8.0% equity dividend rate gives 7.86% and $19,086,240, 9.3% lower, because the sales imply equity buyers accept a 5.9% cash yield.

The assumptions

Illustrative office building and market, invented figures
ItemValue
SubjectNet operating income of $1,500,000
Mortgage65% of value at 6.75%, 30-year amortisation, monthly payments
Equity dividend rate8.0%, the cash yield an equity buyer asks on the equity alone
Comparable salesFour recent sales of similar buildings with known net operating income

Step 1: the cap rate from sales

Capitalisation rate extracted from each sale
SalePriceNOICap rate
Sale A$14,200,000$980,0006.90%
Sale B$21,500,000$1,520,0007.07%
Sale C$9,800,000$740,0007.55%
Sale D$17,000,000$1,190,0007.00%

Average = (6.90% + 7.07% + 7.55% + 7.00%) ÷ 4 = 7.13%, within a range of 6.90% to 7.55%

Value = 1,500,000 ÷ 0.0713 = $21,036,248

Step 2: the band of investment

Mortgage constant = annual payments ÷ loan = 12 × 0.0675/12 ÷ (1 − (1 + 0.0675/12)−360) = 7.783%

Cap rate = 65% × 7.783% + 35% × 8.00% = 5.059% + 2.800% = 7.86%

Value = 1,500,000 ÷ 0.0786 = $19,086,240

Excel: =0.65*(-PMT(0.0675/12,360,1)*12)+0.35*0.08

Step 3: why the two answers differ

The band of investment gives 7.86% against 7.13% from sales, a value $1,950,009 lower, 9.3% below the sales. The mortgage constant of 7.783% includes principal repayment, which is not a cost to the owner but a build-up of equity, while the 8.0% equity dividend rate counts only the cash yield. Setting the sales rate equal to the band and solving for the equity rate:

Implied equity dividend rate = (7.13% − 65% × 7.783%) ÷ 35% = 5.92%

Interest only: 65% × 6.75% + 35% × 8.00% = 7.19%, within 6 basis points of the sales rate

Buyers in these sales accept a cash yield near 5.9% on their equity because they also get about 1.9% a year of equity build-up from loan repayment, measured on their equity,. The 8.0% target is a total yield that already includes that build-up, so the cash part is 6.1%, close to the 5.9% the sales imply. Using 8.0% as a cash yield overstates the cap rate.

What if: the financing terms change

Band of investment under different terms
Loan to valueInterest rateEquity dividend rateCap rateValue
55%6.75%8.0%7.88%$19,033,728
65%6.75%8.0%7.86%$19,086,240
75%6.75%8.0%7.84%$19,139,042
65%6.00%8.0%7.48%$20,062,879
65%7.50%8.0%8.25%$18,173,286
65%6.75%6.0%7.16%$20,952,456
65%6.75%10.0%8.56%$17,525,278

A 1.5-point move in the interest rate changes the cap rate by 78 basis points, and a 4-point move in the equity dividend rate by 140. Loan to value hardly matters: from 55% to 75% the value moves by only $105,314, while the equity dividend rate from 6.0% to 10.0% moves it from $20,952,456 to $17,525,278. The model has no loan fees, no tax and no change in value over the hold.

The common mistakes

Takeaway

Free Excel template: cap rate and exit yield calculator.

Questions readers ask

How do you calculate a band of investment cap rate?

Weight the mortgage constant by loan to value and the equity dividend rate by the equity share. Here 65% × 7.783% + 35% × 8.00% = 7.86%.

Why is the band of investment higher than the cap rate from sales?

The mortgage constant includes principal repayment and the equity dividend rate ignores equity build-up. With an interest-only loan the same band gives 7.19%, close to the 7.13% from the sales.

Which should an appraiser rely on, the band of investment or sales?

The sales, because they show what buyers paid. The band is a cross-check: it implies the buyer’s equity yield, 5.9% here, which can be compared with what equity investors say they require.

The workbooks behind this article

The free companion files for Real Estate Appraisal rebuild the income approach, the sales and cost approaches and the reconciliation of a fictional property with live formulas. The figures in this article use invented inputs and are not in them. No account and no email address.

Open the companion files →

Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →

Also on this site

Reading guide: real estate investing, finance and fund management → · All 1908 articles →