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.
| Item | Value |
|---|---|
| Subject | Net operating income of $1,500,000 |
| Mortgage | 65% of value at 6.75%, 30-year amortisation, monthly payments |
| Equity dividend rate | 8.0%, the cash yield an equity buyer asks on the equity alone |
| Comparable sales | Four recent sales of similar buildings with known net operating income |
| Sale | Price | NOI | Cap rate |
|---|---|---|---|
| Sale A | $14,200,000 | $980,000 | 6.90% |
| Sale B | $21,500,000 | $1,520,000 | 7.07% |
| Sale C | $9,800,000 | $740,000 | 7.55% |
| Sale D | $17,000,000 | $1,190,000 | 7.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
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
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.
| Loan to value | Interest rate | Equity dividend rate | Cap rate | Value |
|---|---|---|---|---|
| 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.
Free Excel template: cap rate and exit yield calculator.
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%.
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.
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 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.
Not on Amazon: 36 paperbacks by Julian R. Sterling on how to read the documents, printed on demand and shipped worldwide. Browse the bookshop →
Reading guide: real estate investing, finance and fund management → · All 1908 articles →