2014 Round 1: Snakes and Ladders
  • 2014 Round 1: Snakes and Ladders - Page 1
  • 2014 Round 1: Snakes and Ladders - Page 2
Originally published: 18/07/2018 14:43
Publication number: ELQ-89595-1
View all versions & Certificate
certified

2014 Round 1: Snakes and Ladders

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

excel skillsexcel trainingfinancial modelingfinancial modeling competitionfinancial modeling trainingsnakes and ladders simulation

Description
This workbook is taken from the 1st round of the 2014 Modeloff financial modeling world championships.

Follow the instructions in order to complete the model:

You and a friend are playing the classic board game of snakes and ladders. Both players begin on the start square and take turns rolling a standard 6-sided die. You move forward the number of places rolled on the die. If you land on a square that is at the very bottom of a ladder, you move to the top of the ladder.

If you land on a snake head, you slide down to the bottom of the snake. The winner is the first player to the finish square, an exact roll is not required to finish.
Being a keen Excel user, you decide to simulate the game. Using your preferred method (e.g. a data table, VBA, or any other means within Excel) simulate exactly 5,000 games of snakes and ladders, and then answer the following questions.

Do not simulate more than 5,000 games at once, as this could increase your workbook size too much. However be sure to run your 5,000 game simulation a few times to make sure your first result was not an outlier.

For the questions found in the PDF:

 ‘Player 1’ refers to the player who moves first and ‘Player 2’ the player who moves second.
 You may wish to run your simulation several times to ensure your results are consistent.
 Your answers may not match exactly those provided, given the nature of simulation and the rounding of the provided answers. Select the closest answer

Allotted time: 25 minutes

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

This business tool includes
1 PDF

MODELOFF offers you this business tool for free!

read 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 1: Snakes And Ladders?

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

please wait...