andrew@agcapitalcfo.com

Stage 4 (2021) “Jet Hockey”

Professional Excel Templates for your Business

Stage 4 (2021) "Jet Hockey"

This is a case from the Financial Modeling World Cup 2021, Stage 4 (Apr 16-19) competition. This is not your traditional financial modeling case. Here you will have to calculate the monetary value that Jet Hockey Championship fans from all over the world will add to the host country’s economy, depending on different championship outcomes.

Case description:

You have been hired by the Jet Hockey Federation of Fantastan (JHFF) to forecast the total amount spent by foreign fans during the Jet Hockey World Championships tournament. JHFF is creating a forecast for the Ministry of Tourism of Fantastan, predicting the amount of money the incoming fans will spend during the tournament.

Jet Hockey is a relatively new sport that has a different number of fans around the globe. Some teams (if they qualify for the World Championship Finals) will bring a huge number of fans to see the event live, while others will be supported only by their family and friends. Some teams come from wealthy countries and their fans will spend a lot of money, while others will probably be saving as much as possible. Finally, some countries are located just too far away from Fantastan and not too many fans will be able to come due to travel costs.

The downloadable file consists of the following:
-Task: Excel file with given case assumptions; PDF file with Case Materials; PDF file with Questions
-Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 300 regular points and 50 points for the bonus question, 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 4 (2021) “Jet Hockey””

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