2014 Round 2: Stepping Up

Excel training/competition model from the 2014 Financial Modeling World Championships

by Full Stack Modeller
To help finance professionals transform their Excel, financial modelling, data visualisation & analytics skillsFollow 72

7 reviews607 views|Start the discussion!|Bookmark download for free

Description
This workbook is taken from the 2nd round of the 2014 Modeloff financial modeling world chamionships.

Follow the instructions in order to complete the model:

It is your first day at a new employer, a massive company that produces widgets. The company has a basic 15 year forecasting model including a profit and loss statement, balance sheet and cash flow statement.

The previous analyst has already left and there was no chance for a proper handover. Fortunately they left you with a series of notes that set out where they believe there are issues in the current model. You are required to identify and fix these errors so you can brief the CFO on the model outputs.

For each question in the attached PDF, you will be provided with the previous analyst’s note on where they thought an error existed. You will be required to find and correct the error. To assist with this, you are also provided the cell reference for where the error(s) are located. Once the error(s) are fixed, you will be able to select the correct answer from the multiple choice options available.

YOU MUST complete the questions in sequence. Ensure your model has the correct answer before continuing. When making your changes, make sure the change is made across the whole row. You should not have to insert any rows or columns to fix the errors in the model. If you do insert rows or columns the cell references below will no longer line up to the model.

Allotted time: 35 minutes

Once finished, feel free to upload your model to your own dedicated author channel!

This Best Practice includes
1 Excel Workbook, 1 PDF