2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
  • 2013 Round 2: Data Analysis
Originally published: 18/07/2018 15:09
Publication number: ELQ-71770-1
View all versions & Certificate
certified

2013 Round 2: Data Analysis

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

excel skillsexcel trainingfinancial modelingfinancial modeling competitionfinancial modeling training

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

Follow the instructions in order to complete the model:

INTRODUCTION

You are working as a business analyst at a leading hardware retailer. You have been asked to assist with the analysis of some recent sales data from one of your hardware stores.

DATA STRUCTURE

The data covers the first 6 months of the year 2013 and has a line for each different item type sold on each invoice. One or more lines may be associated with a single invoice. Note that each line also has a quantity field that represents the quantity of that particular item type sold on that invoice. Each invoice is associated with one Manager on Duty and one Sales Assistant.

RECOMMENDED APPROACH

The format of the data and the questions you will need to answer very strongly lends itself to doing the analysis with the aid of a PivotTable. You may also benefit from adding some extra calculation columns to the table of data.

Using this model will allow you to test your own financial modeling skills and capabilities and identify potential areas for improvement.

Allotted time: 20 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 2013 Round 2: Data Analysis?

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

please wait...