PLEASE SOLVE THESE TWO QUESTIONS USING AN EXCEL SPREADSHEET! PLEASE INCLUDE ALL FORMULAS USED IN THE SOLUTION AND SHOW THEM.

24. (0.3 point) A bond will pay $50 in interest at the end of each of the next four years, plus the principal of $1,000 at the end of the fourth year. If the required yield-to-maturity is 6% and the present price is $980, the bond's NPV is: (a) - $41. (b) + $41. (c) - $15. (d) - $33. 25. (0.3 point) A bond will pay $80 in interest at the end of each of the next six years, plus the $1,000 principal at the end of the sixth year. If the required yield-to-maturity is 10%, the intrinsic value is: (a) $874. (b) $913. (c) $952. (d) $988