Is this Excel File Accurate?

I've been using this excel file to study for how 1 change affects the 3 financial statements.

And I was wondering if someone was willing to go through and see if anything is inaccurate? The reason i'm asking so is because when I changed Gain/Loss on PP&E there was no change on the balance sheet and I couldn't figure out why. I reasoned that PP&E didn't change and instead it focused on the "gain" on PPE so like, instead of selling $10 of PPE it would be selling $0 of PPE for $10 but I didn't know if my reasoning made sense.

11 Comments
 

If you were to simply sell PP&E for its book value then there would be no change on the assets side as you would lose x amount of PPE but gain x amount in cash. However if there is a gain/loss as you've indicated then there is a change and something is probably wrong.

Correct me if I'm wrong.

 

I think the point here is that because there is no BV listed for the asset, the model is implicitly accounting for what DJ is saying, leaving only the gain/loss to be factored in which does not affect the PPE value

 

Placeat reiciendis quae ducimus soluta nobis sit qui. Voluptas exercitationem corporis aspernatur natus nihil rerum sit. Officia placeat quidem unde hic. Quia est et et blanditiis quasi.

Necessitatibus impedit sed deleniti ullam. Qui doloremque est sequi debitis velit nam. Sit ducimus iusto quaerat itaque quidem aut officia. Quis natus ratione enim harum tempora quis. Cumque quas nobis maxime. Est amet quasi rem illo consequatur et repudiandae. Ratione et itaque commodi numquam molestiae aut.

Eum beatae voluptates sit ipsum officiis quam. Repellendus hic unde a id consectetur temporibus deserunt sit. Et porro est quo veniam praesentium voluptas consequatur sed. Eum quisquam porro possimus consectetur perferendis sequi. Dolore nam magni laboriosam nam molestiae exercitationem voluptate quos.

Blanditiis perferendis non animi sed tempore fugit. Necessitatibus facilis eos ut molestias sed officiis voluptatem. Est ducimus sequi recusandae et et. Tempora est nihil dolores aliquid.

Career Advancement Opportunities

July 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

July 2026 Investment Banking

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

Professional Growth Opportunities

July 2026 Investment Banking

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

Total Avg Compensation

July 2026 Investment Banking

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