I need help writing out the formulas in Excel. What I am using is not working.....

Snipping Tool is moving... ? Prices - Excel DATA - Sign In REVIEW VIEW In a future update, Snipping Tool will be moving to a new home. Try improved features and snip like usual with Snip & Sketch (or try the shortcut Windows logo key + Shift + S). Cells Editing Try Snip & Sketch Conditional Format as Cell Formatting' Table Styles Styles D18 WN 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. 1/1/2000 1/1/2013 6.90% Settlement date Maturity date Coupon rate Coupons per year Face value Yield to maturity 100 5.20% BOUWBE600 O Complete the following analysis. Do not hard code values in your answers. Price ...Sheet1 ... 6 READY -1000 FILE Sign HOME Calibri INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW 11 A = % D E U. 3- A. Alignment Number Conditional Format as Cell Formatting Table Styles Font Styles Paste B I Cells Editing Clipboard A1 A B D E F G H I J K Stone Sour Corp. issued 20-year bonds two years ago at a coupon rate of 7.1 percent. The bonds make semiannual payments. If these bonds currently sell for 105 percent of par value, what is the YTM? 1/1/2000 1/1/2018 7.10% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) 100 Complete the following analysis. Do not hard code values in your answers. Yield to maturity Shu 1