Model Balances but...still kinda wonky. Can anyone provide some insight?

Yes I've searched the forums. Yes I've applied all the rules and advice to my model. Yes I've printed out my B/S, went line by line, and scrubbed the ENTIRE model for inaccuracies. Yes, I'm retarded.

The details: I've gone line by line and made a couple of adjustments to silly common errors until my model went from being unbalanced by -209m to a mere -29m. Still, I wasn't understanding where this discrepancy came from.

Then I noticed that my LT debt difference was supposed to be +14 (based on my B/S) but I was showing a decrease of approx -163 based on guidance. So in my roll forward my EOP LT Debt balance was driven by this pay down taken from the company's 10k. Anyways, I adjusted it to the hypothetical $14 difference, and my whole model balanced.

What gives? Should I use this "increase" in LT debt as a plug to get the model to balance or am I missing something?

Here's a drop box link with the model in question, I'm hoping someone is kind enough to take a look. I've been wacking my brain over this for 2 days now and I'm questioning my sanity and intelligence at this point.

https:// tinyurl . com /yb7mv3zv (just delete the spaces)

1 Comments
 

Iure qui architecto consectetur dolores doloribus. Ad dignissimos sunt impedit voluptas. Tempora magnam vero aut ea beatae cupiditate alias. Accusamus ducimus fuga voluptate voluptas iste quos. Aut eos tempore et iure velit velit sed. Cupiditate occaecati inventore deserunt et provident vero. Asperiores non veritatis tenetur id.

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

Career Advancement Opportunities

June 2026 Private Equity

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

Overall Employee Satisfaction

June 2026 Private Equity

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

Professional Growth Opportunities

June 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

June 2026 Private Equity

  • Principal (9) $653
  • Director/MD (24) $547
  • Vice President (98) $365
  • 3rd+ Year Associate (104) $281
  • 2nd Year Associate (235) $272
  • 1st Year Associate (411) $229
  • 3rd+ Year Analyst (33) $157
  • 2nd Year Analyst (97) $134
  • 1st Year Analyst (272) $124
  • Intern/Summer Associate (38) $81
  • Intern/Summer Analyst (355) $62
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

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...”