I had some free times on my hands last night, so I decided to play around with some cap projections moving forward. I have projected out to the '17-'18 season.
Here is the read-only link to the Google Document:
https://docs.google.com/spreadsheets...it?usp=sharing
Some notes about this:
- There is a tab for each season.
- I decided to increase the Salary Cap by 5% on a yearly basis. That seems to be on the low side, so know that this could easily be higher.
- To make a case study like this, you have to make a TON of assumptions. All assumed salary numbers are in green. Please discuss if you think I high/low balled some salaries.
- I have only used players that are currently in the system. Therefore, trades and signings are not part of this.
- I have noted the players that fall off of the roster on the right hand side of the season worksheet.
- Next season, if we make no trades or FA signings, and assuming all RFAs are qualified, we have 16 NHL calibre forwards.
One of my pet projects with this case study was to see if we could somehow trade for Brent Seabrook, and sign him to a 3-5 year extension. You can see with this, there is PLENTY of room for a player like this.
I'd love to hear your comments about this. Please share, and I can manipulate the data as decided by the group.