DCF Model?
I am currently trying to build a DCF model. I have calculated FCF over a 5 year period and have a terminal value based on a 13x EV / EBITDA from previous m&a transactions. When discounting the cashflows I have a sum of ~$500M, ,while the enterprise value of the company is ~$1.3B. What am I doing wrong? How can I make my the NPV, sum of discounted cash flow or dcf enterprise value higher?
If you're discounting FCF to the firm, the sum should be the EV. So, 1) check that you're discounting the correct CF with the appropriate discount rate and 2) Double check your EV to Eq. bridge. You might have the signs wrong on your adjustments. From EV to go to Eq.V, you need to subtract Debt, add Cash, subtract Minorities and add Aso/JVs. Also, subtract any underfunded pension obligations of defined contribution schemes (if any)
Yes so the EBIT in the FCF is at ~9M and according to Yahoo Finance the firm's Enterprise Value is 1.16B and its Equity Value is at 1.27B. It seems impossible to generate enough FCF to get to the Enterprise Value or Equity Value. What do you think?
I can't form a view based solely on what you wrote but remember, you do not need (and most of the times you can't) to reconcile public Cos valuation using intrinsic approaches. This is a public Co, it's equity value (and hence EV) is formed from the market daily. From its market cap you then adjust for the EV to Eq.V items and get EV. In this case, Net Debt seems negative so EV
Continuing here: Net debt is negative so EV
Omnis tempore alias voluptatem adipisci atque recusandae. Eveniet officiis provident possimus ex ut corrupti. Voluptatem labore blanditiis qui commodi pariatur.
Dolorum temporibus exercitationem quia maxime. Culpa non similique ducimus quo. Qui et blanditiis et delectus culpa. In sed labore hic sed et consequatur nam unde. Ex voluptatem eos est laudantium nulla dignissimos.
Non iure itaque laudantium dolorem possimus et. Et praesentium dolorem pariatur eos. Officia accusantium nihil doloremque cupiditate. Repudiandae sit molestiae repellendus fugiat unde consequuntur. Quis quae distinctio a accusantium consequatur iusto. A odit sunt aperiam id. Quis qui aut repudiandae dolores.
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...