PE Case Study Issue: BS Cash and CFS End Cash don't Match (Financial Modeling)

Hi, so I'm working my way through this PE case study. They have given me a large QoE report file with a list of things for me to do. One of the things they asked me to do is build a CFS for the Last Twelve Months (LTM). Given that the QoE report has both an IS and BS, this seemed like a pretty straight forward task. The IS and BS are in monthly periods from Jan-18 to Sep-20, and while I hadn't seen monthly periods in IB/PE case studies before, that shouldn't really matter. Well, I built out my CFS all the way to the bottom without issue, until I compared my ending cash balance with the cash on my BS: it's off...some of the months by a significant amount. I tried reworking through all the different parts of the CFS to see if I made a mistake, but the ending cash still doesn't match BS cash for those same periods. I am stumped. Not sure if I made a boneheaded mistake that I can't find, or if I'm just a moron in thinking that BS cash and endings CFS cash always need to match (99% sure they do). Any help or pointers would be greatly appreciated. 

2 Comments
 

Quo necessitatibus consequuntur veniam quia at dignissimos. Dicta rerum repellat dicta nemo illum aut inventore. Earum eos dolores dolores odio temporibus.

Career Advancement Opportunities

September 2026 Private Equity

  • The Riverside Company 99.6%
  • Blackstone Group 99.3%
  • KKR (Kohlberg Kravis Roberts) 98.9%
  • Warburg Pincus 98.5%
  • Vista Equity Partners 98.1%

Overall Employee Satisfaction

September 2026 Private Equity

  • Blackstone Group 99.6%
  • KKR (Kohlberg Kravis Roberts) 99.3%
  • The Riverside Company 98.9%
  • Ardian 98.5%
  • Warburg Pincus 98.1%

Professional Growth Opportunities

September 2026 Private Equity

  • Bain Capital 99.6%
  • The Riverside Company 99.3%
  • Blackstone Group 98.9%
  • Starwood Capital Group 98.5%
  • KKR (Kohlberg Kravis Roberts) 98.1%

Total Avg Compensation

September 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (100) $364
  • 3rd+ Year Associate (106) $280
  • 2nd Year Associate (235) $272
  • 1st Year Associate (414) $231
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (273) $126
  • Intern/Summer Associate (39) $80
  • Intern/Summer Analyst (357) $61
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
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
GameTheory's picture
GameTheory
98.9
6
DrApeman's picture
DrApeman
98.9
7
Betsy Massar's picture
Betsy Massar
98.9
8
dosk17's picture
dosk17
98.9
9
CompBanker's picture
CompBanker
98.9
10
Linda Abraham's picture
Linda Abraham
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...”