SELECT sf.*, floor(datediff('2024-10-10', p.birth_date) / 365) AS age, p.player_id, p.shoots, p.team_id, t.team_name, t.city_team_name, t.city, t.team_code, p.drafted_year, CASE WHEN p.last_amateur_team_before_draft IS NOT NULL THEN p.last_amateur_team_before_draft WHEN sf.last_name = 'McKenna' THEN '2026 draft eligible' WHEN sf.last_name = 'Hagens' THEN '2025 draft eligible' END AS last_amateur_team_before_draft FROM spofo_mag_fantasy_top_100 sf LEFT JOIN nhl_players p ON sf.player_id = p.player_id LEFT JOIN nhl_teams t ON p.team_id = t.team_id WHERE sf.season = '2024-25' ORDER BY sf.rank LIMIT 100 ; p147-topfantasyprospects
NHL Preview 2024-25 147 SportsForecaster.com

Top 100 Fantasy Prospects

These are the best and safest bets for future fantasy production, based both on talent and circumstance (with [position], age, 2023-24 team)
  1. Gavin McKenna,
    [LW] 2026 draft eligible
  2. Macklin Celebrini, Sharks
    [C], 18, Boston Univ. (NCAA)
  3. Logan Stankoven, Hurricanes
    [RW], 21, Carolina (NHL)
  4. Will Smith, Sharks
    [C], 19, San Jose (NHL)
  5. Ivan Demidov, Canadiens
    [RW], 18, SKA-1946 St. Petersburg (MHL)
  6. Mavrik Bourque, Stars
    [C], 22, Dallas (NHL)
  7. Matt Savoie, Oilers
    [C/W], 20, Edmonton (NHL)
  8. Matvei Michkov, Flyers
    [RW], 19, Philadelphia (NHL)
  9. Gabe Perreault, Rangers
    [RW/LW], 19, New York (NHL)
  10. Berkly Catton, Kraken
    [C], 18, Spokane Chiefs (WHL)
  11. Lane Hutson, Canadiens
    [LD], 20, Montreal (NHL)
  12. Zayne Parekh, Flames
    [RD], 18, Saginaw Spirit (OHL)
  13. Jesper Wallstedt, Wild
    [G], 21, Minnesota (NHL)
  14. Yaroslav Askarov, Sharks
    [G], 22, San Jose (NHL)
  15. Rutger McGroarty, Penguins
    [W/C], 20, Pittsburgh (NHL)
  16. Ryan Leonard, Capitals
    [RW/C], 19, Washington (NHL)
  17. Cutter Gauthier, Ducks
    [LW], 20, Anaheim (NHL)
  18. Easton Cowan, Maple Leafs
    [RW/LW], 19, Toronto (NHL)
  19. Tij Iginla, Mammoth
    [C/LW], 18, Kelowna Rockets (WHL)
  20. Ivan Miroshnichenko, Capitals
    [LW/RW], 20, Washington (NHL)
  21. James Hagens,
    [C] 2025 draft eligible
  22. Beckett Sennecke, Ducks
    [RW], 18, Oshawa Generals (OHL)
  23. Brennan Othmann, Rangers
    [LW], 21, New York (NHL)
  24. Jiri Kulich, Sabres
    [W/C], 20, Buffalo (NHL)
  25. Calum Ritchie, Islanders
    [C], 19, New York (NHL)
  26. Dustin Wolf, Flames
    [G], 23, Calgary (NHL)
  27. Arturs Silovs, Penguins
    [G], 23, Pittsburgh (NHL)
  28. Jani Nyman, Kraken
    [RW], 20, Seattle (NHL)
  29. Jimmy Snuggerud, Blues
    [RW], 20, St. Louis (NHL)
  30. Jonathan Lekkerimaki, Canucks
    [RW], 20, Vancouver (NHL)
  31. Dalibor Dvorsky, Blues
    [C], 19, St. Louis (NHL)
  32. Danila Yurov, Wild
    [C/RW], 20, Minnesota (NHL)
  33. Jagger Firkus, Kraken
    [RW], 20, Seattle (NHL)
  34. Conor Geekie, Lightning
    [C], 20, Tampa Bay (NHL)
  35. Joel Blomqvist, Penguins
    [G], 22, Pittsburgh (NHL)
  36. Brendan Brisson, Rangers
    [LW/RW], 22, New York (NHL)
  37. Brayden Yager, Jets
    [C], 19, Winnipeg (NHL)
  38. Matyas Sapovaliv, Golden Knights
    [C], 20, Vegas (NHL)
  39. Alexander Nikishin, Hurricanes
    [LD], 23, Carolina (NHL)
  40. Erik Portillo, Kings
    [G], 24, Los Angeles (NHL)
  41. Denton Mateychuk, Blue Jackets
    [LD], 20, Columbus (NHL)
  42. Dean Letourneau, Bruins
    [C], 18, St. Andrew's College (PHC)
  43. Artyom Levshunov, Blackhawks
    [RD], 18, Michigan State Univ. (NCAA)
  44. Seamus Casey, Devils
    [RD], 20, New Jersey (NHL)
  45. Zachary Bolduc, Canadiens
    [LW/C], 21, Montreal (NHL)
  46. Zeev Buium, Wild
    [LD], 18, Univ. of Denver (NCAA)
  47. Brad Lambert, Jets
    [RW/C], 20, Winnipeg (NHL)
  48. Cole Eiserman, Islanders
    [LW], 18, U.S. National U18 Team (NTDP)
  49. Trevor Connelly, Golden Knights
    [LW], 18, Tri-City Storm (USHL)
  50. Quentin Musty, Sharks
    [LW], 19, San Jose (NHL)
  51. Colby Barlow, Jets
    [LW], 19, Winnipeg (NHL)
  52. Mackie Samoskevich, Panthers
    [RW], 21, Florida (NHL)
  53. Gavin Brindley, Avalanche
    [RD], 20, Colorado (NHL)
  54. Jackson Blake, Hurricanes
    [RW/C], 21, Carolina (NHL)
  55. Bradly Nadeau, Hurricanes
    [W/C], 19, Carolina (NHL)
  56. Cayden Lindstrom, Blue Jackets
    [C/LW], 18, Medicine Hat Tigers (WHL)
  57. Shakir Mukhamadullin, Sharks
    [RD/LD], 22, San Jose (NHL)
  58. Oliver Bonk, Flyers
    [RD], 19, Philadelphia (NHL)
  59. Tristan Luneau, Ducks
    [RD], 20, Anaheim (NHL)
  60. Carter Yakemchuk, Senators
    [RD], 19, Calgary Hitmen (WHL)
  61. Marco Kasper, Red Wings
    [C], 20, Detroit (NHL)
  62. Josh Doan, Sabres
    [RW], 22, Buffalo (NHL)
  63. Frank Nazar, Blackhawks
    [C/RW], 20, Chicago (NHL)
  64. Zach Dean, Blues
    [C/LW], 21, St. Louis (NHL)
  65. Filip Bystedt, Sharks
    [C], 20, San Jose (NHL)
  66. Noah Ostlund, Sabres
    [C], 20, Buffalo (NHL)
  67. Tanner Molendyk, Predators
    [LD], 19, Nashville (NHL)
  68. Scott Morrow, Rangers
    [RD], 21, New York (NHL)
  69. Logan Mailloux, Blues
    [RD], 21, St. Louis (NHL)
  70. Konsta Helenius, Sabres
    [C], 20, Buffalo (NHL)
  71. Nate Danielson, Red Wings
    [C], 20, Detroit (NHL)
  72. Ethan Gauthier, Lightning
    [RW], 19, Tampa Bay (NHL)
  73. Joshua Roy, Canadiens
    [LW/RW], 21, Montreal (NHL)
  74. Jett Luchanko, Flyers
    [C], 18, Guelph Storm (OHL)
  75. Fraser Minten, Bruins
    [C], 20, Boston (NHL)
  76. Sam Colangelo, Ducks
    [RW], 22, Anaheim (NHL)
  77. Adam Sykora, Rangers
    [LW], 20, New York (NHL)
  78. Lenni Hameenaho, Devils
    [RW], 19, New Jersey (NHL)
  79. Kasper Halttunen, Sharks
    [RW], 19, San Jose (NHL)
  80. Vsevolod Komarov, Sabres
    [RD], 18, Jukurit (Liiga)
  81. Axel Sandin-Pellikka, Red Wings
    [RD], 19, Detroit (NHL)
  82. Jordan Dumais, Blue Jackets
    [RW], 20, Columbus (NHL)
  83. Fabian Lysell, Bruins
    [RW], 21, Boston (NHL)
  84. Aatu Raty, Canucks
    [C], 21, Vancouver (NHL)
  85. Trey Augustine, Red Wings
    [G], 22, Detroit (NHL)
  86. Jacob Fowler, Canadiens
    [G], 19, Montreal (NHL)
  87. David Edstrom, Predators
    [C], 19, Nashville (NHL)
  88. Igor Chernyshov, Sharks
    [LW], 18, Dynamo Moskva (KHL)
  89. Aleksanteri Kaskimaki, Blues
    [C], 20, St. Louis (NHL)
  90. Otto Stenberg, Blues
    [C], 19, St. Louis (NHL)
  91. Raphael Lavoie, Golden Knights
    [RW/C], 24, Vegas (NHL)
  92. Ville Koivunen, Penguins
    [LW], 21, Pittsburgh (NHL)
  93. Cole Hutson, Capitals
    [LD], 18, U.S. National U18 Team (NTDP)
  94. Sean Behrens, Avalanche
    [LD], 21, Colorado (NHL)
  95. Andrew Cristall, Capitals
    [LW], 19, Washington (NHL)
  96. Jack Devine, Panthers
    [RW], 21, Florida (NHL)
  97. Liam Greentree, Kings
    [RW], 18, Windsor Spitfires (OHL)
  98. Carter Mazur, Red Wings
    [RW/LW], 19, Detroit (NHL)
  99. Carson Rehkopf, Kraken
    [LW/RW], 19, Seattle (NHL)
  100. Isak Rosen, Sabres
    [LW/RW], 21, Buffalo (NHL)