"Speed Modeling" - 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 financial firm, you occasionally need to conduct ad-hoc analyses as quickly as possible. Your boss has just asked you for quick answers to several questions. Quickly prepare models and deliver your boss the answers she needs.

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