CHAPTER 8 - EXCEL EXERCISE Finding the Different variables for Bond works the exact ways find the values of an and Using the functions solve for the highlighted sections in the charts below BOND TERMS-ANNUAL PAYMENTS COMPANY Price The Coupon Amist the Coun Iate the Place Value YTM $1.200 Parface Value Coupon Rate Coupon Amount years to Matumly 11.000 100% 3160 $1,000 70% 510,000 50 20 $1,000 110% 15 31000 90 510,000 120% 30 65% 11 1915 10.5% ide on the function button in excel and select what you are trying to solve for (P. For Price or Rate For YTM PV The next step involves just selecting the proper cells that it in each section. The Price is going to be the PV, The Palace is going to be the PV, the per is the years to maturity, the Pot is the Coupon Amount and the Rate is the YTM -0.05 10 M Pro & ES : 25000 - 11134 Here the prevalented the totalment sensor par Hale is the intendere Forum 15.3725 os