Using Excel to solve each and all the problems. Make sure to have detailed cash flows related to your calculations.

2. A bond issued by Coca Cola Co. matures on 19 January 2093, and has the coupon rate of 7.375%. Given that the bond pays semi-annual coupon payments and recently traded at 121.971 (percent per par value of $100), calculate the yield to maturity for the bond using the IRR function. Assume that interest payments are made on 19 January and 19 July of each year and that the current date is 20 January 2007.

*With Excel find YTM, Semi annual(IRR), annualized (IRR and XIRR)*

*For payments show formula to drag down rest of cells*

AutoSava OFF Insert Draw Page Layout Formulas Home - Date Review View Developer Share Comments Arial X G VALA v 10 a Wraa Text Ivy T SI General 4 Pssic B 1 1- Delete Forma: Insert Merge & Center S% Conditional Format Cell Formatting as Table Styles Sort! Filler Incas Fird & Select Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates C9 B F F 3 H j K L M N 0 p R S 8 T W z Note I Widt tre gues doesn't work, but with the guess t works fine Problem 2: COCA COLA BOND 2 Pricwallet 121971 3 Our Ale 7.375 4 Foo valus 100 Meld to maturity IVTM Som-(R Arrusel & Anni XIRRI Payment 10 2D Jancy 11 19-.IO7 10 TH-08 19-11 19-JA-09 18 10 19-01-09 16 19 Jan 10 17 19-1-10 TIIN-11 19.-10 A-12 1923 1 1 12 19... 13 31 34 22 11 1BJ13 19-2-13 TL-14 19-L 14 19-Jan-15 19 ... 10 19-Jan-18 19-18 L-13 19-11-17 19-Jan-18 19 ... 10 19-Jan-18 19-11-19 19-20 19-01-20 19 Jan 21 19-12 10. 2-28 19.2.1-2 19 Jan 24 19-01-24 Alash 19- 37 41 42 2 24 27 20 20 19-20 19 Jan 2 19-JEZI HIN 19-12 19-Jan-29 19.11 20 19-Jan GO 50 Problem1_temp Problem 2 temp Problem 3 tamp + - + 86% AutoSava OFF Insert Draw Page Layout Formulas Home - Date Review View Developer Share Comments Arial X G VALA v 10 a Wraa Text Ivy T SI General 4 Pssic B 1 1- Delete Forma: Insert Merge & Center S% Conditional Format Cell Formatting as Table Styles Sort! Filler Incas Fird & Select Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates C9 B F F 3 H j K L M N 0 p R S 8 T W z Note I Widt tre gues doesn't work, but with the guess t works fine Problem 2: COCA COLA BOND 2 Pricwallet 121971 3 Our Ale 7.375 4 Foo valus 100 Meld to maturity IVTM Som-(R Arrusel & Anni XIRRI Payment 10 2D Jancy 11 19-.IO7 10 TH-08 19-11 19-JA-09 18 10 19-01-09 16 19 Jan 10 17 19-1-10 TIIN-11 19.-10 A-12 1923 1 1 12 19... 13 31 34 22 11 1BJ13 19-2-13 TL-14 19-L 14 19-Jan-15 19 ... 10 19-Jan-18 19-18 L-13 19-11-17 19-Jan-18 19 ... 10 19-Jan-18 19-11-19 19-20 19-01-20 19 Jan 21 19-12 10. 2-28 19.2.1-2 19 Jan 24 19-01-24 Alash 19- 37 41 42 2 24 27 20 20 19-20 19 Jan 2 19-JEZI HIN 19-12 19-Jan-29 19.11 20 19-Jan GO 50 Problem1_temp Problem 2 temp Problem 3 tamp + - + 86%