andrew@agcapitalcfo.com

Stage 6 (2021) “Soccer Stats”

Professional Excel Templates for your Business

Stage 6 (2021) "Soccer Stats"

This is an actual case from the Financial Modeling World Cup 2021, Stage 6 (June 25-28) competition. This case is a typical data management case. The data this time is a collection of soccer match results. But don’t worry – even if you’ve never played soccer, you don’t have to know the rules or any specific things about soccer, this case is completely about data management.

Case description:

As a record keeper for the local soccer league, the objectives of this case are to compile data on team and player performance for the last three seasons, calculate the points and goal difference for each team in the league, and work out the season standings as at a given date in a season.

The previous record keepers did not keep complete records, resulting in missing information in the match data. For the 2019/20 season, the number of goals per team is missing, but the list of goal scorers is provided, which may be in various formats. For the 2018/19 season, the dates are entered as text in a mix of formats. The challenge is to fill in these gaps accurately to calculate the points and goal differences for each team in the league.

The downloadable file consists of the following:
-Task: PDF file with Case Materials; PDF file with Questions; Excel file with data for the financial model
-Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 500 regular points + 100 Extra Points for the bonus questions, while the whole 2h Stage allowed to earn 1,150 points in total.

For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at info@fmworldcup.com
You can also buy tickets to participate in the future FMWC Stages at https://fmworldcup.com/shop/

 

Reviews

There are no reviews yet.

Be the first to review “Stage 6 (2021) “Soccer Stats””

Your email address will not be published. Required fields are marked *