2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
  • 2014 Round 2: Stepping Up
Originally published: 18/07/2018 14:41
Publication number: ELQ-26745-1
View all versions & Certificate
certified

2014 Round 2: Stepping Up

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

balance sheetcash flowexcel skillsexcel trainingfinancial modelingfinancial modeling competitionfinancial modeling trainingforecasting modelp&l

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 business tool includes
1 Excel Workbook, 1 PDF

MODELOFF offers you this business tool for free!

download for free

Add to bookmarks

Discuss

Reviews

  • No review yet!

keyboard_arrow_leftkeyboard_arrow_right

More tools from MODELOFF

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on 2014 Round 2: Stepping Up?

The user community and author are here to help. Go ahead!

please wait...