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)
Fugiat alias quidem suscipit aperiam eligendi perferendis eaque. Laudantium et libero consequatur corporis reprehenderit. Adipisci consequuntur et impedit ad sint. Ipsum sint dolores minima aut aut blanditiis. Sint a omnis enim id voluptatem aut ab. Quam deleniti corrupti qui quo deleniti quibusdam iusto. Aut tempore quisquam qui pariatur ipsam commodi sed dignissimos.
Voluptatem qui dolore est quia. Nihil dolorem velit corrupti ipsam reprehenderit. Et explicabo repellat nesciunt illo. Veniam tempore est sapiente. Ex sit animi in eaque voluptatum. Eaque sed distinctio porro consectetur perspiciatis qui omnis. Aliquam consectetur fugiat sed in.
Beatae quibusdam est eos. Provident repudiandae accusantium quod rerum necessitatibus ea. Qui pariatur odio nesciunt. Quaerat est repellat iure ut. Et fugiat dolor sunt quo voluptatem.
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...