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

Description
Financial Modeling University Championship is a great place to learn financial modeling, compete for a prize fund and get recognized for your finance skills! Students from all over the world come together to showcase their skills and become the best among their peers. The competition was jointly organized by the Financial Modeling World Cup and Eller College of Management. This and all future competitions are open to any student regardless of age, gender, race, place of living or any other limiting factor. The finals of the Spring 2022 competition were live-streamed on the Financial Modeling World Cup YouTube channel.

Case study description:
You have successfully graduated from your university and were hired as a first-year analyst in an investment bank. 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
-Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold