andrew@agcapitalcfo.com

MECC 2022 – Round 1 – “Where is Our Money”

Professional Excel Templates for your Business

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

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

Your first task is to analyze historical sales. The data is provided on a weekly basis (dates given are Fridays at the end of each week). Sales are provided for each major customer and minor customers are aggregated as “All Other Customers”. Each customer’s geographic region is provided in the template model.

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

You can also sign-up for the future MECC here.

Reviews

There are no reviews yet.

Be the first to review “MECC 2022 – Round 1 – “Where is Our Money””

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