Jump to content

Financial Modeling World Cup

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Ftrebien (talk | contribs) at 22:12, 7 May 2023 (The coltit template is intended to display a tooltip showing the background color code, replaced with a template intended to distinguish categories). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

The Financial Modeling World Cup (FMWC) is a organization that hosts various Microsoft Excel based competitions.

The FMWC held its first competition in September 2020 and currently hosts three competitions:


Financial Modeling World Cup (FMWC)

Description, Competition Format, and Scoring

FMWC is an annual Excel modeling competition.

During the course of a season (January through November), competitors complete eight stages, and are allotted two hours over a 48 hour window to complete each stage.

Each stage contains three case studies, one to five pages long, with multiple choice or fill-in questions at the end. Contrary to what the name suggests, not all case studies are financial modeling based; Many are business modeling or data modeling based.

Stage points are available for:

  • Task: Correctly solving questions on each case (Points vary by question)
  • Time: Completing the stage early (10 points per minute, awarded only if the competitor has scored 900 task points)

Each stage winner's score is normalized to 1,000 points, and the score of all other competitors are normalized accordingly.

FMWC rankings and final standings are based on points scored across each competitor's top 6 stages (bottom 2 stages are dropped).

Format Changes

  • 2020: The first of four FMWC stages started in September 2020. All stages contributed to the final standings.
  • 2021: The stage count increased to twelve. The bottom two stages for each competitor were dropped from the final standings.
  • 2022: The stage count decreased to eight. Case authors can not score a higher time bonus than any other player. Stage score normalization was introduced. The prize for top company was eliminated.
  • 2023: Case authors may not be the sole winner of a stage.

Competition Statistics

Year Registrations [a] Participants [b] Completed Max Number of Stages [c] Prize Pool (USD)
2020 [1] 125 117 36 $10,000
2021 [2] 333 307 72 $20,000
2022 [3] 443 402 136 $25,000

Results

Key
Score dropped from final rankings per FMWC rules
2020
Rank Name Nation Age Group 1 2 3 4 Total Prize
1st place, gold medalist(s) Joseph Lau  Australia Masters 785 1,285 795 2,670 5,535 $3,000
2nd place, silver medalist(s) Diarmuid Early  United States Open 825 1,260 1,035 1,650 4,770 $2,000
3rd place, bronze medalist(s) Andrew Ngai  Great Britain Open 1,160 880 2,670 4,710 $1,000
4 John Lim  Australia Open 605 890 735 2,290 4,520
5 Christian Hueber  Austria Open 470 1,105 805 2,105 4,485
6 Anup Agarwal  India Open 1,000 955 2525 4,480
7 Samir Asadov  Ireland Open 520 1,025 555 2050 4,150
8 Joseph Michael Palisoc  United States Open 655 885 805 1,750 4,095
9 Dan Mayoh  Australia Open 620 875 720 1,850 4,065
10 Willem Gerritsen  Netherlands Masters 655 845 825 1,475 3,800
2021
Rank Name Nation Age Group 1 2 3 4 5 6 7 8 9 10 11 12 Total Prize
1st place, gold medalist(s) Diarmuid Early  United States Open 1,170 1,015 1,160 1,165 865 1,510 1,260 970 815 1,145 1,440 1,090 11,925 $5,000
2nd place, silver medalist(s) Anup Agarwal  India Open 1,105 790 1,460 1,065 865 1,265 835 1,175 535 1,005 1,550 850 11,175 $2,000
3rd place, bronze medalist(s) Andrew Ngai  Australia Open 1,200 735 820 765 1,315 1,265 1,030 1,140 820 1,325 1,300 635 10,980 $1,000
4 Jeff Heng Siang Tan  Malaysia Open 495 485 1,290 530 1,145 1,230 650 1,250 530 1,460 1,190 1,350 10,625 $500
5 Willem Gerritsen  Netherlands Open 1,275 605 720 750 885 1,200 1,210 1,070 720 1,060 1,350 850 10,370 $500
6 Michael Jarman  Canada Open 825 820 1,300 765 895 1,170 895 1,040 867 1,420 1,090 10,322 $500
7 Christian Hueber  Austria Open 725 1,130 925 865 830 670 1,035 615 970 1,305 850 9,305 $500
8 Janis Reinis Beikmanis  Latvia U-25 645 760 840 1,178 795 830 0 820 625 765 1,285 1,371 9,289 $350
9 Joseph Michael Palisoc  United States Open 725 560 675 610 1,015 840 680 840 605 1,130 1,400 875 8,790 $350
10 Sameer Jagetia  United States Open 705 650 821 685 1,040 945 670 920 570 950 1,330 563 8,716 $350
2022
Rank Name Nation Age Group 1 2 3 4 5 6 7 8 Total Prize
1st place, gold medalist(s) Laurence Lau  United States Open 1,000 957 1,000 959 1,000 1,000 769 978 5,937 $7,000
2nd place, silver medalist(s) Diarmuid Early  Ireland Open 821 1,000 830 1,000 885 956 1,000 1,000 5,841 $4,000
3rd place, bronze medalist(s) Andrew Ngai  Australia Open 847 899 815 838 971 803 974 883 5,412 $2,000
4 Michael Jarman  Canada Open 898 670 596 775 899 956 968 780 5,276 $1,000
5 Willem Gerritsen  Netherlands Open 740 790 237 622 795 646 788 834 4,593 $800
6 Joseph Michael Palisoc  United States Open 809 576 737 779 676 507 840 713 4,554 $750
7 Anup Agarwal  India Open 694 634 526 712 849 697 840 749 4,541 $700
8 Tim Roberts  Great Britain Open 762 778 593 698 835 700 4,366 $650
9 Matthew Fried  Australia Open 821 611 694 646 878 686 4,336 $600
10 Paul Dent  Great Britain Open 587 833 619 734 705 500 644 794 4,329 $550

