andrew@agcapitalcfo.com

Stage 7 (2022) – “Harvest Time”

Professional Excel Templates for your Business

Stage 7 (2022) - "Harvest Time"

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

Case study description:

 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. (we will call them “units” throughout the case). The field size is 100×100 cells in Excel. The map of the field is provided in the financial model. In case your system does not recognize any of the Unicode characters, we have duplicated the map replacing these symbols with the corresponding numbers (see tab “Map2 – No Unicode”).

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 initial data and case assumptions
Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold

You can also buy tickets to participate in the future FMWC Stages here.

Reviews

There are no reviews yet.

Be the first to review “Stage 7 (2022) – “Harvest Time””

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