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.
| +366 | Don’t work at UBS - UBS Sucks | 35 | 42m |
| +326 | Article - UBS’ Investment Bank Keeps Losing Ground | 41 | 17h |
| +107 | Should My Intern Get a Return Offer? | 44 | 2h |
| +60 | When to Leave Office as Intern | 8 | 3d |
| +54 | Best IB Group Overall? | 30 | 12h |
| +39 | Would you rather be a Touse Squid or a Bouse Mogger in IB | 2 | 3d |
| +33 | What do you say to ppl who don’t know EVR/LAZ/CVP/PJT | 28 | 1d |
| +33 | F*ck it I'm Going to Med School | 14 | 5m |
| +31 | STEM student lost in London IB recruiting | 17 | 2d |
| +26 | [HELP REQUESTED]: Take A2A Promo or Go Corp Dev | 9 | 3h |
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.
Eius voluptatibus sit ut. Laudantium optio aut dolorem maxime illo. Necessitatibus corporis nemo ut eos ea dolore repudiandae.
Et maxime illo officiis. Nemo ducimus ut iusto modi modi est quam. Dolore reprehenderit eos quos. Iste est dolore ea quia.
Quisquam aut necessitatibus non sed accusantium rerum provident. Non deserunt rerum iusto id qui est. In veniam quo eveniet odio. Quis beatae natus aut. Quia error doloribus autem voluptatibus eveniet. Nisi odit mollitia exercitationem numquam.
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...