Finance Project Report

profileRopela
WalmartweightedaverageforWACC.xls
Home>Business & Finance homework help>Accounting homework help>Finance Project Report

Sheet1

139.23 187.9605
Name Maturity Date Amount $(Mil) Par Value Number Bonds Price YTM YTM as a decimal Market Value $(Mil) Weight Weighted YTM 10
Wal-Mart Stores 5.25% 1/9/35 2500.00 1000 2500000 1228.00 3.53 0.035 3070.00 0.08 0.0027 2500000000 http://quicktake.morningstar.com/StockNet/bonds.aspx?Symbol=WMT&Country=USA
Wal-Mart Stores 5.625% 04/15/2041 2000.00 1000 2000000 1286.00 3.78 0.038 2572.00 0.06 0.0024
Wal-Mart Stores 6.2% 04/15/2038 1822.40 1000 1822400 1360.00 3.69 0.037 2478.46 0.06 0.0023
Wal-Mart Stores 6.5% 08/15/2037 1761.90 1000 1761900 1394.00 3.69 0.037 2456.09 0.06 0.0023
Wal-Mart Stores 3.25% 10/25/2020 1750.00 1000 1750000 1043.00 1.81 0.018 1825.25 0.05 0.0008
Wal-Mart Stores 2.55% 11/4/23 1750.00 1000 1750000 1015.00 2.26 0.023 1776.25 0.04 0.0010
Wal-Mart Stores 3.625% 8/7/20 1500.00 1000 1500000 1053.00 1.71 0.017 1579.50 0.04 0.0007
Wal-Mart Stores 3.3% 04/22/2024 1500.00 1000 1500000 1051.00 2.46 0.025 1576.50 0.04 0.0010
Wal-Mart Stores In 5.625% 03/27/2034 1290.60 1000 1290600 1447.00 2.35 0.024 1867.50 0.05 0.0011
Wal-Mart Stores In 5.25% 09/28/2035 1290.60 1000 1290600 1425.00 2.35 0.024 1839.11 0.05 0.0011
Wal-Mart Stores 1.125% 11/4/18 1250.00 1000 1250000 998.00 1.48 0.015 1247.50 0.03 0.0005
Wal-Mart Stores 5% 10/25/2040 1250.00 1000 1250000 1199.00 3.71 0.037 1498.75 0.04 0.0014
Wal-Mart Stores 5.625% 1/4/40 1250.00 1000 1250000 1295.00 3.69 0.037 1618.75 0.04 0.0015
Wal-Mart Stores 5.8% 02/15/2018 1250.00 1000 1250000 1018.00 1.44 0.014 1272.50 0.03 0.0005
Wal-Mart Stores In 4.875% 09/21/2029 1181.80 1000 1181800 1390.00 1.34 0.013 1642.70 0.04 0.0005
Wal-Mart Stores 1.9% 8/4/22 1004.50 1000 1004500 - - - - - -
Wal-Mart Stores 4.25% 04/15/2021 1000.00 1000 1000000 1079.00 1.95 0.020 1079.00 0.03 0.0005
Wal-Mart Stores 7.55% 02/15/2030 1000.00 1000 1000000 1450.00 3.14 0.031 1450.00 0.04 0.0011
Wal-Mart Stores 4% 11/4/43 1000.00 1000 1000000 1055.00 3.67 0.037 1055.00 0.03 0.0010
Wal-Mart Stores 4.3% 04/22/2044 1000.00 1000 1000000 1106.00 3.67 0.037 1106.00 0.03 0.0010
Wal-Mart Stores 1.95% 12/15/2018 1000.00 1000 1000000 1005.00 1.56 0.016 1005.00 0.03 0.0004
Wal-Mart Stores In 4.875% 01/19/2039 832.50 1000 832500 1383.00 2.54 0.025 1151.35 0.03 0.0007
Wal-Mart Stores 2.55% 8/4/26 768.10 1000 768100 - - - - - -
Wal-Mart Stores 4.875% 8/7/40 750.00 1000 750000 1182.00 3.69 0.037 886.50 0.02 0.0008
Wal-Mart Stores 5.875% 5/4/27 750.00 1000 750000 1236.00 3.01 0.030 927.00 0.02 0.0007
Wal-Mart Stores 4.75% 2/10/43 750.00 1000 750000 1175.00 3.7 0.037 881.25 0.02 0.0008
Wal-Mart Stores In 5.75% 12/19/2030 645.30 1000 645300 1415.00 2.14 0.021 913.10 0.02 0.0005
Wal-Mart Stores 0.52% 07/16/2027 551.70 1000 551700 - - - - - -
Wal-Mart Stores 5.85% 1/6/18 500.00 1000 500000 - - - - - -
Wal-Mart Stores 5.85% 1/6/18 500.00 1000 500000 1032.00 1.67 0.017 516.00 0.01 0.0002
Wal-Mart Stores 4.125% 1/2/19 500.00 1000 500000 1035.00 1.53 0.015 517.50 0.01 0.0002
Wal-Mart Stores 0.298% 07/18/2024 367.80 1000 367800 - - - - - -
Wal-Mart Stores 6.75% 10/15/2023 250.00 1000 250000 1223.00 2.75 0.028 305.75 0.01 0.0002
Wal-Mart Stores In 1.6% 07/28/2020 91.90 1000 91900 - - - - - -
Wal-Mart Stores 0.183% 07/15/2022 0.64 1000 644 - - - - - -
36609.74
Mv Bonds 40114.30 1.00 2.783%
Mv Leases 707.00
MVd 40821.30
common shares 728100000 MVe 9326.96
preferred shares 0 MVPF 0.00
Common Price @4/5 (WSJ) 12.81 MVf 50148.27
preferred price 0 Ws 0.19
Wd 0.81
wpf 0
J-MRP: This is the weighted average rd
J-MRP: 376 + 331 Leases info from Note 5 Non Current Lease Related Obligations and Airport Construction Obligation

Sheet2

Sheet3