Microsoft Excel World Championship (MEWC)

2021

The MEWC began in 2021 as the FMWC Open, an Excel Esports tournament. The competition was a standalone event that did not impact the Financial Modeling World Cup Rankings in regular seasons.[1]

The tournament consisted of a Qualification Round, with the top 128 qualifiers advancing to a single elimination tournament. [4]

Qualification rounds began on November 13, and continued into December.[4] The last three rounds of the FMWC Open competition were held on December 11, 2021, and were broadcast on FMWC YouTube channel and ESPN3.[5][6] Andrew Ngai (now representing Australia), Anup Agarwal (India), and Michael Jarman (Canada) returned as quarterfinals qualifiers, and Harry Gross from the UK, Jason Moore from the US, Joseph Palisoc from the US, Sameer Jagetia from the US, and Tim Roberts from the UK also qualified.[7] The final round, entitled "Knights and Warriors", had contestants, each representing a fictional nation, send fictional warriors to conquer each other. Ngai defeated Jarman 734–280, with a maximum of 1,000 points per side.[4]

2022

The FMWC Open was rebranded as the Microsoft Excel World Championship (MEWC). Like its predecessor, it also consisted of a Qualification Round, with the top 128 qualifiers advancing to a single elimination tournament.

Qualification results (Top 20)

In total 377 people took part and 128 qualified for the final round. The best ranked participants of the FMWC ranking, were prequalified.

Rank Name Total Points Time
1 Netherlands Willem Gerritsen 5,000 00:36:50
2 New Zealand Michael Clarke 5,000 00:46:59
3 Canada Michael Holmes 5,000 00:51:01
4 United States Brian Hanley 5,000 00:51:28
5 Spain Alfons Oliver Altes 5,000 00:52:23
6 Canada Justin Merson 5,000 00:54:51
7 United States Britanny Deaton 5,000 00:54:57
8 South Africa Jason Webber 5,000 00:55:02
9 Spain Eduardo Gonazales Arias 5,000 00:55:32
10 United Kingdom Peter Rebecchi 5,000 00:55:57
11 United States David Brown 5,000 00:56:49
12 India Stefanus Ng 5,000 00:59:28
13 United States Diarmuid Early 4,800 00:25:14
14 United Kingdom Paul Dent 4,600 00:50:55
15 France Nicolas Micot 4,600 00:52:31
16 United States Nick McCartney 4,600 00:54:55
17 United States Lianna Gerrish 4,600 00:57:34
18 Belgium Bram Van Eeckhout 4,600 00:58:14
19 Australia Matthew Fried 4,550 00:50:17
20 Spain Isaac Mendez Cortinas 4,400 00:56:55

Bracket

 
Quarter-finalsSemi-finalsFinal
 
          
 
 
 
 
 Australia Andrew Ngai1,250
 
 
 
 United States Kenneth Wang760
 
 Australia Andrew Ngai615
 
 
 
 United States Brittany Deaton610
 
 United States Joseph Michael Palisoc1,000
 
 
 
 United States Brittany Deaton1,250
 
 Australia Andrew Ngai1,250
 
 
 
 Australia Matthew Fried420
 
 Canada Michael Jarman1,200
 
 
 
 New Zealand Michael Clarke770
 
 Canada Michael Jarman415
 
 
 
 Australia Matthew Fried914
 
 Australia Matthew Fried986
 
 
 Canada Michael Holmes976
 

