“Where Is Our Money?” – Microsoft Excel Collegiate Challenge (2022)

This is an actual case from the Microsoft Excel Collegiate Challenge Round 1 (October 8-9).

Case Description:
You are a junior associate 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. Complete the analysis for your client by first thing tomorrow morning.

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