Commercial Real Estate Valuation Tool

Cash on Cash Rate of Return w/ Integral Debt Coverage Ratio

Calculate a Property’s Rate of Return

There are different ways to estimate a rental property’s financial returns. Most of them are complicated, like the Blended Discount Rate of Return and the Internal Rate of Return ¬†However, if it is a fairly simple rental property and you are not a real estate investment trust for example, over my career I have developed the one sheet shown above, which I call “The Cash on Cash Return with DCR.” This includes the Net Operating Income Calculation, the Cap Rate, two mortgage amortizations, the pre mortgage paydown, the post mortgage paydown, debt covereage ratio, the property valuation at a specified cap rate and the initial cash requirements required to purchase the property.

As a comparison, if you take a bond that costs you $100 to purchase and it earns you $6 annual interest, its cash on cash return is $6.00/$100.00 or 6.00% annually.  Residential rental properties, although they have many more calculations and computations, conceptially the caclulation of the rate of return is no more complicated than the bond example.

Contact Mike Today