2014 Round 1: Snakes and Ladders
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

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 Best Practice includes
1 PDF

Full Stack Modeller offers you this Best Practice for free!

read for free

Add to bookmarks

Discuss


5.0 / 5 (2 votes)

please wait...