andrew@agcapitalcfo.com

FMUC – Round 3 – “Factory Finding”

Professional Excel Templates for your Business

FMUC - Round 3 - "Factory Finding"

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.

Reviews

There are no reviews yet.

Be the first to review “FMUC – Round 3 – “Factory Finding””

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