1. Compute the current bond price Bond Price Excel FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW M Font Paste Alignment Number Cells Editing Conditional Formatas Formatting Table Styles Styles Clipboard A15 A D E F 1 J K 1 2 Ninja Co, issued 14-year bonds a year ago at a coupon rate of 6.9 percent. The bonds make semiannual payments. If the YTM on these bonds is 5.2 percent, what is the current bond price in dollars? Assume a par value of $1,000 5 6 7 8 9 Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity 1/1/2000 1/1/2013 6.90% 2. 100 5.20% 10 11 12 13 14 Complete the following analysis. Do not hard code values in your answers. 16 17 18 Price 19 Sheet1 READY 100 Attempts) References eBook & Resources Excel Simulation Learning Objective: 06-02 Describe bond values and why they fluctuate Difficulty: 1 Basic Section 6.1 Bonds and Bond Valuation