| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
1 | Season | Years Remaining | Salary | Cumulative Salary | Caphit | Cumulative Caphit | Savings | Recapture penalty per year |
2 | 2011 | 14 | 6.000 | 6.000 | 6.667 | 6.667 | 0.667 | 0.048 |
3 | 2012 | 13 | 6.000 | 12.000 | 6.667 | 13.333 | 1.333 | 0.103 |
4 | 2013 | 12 | 11.000 | 23.000 | 6.667 | 20.000 | -3.000 | -0.250 |
5 | 2014 | 11 | 11.300 | 34.300 | 6.667 | 26.667 | -7.633 | -0.694 |
6 | 2015 | 10 | 11.300 | 45.600 | 6.667 | 33.333 | -12.267 | -1.227 |
7 | 2016 | 9 | 11.600 | 57.200 | 6.667 | 40.000 | -17.200 | -1.911 |
8 | 2017 | 8 | 11.800 | 69.000 | 6.667 | 46.667 | -22.333 | -2.792 |
9 | 2018 | 7 | 10.000 | 79.000 | 6.667 | 53.333 | -25.667 | -3.667 |
10 | 2019 | 6 | 7.000 | 86.000 | 6.667 | 60.000 | -26.000 | -4.333 |
11 | 2020 | 5 | 4.000 | 90.000 | 6.667 | 66.667 | -23.333 | -4.667 |
12 | 2021 | 4 | 1.000 | 91.000 | 6.667 | 73.333 | -17.667 | -4.417 |
13 | 2022 | 3 | 1.000 | 92.000 | 6.667 | 80.000 | -12.000 | -4.000 |
14 | 2023 | 2 | 1.000 | 93.000 | 6.667 | 86.667 | -6.333 | -3.167 |
15 | 2024 | 1 | 3.000 | 96.000 | 6.667 | 93.333 | -2.667 | -2.667 |
16 | 2025 | 0 | 4.000 | 100.000 | 6.667 | 100.000 | 0.000 | 0.000 |