Excel Activity: Bond Valuation Start with the partial model in the file cho4 P24 Bulld a Model.xlsx. A 20-year, 9% semiannual coupon bond with a par value of $1,000 may be called in 6 years at a call price of $1,080. The bond sells for $1,130. (Assume that the bond has just been issued.) The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not found intermediate calculations, Download spreadsheet Ch04 P24 Build a Model-984d7xlsx a. What is the bond's yield to maturity? Round your answer to two decimal places. 7.71% b. What is the bond's current yield? Round your answer to two decimal places. 7.96 % c. What is the band's capital gain or loss yield Round your answer to two decimal places. Use a minus sign to enter a negative in -0.25 d. What is the band's yield to call? Round your answer to two decimal places 736 c. How would the price of the bond be affected by a change in the going market interest rate? (Hint: Conducta storica to changes in the going market interest rate for the bond. Assume that the bond will be called it and any of the young not ow the coupon rate. This is an oversimplification, but assume it for purposes of this problem.) Round your answers to the nearest cert. Nominal market rate Actual bond price 0 e. How would the price of the bond be affected by a change in the going market interest rate? (Hint: Conduct a sensitivity analysis of price to change in the going market interest rate for the bond. Assume that the bond will be called if and only if the going rate of interest fails below the coupon rate. This is an oversimplification, but assume it for purposes of this problem.) Round your answers to the nearest cent. Nominal market rate Actual bond price $ $ 0% 2% 4% 6% 89 10% 12% $ $ 5 $ 5 16% t. Now assume the date is October 25, 2020. Assume further that an 11%, 15-year bond was issued on July 1, 2020, pays verest serannually con January 1 and July 1), and sells for $1,130. Again, it may be called in 6 years from the date of issue at a call price of 59.080. Use your spreadsheet to find the bond's yield. Round your answers to two decimal places. Yield to maturity: Yield to call Excel Activity: Bond Valuation Start with the partial model in the file cho4 P24 Bulld a Model.xlsx. A 20-year, 9% semiannual coupon bond with a par value of $1,000 may be called in 6 years at a call price of $1,080. The bond sells for $1,130. (Assume that the bond has just been issued.) The data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not found intermediate calculations, Download spreadsheet Ch04 P24 Build a Model-984d7xlsx a. What is the bond's yield to maturity? Round your answer to two decimal places. 7.71% b. What is the bond's current yield? Round your answer to two decimal places. 7.96 % c. What is the band's capital gain or loss yield Round your answer to two decimal places. Use a minus sign to enter a negative in -0.25 d. What is the band's yield to call? Round your answer to two decimal places 736 c. How would the price of the bond be affected by a change in the going market interest rate? (Hint: Conducta storica to changes in the going market interest rate for the bond. Assume that the bond will be called it and any of the young not ow the coupon rate. This is an oversimplification, but assume it for purposes of this problem.) Round your answers to the nearest cert. Nominal market rate Actual bond price 0 e. How would the price of the bond be affected by a change in the going market interest rate? (Hint: Conduct a sensitivity analysis of price to change in the going market interest rate for the bond. Assume that the bond will be called if and only if the going rate of interest fails below the coupon rate. This is an oversimplification, but assume it for purposes of this problem.) Round your answers to the nearest cent. Nominal market rate Actual bond price $ $ 0% 2% 4% 6% 89 10% 12% $ $ 5 $ 5 16% t. Now assume the date is October 25, 2020. Assume further that an 11%, 15-year bond was issued on July 1, 2020, pays verest serannually con January 1 and July 1), and sells for $1,130. Again, it may be called in 6 years from the date of issue at a call price of 59.080. Use your spreadsheet to find the bond's yield. Round your answers to two decimal places. Yield to maturity: Yield to call
