Please show all work in excel please there are two questions

IIIIATSiT '3' 10:22 PM @ >3 60% C]: coursehero.com coupon interest rate? 4 P548 Bondvalueandtime: Constant requiredremrns PecosManufacturinghasiust is- sued a 15-year, 12% coupon interest rate, $IJIJ'0-par bond that pays interest ailm- alty. 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, nd the value ofrhe bond with [1} 15 years, {2) l2 years, (ill 9 years, [4} 6 years, 15] 3 years, and [6} 1 year to maturity. b. Plot your ndings on a set of \"time to maturity (Jr axislrnarltet value of bond (at axisl' are: 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 maturity? Explain in light of the graph in part b. Personal Finance Problem PB1B Bond VIII]: and time. Changing required returns Lynn Parsons is considering invest- ing in either of two outstanding bonds. The bonds both have 51,000 per values and 11% coupon interest rates and pay annual interest. Band A has exactly 5 years to maturity. and bond Bhas 15 years to maturity. a. Calculatethevalueofbondn ifthcrequiredteturn islll 8%, l2] 11%,and {BI 14%. b. Calculate the talue of bond B if the required return is [1] 8%,{211I%, and Hi 14%