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?
| +132 | If Tik Tok is forced to sell, what banks do you think would be involved in the deal? | 60 | 3h | |
| +49 | Intern Ettiquette | 14 | 18h | |
| +47 | Ranking banks that went under | 34 | 17h | |
| +42 | Relevance of A-Levels for U.K. London recruiting | 31 | 1h | |
| +39 | Burnt Out M&A ASO | 22 | 1d | |
| +31 | NEED NY RESTAURANT RECOMMENDATIONS | 23 | 33s | |
| +26 | What are hours like at BBs in London? | 48 | 1d | |
| +26 | 2024 new grads who didnt get return offers update | 12 | 1d | |
| +23 | PSA to gymcels: focus on the summer internship | 9 | 1d | |
| +21 | IB Career Guideline | 12 | 6h |
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 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<Eq.V . Whether cash flows can support such a valuation is a completely different story.
Continuing here: Net debt is negative so EV<Eq.V. Whether cash flows can support such a valuation is a different story. In terms of mechanics, make sure your cash flows calcs include all necessary adjustments, growth rates, WACC etc are correct. If you get those right you can then adjust your assumptions to get closer to the market's valuation
Et quibusdam error corporis sunt eos optio ea. Deleniti itaque inventore quam rerum dolores reiciendis non. Adipisci et modi aut aperiam eum. Aliquam molestias possimus laborum voluptatum eligendi unde ea. Et vel quas id aspernatur.
Numquam aliquid dicta repellat eos. Magnam amet officia natus et. Occaecati perspiciatis quia ut excepturi blanditiis rem. Amet soluta omnis et assumenda.
Officiis est magni laboriosam omnis velit praesentium. Placeat eum quisquam ex consequatur.
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...