2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
  • 2013 Round 2: Hard Times. Turnaround a Toy Company
Originally published: 18/07/2018 15:12
Publication number: ELQ-43169-1
View all versions & Certificate
certified

2013 Round 2: Hard Times. Turnaround a Toy Company

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

cash flow forecastcash flow statementexcel 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

Slick Micks Toys Inc, is the manufacturer of a type of action figure moderately popular with kids between the ages of 3 and 8 years. Slick Mick’s not so slick accountants all have kids that love the figurines but have nonetheless identified that unless there is a swift improvement in cash flow, the business might not make it to the next season.

You have been asked to help the team forecast cash flow for the coming three years with particular focus on the next twelve months. Use the following information to draft a three year monthly cash flow forecast with the first month being October 2013 and use it to answer the following key questions. The key assumptions are provided in the Excel file that accompanies this question and are also set out in the attached PDF file.

KEY ASSUMPTIONS

All key assumptions are provided in the Excel file that accompanies this question and are also set out
below in the attached PDF.

Allotted time: 40 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


keyboard_arrow_leftkeyboard_arrow_right

More tools from MODELOFF

See all
keyboard_arrow_leftkeyboard_arrow_right

Any questions on 2013 Round 2: Hard Times. Turnaround A Toy Company?

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

please wait...