NOTE PLEASE ALL ANSWERS MUST BE IN EXCEL FORMULA.

X 5 ? X . HOME Calculating yield to maturity - Excel FORMULAS DATA REVIEW - Sign In FILE INSERT PAGE LAYOUT VIEW Paste B I U- - - A Alignment Number 8.12 oints Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped D17 E F G H I 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 x 5 ? x H FILE Calculating a bond price - Excel FORMULAS DATA REVIEW - Sign In HOME INSERT PAGE LAYOUT VIEW Paste B IU , - A Alignment Number 3.12 points Editing Conditional Format as Cell Formatting Table Styles Styles Cells - Clipboard Font Skipped A1 D E F G H I J 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 $ ... 2 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 X 5 Calculating a bond price - Excel ? X = INSERT - Sign In FILE HOME PAGE LAYOUT FORMULAS DATA REVIEW VIEW Calibri 11 AA - A Paste B IU Alignment Number Cells Editing 5.12 oints Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Skipped A1 AB E F G H eBook Print Yan Yan Corp. has a $2,000 par value bond outstanding with a coupon rate of 4.9 percent paid semiannually and 13 years to maturity. The yield to maturity of the bond is 3.8 percent. What is the dollar price of the bond? References 1/1/2000 1/1/2013 4.90% Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 100 3.80% 2,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 ? X XUS FILE , HOME Calculating the nominal rate - Excel FORMULAS DATA REVIEW - 2 Sign In INSERT PAGE LAYOUT VIEW - Paste B I U - PD - A Cells Editing 3.12 points Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Font Skipped D12 C D E F G H I J eBook Suppose the real rate is 1.9 percent and the inflation rate is 3.1 percent. What rate would you expect to see on a Treasury bill? Print Real rate Inflation rate 1.90% 3.10% References Complete the following analysis. Do not hard code values in your calculations. Treasury rate All answers must be entered as a formula Click OK to begin. OK