Stage 2 (2022) “Client’s Model”

This case contains a simple model taken over from a client, which has several errors (a total of 4 errors). You have to find and correct these errors. Although all questions are connected regarding the storyline, you can choose to complete each one separately, as they are not related in terms of calculations. If you’re experienced in auditing other people’s models, this case should not be too difficult for you.

This is an actual case from the Financial Modeling World Cup 2022, Stage 2 (March 11-14) competition. The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with the initial model
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

This model awarded 200 regular points, 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