Stage 7 (2022) – “1st Year Analyst – Fall 2022”

Professional Excel Templates for your Business

Stage 7 (2022) - "1st Year Analyst - Fall 2022"

This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2022, Stage 7 and Microsoft Excel Collegiate Challenge, Round 2 (October 2022).

Case study description:

You have successfully graduated from your university and were hired as a first-year analyst in a financial institution (you may decide for yourself whether it is an investment bank, a consulting company or any other institution of your interest). But how well prepared are you for the role? This case study will test your knowledge of various finance, valuation and financial modeling concepts and Excel skills. You will have to answer questions that should be known by every junior analyst in an investment bank. This case is designed to help you learn or refresh such aspects of financial modeling as loans, investments, depreciation, valuation and others.

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.


There are no reviews yet.

Be the first to review “Stage 7 (2022) – “1st Year Analyst – Fall 2022””

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