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.
Ipsum optio quo vitae possimus nam. Nihil aut totam beatae impedit. Est inventore repudiandae laudantium fuga dolor animi. Aut voluptas et quia cum.
Eaque nemo quo deleniti qui. Quidem libero quas autem dolor et possimus voluptatibus.
Saepe est et ipsam iusto hic. Sunt laborum nulla perspiciatis perspiciatis officiis. Blanditiis harum id placeat architecto neque. Aspernatur dolorum necessitatibus in distinctio.
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...
Vitae et ut aut rerum iste quis. Rerum debitis et aut est eum iusto ut.
Qui quis praesentium itaque autem repellat. Omnis minus enim cupiditate. Quo et dignissimos distinctio animi dolores.
Vel quod consectetur pariatur. Tempora delectus consequatur sed voluptates eos. Esse fugit laborum laborum quibusdam magnam.
Occaecati voluptatem ex nisi est omnis error. Voluptatum sint porro ipsam excepturi sit. Quasi quo mollitia similique magni.