I'm trying to create an LBO for a case.
-
This might be a very stupid question, but why does a DCF model add back depreciation, but the lbo model does not in the calculation of free cash flow? (Would it be wrong to add depreciation in an LBO?)
-
What are typical IRRs? I'm getting 19% but I added depreciation into the calculation of FCF
-
What are typical financial buyer acquisition control premiums? I assumed 10% if there even is one...
-
I don't know if this is some standard, but from what I can tell blue=hard coded and black=not hard coded.. what is red?
-
What is the usual % paydown (of debt) by year 5 (exit year)? I am getting 100% by year 6, but the model goes until year 10.
Thanks!
-Learning Student
In the past funds have aimed for 20+%, but these margins have been squeezed since the financial crisis (and increase in industry competitiveness).
Not bad questions actually.
1) In a DCF adding back D&A is because it's a non-cash expense (unless it's non deductible amort.) and you
want to value the firm and it's operation of it's assets. Depreciation is subject to it's depreciation schedule and for simplicity sake, outside of the control of the firms management. In a DCF you want to know PV of the forecast-ed cash flows that are generated by your assets and firm operations and the the terminal value in perpetuity.
4) We use red to show initial investment on NPV and IRR calc's and only rare cases if something needs to stand out on the model. Have noticed that PE shops like using it a lot more some reason.
5) Really the ideal % payed down is the amount that (sans any mandatory or revolver payments) A) get's the sponsor their desired return the quickest or B) whenever you hit a specified hurdle rate. That's at least in my experience.
Not sure I understand your Q#1. D&A is non cash, hence it is added back for the FCF calc in both a DCF and an LBO.
The only real difference between the FCF in a DCF and the FCF (pre debt service) in an LBO is that the LBO FCF is levered (includes interest payments, as well as a respective tax shield) whereas the DCF FCF is unlevered (pre interest payments).
To better answer your question, can you please walk me through how you are calcing FCF? Are you starting with EBITDA or Net Income?
So I am starting off with EBITDA. Then subtracting interest expense, tax, increase in NWC and Capex for the FCF available for debt.
I am working with a very basic model but I am also referencing a full blown model so I can see what the differences are. I have worked with DCF models so I know that you add depreciation in, but as I mentioned, I'm not quite clear why you don't add it back in on the LBO model.
When you say "don't add it back", where exactly are you referring to? Are you referring to the DCF FCF when you go:
EBITDA -D&A =EBIT *(1-Tax) +D&A LBO model?
Ohhh, that was one of them retard moments i just had. I never paid attention to the fact that FCF in a dcf starts from the EBIT and not the EBITDA, but now I get it. dcf: unlevered fcf lbo: levered fcf and thats why you subtract and add it back in. Thanks!
Fugit exercitationem atque placeat non. Et molestiae qui cumque laboriosam. Eius voluptas suscipit sunt voluptas dolores. Alias dolores aut magnam iure dolor optio. Dolores enim porro ratione facilis.
Omnis illo ea minima eveniet reprehenderit molestias. Magnam sunt iure inventore porro. Dolorem nisi sint dolor ratione occaecati. Voluptatem ut nihil similique cupiditate consequuntur rerum. Explicabo perferendis illo quaerat velit et possimus ad. Error eius non modi accusantium quis.
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...