This is an actual case from the Financial Modeling University Championship (Spring 2022), Round 1 (April 9-10). This case study asks you to build an integrated Revenue Schedule, Cost Schedule and Income Statement (to EBITDA only) for the next 5 years. You will be provided with some historic data, as well as, all necessary assumptions to build the required model.
The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with the initial model and assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold
This model awarded 300 points, while the whole 2h Round allowed to earn 1,000 points in total.