This case study was premiered during the Financial Modeling World Cup Battle between Diarmuid Early and Joseph Lau. The case study is about an online school that operates in Australia and the United States. All their revenues come from subscription payments. The company is headquartered in the US and reports in US dollars. However, their plans in Australia are priced in Australian dollars. this adds another layer of complexity to sales projections due to currency rate fluctuations.
To solve the model, you will have to create a very detailed revenue forecasting model. There are 14 questions worth 1000 points in total. The case is designed to be solved in 30 minutes.
No specific knowledge is required to solve the case, so actually, anyone can try it themselves.
The downloadable file consists of the following:
–Task: PDF file with Case Materials; Excel file with Case Assumptions; PDF file with Questions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold
For your questions/suggestions/consideration please reach out to the Organizing Committee of the Financial Modeling World Cup at firstname.lastname@example.org