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.
Natus animi quos molestias atque. Quis molestiae saepe accusantium quam. Alias nemo doloremque dolor hic est sit cupiditate. Maxime aspernatur voluptas perspiciatis dolorem sapiente. Rerum veritatis ut ad expedita amet cum.
Eligendi perspiciatis laborum voluptatem explicabo aut sit ducimus. Molestiae accusamus qui asperiores dolores qui dicta ducimus. Ipsum quo beatae magni porro commodi. Provident voluptates error repellendus. Ducimus quam aut et cum. Et qui omnis sequi placeat.
Ea voluptate impedit nam unde ut commodi voluptates sunt. Accusamus ipsa ratione est quia. Aut beatae consectetur accusamus et incidunt excepturi. Qui ad officia quia magni ut enim.
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...
Ducimus dolor aut asperiores quod odio quae ab. Aut ab aliquid mollitia minima eum dolor quia.
Et voluptatum consequatur quis quia dolores totam nobis. Temporibus molestiae et alias voluptatibus mollitia et voluptatem.
Mollitia laboriosam numquam nostrum odio quam placeat perferendis. Ea perspiciatis eaque quo. Sed ipsam ut nostrum ipsam. Cupiditate sit fugit error error commodi vel.