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?
| +48 | Being asked to stay behind and train my replacement | 14 | 2d | |
| +33 | Best CRE brokerage firms | 23 | 32m | |
| +31 | New Comp Database - Google Form (Now with Data Validation) | 17 | 49m | |
| +30 | What does REPE actually do? | 12 | 1m | |
| +24 | Public Homebuilders | 9 | 2h | |
| +24 | Thoughts on joining an early-stage REPE fund | 7 | 6d | |
| +22 | REPE/Development GPA | 15 | 16h | |
| +22 | Starting University LP Fund | 5 | 13h | |
| +17 | What would your strategy be? | 14 | 4d | |
| +17 | MSRE/MSRED with no RE experience; Naive to think I’ll land a job afterwards? | 4 | 2d |
Career Resources
Get instant access to lessons taught by experienced private equity pros and bulge bracket investment bankers including financial statement modeling, DCF, M&A, LBO, Comps and Excel Modeling.
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.
Vel beatae provident consequatur iure cupiditate et facere consequatur. Quo ut vel ut. Ipsum ut repellat in nam praesentium dolore. Aut delectus cumque voluptatem ipsam eum repellendus assumenda.
Aspernatur dolorem reprehenderit et voluptatum perspiciatis. At adipisci laboriosam aut veniam nobis.
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...