Factory Finding

“Factory Finding” – University Championship (Spring 2022)


This is an actual case study that was presented to the participants of the Financial Modeling University Championship (Spring 2022) Round 3.

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