I need help with the discounted annual salary section and the discount performace bonus section

bonus is 15% but i think its of the discount annual salary. please help

please advise how to conplere the rest of the spreadsheet

Flynn Fireballer's Contract Evaluation Worksheet C D 1Assumptions and Calulated Values 2 Bank Rate Information: 3 Flynn's Bank Account Rate (compounded monthly) 7.0000% 4 Monthly Bank Rate 0.0058%) Effective Annual Interest Rate 0.0723%) 6 7 Salary and Bonus Information: 8 Annual Salary (4 % COLA adjustment) Year 2 Year 1 Year 3 Year 4 Total value $610,022] $564,000 $634,423 $586,560 $2,395,006 9 Monthly Salary 47,000 50,835 48,880 52,869 10 Discount factor (based on Cell 84 above) 11 Discounted Annual Salary 11.5571 10.0514 10.7780 9.3738 491,312 $2,037,842 12 13 Time-in-League Bonus $20,000 $20,000 Discount factor (based on Cel 84 above) 14 0.9657 15 Discounted Time-in-League Bonus 19,314 $19,314 16 17 Milestone Bonus $100,000 $100,000 $100.000 $100,000 $400,000 Discount factor (based on Cel B5 above) 18 0.9326 0.8697 0.8111 0.7564 19 Discounted Milestone Bonus 93.260 $86,970 81,110 75,640 $336,980 20 21 Performance Bonus $91,503 $352,071 22 Discount factor (based on Cell 85 above) 0.9326 0.8697 0.811 0.7564 23 Discounted Performance Bonus $76,520 24 25 Monthly Endorsement Contract Payment $3.000 $3,000 Discount factor (based on Cell B4 above) 27 Discounted Monthly Endorsement Payment 26 11.5571 10.7780 34.671 $32,334 28 29 Contract's Total Nominal Value 130 Contract's Total Discounted Value $2,690,1311 age St in the timng ed Flynn Fireballer's Contract Evaluation Worksheet C D 1Assumptions and Calulated Values 2 Bank Rate Information: 3 Flynn's Bank Account Rate (compounded monthly) 7.0000% 4 Monthly Bank Rate 0.0058%) Effective Annual Interest Rate 0.0723%) 6 7 Salary and Bonus Information: 8 Annual Salary (4 % COLA adjustment) Year 2 Year 1 Year 3 Year 4 Total value $610,022] $564,000 $634,423 $586,560 $2,395,006 9 Monthly Salary 47,000 50,835 48,880 52,869 10 Discount factor (based on Cell 84 above) 11 Discounted Annual Salary 11.5571 10.0514 10.7780 9.3738 491,312 $2,037,842 12 13 Time-in-League Bonus $20,000 $20,000 Discount factor (based on Cel 84 above) 14 0.9657 15 Discounted Time-in-League Bonus 19,314 $19,314 16 17 Milestone Bonus $100,000 $100,000 $100.000 $100,000 $400,000 Discount factor (based on Cel B5 above) 18 0.9326 0.8697 0.8111 0.7564 19 Discounted Milestone Bonus 93.260 $86,970 81,110 75,640 $336,980 20 21 Performance Bonus $91,503 $352,071 22 Discount factor (based on Cell 85 above) 0.9326 0.8697 0.811 0.7564 23 Discounted Performance Bonus $76,520 24 25 Monthly Endorsement Contract Payment $3.000 $3,000 Discount factor (based on Cell B4 above) 27 Discounted Monthly Endorsement Payment 26 11.5571 10.7780 34.671 $32,334 28 29 Contract's Total Nominal Value 130 Contract's Total Discounted Value $2,690,1311 age St in the timng ed