My Financial model won't balance

Hello everyone I'm new to WSO, and I was hoping someone could help me with a financial model I made in my spare time for International Paper. The balance sheet doesn't balance. I've noticed that the figure in the balance check (cell E114) that doesn't balance coincides with the capital expenditure figure in cell E162. And the subsequent cells in row 114 are basically the sum of all the capital expenditures in row 162. I don't want to continue with it until the mistake has been fixed. So, I've attached the file to this thread for your scrutiny, any help would be greatly appreciated. Thank you.

Attachment Size
International Paper Model XLS.xls 122.5 KB 122.5 KB
4 Comments
 
kingb

Row 222 includes CFI in CFF so you're double counting Capex.

This is correct. Good catch kingb. Can't tell you how times this happens. Very annoying.
"We're not lawyers, we're investment bankers. We call you for the paperwork. We didn't go to Harvard, we went to Wharton, and we saw you coming a mile away."
 

Dicta sequi aspernatur quos mollitia voluptates. Mollitia natus quo qui consequuntur pariatur aspernatur nostrum. Est neque soluta commodi. Porro at natus doloribus ut sunt.

Career Advancement Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • JPMorgan 01 98.4%
  • Guggenheim Partners 02 97.9%
  • Morgan Stanley 06 97.4%

Overall Employee Satisfaction

October 2026 Investment Banking

  • Moelis & Company No 99.5%
  • Morgan Stanley 02 99.0%
  • Evercore 01 98.4%
  • Banco Santander 02 97.9%
  • BMO Capital Markets 13 97.4%

Professional Growth Opportunities

October 2026 Investment Banking

  • Evercore 01 99.5%
  • Moelis & Company 01 99.0%
  • Morgan Stanley 05 98.4%
  • Goldman Sachs 01 97.9%
  • JPMorgan No 97.4%

Total Avg Compensation

October 2026 Investment Banking

  • Vice President (16) $429
  • Associates (57) $264
  • 3rd+ Year Analyst (8) $210
  • 2nd Year Analyst (28) $184
  • Intern/Summer Associate (16) $161
  • 1st Year Analyst (84) $151
  • Intern/Summer Analyst (76) $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
Secyh62's picture
Secyh62
99.0
3
kanon's picture
kanon
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
DrApeman's picture
DrApeman
98.9
6
dosk17's picture
dosk17
98.9
7
GameTheory's picture
GameTheory
98.9
8
Betsy Massar's picture
Betsy Massar
98.9
9
CompBanker's picture
CompBanker
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...”