I'm building a levered DCF for a greenfield project where there is 30% equity 70% debt.
Let's say construction capex in Y1 and Y2 is 100 respectively then 30 is via equity.
When calculating returns and IRR should I be using Levered Free Cash Flow (Cash flow to equity) which varies from the actual equity investment? or link to the actual equity cash flow. In the example below, FCFE is 0 when in reality equity has funded 60 over the two years.
| +219 | UBS preparing for a October Layoff Massacre | 187 | 12m |
| +103 | Work and Suicide | 38 | 4h |
| +90 | A Message to Students Who Think this Job Will Fix Their Life | 16 | 29m |
| +53 | Is 7 years in banking enough to retire, or am I delusional? | 30 | 23m |
| +47 | Do actual investment bankers despise IB TikTokers as much as I think they do? | 28 | 1d |
| +39 | UBS IB Balance Sheet Set to take a Hit | 9 | 20h |
| +27 | Should I escape the matrix | 5 | 1d |
| +23 | LevFin, First Interview (Ever) Help! | 5 | 2d |
| +22 | JPMorgan Banker Hospitalized | 7 | 2d |
| +19 | Interview with BofA | 10 | 1d |
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.
The answer is yes. Your calculation of FCFE is just incorrect. You should be subtracting capex and adding debt draws, so your equity cash flows in those years should be -$30 assuming no other CFs for sake of simplicity.
Thanks - is that not what I have done? Debt funding is +70 and capex is - 100 which equals -30. But I am including equity funding in my formula too. Is that where I am going wrong? Thanks again
Correct, you shouldn’t be adding your equity funding in the build-up. Negative FCFE implies equity funding/injections. FCFE is used to calculate returns to the sponsor and conveys cash flow distributed to the equity sponsor if positive or contributed by the sponsor if negative. You can’t contribute money to yourself and call that positive cash flow if that makes sense.
That makes perfect sense and thanks for explaining. So the FCFE should always reflect the equity contributions/inflows in the given period. Appreciate it.
UPDATE: if I had interested expense in the example above, FCFE would be even lower than -30. Would that also be correct?
Yes correct. Though, typically, interest during construction is not a cash expense but gets added to the construction debt balance (capitalized) and is ultimately repaid with a permanent form of financing (eg term loan) at end of construction when the project becomes operational.
Non soluta sint delectus voluptas. Reprehenderit nihil non dolores ut saepe non rerum eveniet. Repudiandae aspernatur esse optio officia numquam aperiam. Quo voluptas perspiciatis dolore commodi et ipsa perspiciatis aut.
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...