All answers must be entered as a formula Click OK to begin. OK 5 1 ? x XD FILE . HOME Calculating a bond price - Excel FORMULAS DATA REVIEW - Sign In INSERT PAGE LAYOUT VIEW 19 Calibri -11-AA Paste B IU , , A, Alignment Number 3.12 points Conditional Format as Cell Formatting Table Styles Cells - Editing Clipboard Font Styles Skipped A1 E F G H I J 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 D17 x fx AB nts 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? Skipped 1/1/2000 1/1/2013 4.90% eBook Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 100 Print 3.80% 2,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 @ J - 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. ? X Calculating the nominal rate - Excel FORMULAS DATA REVIEW - Sign In INSERT PAGE LAYOUT VIEW XDS, FILE HOME * Calibri Paste B I 111 A A = % P D A U. 3- A Cells Editing pints Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Skipped 41 C D E F G H I 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 Clipboard Font Styles D12 - D E F G H I J K 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? Ints Skipped Real rate Inflation rate 1.90% 3.10% Complete the following analysis. Do not hard code values in your calculations. eBook Treasury rate Print References ... Sheet1 ... + READY Attempt(s) 4/5 Step: The Fisher effect is (1 + R) = (1 + r) (1 + h), @ D -- + 100% Hint All answers must be entered as a formula Click OK to begin. OK 5 1 ? x XD FILE . HOME Calculating a bond price - Excel FORMULAS DATA REVIEW - Sign In INSERT PAGE LAYOUT VIEW 19 Calibri -11-AA Paste B IU , , A, Alignment Number 3.12 points Conditional Format as Cell Formatting Table Styles Cells - Editing Clipboard Font Styles Skipped A1 E F G H I J 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 D17 x fx AB nts 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? Skipped 1/1/2000 1/1/2013 4.90% eBook Settlement date Maturity date Coupon rate Coupons per year Redemption value (% of par) Yield to maturity Par value 100 Print 3.80% 2,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 @ J - 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. ? X Calculating the nominal rate - Excel FORMULAS DATA REVIEW - Sign In INSERT PAGE LAYOUT VIEW XDS, FILE HOME * Calibri Paste B I 111 A A = % P D A U. 3- A Cells Editing pints Alignment Number Conditional Format as Cell Formatting Table Styles Styles Clipboard Skipped 41 C D E F G H I 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 Clipboard Font Styles D12 - D E F G H I J K 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? Ints Skipped Real rate Inflation rate 1.90% 3.10% Complete the following analysis. Do not hard code values in your calculations. eBook Treasury rate Print References ... Sheet1 ... + READY Attempt(s) 4/5 Step: The Fisher effect is (1 + R) = (1 + r) (1 + h), @ D -- + 100% Hint