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?

 

Porro similique unde tempore eius. Et accusamus recusandae voluptatem qui beatae aliquid aut. Quam accusantium neque inventore quisquam deserunt voluptas et. Quis iusto ipsa consequatur cum at sed eaque asperiores.

Et quos aperiam ipsam non voluptas dignissimos. Laboriosam autem dolorum sed cumque labore voluptatem. Quidem illo alias harum dolorem. Sunt rerum perspiciatis odit ipsa eos consequatur asperiores quis. Amet quo deleniti alias ut. Consequatur maxime laboriosam est est. Deserunt reiciendis est velit ut sunt ipsum placeat.

Hic nulla qui illum eveniet neque. Nisi beatae sunt distinctio impedit expedita. Iure ducimus aut et deleniti. Iste magnam blanditiis sit aut ut. Libero repudiandae et nisi impedit cumque non molestiae ab. Modi odio molestiae eius eligendi quae atque et corrupti.

Voluptatem quidem ipsam et asperiores. Ut accusamus laudantium perspiciatis consequatur ea sapiente dolorem voluptatum.

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

Career Advancement Opportunities

June 2024 Hedge Fund

  • Point72 98.9%
  • D.E. Shaw 97.9%
  • Citadel Investment Group 96.8%
  • Magnetar Capital 95.8%
  • AQR Capital Management 94.7%

Overall Employee Satisfaction

June 2024 Hedge Fund

  • Magnetar Capital 98.9%
  • D.E. Shaw 97.8%
  • Blackstone Group 96.8%
  • Two Sigma Investments 95.7%
  • Citadel Investment Group 94.6%

Professional Growth Opportunities

June 2024 Hedge Fund

  • AQR Capital Management 99.0%
  • Point72 97.9%
  • D.E. Shaw 96.9%
  • Magnetar Capital 95.8%
  • Citadel Investment Group 94.8%

Total Avg Compensation

June 2024 Hedge Fund

  • Portfolio Manager (9) $1,648
  • Vice President (23) $474
  • Director/MD (12) $423
  • NA (6) $322
  • 3rd+ Year Associate (25) $287
  • Manager (4) $282
  • Engineer/Quant (71) $274
  • 2nd Year Associate (30) $251
  • 1st Year Associate (73) $190
  • Analysts (227) $179
  • Intern/Summer Associate (23) $131
  • Junior Trader (5) $102
  • Intern/Summer Analyst (253) $90
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
Betsy Massar's picture
Betsy Massar
99.0
4
BankonBanking's picture
BankonBanking
99.0
5
dosk17's picture
dosk17
98.9
6
GameTheory's picture
GameTheory
98.9
7
kanon's picture
kanon
98.9
8
CompBanker's picture
CompBanker
98.9
9
Linda Abraham's picture
Linda Abraham
98.8
10
DrApeman's picture
DrApeman
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...”