MECC (2022) - Round 1 "Where is Our Money"

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 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.
This is an actual case study that was presented to the participants of the Microsoft Excel Collegiate Challenge 2022, Round 1(October 2022).


Case study description:
You are a junior associate at Alvarez and Marsal (A&M) and have been brought in to help restructure an energy company in financial distress. As a first step, you need to understand when the company’s revenues will be collected over the next 13 weeks. Your Managing Director has provided a template model used for prior clients along with the energy company’s historical sales and assumptions regarding sales over the next 13 weeks.




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


You can also buy tickets to participate in the future MECC at https://www.fmworldcup.com/microsoft-excel-collegiate-challenge/