“Factory Finding” – University Championship (Spring 2022)

Professional Excel Templates for your Business

"Factory Finding" - University Championship (Spring 2022)

Factory Finding

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

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

Product – Let us do the work for you!

Contact our team if you’re looking for additional support with your company’s financial needs! You can request model adjustments for any template found on our website or request a completely customized financial template with your company’s data (operational budgets, cashflow projections, valuation models, cost analysis and other models).


Our company has over 12 years of experience as outsourced CFOs creating and improving financial models for different industries. Over these years we have worked with 500+ companies from 20+ countries in the world. We bet you won’t be able to name an industry we haven’t made financial models for.


The customization services are performed by the same team of analysts that organizes the Financial Modeling World Cup (our group’s company). The Financial Modeling World Cup is the world’s largest financial modeling competition, enjoyed by top-class modelers from all over the world. Our team is trusted by such big names as Microsoft, the main sponsors of the tournament, and ESPN who broadcast the tournaments to TV audience. You can learn more about FMWC here.


We typically charge a fixed price, depending on the amount of work. The most popular pricing plans are $199, $749 and $1,499 (see details).


Drop us a line at and we’ll get back to you with an offer!


Have feedback or suggestions? Get in touch with our founder & CEO, Andrew Grigolyunovich, CFA:


There are no reviews yet.

Be the first to review ““Factory Finding” – University Championship (Spring 2022)”

Your email address will not be published.

five × 1 =