“1st Year Analyst” – FMWC Stage 3 (2022) & University Championship (Spring 2022)

Professional Excel Templates for your Business

"1st Year Analyst" - FMWC Stage 3 (2022) & University Championship (Spring 2022)

1st Year Analyst

This is an actual case study that was presented to the participants of both Financial Modeling University Championship (Spring 2022) Round 2 and Financial Modeling World Cup Stage 3.

Case study description:

This case study aims to assess the knowledge of a first-year analyst in a financial institution across various finance, valuation, and financial modeling concepts, as well as Excel skills. The case includes 15 small questions designed to help the analyst learn or refresh such aspects of financial modeling as loans, investments, depreciation, and valuation.

As a first-year analyst in a financial institution, the analyst’s knowledge and skills in finance, valuation, and financial modeling, as well as Excel skills, need to be tested. Since no financial model is provided for this case, the analyst is advised to create calculations from scratch and attach the file with their calculations when they answer all the questions. Some questions might be easy for the analyst while others might require more time and effort.

The downloadable file consists of the following:
Task: PDF file with Case Materials; PDF file with Questions
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.


There are no reviews yet.

Be the first to review ““1st Year Analyst” – FMWC Stage 3 (2022) & University Championship (Spring 2022)”

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