Please use spreadsheet functions to calculate

M N 0 B C D G H 1 Part A 2 ABC Corporation's bonds have a 15-year maturity, a 7.25% coupon rate, and a par value of $1,000. The going interest rate (rd) is 6.20%, 3 What is the bond's price based on semiannual compounding (using Excel functions)? (5 pts) 4 5 bond price = 6 7 4 9 10 11 12 Part B 13 You will receive the following future cash stream: 14 Year 1 2 3 15 Cash flow $100 200 1,000 100 16 17 If you require a return of 10%, what is the minimum amount you are willing to accept for giving up your future cash stream? (5 pts) 18 19 total present value using NPV function 20 21 22 23 24 25 01 02 03 04 05 06 07 08 09