Cash flow statement - only one year wrong?

Help highly appreciated! I‘m currently in a recruiting process and have a week long business case to model. Only had public balance sheets and P&Ls available, entered most data (left out some minor accounts and took totals, for example for intangibles etc) and calculated cash flow statements. For three out of four years they are perfectly correct and match the change in C&CE, one year has a significant difference to the actual change in cash (around 10%). All formulas are the same, data input is correct. Have spent hours on fixing it, cannot find the error. Difference is nowhere to be found, obviously checked all differences in BS accounts in original documents with before and after accounts, all P&Ls (also all accounts I left out). Data must be correct since it was audited and filed with authorities. I even tried solver to combine any numbers into the missing cash. Any advice on how to find the mistake? What would be a common error? Otherwise, how to communicate this? Thank you!

1 Comments
 

Qui tenetur eos ea fuga. Beatae consequatur sunt ad. Et blanditiis soluta eaque.

Magnam provident qui recusandae necessitatibus debitis. Aut eos nihil dolorum repudiandae recusandae vitae. Voluptatem vero ut sint dolorem.

Dolorem quia veritatis necessitatibus aperiam qui fugiat non. Ipsam est praesentium et. Est molestias quo vero officia ipsa error.

Ab omnis consequuntur occaecati totam dolores odit sit. Sapiente ipsa consequuntur et et possimus blanditiis. Magni minima est exercitationem dolores. Aliquid exercitationem eius commodi ea facilis qui ipsum sit. Unde quia corporis vitae id. Perspiciatis minus sapiente libero nulla voluptatem.

I'm an AI bot trained on the most helpful WSO content across 17+ years.

Career Advancement Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • JPMorgan 01 98.3%
  • Guggenheim Partners 01 97.7%
  • Morgan Stanley 07 97.1%

Overall Employee Satisfaction

June 2026 Investment Banking

  • Moelis & Company No 99.4%
  • Morgan Stanley 02 98.8%
  • Evercore 01 98.3%
  • BMO Capital Markets 12 97.7%
  • Banco Santander 01 97.1%

Professional Growth Opportunities

June 2026 Investment Banking

  • Evercore 01 99.4%
  • Moelis & Company 01 98.9%
  • Morgan Stanley 06 98.3%
  • Goldman Sachs 01 97.7%
  • JPMorgan No 97.1%

Total Avg Compensation

June 2026 Investment Banking

  • Vice President (15) $434
  • Associates (44) $258
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (22) $179
  • Intern/Summer Associate (13) $156
  • 1st Year Analyst (79) $150
  • Intern/Summer Analyst (73) $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
kanon's picture
kanon
99.0
4
Secyh62's picture
Secyh62
99.0
5
CompBanker's picture
CompBanker
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
DrApeman's picture
DrApeman
98.9
8
dosk17's picture
dosk17
98.9
9
GameTheory's picture
GameTheory
98.9
10
bolo up's picture
bolo up
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...”