Stage 12 (2021) "Consultant's Nightmare"

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.

Consultant's Nightmare is an actual case from the Financial Modeling World Cup 2021, Stage 12 (December 17-20) competition. This case is a simplified version of daily tasks that can be expected from a Transaction Service consultant in a valuation project.

The downloadable file consists of the following:
-Task: PDF file with Case Materials; PDF file with Questions; 2 Excel files with case data and assumptions
-Solution: Excel file with full Solution Model; PDF file with correct answers in bold

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

You can also buy tickets to participate in the future FMWC Stages at https://www.fmworldcup.com/product-category/regular-competition/