SampleWeightedAverageofBondswithWeightsforWACCfinal1.xls

Sheet1

Name Maturity Date Amount $(Mil) Par Value Number Bonds Price YTM YTM as a decimal Market Value $(Mil) Weight Weighted YTM
Southwest Air 1995-A 7.22% 7/1/13 43.30 1000 43300 1000.00 7.20 0.072 43.30 0.03 0.0022
Southwest Air 1996-A 7.67% 1/2/14 33.30 1000 33300 1005.00 6.87 0.069 33.47 0.02 0.0016
Southwest Airls 5.25% 10/1/14 350.00 1000 350000 1060.00 1.20 0.012 371.00 0.26 0.0032
Southwest Air 1994-A 9.15% 7/1/16 86.30 1000 86300 1026.00 7.70 0.077 88.54 0.06 0.0048
Southwest Airls 5.75% 12/15/16 300.00 1000 300000 1136.00 1.87 0.019 340.80 0.24 0.0045
Southwest Airls 5.125% 3/1/17 300.00 1000 300000 1092.00 2.57 0.026 327.60 0.23 0.0060
Southwest Air 1995-A 7.64% 1/1/18 49.00 1000 49000 897.00 10.55 0.106 43.95 0.03 0.0033
Southwest Air 1996-A 8% 1/2/21 33.10 1000 33100 894.00 10.03 0.100 29.59 0.02 0.0021
Southwest Airls 7.375% 3/1/27 111.00 1000 111000 1210.00 5.20 0.052 134.31 0.10 0.0049
Mv Bonds 1412.56 1.00 3.261%
Mv Leases 707.00
MVd 2119.56
common shares 728100000 MVe 9326.96
preferred shares 0 MVPF 0.00
Common Price @4/5 (WSJ) 12.81 MVf 11446.53
preferred price 0 Ws 0.81
Wd 0.19
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