2012 Finals: All In

Description
This workbook is taken from the Finals of the 2012 Modeloff financial modeling world championships.

In this exercise, use the rules provided in the attached workbook, you will need to analyze two 5 card poker hands to:

1. Sort each of the players' cards by value, highest to lowest (assuming that aces are high)

2. Classify each of the players' hands into one of the hands shown on Table 3; and

3. Identify the winner where the two 5 hard hands have the same classification.

Using Excel, input the values of each card using the abbreviations that can be found in the attached PDF. Each of the 5 card hands can then be scored against the table in the PDF, which will help you to allocate a score to each hand.

In this question, you sill receive 1 mark for each correctly identified outcome up to 20 and 2 marks for each correctly identified outcome above 20. The maximum score for the question is 30 marks and there are a total of 25 potential outcomes.

A marking macro has been integrated into the workbook. This will help to quickly:

- Identify hands for which your formulae and logic fail; or

- Provide you with an indicative mark

Marks are allocated for consistently identifying the strongest hand and the winning player for any given scenario.

This exercise will allow you to test and improve your Excel skills.

Allotted time: 75 minutes

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