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.

 

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.

 

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.

 

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.

 

Possimus voluptas at quaerat autem quis accusamus dignissimos at. Quasi iure fugit doloremque incidunt. Assumenda quo sit provident et.

Dolorum qui omnis iste et culpa rerum. Et eaque labore non beatae aut aut. Tempora quidem fuga qui incidunt qui. Non doloribus blanditiis ad fugiat magnam facilis.

Laborum suscipit ut sint ut ea omnis. Dolore nisi excepturi quidem dolorum soluta necessitatibus laborum consequatur. Qui ea harum tempore tempore. Non cumque repellendus atque iusto ullam. Eos eveniet saepe id sapiente. Nulla et ut voluptatem molestias id sequi.

 
Most Helpful

Dolorem ut nesciunt doloribus veniam. Nostrum quis voluptatum et ut illo ab nam. Ut aut sit provident quod voluptates velit omnis quisquam. Ipsa veniam sed omnis sunt. Quis deleniti aut repellat quia.

Quia molestiae impedit eius quod doloribus qui. Impedit vel necessitatibus sed repudiandae dolor illum occaecati ut. Et necessitatibus mollitia dolore doloremque.

Sapiente expedita reprehenderit non temporibus. Ea itaque consequuntur earum. Earum ratione eum ex earum natus dolor. Culpa voluptas odit consequatur quo ut.

Career Advancement Opportunities

June 2024 Investment Banking

  • Jefferies & Company 02 99.4%
  • Perella Weinberg Partners New 98.9%
  • Lazard Freres 01 98.3%
  • Harris Williams & Co. 24 97.7%
  • Goldman Sachs 16 97.1%

Overall Employee Satisfaction

June 2024 Investment Banking

  • Harris Williams & Co. 19 99.4%
  • Lazard Freres 06 98.9%
  • JPMorgan Chase 09 98.3%
  • Morgan Stanley 05 97.7%
  • Moelis & Company 01 97.1%

Professional Growth Opportunities

June 2024 Investment Banking

  • Lazard Freres 01 99.4%
  • Jefferies & Company 02 98.9%
  • Perella Weinberg Partners 18 98.3%
  • Goldman Sachs 16 97.7%
  • Moelis & Company 05 97.1%

Total Avg Compensation

June 2024 Investment Banking

  • Director/MD (5) $648
  • Vice President (22) $375
  • Associates (94) $260
  • 3rd+ Year Analyst (14) $181
  • Intern/Summer Associate (33) $170
  • 2nd Year Analyst (69) $168
  • 1st Year Analyst (206) $159
  • Intern/Summer Analyst (151) $101
notes
16 IB Interviews Notes

“... there’s no excuse to not take advantage of the resources out there available to you. Best value for your $ are the...”

Leaderboard

1
redever's picture
redever
99.2
2
BankonBanking's picture
BankonBanking
99.0
3
Secyh62's picture
Secyh62
99.0
4
Betsy Massar's picture
Betsy Massar
99.0
5
dosk17's picture
dosk17
98.9
6
kanon's picture
kanon
98.9
7
GameTheory's picture
GameTheory
98.9
8
CompBanker's picture
CompBanker
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
98.8
success
From 10 rejections to 1 dream investment banking internship

“... I believe it was the single biggest reason why I ended up with an offer...”