2012 Finals: All In
  • 2012 Finals: All In
  • 2012 Finals: All In
  • 2012 Finals: All In
  • 2012 Finals: All In
  • 2012 Finals: All In
  • 2012 Finals: All In
  • 2012 Finals: All In
Originally published: 23/07/2018 12:49
Publication number: ELQ-24040-1
View all versions & Certificate
certified

2012 Finals: All In

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

excel modelingexcel modeling skillsexcel modeling trainingfinancial modelingfinancial modeling competition

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!

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 2012 Finals: All In?

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

please wait...