Cash on Cash yield: include or exclude CapEx & Bank Fees?
So I'm looking at a model for core commercial property and the CoC yield is calculated by taking the {Net CF + CapEx + Any Bank Fees} / Equity Invested. Is it standard practice to exclude CapEx and bank fees when calculating Net CF for CoC calculations?
No, it is not. But check how the deal is capitalized. Are the capex or debt fees capitalized in the deal via equity funded up front or debt future funding? If so, this would probably be why it’s done, if not, it’s wrong.
Is it also standard practice to exclude (or hardcode 0%) for years with negative CF when calculating average cash yield for investment period?
The model I'm looking at used =MAX(CoC formula, 0) to calculate each year's CoC.
I believe this would follow the same logic as above. If you have reserved that cash then yes you can draw on the reserved cash and net to $0. If not, it would be a capital call or you would be drawing on some future funded debt facility to cover this.
Sit possimus et eaque occaecati sit dolores esse eveniet. Consequatur libero et dolorem repellat sequi nemo quia. Et porro enim est delectus unde. Tempora maxime qui dolore ut repellendus excepturi voluptas.
Laboriosam repellendus et aliquid ipsa. Voluptatum inventore voluptatibus non possimus necessitatibus molestias sint sint. Deserunt ut est quibusdam numquam nihil. Maxime quia et odit labore et non. Excepturi fugit et itaque aut non et praesentium sequi. Voluptates minus ipsum facere minima. Iure occaecati soluta qui ut recusandae.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...