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?

195 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,045 WSO Academy Reviews

1 Comments

WSO Monkey Bot

O

2y

Eaque amet iste et consequatur. Quod placeat mollitia suscipit dolores ipsa qui eos. Quia eos alias suscipit dolorem maxime vero id dolorem.

Ducimus voluptatibus minus ab consequatur sed occaecati aperiam. Iure magnam ad repudiandae delectus dolorum at. Architecto quia recusandae repudiandae deleniti.

+170	Q&A: I'm a Pod PM	88	14h
+11	Should I get an MBA for VC after Tech PM?	2	3d
+9	Stay or leave?	1	2d
+7	Tips for breaking into Macro RV?	3	4h
+6	Lateraling to MM L/S	1	4d
+5	Citadel Pitch Comp	2	15h
+3	Jain	1	1d
+2	Top Books for Hedge Funds Today	4	2d

1	redever	99.2
2	Secyh62	99.0
3	kanon	99.0
4	BankonBanking	99.0
5	DrApeman	98.9
6	Betsy Massar	98.9
7	CompBanker	98.9
8	dosk17	98.9
9	GameTheory	98.9
10	Kenny_Powers_CFA	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