Question P6-16 Bond Valuation: Annual Interest. Help! Answers to the excel spreadsheet please

P6-16 Bond valuation: Annual interest Calculate the value of each of the bonds shown in the following table, all of which pay interest annually. Bond Par value Coupon interest rate Years to maturity Required return $1,000 14% 12% 1,000 100 500 1,000 14 Problem P6-16 16 A Settlement Maturity Rate YTM Redemption Frequency Basis Bond Price: Multiply by 101 (Think of Settlement as the beginning of the duration of the bond) l(Think of Maturity as the end of the duration of the bond) (Coupon Rate) (Yield to Maturity or Required Rate fo Return) (Bonds Face Value, Par Value, or Fair Price; Note that is is $100, not $1,000. You make the adjustments by multiplying the answer by 10.) (Coupon payments are semiannul, so you put in a 2. If they are annual, then you input a 1) (Always leave it blank) (The answer. But you need to multiply it by 10 to get the actual bond price.) (Microsoft gives the bond price in 2 digits like in cell B111. You need to multiply it by 10 to get the actual bond price) 27 B Settlement Maturity Rate YTM Redemption Frequency Basis Bond Price: Multiply by 10 (Think of Settlement as the beginning of the duration of the bond) (Think of Maturity as the end of the duration of the bond) (Coupon Rate) (Yield to Maturity or Required Rate fo Return) (Bonds Face Value, Par Value, or Fair Price; Note that is is $100, not $1,000. You make the adjustments by multiplying the answer by 10.) (Coupon payments are semiannul, so you put in a 2. If they are annual, then you input a 1) (Always leave it blank) (The answer. But you need to multiply it by 10 to get the actual bond price.) (Microsoft gives the bond price in 2 digits like in cell B111. You need to multiply it by 10 to get the actual bond price) 38 C Settlement Maturity Rate (Think of Settlement as the beginning of the duration of the bond) (Think of Maturity as the end of the duration of the bond) (Gounon Rate)