"Factory Finding" - University Championship (Spring 2022)

Description
Financial Modeling University Championship is a great place to learn financial modeling, compete for a prize fund and get recognized for your finance skills! Students from all over the world come together to showcase their skills and become the best among their peers. The competition was jointly organized by the Financial Modeling World Cup and Eller College of Management. This and all future competitions are open to any student regardless of age, gender, race, place of living or any other limiting factor. The finals of the Spring 2022 competition were live-streamed on the Financial Modeling World Cup YouTube channel.

Factory Finding 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

You can also buy tickets to participate in the future FMWC Stages at https://www.fmworldcup.com/product-category/regular-competition/