All answers must be entered as a formula Click OK to begin. OK 5 ? X XJ FILE Calculating yield to maturity - Excel FORMULAS DATA REVIEW - Sign In HOME INSERT PAGE LAYOUT VIEW * Calibri 11 MAC = % V BE 3.12 B I U 1 - - A Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles - points Clipboard Font Skipped A1 D E F G H I J K eBook Print A Japanese company has a bond outstanding that sells for 91.53 percent of its #100,000 par value. The bond has a coupon rate of 3.4 percent paid annually and matures in 16 years. What is the yield to maturity of this bond? References 1/1/2000 1/1/2016 3.4% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Face value 100 91.530 \ 100,000 Complete the following analysis. Do not hard code values in your calculations, Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Yield to maturity D17 * fix C D E F G H I J K A Japanese company has a bond outstanding that sells for 91.53 percent of its #100,000 par value. The bond has a coupon rate of 3.4 percent paid annually and matures in 16 years. What is the yield to maturity of this bond? Skipped 1/1/2000 1/1/2016 eBook 3.4% Settlement date Maturity date Annual coupon rate Coupons per year Face value (% of par) Bond price (% of par) Face value Print 100 91.530 100,000 -ferences Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Yield to maturity ... Sheet1 ... + @ -- + 100% READY Attempt(s) 5/5 Step: Use the YIELD function to calculate the yield to maturity Zoom Level. Click to open the Zoom dialog box. X 5 ? X Calculating a bond price - Excel FORMULAS DATA REVIEW - Sign In FILE HOME INSERT PAGE LAYOUT VIEW Arial 12 - AA A B IU, Alignment Number Cells Editing 3.12 points Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Skipped D17 ABC D E F G H I J K eBook You find a zero coupon bond with a par value of $10,000 and 17 years to maturity. If the yield to maturity on this bond is 4.9 percent, what is the price of the bond? Assume semiannual compounding periods. Print References 1/1/2000 1/1/2017 0.00% Settlement date Maturity date Coupon rate Coupons per year Redemption value % of par) Yield to maturity Par value 100 4.90% 10,000 Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Dollar price D17 AB E F G H I J You find a zero coupon bond with a par value of $10,000 and 17 years to maturity. If the yield to maturity on this bond is 4.9 percent, what is the price of the bond? Assume semiannual compounding periods. nts Skipped 1/1/2000 1/1/2017 0.00% eBook Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 100 Print 4.90% 10,000 eferences Complete the following analysis. Do not hard code values in your calculations. Leave the "Basis" input blank in the function. You must use the built-in Excel function to answer this question. Dollar price ... Sheet1 ... + READY @ 0 -- + 100% Attempt(s) 5/5 Hint Step: Use the PRICE function to find the price of a bond. Remember, Excel calculates the price as a percentage of par value
