2 Finding the Different Variables for Bond works the exact ways findind the values or an annuity Using these functions solve for the highlighted sections in the charts below 5 7 1 BOND TERMS - ANNUAL PAYMENTS COMPANY Price $1,000 The Coupon Amount is just the Coupon Ratex the Palace Value YTM Parface Value 51600 $1000 310000 Coupon Rate 100% 704 Coupon Amount years to Maturity 5100 TO 10 11 12 20 16 D E 1 559 110 11 04 00 120 $1.000 $10.000 14 10 10 M 15 NI Click on the function button in excel and lect what you are trying to solve for (PV For Price or late For YTM 23 24 Function Argument The next step involves ja selecting the proper cells that it in each section. The Price is going to be the PV. The Par/Faces going to be the IV, the per is the years to - 005 Chapter 6 D G H Function Arguments PV The next step involves just selecting the proper cells that fit in each section. The Price is going to be the PV, The Par/Face is going to be the FV, the Nper is the years to maturity, the Pmt is the Coupon Amount and the Rate is the YTM Rate ON EC -0.05 Nper Os - 10 Pet FB -0 FES - 25000 Type AN number 15347,83134 Return the present value of an investment the total amount that a series of future payment is worth now. Rate is the interest rate per period. For example, use for quarterly payments at 6N APR Formuta result S15,347.83 OK Cancel Help Action