Help with 3-Statement Model Test
A friend sent me an old modelling test he had to complete for a BB a few years ago so that I could practice but I am having trouble with it (Balance Sheet wont Balance, not sure if margin assumptions are right). Would anyone be willing to take a look and see where I am messing up or what I should change? It's not super robust, very simple for someone who knows what they are doing I am sure. I don't know how to attach files here so I can send it or someone can tell me the best method. Would really appreciate any help.
DM me. I would be happy to help. Send all of the case materials so I know what we are working with
a
looking at this now. who created the assumptions? the bank giving the interview?
Check the solution if u really have trouble finishing. https://gofile.io/?c=63sImg
Hi sir, just wondering if I could get your help on a case too? Have it for a fin. modelling role!
DM me as well I can help you out
Heya , just wondering if I could get your help on a case too? Have it for a fin. modelling role!
Thanks
In your cash flow statement you should reflect the change in working capital items, not the actual values, like "Adjustment for AR" should be (Prior Year AR-Current Year AR) and "Adjustment for AP" should be (Current Year AP-Prior Year AP)-for assets do Prior-Current and for liabilities do Current-Prior. Then link depreciation on the bs to the cash flow statememt and link net PPE to CAPEX. Also, add net income to prior year's shareholder equity. It should balance then, I made a version that balances if you need.
a
You don't need to build a CFS for the first year of actuals. Only the projection periods
What kind of position would this test be for? Do they give these tests for investment banking analysts out of college?
Hey Bun, this is for an Investment Banking 1st year analyst who didn't have an internship.
That's a pretty rough test for a college kid. Did the test include the template or did you have to make it?
a
Just a heads up that in your model Gross PPE does not include capex. It’s also not reflected in your investing activities, but you might have already adjusted it on a newer version.
Can you email me the completed model: [email protected]
I want to practice building one in my spare time
Maybe you can post the completed model on the Github?
Would you be able to send it to me as well? Email (burner) is [email protected]
Hey, I am working on a model for US Foods and can't seem to get it to balance. I have a few ideas and I'm sure it's very simple, but I still can't figure it out. Anyone mind taking a look as well?
Sorry for hijacking.
Post it on github.
Voluptatibus modi aut nihil sit aliquam quaerat. Enim quod aperiam sed exercitationem velit. Sunt error non soluta incidunt iure animi. Sed qui quia consequatur velit rerum.
Similique est quo praesentium molestiae. Dicta perspiciatis vel rerum repudiandae praesentium et. Molestias nostrum necessitatibus et occaecati ratione inventore.
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...
At atque incidunt atque quae. In ut eos fugit expedita quia. Inventore aut officiis qui aut porro sit repudiandae. Et et eveniet iusto aut illum quae ipsa. Minus sunt cupiditate ut sequi in neque.