Has anyone ever held an associate/analyst role in sales planning? I was recruited for a role and was told I will have a take home excel modeling assignment. I'm curious as to what it will be and what the task will be. I'm assuming projections with scenarios as to hitting sales targets? Does anyone have any samples or links to sales planning excel models? Thanks.
Career Resources
Career Advancement Opportunities
September 2026 Investment Banking
-
Evercore 01 99.5%
-
Moelis & Company 01 98.9%
-
JPMorgan 01 98.4%
-
Goldman Sachs 01 97.9%
-
Morgan Stanley 07 97.3%
Overall Employee Satisfaction
September 2026 Investment Banking
-
Moelis & Company No 99.5%
-
Morgan Stanley 03 98.9%
-
Evercore 01 98.4%
-
Banco Santander 02 97.9%
-
BMO Capital Markets 12 97.3%
Professional Growth Opportunities
September 2026 Investment Banking
-
Evercore 01 99.5%
-
Moelis & Company 01 98.9%
-
Morgan Stanley 07 98.4%
-
Goldman Sachs 01 97.9%
-
JPMorgan No 97.3%
Total Avg Compensation
September 2026 Investment Banking
-
Vice President (16) $429
-
Associates (51) $260
-
3rd+ Year Analyst (8) $210
-
2nd Year Analyst (26) $182
-
Intern/Summer Associate (15) $159
-
1st Year Analyst (84) $151
-
Intern/Summer Analyst (76) $101
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 |  |
99.2 |
| 2 | |
99.0 |
| 3 | |
99.0 |
| 4 | |
99.0 |
| 5 | |
98.9 |
| 6 |  |
98.9 |
| 7 | |
98.9 |
| 8 |  |
98.9 |
| 9 | |
98.9 |
| 10 | |
98.8 |
From 10 rejections to 1 dream investment banking internship
“... I believe it was the single biggest reason why I ended up with an offer...”
Exercitationem in animi omnis. Architecto dignissimos soluta ut voluptatem velit itaque. Et voluptas eaque accusantium. Est magni omnis porro ratione. Nesciunt commodi quam est.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...