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?

198 WSO Academy Hedge Fund Session Reviews: 4.78/5

Class of '29 Sep 2026 Cohort

5.00/5

Hedge Fund LinkedIn Review

“My meeting with Kevin Lee was super helpful and went well beyond what I originally expected. We met to discuss my LinkedIn profile, but the conversation also covered the hedge fund space and how I’m thinking about my career as a whole. I really appreciated being able to talk about both how I present myself professionally and the broader direction I want to take. As someone interested in hedge funds but also exploring other paths in finance, it was helpful to have a conversation that connected my profile to my actual interests and goals. Kevin gave me a lot to think about, and I left feeling clearer about my next steps. Overall, I really appreciated his time and willingness to go beyond the original purpose of our meeting.”

Class of '26 Sep 2026 Cohort

4.56/5

Hedge Fund Mock Interview

“He was very responsive and prepared for the meeting. He actually read the JD, resume, and looked up linkedin which sometimes other mentors doesn't actually go over those to prepare things beforehand. I appreciate his direct comments I think it saved time and actually helped me to know exactly where to improve. I also appreciated him admitting if he doesn't know about specific HF strategy. Only thing I'd suggest for him is probably sending actionable key takeaways after the meeting because other mentors did and that was very helpful. ”

See All 11,639 WSO Academy Reviews

1 Comments

WSO Monkey Bot

O

2y

Et illo aut delectus exercitationem dolores. Nemo et dolorum consequatur recusandae ut. Earum corporis ex aut et quae. Sunt inventore aut nisi ratione. Esse optio et laudantium cupiditate nesciunt dolorem.

Reply

Quote

Report

Other

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

Trending Content - Hedge Fund Forum

+12	Latest blow up / wind down	22	8h
+10	Warburg Pincus plans a JPY 9,000 per share tender for J.S.B., est. JPY 200B. How do you approach a sponsor tender in Japan?	5	15h
+9	CRH agreed to buy Arcosa at US$150 per share in cash, about US$8.5B. How do you think about the spread on a big strategic cash deal?	3	15h
+9	Future of L/S	4	16h
+9	Looking for Fund to Partner With - LMM Activist	3	10h
+7	Nuvei is paying $7.40 a share in cash for Payoneer, US$2.75B equity. How do you read a premium that is still below the debut valuation?	1	3d
+6	Moving from credit to equity?	3	9h
+3	Question on case Internship Case Study for fundamental position	1	3d
0	Small UK defence radio deal has cash up front plus earnouts, how would you read the timing?	1	15h

Career Resources

1	redever	99.2
2	BankonBanking	99.0
3	Secyh62	99.0
4	kanon	99.0
5	Betsy Massar	98.9
6	DrApeman	98.9
7	GameTheory	98.9
8	CompBanker	98.9
9	dosk17	98.9
10	Mimbs	98.8

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Projecting EPS Sensitivity

Score Breakdown

Feedback

Score Breakdown

Feedback

Elite Career Bootcamp. Top Job Offer Guaranteed.

Elite Career Bootcamp. Top Job Offer Guaranteed.

Projecting EPS Sensitivity

See All Comments - 100% Free

Trending Content - Hedge Fund Forum