Stage 1 (2021) "Headcount Analysis"

Description
Financial Modeling World Cup is an annual competition dedicated to financial modeling with a view of promoting healthy competition and education. FMWC challenges participants through a range of different types of questions. To answer everything correctly and win prizes, it takes a wide spectrum of skills and knowledge related to financial modeling. The competition is structured in a way that each participant accumulates points during the season by participating in as many monthly Stages as they desire. At the end of the season (December), the overall winners are announced and the prize fund is distributed. Additional monthly prize money is distributed to the best performing participants of each stage.

This is an actual case from the Financial Modeling World Cup 2021, Stage 1 (Jan 22-25) competition. This case deals with employee turnover data structuring and analysis.

The downloadable file consists of the following:
-Task: Excel file with given case assumptions; PDF file with Case Materials; PDF file with Questions.
-Solution: 2 Excel files with different approaches to the Solution Model; PDF file with correct Answers in Bold.

This model awarded 450 points + 150 Extra Points, while the whole 2h Stage allowed to earn 1,150 points in total.

For your questions/suggestions/consideration please contact us through our Eloquent channel.