2023

The MEWC continued in 2023 with a modified format, the Qualification round was split into nine events, called "Road to Las Vegas" and one Qualification Round. However the 128 final-participants will still be competing in a 1v1 grid. The final of the top 8 will be hosted in Las Vegas.

Microsoft Excel Collegiate Challenge (MECC)

Main article: Microsoft Excel Collegiate Challenge

Other Events

FMWC also holds other events (typically Excel Esports battles). Some events have granted automatic qualification to the MEWC playoff rounds. Some events are livestreamed and can be viewed by the public. These events include (but are not limited to):

Date Event Name Winner Nation Case Name
8 June 2021 888 Battle[8][9][10] Michael Jarman  Canada Cake To Bake
9 September 2021 Battle of 16[11] Diarmuid Early  United States N/A (Multiple)
17 February 2022 Global Excel Summit 2022[12] Jason Webber  South Africa Ludo
18 February 2022 Global Excel Summit 2022[13] David Brown  United States Square of Fortune
31 March 2022 Continent Battle: Asia / Pacific[14] Nick Boberg  New Zealand Minesweeper
24 May 2022 All-Star Battle[15] Andrew Ngai  Australia N/A (Multiple)
30 June 2022 Women's Battle[16] Stephanie Annerose  United States Lottery
28 July 2022 Continent Battle: Africa[17] Gareth Watson  South Africa Tug of War
25 August 2022 Continent Battle: Europe[18] Willem Gerritsen  Netherlands It's a Sequence
23 February 2023 Global Excel Summit 2023[19] Jason Webber  South Africa A Story About the Reels

Notes

  1. ^ Competitors that have registered for at least one stage, not necessarily for the entire competition
  2. ^ Competitors that have attempted at least one stage. A stage score of 0 indicates participation, while a blank stage score does not
  3. ^ Competitors that attempted the maximum number of stages contributing to the final season point total (i.e., The 2021 season had 12 stages, but only the top 10 results determined a competitors season point total. In 2021, 307 competitors participated in at least 10 FMWC stages.)

References

  1. ^ a b "FMWC 2020 Rankings".
  2. ^ "FMWC 2021 Rankings".
  3. ^ "FMWC 2022 Rankings".
  4. ^ a b c Hachman, Mark (December 10, 2021). "Top Excel experts will battle it out in an esports-like competition this weekend". PCWorld. Retrieved December 11, 2021.
  5. ^ Roth, Emma (December 11, 2021). "Watch these Excel pros duke it out in a financial modeling competition". The Verge. Retrieved December 11, 2021.
  6. ^ Bolding, Jonathan (December 11, 2021). "Watch the world's greatest spreadsheet sorcerers throw down in the World Cup of Microsoft Excel". PC Gamer. Retrieved December 11, 2021.
  7. ^ Financial Modeling World Cup [@FMWC_] (December 10, 2021). "📢 Tomorrow, December 11, is the day for the FMWC Open finals!" (Tweet) – via Twitter.
  8. ^ Matyszczyk, Chris (June 10, 2021). "I just watched Microsoft (try to) make Excel exciting. Recovery won't be easy". ZDNet. Archived from the original on June 23, 2021. Retrieved December 11, 2021.
  9. ^ Sacco, Dom (June 6, 2021). "Microsoft Excel… esports? UK to take part in 'Financial Modeling World Cup'". Esports News UK. Archived from the original on June 6, 2021. Retrieved December 11, 2021.
  10. ^ "Acht experts strijden tegen elkaar in internationale Microsoft Excel-competitie" [Eight experts compete in international Microsoft Excel competition]. Algemeen Dagblad (in Dutch). June 5, 2021. Archived from the original on July 4, 2021. Retrieved December 11, 2021.
  11. ^ "Battle of 16 – FMWC". Retrieved 2022-01-17.
  12. ^ "Global Excel Summit 2022 - Ludo". Retrieved 2023-04-30.
  13. ^ "Global Excel Summit 2023 - Square of Fortune". Retrieved 2023-04-30.
  14. ^ "Continent Battle: Asia / Pacific". Retrieved 2023-04-30.
  15. ^ "All-Star Battle". Retrieved 2023-04-30.
  16. ^ "Women's Battle". Retrieved 2023-04-30.
  17. ^ "Continent Battle: Africa". Retrieved 2023-04-30.
  18. ^ "Continent Battle: Europe". Retrieved 2023-04-30.
  19. ^ "Global Excel Summit 2023". Retrieved 2023-04-30.

External links

Retrieved from "https://en.wikipedia.org/w/index.php?title=Financial_Modeling_World_Cup&oldid=1153713421"