It is common for financial modelers to stop learning Excel formulas after they have learned the minimum number of formulas that can do the work. This may result in them not knowing the best formula to use for certain situations, leading to time-consuming workarounds. In this case, financial modelers are challenged to match Excel formulas with their definitions to broaden their knowledge of Excel.
This is an actual case from the Financial Modeling World Cup 2021, Stage 3 (Mar 26-29) competition. The downloadable file consists of the following: –Task: PDF file with Case Materials and Task Description –Solution: PDF file with correct Answers in Bold
This model awarded 250 points, while the whole 2h Stage allowed to earn 1,000 points.
For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at info@fmworldcup.com