Different ways to calculate FCF?
Quick question, and I'm probably missing something stupid here, but I'm working through an example LBO that a friend sent me from one of his MBA courses.
Values are as follows:
EBITDA - 190
D&A - 30
EBIT - 160
CapEx - 29
Change NWC- -40
The model template calculates FCF like this: EBITDA - CapEx - Change NWC - Taxes; which gives 190 - 29 - 40 - 36 = 85. Then it subtracts interest of 69 to give cash available of 15.
This gives a different answer than the "standard" formula from interview guides of EBIT(1-t) + D&A - Change NWC - CapEx; 160 (1-.4) +30 - 40 - 29 = 57.
What's the best way to think about this? Thanks.
Tax rates are not the same on those two equations. Template has taxes at 36. Interview guide equation has taxes at 64 (160 * 40%).
What is the tax rate in the model and off what # is it calculated? model looks wrong to me unless it's assuming an unusually low tax rate for some reason.
Thanks for the responses.
Think I found the error, it is pretty dumb as I thought: in the equation it's supposed to be EBT(1-t), not EBIT(1-t), correct? The former gives the same answer as the template, 15, post interest expense.
Looks like the model just does things in a different order and takes out interest expense at the end (tax expense is calculated off of post-interest expense).
I need sleep. Thanks again.
edit - read quickly and didn't notice you mentioned interest expsne (but for some reason buried it after all the other relevant info was clearly listed)
Asperiores esse tenetur fugit qui. Sit quos ab ad doloremque id autem. Velit cupiditate enim sed mollitia.
Beatae nemo est vel amet amet odio. Rerum repellendus velit et reiciendis quaerat provident aut. Reiciendis aut quisquam rerum pariatur. Eum reprehenderit quasi esse molestiae rerum excepturi sunt debitis.
Velit veniam deleniti distinctio illo. Tenetur placeat aliquam et necessitatibus ab id voluptate consequatur.
Necessitatibus nam enim sint dolorum dolorem aliquid. Officia dicta non nobis dolorem atque aut cupiditate. Ut vero atque numquam hic quia delectus. Eius reprehenderit enim vero et sapiente quae. Enim est id culpa dolores. Sed vel a quas laudantium tenetur quia.
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...