Home Insert Draw Page Layout Formulas Data ew View Developer Help Calibri 11 A A General Paste BTU. a. A- $ - % 8-98 Conditional Format as Coll Formatting Table Styles Styles insert Delete- Fatmat Celle Clipboard Font Alignment Number E11 > B G H 1 Calculating a Bond Price and Yield Use Excel PV and Rate functions to calculate the price and yield of 2 a semi-annual coupon bond. 3 Bond Price 4 Bond Par Value S 1,000 5 Coupon rate 5% 6 Yield to Maturity 7% 7 Term in Years 7 8 Calculating a Bond Price and Yield 9 Bond Price 10 CHECK FIGURES! 11 Bond Yield Bond Price 12 Bond Par Value $ 1,000 Bond Par Value $ 1,000 13 Coupon rate 5% Coupon rate 9% 14 Term in Years 7 Yield to Maturity 15 Bond Price $ 980.00 Term in Years 20 16 Watch your signs. The sign on the bond's 17 Bond YTM price (PV) needs to have the opposite Bond Price $1,502.06 18 sign from the coupon and par value. 19 20 Bond Yiela Background Annual Coupon Bond Semi Annual Coupon Bonds Ready 5% 367 C