“It’s Harvest Time” – FMWC Stage 7 & MECC Round 2 (2022)


This is an actual case study that was presented to the participants of both the Microsoft Excel Collegiate Challenge Round 2 and Financial Modeling World Cup Stage 7, 2022.

Case description:
This is a non-finance case, that can be solved by all Excel enthusiasts. AgroWizards Inc. is a fictional company in a fictional universe. They operate a magic field that is able to produce fruits and vegetables – tomatoes, grapes, apples, etc. The field size is 100×100 cells in Excel. The map of the field is provided in the financial model. Your goal is to make calculations based on the location of the units on the field and to answer the questions for the case.

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