Professional Excel Templates for your Business
FMUC - Round 3 - "Factory Finding"
This is an actual case study that was presented to the participants of the Financial Modeling University Championship, Round 3 (May 2022).
Case study description:
As part of your role as an analyst at a major financial consulting firm, you are tasked with building models to analyze clients’ business decisions. A major car manufacturer has approached your firm to analyze potential locations for a new factory. Your task is to determine the optimal location for the factory based on factors such as local labor costs, transportation costs, and local tax credits. The necessary details are provided below and all relevant figures are provided in the model template.
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.