Hello
I have an upcoming superday with an M&A boutique. Part of it involves making a 3-statement Excel model in 1 hour using some given assumptions. My background is finance but ive never made a 3-statement model using Excel before. Does anyone have any advice on what i should focus on learning/studying?
Also, can i expect some additional elements like debt-schedule/LBO or are they not likely to expect that much for just an intern role?
Thanks guys
| +117 | Is my life over after not getting GS? | 28 | 1s | |
| +70 | Best IB group on the Street | 32 | 10m | |
| +65 | Thoughts and tips on how to speak like an investment banker. | 25 | 16h | |
| +58 | BIG FOUR ARE PARADISE | 15 | 16h | |
| +48 | Tell me one good reason why Jefferies isn’t going to be a top bank in the next 5 years | 23 | 8h | |
| +36 | UBS Outlook | 28 | 1d | |
| +35 | How to deal with egotistical team? | 6 | 3d | |
| +33 | Highest Paid Bankers in Toronto? | 51 | 13h | |
| +29 | Are you “less ambitious” for having long term goals outside of NYC | 13 | 34m | |
| +26 | Very ridiculous interview feedback | 13 | 1h |
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.
Bump
1 hour is very limited even for the most adept associates, unless it's a very simple model that doesn't need to align with actual financial statements.
Unfortunately the email I got from the VP was rather vague ("We need you to compile a 3 statement model in about an hour using given assumptions"). But if so, then I will assume that no debt-scheduling or additional analysis is required...
Sorry, but what do you mean by "unless it's a very simple model that doesn't need to align with actual financial statements"?
My guess is that you will be asked to assume some key ratios such as sales increase, gross profit rate, etc., without having to dig into the business and extract operating information like how it's done in hedge funds, because otherwise it would be weeks' workload.
By that, I mean your financial model may not align with historical financial statements. For example, if you find that when you plug the numbers in 2015 balance sheet and 2015 income statement into your cash flow model of indirect method, the net change in cash might be different from that in the actual cash flow statement. I don't know if that's a common problem in US, but it's like happening all the time in HK.
Crack open some financials and practise. I would imagine that seeming as its for a SA position the test will either be simpler than you imagine or you will not be expected to finish and its about seeing how far you can progress it.
I would imagine you will be given a very simple balance sheet, p and l and then tasked with simple assumptions e.g debt held constant etc to forecast and they are more interested with your understand of how the models link together basic accounting and then probably some analysis of the model once completed.
Thanks. I guess (and hope) it should be a bit simpler given that it is an hour only. What do you mean by "p and I". Im not too familiar with the jargon!
profit and loss - income statement.
I suggest cleaning up your excel skills as well. From now until your superday (and afterwards) try using just the keyboard in excel and learn various hotkeys to make yourself more efficient. You'd be surprised how much easier it is to build a model when you can work quickly in excel. Start with using Alt as your navigation tool through the ribbon and then learn various hotkeys like Ctrl + b to make something bold. Best of luck to you.
Will do, thanks
Might know the firm, PM me
Use multipleexpansion.com and macabacus.com to practice 3-statement models. Don't spend time learning short cuts and hot keys. Make sure you understand the fundamentals of a three statement model rather than memorizing what links to where etc.
When you say 'fundamentals' what do you mean exactly? I assumed that the relationship and linking dynamics were part of the fundamentals. Would be grateful if you could expand on this a bit
Deserunt totam impedit sit repudiandae fugit. Illo molestiae sit accusamus. Quas architecto ipsa quis doloremque.
Quidem earum corporis cupiditate vero voluptates adipisci cupiditate saepe. Voluptatem delectus dolorem voluptas ducimus quis deleniti. Ab doloribus sed vel. Repellat deserunt et explicabo aspernatur quia maiores et.
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...