Hi All,
I have some interviews coming up that involve DCF testing (I believe using unlevered FCF). I understand the basic principles behind it, but I can't seem to find any practice models online.
The tests are mainly 1hr (some 2 hr) and i think will involve a template that needs to be filled in.
Can anyone share a few practice DCFs (for me to have a mock go at), or what tricks/unexpected items they may chuck in to complicate?
Thanks all
| +186 | Americas M&A League Table Q2 Updated | 75 | 5h |
| +135 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 29 | 38m |
| +115 | Restructuring: Anti-climactic Experience | 30 | 5h |
| +85 | IB Net Worth / Savings Check | 35 | 2h |
| +75 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 2d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 1d |
| +37 | Woman who emptied Knicks trashcan on street then stole it was DEI exec, worked at JPMorgan Chase | 12 | 1h |
| +31 | PWP vs BofA | 23 | 13h |
| +27 | Who pays the highest right now? | 14 | 13h |
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.
I think you need theoretical basis in financial forecasting. If you already know the theoretical aspects of DCF and you have some ideas on forecasting I suggest you to try to put it in practice.
Take a SEC 10-k and try to forecast those figures relevant to DCF (EBITDA, NWK, capex, debt etc.) using excel. It entails making assumptions (operative and financial) on the measures mentioned before looking at (i) the company-specific trends and (ii) the industry trends from both a historical and perspective points of view.
You can probably find the cost of debt on the 10-k in order to calculate the Wacc and you can apply a CAPM (+ adjustments) or a mere arbitrary cost of equity estimate.
The academic theory suggests using the perpetuity formula to calculate the Terminal value, but it is also useful adopt a market multiple to work out it.
The time horizon should be 3 or 5 years or, someone told me to work on a range of time until when annual capex will be equal or less than annual D&Aexpense.
Always, always, always rely on target (future) capital structure and market values for debt and pay attention on non-recourring items like restructuring expenses and sale of assets if you start the DCF calculation from net income rather than Ebitda.
I’ve always been told that even a 5-year forecast is a stretch and anything beyond that isn’t very helpful though. Purely because no one can read so far into the future.
But I agree, practicing on actual companies beats doing any practice question you can find out there. It’s a little bit daunting at first cause of how much you have to read but you have to tackle it sooner or later anyway.
Ratione pariatur quo ut laborum eveniet. Debitis et earum et eius accusamus ut. Quod id dignissimos ut aut. In provident inventore minus placeat rerum illum perspiciatis nisi.
Sit aperiam qui illum dolorem similique repudiandae esse. Qui alias nobis accusamus a. Quasi et consequatur dolores id molestiae sed. Asperiores ea repellendus repellendus. Unde quibusdam vel non et totam ut. Harum sit error voluptatem voluptas qui.
Rerum cum quas labore laudantium. Esse quae amet unde voluptatem necessitatibus velit. Consequatur velit ut doloribus soluta consectetur voluptatibus qui. Unde veniam in totam quaerat incidunt. Corporis et reiciendis tempore dolorem labore et. Accusantium nemo non odio exercitationem voluptatem quis magnam.
Optio ipsa reprehenderit reiciendis. Molestiae laudantium hic consequuntur esse illum qui sed est.
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...