90.2K

Verified Solution

Link Copied!

please answer the following questions with out using excel

Moody SLP A AR Coupon Maturity 7.550 02/152000 5.750 10/152073 5.250 2005 AA Symbol WMT OP WMT GG WTHV WMTIA AR Issuer Name WALMARTING 3 WALMARTLING a WALMARTING WALMART INC WALMARTING WALMARTING WALMARTING A Last Price Yield 14200 112120167 137.291 2.139 123315 1481 153.930 2396 14.290 2514 2364 137212 2404 Az AA AN 8500 AA 6.200 A AA WALMARTING AM D WALMART INC WALMARTIN A Callable Sub-Product Type Corporate Bond Corporate Bond Corporate Bond Corporate Bond WMTC No Corporate Bond WMTIE No Corporate Bond WMTS Corporate Bond WMTIM NO Corporate Bond WMTI Corporate Bond WMTAB No Corporate Bond WMT4117477 Yes Corporate Bond WMT4117478 Yes Corporate Bond WMT3991377 Yes Corporate and WMT301665 Yes Corporate Bond WMTADT20 Yes Corporate Bond WMT2552771 Yes Corporate Bond WMT4553032 Yes Corporate Bond WT453003 Yes Corporate Bond WMT4647497 Yes Corporate Bond WMT4647490 Yes Corporate Bond 041520 04010040 0706200 102200 0152041 04220004 22044 Dr. 2003 1062200 5005 475 5.000 3.63 300 6300 4000 250 4710 2.150 2.050 WALMARTING WALMARTING WALMARTINS WALMARLING B WALMARTIN WALMARTINS WALMARTIN WALMARTIN WALMARTING WALMARTIN 3 33 AA AA AA 150.976 2.30 10.32 0.434 131.32 2444 125.26 2407 109.92 0245 133773 2679 10237 0.24 100.00 118271 2.500 305.14 0.250 100290 0.900 AR 3.95 3.400 3.550 05220 04/2005 333 % per year 7 Moody SSP 2.875 Ba BBB BOB Band Ba Coupon Matury 012043 4900 16/2004 5.100 01/152044 3900 6 201 2005 4.100 105 4500 0201 100 4150043 4.750 2045 3.250 300 she 300 Bas2 Band Issuer Name B BEDEX GEREZORE D EREXCORD BEEREX CORO E HEEXERAL BEREXCORD DERRRR DEEREX CORP DEEDEX COP FEDEXCORO FEDEX CORP DEEREX CON BEEREXCO FEDEX FEREX CORP EFDEX CORP EEREX CORE B EFQEX CORP Last Sale Price Yield 114203125 124064 2001 12.195 121 115.100 2.550 114.342 3221 120 315 3.551 113.730 3.212 124254 3.299 to20 1.16 121.05 3.244 119.03 3273 110.30 1.614 1140 3200 114.935 1.652 120.251 337 Bas Symbol FOX1474 FOX87157 FOX4657150 FOX4200110 FOK4200154 FOK4200151 FDX2000 FDX4302012 FOX4346475 FOX4345474 FDX4442042 FOX4593524 FOX4503525 FOXT29440 FOX4730141 FOKASG2200 FOX4973082 FOX1072953 Collable Sub-Product Type Yes Corpo Band Yu Corporate Bond Yes Corporate Bond Yes Corpo Bond Yes Come Blond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Corporwa Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond 450 40 01/2009 880 888 380 300 1.400 405 6.200 Bana Bee Band 02/152043 19170002 101204 0008/2009 05152030 152050 4960 3.100 4.250 2.071 350 BB 107202 115661 San 2.194 3201 5.250 Homework assignment #11 is taken from your in-class bond price handout as follows #1 Locate the listing for the FEDEX CORP bond with a 49% coupon rate and a maturity of 1/15/2034 The bond symbolis FDX4087157 A draw a time line showing all remaining cash flows (coupon and par) for this bond Assume semiannual payments and a par value of $1,000 B calculate the value of this bond based on a required rate of return of 4 40% per year C. calculate the annual yield to maturity of this band using the price listed in the handout D. based on your answers to C and D should you invest in the bond? Why or why not? #2 Locate the listing for the WALMART INC bond with a 4 75% coupon rate and a maturity of 10/2/2043 The bond symbol is WMT4055720 A draw a time line showing all remaining cash flows for this bond. Assume semiannual payments and a par value of $1,000 B calculate the value of the bond based on a required rate of return of 5 20% per year C calculate annual yield-to-maturity of this band using the price listed in the handout D. based on your answers to C and D should you invest in the bond? Why or why not? ASSIGNMENT SUBMISSION Text Submission We Submission Moody SLP A AR Coupon Maturity 7.550 02/152000 5.750 10/152073 5.250 2005 AA Symbol WMT OP WMT GG WTHV WMTIA AR Issuer Name WALMARTING 3 WALMARTLING a WALMARTING WALMART INC WALMARTING WALMARTING WALMARTING A Last Price Yield 14200 112120167 137.291 2.139 123315 1481 153.930 2396 14.290 2514 2364 137212 2404 Az AA AN 8500 AA 6.200 A AA WALMARTING AM D WALMART INC WALMARTIN A Callable Sub-Product Type Corporate Bond Corporate Bond Corporate Bond Corporate Bond WMTC No Corporate Bond WMTIE No Corporate Bond WMTS Corporate Bond WMTIM NO Corporate Bond WMTI Corporate Bond WMTAB No Corporate Bond WMT4117477 Yes Corporate Bond WMT4117478 Yes Corporate Bond WMT3991377 Yes Corporate and WMT301665 Yes Corporate Bond WMTADT20 Yes Corporate Bond WMT2552771 Yes Corporate Bond WMT4553032 Yes Corporate Bond WT453003 Yes Corporate Bond WMT4647497 Yes Corporate Bond WMT4647490 Yes Corporate Bond 041520 04010040 0706200 102200 0152041 04220004 22044 Dr. 2003 1062200 5005 475 5.000 3.63 300 6300 4000 250 4710 2.150 2.050 WALMARTING WALMARTING WALMARTINS WALMARLING B WALMARTIN WALMARTINS WALMARTIN WALMARTIN WALMARTING WALMARTIN 3 33 AA AA AA 150.976 2.30 10.32 0.434 131.32 2444 125.26 2407 109.92 0245 133773 2679 10237 0.24 100.00 118271 2.500 305.14 0.250 100290 0.900 AR 3.95 3.400 3.550 05220 04/2005 333 % per year 7 Moody SSP 2.875 Ba BBB BOB Band Ba Coupon Matury 012043 4900 16/2004 5.100 01/152044 3900 6 201 2005 4.100 105 4500 0201 100 4150043 4.750 2045 3.250 300 she 300 Bas2 Band Issuer Name B BEDEX GEREZORE D EREXCORD BEEREX CORO E HEEXERAL BEREXCORD DERRRR DEEREX CORP DEEDEX COP FEDEXCORO FEDEX CORP DEEREX CON BEEREXCO FEDEX FEREX CORP EFDEX CORP EEREX CORE B EFQEX CORP Last Sale Price Yield 114203125 124064 2001 12.195 121 115.100 2.550 114.342 3221 120 315 3.551 113.730 3.212 124254 3.299 to20 1.16 121.05 3.244 119.03 3273 110.30 1.614 1140 3200 114.935 1.652 120.251 337 Bas Symbol FOX1474 FOX87157 FOX4657150 FOX4200110 FOK4200154 FOK4200151 FDX2000 FDX4302012 FOX4346475 FOX4345474 FDX4442042 FOX4593524 FOX4503525 FOXT29440 FOX4730141 FOKASG2200 FOX4973082 FOX1072953 Collable Sub-Product Type Yes Corpo Band Yu Corporate Bond Yes Corporate Bond Yes Corpo Bond Yes Come Blond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Corporwa Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond Yes Corporate Bond 450 40 01/2009 880 888 380 300 1.400 405 6.200 Bana Bee Band 02/152043 19170002 101204 0008/2009 05152030 152050 4960 3.100 4.250 2.071 350 BB 107202 115661 San 2.194 3201 5.250 Homework assignment #11 is taken from your in-class bond price handout as follows #1 Locate the listing for the FEDEX CORP bond with a 49% coupon rate and a maturity of 1/15/2034 The bond symbolis FDX4087157 A draw a time line showing all remaining cash flows (coupon and par) for this bond Assume semiannual payments and a par value of $1,000 B calculate the value of this bond based on a required rate of return of 4 40% per year C. calculate the annual yield to maturity of this band using the price listed in the handout D. based on your answers to C and D should you invest in the bond? Why or why not? #2 Locate the listing for the WALMART INC bond with a 4 75% coupon rate and a maturity of 10/2/2043 The bond symbol is WMT4055720 A draw a time line showing all remaining cash flows for this bond. Assume semiannual payments and a par value of $1,000 B calculate the value of the bond based on a required rate of return of 5 20% per year C calculate annual yield-to-maturity of this band using the price listed in the handout D. based on your answers to C and D should you invest in the bond? Why or why not? ASSIGNMENT SUBMISSION Text Submission We Submission

Answer & Explanation Solved by verified expert

See Answer