Nothing says Happy Saturday more than a bit of number crunching. +10 for coffee! I've been looking at the Prospectuses (Prospecti?) of a few funds, and one thing that caught my eye in a couple of them were the projected cash-on-cash returns. To try and make my life a bit easier, I've been converting things into metrics I understand from the stock investing world. Namely CAGR (Compound Annual Growth Rate). Where I'm at now is I have three different CAGR metrics I need to track:
(1) The CAGR of the cash-on-cash return
(2) The CAGR of the underlying properties
(3) The total CAGR of the investment over its lifetime.
In the example table, it's a 10 year hold. Column A is the year, column B is the projected cash-on-cash growth rate from the fund's prospectus, column C is my calculation on what % that return changes year to year, and column D is the projected dividend based on 150k invested. Year 10 assumes no dividend and that the property is sold with a CAGR of 7%.
To go back to my three CAGR calculations, referencing the table, we get:
(1) The cash-on-cash return CAGR comes out to 16.24%.
(2) The CAGR on the underlying property comes out to 7%
(3) The CAGR on the investment over the 10 year holding period comes out to 12.8%
Some probably loaded questions and comments since I understand these numbers are in a bit of a vacuum...
Do these numbers seem realistic? Increasing cash-on-cash return at a 16.24% clip over 10 years would seem to require underlying assets that were horribly under-managed. Getting a CAGR of 7% on the underlying property itself would seem to require an asset that was bought well below market and / or something that was fixed up and enhanced with ancillary services. An overall CAGR of 12.8% seems fantastic, but it doesn't take much to derail that if the cash-on-cash and / or property CAGRs don't meet their targets.
Am I on the right track here?
-Jamie.