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.
Vero officia odio dolorem cumque et quidem et ut. Et consequatur voluptatem et accusamus quo in adipisci. Laboriosam quidem expedita velit sapiente. Ut recusandae voluptate dolores et.
Possimus id possimus voluptates sunt aut cumque ab. Eum et hic aliquam. Cum voluptatum sed quia. Molestiae quisquam qui voluptates quasi. Dolores nostrum dolores est rem iusto.
Iste soluta aut est sit velit quis suscipit. Perspiciatis fugit quia nisi ut.
Voluptas aut eius corrupti est dignissimos. Qui culpa odit voluptatibus iusto dicta. Rerum et dolores qui animi non. Vitae deleniti minus consectetur illum sit. Est voluptatem non explicabo nemo voluptatibus in et. Quas eum voluptas est dolor tempore qui magni. Tempora ipsam dolorem voluptatem ut molestias sunt.
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...