how do I calculate discount annual salary?

kererence Irig Functions Manager Create from Selection Defined Names Remove Function Library C11 f B D G 5.0000% 0.4167% 5.1162% Year 1 Year 2 Year 3 Total Value $476,100 $476,100 476,100 $1,428,300 39,675 39,675 39,675 11.6812 11.1126 10.5717 463,452 419,493 1.0000 A 1 Assumptions and calculated values 2 Bank rate information 3 Freddies bank account rates (compounded monthly) 4 Monthly bank rate 5 Effective Annual Interest Rate 6 7 Salary and Bonus information 8 Annual Salary 9 monthly salary 10 Discount Factor (based on cell 4 above) 11 Discount Annual Salary 12 13 Moving Bonus 14 Discount Factor (based on cell 4 above) 15 Discounted moving bonus 16 17 Signing Bonus 18 Discount factor (based on Cell BS above) 19 Discounted signing bonus 20 21 Time in legue Bonus 22 Discount factor (based on Cell B5 above) 23 Discounted Time In League Bonus 24 25 Performance Bonus 26 Discount factor (based on Cell B5 above) 27 Discounted Performance Bonus 28 29 Monthly Endorsement Contract Payment 30 Discount Factor (based on cell 4 above) 7,500 1.0000 0.9513 0.9050 0.9513 0.9513 0.9050 0.8610 11.6812