Please show cell references thanks

-------------------------------------------------------------------

15 Calculate the Fair Value of the following bonds based on their Required Rate of Return. Use a nested IF statement in your Should Sell For columns, i.e. =IF(logical testl, value if truel, IF(logical test2, value if true2, value if both false)). 16 17 Index Par Value Years to Maturity 18 Fal valu 14 19 20 $ $ 14 10 21 22. 23 24 25 26 27 12 28 29 13 15 30 Bond 1 Bond 2 Bond 3 Bond 4 Bond 5 Bond 6 Bond 7 Bond 8 Bond 9 Bond 10 Bond 11 Bond 12 Bond 13 Bond 14 Bond 15 Bond 16 Bond 17 Bond 18 Bond 19 Bond 20 Bond 21 Bond 22 Bond 23 Bond 24 Bond 25 Coupon R ) 10.65% 5.80% 13.86% 8.37% 9.44% 8.17% 5.45% 7.81% 9.09% 6.25% 5.17% 5.47% 10.14% 6.39% 5.18% 11.01% 7.60% 10.40% 7.60% 9.06% 7.96% 6.81% 7.19% 6.35% 9.77% 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 31 32 Required Rate of Return Semi-annue 8.00% Yes 7.01% Yes 7.89% No 10.25% Yes 9.09% No 8.40% No 8.42% Yes 7.81% Yes 9.09% Yes 7.60% No 7.73% No 7.39% Yes 10.22% No 6.27% Yes 6.84% No 8.49% No 7.60% No 9.27% No 7.60% Yes 5.93% No 7.96% Yes 8.19% No 8.80% Yes 9.19% No 8.52% No 33 13 34 35 36 37 14 14 38 10 39 14 40 15 41 15 42 43 13 15 Calculate the Fair Value of the following bonds based on their Required Rate of Return. Use a nested IF statement in your Should Sell For columns, i.e. =IF(logical testl, value if truel, IF(logical test2, value if true2, value if both false)). 16 17 Index Par Value Years to Maturity 18 Fal valu 14 19 20 $ $ 14 10 21 22. 23 24 25 26 27 12 28 29 13 15 30 Bond 1 Bond 2 Bond 3 Bond 4 Bond 5 Bond 6 Bond 7 Bond 8 Bond 9 Bond 10 Bond 11 Bond 12 Bond 13 Bond 14 Bond 15 Bond 16 Bond 17 Bond 18 Bond 19 Bond 20 Bond 21 Bond 22 Bond 23 Bond 24 Bond 25 Coupon R ) 10.65% 5.80% 13.86% 8.37% 9.44% 8.17% 5.45% 7.81% 9.09% 6.25% 5.17% 5.47% 10.14% 6.39% 5.18% 11.01% 7.60% 10.40% 7.60% 9.06% 7.96% 6.81% 7.19% 6.35% 9.77% 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 1,000.00 31 32 Required Rate of Return Semi-annue 8.00% Yes 7.01% Yes 7.89% No 10.25% Yes 9.09% No 8.40% No 8.42% Yes 7.81% Yes 9.09% Yes 7.60% No 7.73% No 7.39% Yes 10.22% No 6.27% Yes 6.84% No 8.49% No 7.60% No 9.27% No 7.60% Yes 5.93% No 7.96% Yes 8.19% No 8.80% Yes 9.19% No 8.52% No 33 13 34 35 36 37 14 14 38 10 39 14 40 15 41 15 42 43 13