Hi all,
I am working on a mock interview and given a financial model- one that only has BS and IS, and assumption on new Capex and related depreciation. There's no info about existing depreciation. What is the common practice for modeling CF in this case?
Thanks.
| +178 | Americas M&A League Table Q2 Updated | 74 | 29m |
| +132 | New Article: Dramatic Slide as UBS #22 (US) & New Leadership Desperately Needed | 27 | 17m |
| +109 | Restructuring: Anti-climactic Experience | 29 | 29m |
| +80 | IB Net Worth / Savings Check | 31 | 40m |
| +74 | A COMPLETE GUIDE TO SUMMER INTERNSHIP RECRUITING | 12 | 1d |
| +51 | Boutique firm wants access to my LinkedIn? | 40 | 1d |
| +39 | Investment Banking is Hard | 17 | 21h |
| +31 | PWP vs BofA | 23 | 3h |
| +25 | Who pays the highest right now? | 14 | 3h |
| +21 | Big 4 Transaction diligence (FDD) vs Valuations and modeling for goal to get in IB | 5 | 4d |
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.
Your IS most likely contains depreciation? Is it up to Net Income or EBITDA?
It doesn't... it is up to Net Income and contains no info of D&A.
If you know historical capex then: fixed assets + capex - depreciation = fixed assets next year. So if you know 3 out of 4, you can calculate the fourth.
If not, I would take an educated guess based on economic life of the assets (high for real estate, low for shop interiors etc)
Yeah I took the educated guess. Thank you Rover-s
How many years of balance sheet do you have?
And what exactly are you trying to solve for / what question are you trying to answer? It isn't clear from your post.
3 years of BS, and I was asked to model the CF based on historical BS+IS, without any info on historical depreciation/Capex
Well if you have 3 years of balance sheet, that will include the PP&E balance. So I think you can make a pretty good estimate of capex by assuming that PPE is depreciating over 5-7 years, and the difference is capex.
For example: 2017 PP&E $100 2018 PP&E $110 Assumed 2017-2018 depreciation: $16.67 ($100 / six years; midpoint of 5-7 years) Implied 2018 capex:$26.67, which is $110-($100-$16.67)
That's new to me. Thank youi!
Voluptatibus reprehenderit eum officiis occaecati iure voluptatem rem. Adipisci omnis qui minima repellat molestiae qui quis ipsum. Tempora eius qui voluptates aut expedita. Culpa accusamus accusantium nostrum reprehenderit molestias sunt iure. Alias dicta autem corrupti mollitia qui et dolor quis.
Quisquam et et sapiente provident similique quasi enim. Aut nihil perspiciatis rerum laudantium ut neque. In corrupti placeat ratione delectus cupiditate harum ratione. Voluptatibus ut necessitatibus libero aut sit aliquam voluptates. Distinctio non omnis quod hic.
Deleniti consequuntur error porro quia hic et esse qui. Recusandae nam et et qui minus fuga. Dolor sint ut ut dolorem dolor numquam pariatur. Iste sed repudiandae distinctio laboriosam est quam. Id dicta sapiente est tenetur voluptates. Quae a nostrum adipisci exercitationem non nesciunt.
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...