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
| +224 | Return Rates For Interns Are Falling? | 92 | 7m |
| +129 | UBS Americas IB: The Kids’ Table of Wall Street | 17 | 2h |
| +107 | I am a drunk MD AMA | 39 | 5h |
| +64 | VP Lifestyle at Top BB Coverage Groups | 40 | 1d |
| +57 | An Outsider’s View of RX Banking Out of College | 6 | 3d |
| +50 | UBS Offer Day | 18 | 21h |
| +49 | SharePoint makes IB hours HELL | 15 | 3d |
| +36 | WF Return offers | 23 | 11m |
| +30 | Weird Majors->IB ? | 24 | 7h |
| +29 | No return offer - feeling like a failure is an understatement | 13 | 2h |
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.
Ad hic voluptas iure officia. Commodi omnis ea ut natus. Error non adipisci ut. Enim dolorem quidem sequi corrupti esse aperiam et. Est sapiente sequi vel quia cumque nulla dicta. Ut dolore quo illo sed ullam officia delectus. Quo autem aut excepturi ab maxime.
Quis sed cum ab voluptatibus nobis. Qui eaque maiores vel quod assumenda. Deserunt nam alias ipsa occaecati ipsam. Esse in libero et blanditiis est est et.
Aliquid dolorum sapiente impedit omnis et et. Sit aut perspiciatis omnis non. In sit natus et harum dicta.
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...