mouser
Business of Hockey
My swing at what the escrow balance might look like. Copied from another thread
I tried a spreadsheet mock up of how the Escrow Balance and salary cap could look going forward if no changes are made.
List of figures and assumptions used in this model.
- HRR for 2018-19 was ~$4.61B (based on reverse engineering the 2019-20 cap)
- Actual player salary/bonuses for 2018-19 were ~$2.414B (based on reverse engineering HRR and final escrow %)
- HRR has been growing at an annual 4% average in the 5 years leading up to the covid shutdown and will continue to do so in 2021-22 and following years.
- One time 5% year over year increase in HRR due to the new TV contract. $250m year to year increase estimate on TV money.
- $500M starting Escrow Balance following the 2019-20 season. *This may be high, need to research further, any input appreciated.
- Seattle revenue and new player costs are not included. Proportionally they should be neutral to a small upward adjustment, but not huge impact on this model.
- HRR for 2020-21 of $2.5B. HRR for 2021-22 returns to normal and is equal to 2019-20 projection of $4.8B. Increases by 4% year by year going forward.
- Player compensation increases year to year at same % as cap increase.
- Did not include 2020 MOU increases in non-salary player benefits that are included in compensation. It is a material number but not large enough to significantly change this model.
[TBODY]
[/TBODY]So the tradeoff for overpaying the players this season (including deferred salary) is an essentially flat cap for six additional years out through 2026-27. The players would also receive much less then 50% of HRR in every one of those seasons, with a low of 42%.
I did a similar mock up with a 5% annual HRR growth and that still shows a flat cap through 2025-26, after which cap growth should return to normal.
I tried a spreadsheet mock up of how the Escrow Balance and salary cap could look going forward if no changes are made.
List of figures and assumptions used in this model.
- HRR for 2018-19 was ~$4.61B (based on reverse engineering the 2019-20 cap)
- Actual player salary/bonuses for 2018-19 were ~$2.414B (based on reverse engineering HRR and final escrow %)
- HRR has been growing at an annual 4% average in the 5 years leading up to the covid shutdown and will continue to do so in 2021-22 and following years.
- One time 5% year over year increase in HRR due to the new TV contract. $250m year to year increase estimate on TV money.
- $500M starting Escrow Balance following the 2019-20 season. *This may be high, need to research further, any input appreciated.
- Seattle revenue and new player costs are not included. Proportionally they should be neutral to a small upward adjustment, but not huge impact on this model.
- HRR for 2020-21 of $2.5B. HRR for 2021-22 returns to normal and is equal to 2019-20 projection of $4.8B. Increases by 4% year by year going forward.
- Player compensation increases year to year at same % as cap increase.
- Did not include 2020 MOU increases in non-salary player benefits that are included in compensation. It is a material number but not large enough to significantly change this model.
Season | cap | Revenue | Player share | Player actual | deferred | escrow% | final escrow | escrow $ | Starting balance | ending balance | Player share |
2020-21 | 81.5 | 2500 | 1130 | 2238.994 | 20% | -20% | (447.80) | 500 | 1161.20 | 71.6% | |
2021-22 | 81.5 | 4799 | 2279.28 | 2487.771 | 16% | -16% | (398.04) | 1161.20 | 971.64 | 43.5% | |
2022-23 | 82.5 | 5182 | 2471.222 | 2518.296 | 74.63 | 10% | -10% | (251.83) | 971.64 | 841.52 | 45.2% |
2023-24 | 83.5 | 5390 | 2574.871 | 2548.821 | 74.63 | 6% | -6% | (152.93) | 841.52 | 737.17 | 45.8% |
2024-25 | 84.5 | 5605 | 2682.666 | 2579.346 | 74.63 | 6% | -6% | (154.76) | 737.17 | 553.73 | 44.6% |
2025-26 | 85.5 | 5830 | 2794.773 | 2609.87 | 6% | -6% | (156.59) | 553.73 | 212.23 | 42.1% | |
2026-27 | 87.0 | 6063 | 2911.364 | 2655.658 | 0% | 0% | 0.00 | 212.23 | (43.48) | 43.8% |
I did a similar mock up with a 5% annual HRR growth and that still shows a flat cap through 2025-26, after which cap growth should return to normal.
Last edited: