please help

1Assumptions and Calulated Values 2 Bank Rate Information: 3 Saleem's Bank Account Rate (compounded monthly) 4 Monthly Bank Rate 5 Effective Interest Rate 7.5000% 0.6250% 1.1630% 7 Salary and Bonus Information: 8 Annual Salary (4% COLA adjustment) 9Monthly Salary 10Discount factor (based on Cell B4 above) 11 Discounted Monthly Salary Year 1 Year 2 Year 3 Year 4 Total value $444,000$461,760 $480,230$499,440$1,885,430 37,000 11.5264 33,177 38,480 10.6960 9.9255 9.2105 381,933 $1,588,587 13 Time-in-League Bonus 14 Discount factor (based on Cell B4 above) 15 Discounted Time-in-League Bonus $20,000 0.9633 17 Milestone Bonus 18 Discount factor (based on Cell B5 above) 19 Discounted Milestone Bonus $125,000 $500,000 0.9280 0.8611 0.7991 0.7415 $107,638 21 Performance Bonus 22 Discount factor (based on Cell B5 above) 23 Discounted Performance Bonus $72,035 $277,163 0.9280 0.8611 0.7991 0.7415 2 $59,643 25 Monthly Endorsement Contract Payment 26 Discount factor (based on Cell B4 above) 27 Discounted Monthly Endorsement Payment $800 10.6960 $8,557 11.5264 29 Contract's Total Nominal Value 30 Contract's Total Discounted Value $2,254,278 1Assumptions and Calulated Values 2 Bank Rate Information: 3 Saleem's Bank Account Rate (compounded monthly) 4 Monthly Bank Rate 5 Effective Interest Rate 7.5000% 0.6250% 1.1630% 7 Salary and Bonus Information: 8 Annual Salary (4% COLA adjustment) 9Monthly Salary 10Discount factor (based on Cell B4 above) 11 Discounted Monthly Salary Year 1 Year 2 Year 3 Year 4 Total value $444,000$461,760 $480,230$499,440$1,885,430 37,000 11.5264 33,177 38,480 10.6960 9.9255 9.2105 381,933 $1,588,587 13 Time-in-League Bonus 14 Discount factor (based on Cell B4 above) 15 Discounted Time-in-League Bonus $20,000 0.9633 17 Milestone Bonus 18 Discount factor (based on Cell B5 above) 19 Discounted Milestone Bonus $125,000 $500,000 0.9280 0.8611 0.7991 0.7415 $107,638 21 Performance Bonus 22 Discount factor (based on Cell B5 above) 23 Discounted Performance Bonus $72,035 $277,163 0.9280 0.8611 0.7991 0.7415 2 $59,643 25 Monthly Endorsement Contract Payment 26 Discount factor (based on Cell B4 above) 27 Discounted Monthly Endorsement Payment $800 10.6960 $8,557 11.5264 29 Contract's Total Nominal Value 30 Contract's Total Discounted Value $2,254,278