andrew@agcapitalcfo.com

Stage 8 (2022) – “FMWC Winter Classics”

Professional Excel Templates for your Business

Stage 8 (2022) - "FMWC Winter Classics"

This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2022, Stage 8 (November 2022).

Case study description:

This case is a typical financial modeling exercise where you need to create a 3-way statement financial model based on historical data. After the model is ready, you will be required to perform a valuation of the company. An ability to create 3-way financial models and do company valuations based on that, probably, is one of the core skills required from a financial modeler.

Squirrel Hill Ski Inc. (SHS) operates skiing infrastructure in the fictional country of Flatistan. The company generates most of its revenue during the winter season, and it also generates some decent income during the summer by providing visitors with summer attractions. You have been tasked with creating a 5-year monthly financial model for the company based on the provided assumptions. SHS has a maximum daily capacity of 5000 visitors during the winter season and 1250 visitors during the summer season. However, the actual number of visitors depends on the air temperature and the day of the week.

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 buy tickets to participate in the future FMWC Stages here.

Reviews

There are no reviews yet.

Be the first to review “Stage 8 (2022) – “FMWC Winter Classics””

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