by Jim Plante on Sun Oct 14, 2007 1:06 pm
It represents the rate at which you receive a return OF capital as well as ON capital (i.e., your profit.) In other words, it's the payment on the loan, without considering amounts escrowed for insurance and taxes. The "PI" portion of "PITI."
You need to know it because that's the amount represented by Rm in the formula Ro=Rm+Re. For example, you've got a property with conventional financing. Purchase price is $100K. To build a cap rate using the weighted average (a.k.a. "band of investments") method, you survey local banks and find out that they'll finance up to 70% of the selling price at 6.75%; The longest they'll lend for is 20 years. Surveying local investors and extracting rates from the market shows the local equity rate (cash-on-cash return) (equity dividend rate) to be 12%. In other words, if you can't get at least 12% on the money you actually have invested, then it isn't worth the trouble.
So, your cap rate is composed of (30% x 12%) plus (70% x 6.75%), right?
Not so fast, Bubba. That 6.75% represents the bank's return ON capital. What about the return OF capital? To figure that, use your HP12C to figure out the payment due on $1 at 6.75% for 20 years. Go ahead: 20 g n; 6.75 g i; -1 PV; PMT = 0.00756, if you've got it set to the beginning of the period. Otherwise, 0.00760. That's per month. Multiply it by 12 for the annual rate. In a spreadsheet, use the PMT function like this: =12*PMT(rate/12, years*12, -1,,1) (and watch those two commas in that formula!). So your mortgage financing rate is 6.75%, and your mortgage constant is 9.073%. Quite a difference.
But now you can build your cap rate: (9.073%*.70)+(.12*.30) = 9.95%
General rule of thumb for logical test of results is that the mortgage constant should be about 3% above the mortgage rate. If there's a large divergence, check and double check your numbers and methods.
Jim Plante