Is the levered DCF formula to calculate FCF the following one:
FCF = EBIT * (1-T) + D&A - CAPEX - Change in working capital - Principal repayment - After tax interests + New loans - Taxes
And then discount it to the cost of equity right?
| +185 | Americas M&A League Table Q2 Updated | 75 | 1h |
| +134 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 28 | 55m |
| +114 | Restructuring: Anti-climactic Experience | 30 | 1h |
| +84 | IB Net Worth / Savings Check | 34 | 2h |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 2d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 1d |
| +34 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 10 | 3h |
| +31 | PWP vs BofA | 23 | 9h |
| +27 | Who pays the highest right now? | 14 | 9h |
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.
If you're calculating levered free cash flow, you discount it with the cost of equity. If you're calculating unlevered free cash flow, you discount it with WACC.
I've never seen the formula written out the way you have it for levered cash flow (including the "new loans," and it looks like you're double counting taxes?)
I'd strongly suggest reading this, definitely one of the best resources on this site: https://www.wallstreetoasis.com/forums/notes-for-technical-interview-qu…
Agree with the first poster that your treatment of taxes looks weird, and if this is for an interview, you'd probably throw your interviewer off. I think starting from EBITDA makes the most sense. I think for an interview id say something like below:
EBITDA - capex
- cash taxes
- chance in NWC
= Unlevered (technically we've got the interest tax shield in here but whatever)
- interest
- mandatory amort
+/- other (fx, etc)
= Levered
Alternatively, you can start from net income. In general, i'd just look at the cash flow statement on a 10k to see what you need to add back or deduct.
Remember though that you're usually not trying to reconcile cash exactly because you'll have items like gain/loss on FX which you might not want to model going forward.
shouldn’t you start with EBIT then tax affect it then add D&A and other adjustments to get to UFCF? as D&A is already included in COGS/SG&A within EBIT you are ignoring the tax savings from depreciation by tax affecting EBITDA instead of EBIT before making additional adjustments. is this what you mean by “cash taxes” aka EBIT * (1-t)?
agree with everything else
i always thought of the formula for FCFs as
EBIT
EBIT(1-t)
+ D&A
-CapEx
-/+ Δ NWC
UFCF
- interest
- mandatory amort
- other
LFCF
Yes.
I think building it out your way makes sense when you start reading the guides, but when you actually work in real models, you typically build it out as motley_accrual shows (usually IS and CFS are built out separately).
Yeah makes sense just wanted to double check on the “cash taxes” definition - i think it’s much better to learn it the way motley built it out than the guides
Eaque praesentium dolorem consequatur sed ea. Nesciunt molestias placeat id mollitia qui nihil. Aperiam laboriosam quos quia omnis velit doloremque.
Harum dolorem assumenda qui neque. Dolores magni velit totam labore sint vero quis. Quo ut iure ullam.
Labore nulla dolor officiis sunt. Excepturi accusamus in recusandae et sunt beatae et deleniti. Quibusdam asperiores velit et et iste. Consectetur dolore sed ut iste eligendi asperiores animi. Commodi delectus qui sunt laborum sit. Odio ut sequi maxime praesentium modi fugiat.
Optio deserunt veniam voluptas est. Velit ut aut assumenda sed ullam dolorem fuga. Laborum tenetur consequuntur quos rerum voluptate dolores voluptas. Veniam voluptate ducimus tenetur nobis. Harum enim velit iure sed sapiente. Commodi repellendus et asperiores porro non debitis sed. At soluta harum qui iusto.
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...