I only need question B explained to me. How do I create this in excel?
LG 6 P6-18 Bond value and time: Constant required returns Pecos Manufacturing has just is- sued a 15-year, 12% coupon interest rate, $1,000-par bond that pays interest annu- ally. The required return is currently 14%, and the company is certain it will remain at 14% until the bond matures in 15 years. a. Assuming that the required return does remain at 14% until maturity, find the value of the bond with (1) 15 years, (2) 12 years, (3) 9 years, (4) 6 years, (5) 3 years, and (6) 1 year to maturity. b. Plot your findings on a set of "time to maturity (x axis)-market value of bond (y axis)" axes constructed similarly to Figure 6.5 on page 252. c. All else remaining the same, when the required return differs from the coupon interest rate and is assumed to be constant to maturity, what happens to the bond value as time moves toward maturityP Explain in light of the graph in part b. 252 Valuation of Securities PART 3 FIGURE 6.5 Time to Maturity and Bond Values Relationship among time to maturity, required returns, and bond values (Mills Company's 10% coupon interest rate, 10-year maturity, $1,000 par, January 1, 2014, issue date paying annual interest) Premium Bond, Required Return, ,,-8% 1,134 1,115 1,052 Par-Value Bond, Required Return, rd 10% 1,000 952- 901 G 887 Discount Bond, Required Return, 412% Time to Maturity (years LG 6 P6-18 Bond value and time: Constant required returns Pecos Manufacturing has just is- sued a 15-year, 12% coupon interest rate, $1,000-par bond that pays interest annu- ally. The required return is currently 14%, and the company is certain it will remain at 14% until the bond matures in 15 years. a. Assuming that the required return does remain at 14% until maturity, find the value of the bond with (1) 15 years, (2) 12 years, (3) 9 years, (4) 6 years, (5) 3 years, and (6) 1 year to maturity. b. Plot your findings on a set of "time to maturity (x axis)-market value of bond (y axis)" axes constructed similarly to Figure 6.5 on page 252. c. All else remaining the same, when the required return differs from the coupon interest rate and is assumed to be constant to maturity, what happens to the bond value as time moves toward maturityP Explain in light of the graph in part b. 252 Valuation of Securities PART 3 FIGURE 6.5 Time to Maturity and Bond Values Relationship among time to maturity, required returns, and bond values (Mills Company's 10% coupon interest rate, 10-year maturity, $1,000 par, January 1, 2014, issue date paying annual interest) Premium Bond, Required Return, ,,-8% 1,134 1,115 1,052 Par-Value Bond, Required Return, rd 10% 1,000 952- 901 G 887 Discount Bond, Required Return, 412% Time to Maturity (years
