London EB Interview: 1hr DCF modelling test
I have a 1hr DCF modelling test tomorrow for an analyst role at an elite boutique in London. I can build a complete DCF within 50 minutes to a good standard, so I am relatively confident of my intrinsic modelling skills going in.
My main concern is the time it'll take to gather commercially reasonable assumptions (growth, margins, D&A % of capex etc.) from the information source they provide me with (I don't know what this is but assume it'll be broker notes).
I'd appreciate any last minute tips/recommendations you have from prior experience.
For a 50 minute test, I think it's fairly unlikely that you'll be provided with an Information Memorandum or anything particularly onerous. More likely, they'll provide some sort of briefing document that's maybe a couple of pages and might even state explicitly most of the assumptions.
It's possible that bits of the model will be pre-populated even. They'd rather test you on skills you'll need on the job (e.g. do you know how to un-lever and re-lever a beta).
That said, if I needed to give some tips, then:
What’s the rationale behind D&A being 4% of revenue?
Fair question (and apologies - it was meant as a throwaway example of the broader point but that wasn't clear) - I cover Consumer and usually it tends to be in this ballpark for, e.g. Food and Beverage companies.
More capex-intensive industries will see a much higher D&A rate.
A much better "super simple" assumption would be to hold the D&A % equal to that in the last prior historic year (or maybe average of last 3 years or something to that effect).
Look at your capex as a % of revenue as a guideline for the latter years
Thank you, appreciate the tips.
i'm sure you're probably quick with shortcuts but if you'd like a good list on hand i have some good guides. can pm if you'd like
Practising these models - what is the best way to go about this? I have some tutorials on youtube that i am working on, but is there anything else that is worth preparing? I got laid off in December and didn't get a chance to do too much modelling :/
Coming back after passing the modelling test I made this post for - honestly there is no hack, just practice, practice and practice. Focus on knowing the mechanics (formulae and layout) of a model inside out and once you've got this locked down think about what you'll do to make reasonable commercial assumptions (e.g. revenue growth, margins, cost items etc.) under pressure in a test scenario and practice a few different approaches to do so
Will send you a PM tomorrow
I have a DCF (and Accretion / Dilution) modeling test that I have to complete this week. I want to practice as much as possible, but I'm having a hard time finding tests / basic assumptions to practice with. Would you be able to point me to some resources? Thank you very much!
]
Evercore?
Neque libero qui ut excepturi et dolores. Doloribus aut est mollitia animi delectus molestias velit explicabo. Asperiores repudiandae dolore perspiciatis ipsa voluptas beatae officiis. Sint ratione ex amet ipsa quia. Nihil est voluptatem ipsam sit.
Velit fuga iusto nemo consequuntur veritatis est veritatis non. Est repudiandae iusto qui magni aliquam ipsum eius. Esse dolores enim dicta eos ut. Quam cum dolor eveniet cum.
Non et repellendus vel voluptates unde. Quia atque aut quo non aut iste. Eius quia eius et animi. Facilis aut beatae nesciunt voluptates odio.
Vel distinctio a id exercitationem. Magni commodi sunt cumque eius maxime voluptas voluptas at. Accusamus in doloribus laborum. Fugiat officia veniam tempore. Iure consequatur blanditiis necessitatibus maiores commodi neque nostrum.
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...