Projecting EPS Sensitivity

I’m doing the P72 case study for the 2025 Academy Analyst LDN program, and I’m pretty much done with the model. My EPS sensitivity table keeps giving me the same numbers despite the calculations being set to auto for everything and all data points being on the same sheet. How do I fix this?

1 Comments
 

Omnis ipsam asperiores fuga amet quasi magni mollitia. Quis recusandae numquam sit commodi aut. Omnis nobis voluptatem dicta voluptas provident.

Quo et deserunt error. Enim corrupti et et velit et facilis nostrum. Maxime culpa eligendi recusandae pariatur voluptatem. Vel tempore excepturi eos quas.

Non sit nisi rerum dolorem enim in. Odio facere consequatur qui nostrum dolor. Nulla rem in cumque quis suscipit tenetur qui omnis.

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

Career Advancement Opportunities

July 2026 Hedge Fund

  • Point72 99.0%
  • D.E. Shaw 98.1%
  • Citadel Investment Group 97.1%
  • AQR Capital Management 96.1%
  • Magnetar Capital 95.1%

Overall Employee Satisfaction

July 2026 Hedge Fund

  • Magnetar Capital 99.0%
  • D.E. Shaw 98.0%
  • Blackstone Group 97.0%
  • Citadel Investment Group 96.0%
  • Millennium Partners 95.0%

Professional Growth Opportunities

July 2026 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 98.1%
  • D.E. Shaw 97.1%
  • Citadel Investment Group 96.2%
  • Magnetar Capital 95.2%

Total Avg Compensation

July 2026 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (27) $464
  • Director/MD (12) $423
  • NA (9) $320
  • Engineer/Quant (86) $288
  • 3rd+ Year Associate (26) $284
  • Manager (4) $282
  • 2nd Year Associate (32) $253
  • 1st Year Associate (77) $191
  • Analysts (242) $181
  • Intern/Summer Associate (29) $145
  • Junior Trader (5) $102
  • Intern/Summer Analyst (282) $96
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
kanon's picture
kanon
99.0
3
Secyh62's picture
Secyh62
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
Betsy Massar's picture
Betsy Massar
98.9
7
GameTheory's picture
GameTheory
98.9
8
DrApeman's picture
DrApeman
98.9
9
CompBanker's picture
CompBanker
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...”