[Preds]

Dave, thanks for doing the legwork on this, however, your 2021 salaries are off. The 10% annual increase is only on the BASE salary, not the rookie bonus.

For example - Josh Allen base salary in 2020 was 232 x 10 % increase (23) for a sum-total of 255 + 200 rookie bonus for being the #1 QB overall as a 3rd rd pick, for a total 2021 salary of 455.

Another example - Calvin Ridley would be 610 x 10% increase (61) for a sum-total of 671 +450 for finishing as the #3 WR as a 1st rd pick, for a total 2021 salary of 1121.

It looks like you calculated this on a spreadsheet, thus it's a pretty easy fix, just change your formula to do the 10% increase on the base salary only and then add the bonus and it should all be correct.