Debt Management Firms

Document Sample
Debt Management Firms Powered By Docstoc
					To update this spreadsheet, enter the following
Long Term Treasury bond rate =                                                     3.84%
Risk Premium to Use for Equity =                                                   4.36%

Do you want to use the marginal tax rate for cost of debt?
If yes, enter the marginal tax rate to use




Industry Name                                         Number of Firms Beta   Cost of Equity E/(D+E)
Advertising                                                      36   1.60       10.83%     ####
Aerospace/Defense                                                67   1.19        9.02%     ####
Air Transport                                                    44   1.06        8.47%     ####
Apparel                                                          56   1.30        9.52%     ####
Auto & Truck                                                     22   1.72       11.34%     ####
Auto Parts                                                       54   1.75       11.46%     ####
Bank                                                            481   0.75        7.11%     ####
Bank (Canadian)                                                   7   0.86        7.61%     ####
Bank (Midwest)                                                   39   0.96        8.03%     ####
Beverage                                                         41   1.04        8.37%     ####
Biotechnology                                                   121   1.10        8.62%     ####
Building Materials                                               53   1.45       10.14%     ####
Cable TV                                                         24   1.69       11.22%     ####
Canadian Energy                                                  10   1.18        8.96%     ####
Chemical (Basic)                                                 17   1.27        9.38%     ####
Chemical (Diversified)                                           31   1.37        9.83%     ####
Chemical (Specialty)                                             97   1.29        9.47%     ####
Coal                                                             21   1.67       11.13%     ####
Computer Software/Svcs                                          333   1.02        8.29%     ####
Computers/Peripherals                                           129   1.29        9.45%     ####
Diversified Co.                                                 121   1.20        9.09%     ####
Drug                                                            337   1.11        8.67%     ####
E-Commerce                                                       56   1.18        8.96%     ####
Educational Services                                             38   0.75        7.12%     ####
Electric Util. (Central)                                         23   0.79        7.30%     ####
Electric Utility (East)                                          24   0.73        7.03%     ####
Electric Utility (West)                                          14   0.75        7.13%     ####
Electrical Equipment                                             87   1.41        9.99%     ####
Electronics                                                     183   1.16        8.90%     ####
Entertainment                                                    95   1.81       11.73%     ####
Entertainment Tech                                               35   1.32        9.58%     ####
Environmental                                                    91   0.97        8.06%     ####
Financial Svcs. (Div.)                                          296   1.39        9.90%     ####
Food Processing                                                 121   0.86        7.60%     ####
Foreign Electronics                                               9   1.13        8.76%     ####
Funeral Services                                                  5   1.19        9.03%     ####
Furn/Home Furnishings                                            35   1.52       10.48%     ####
Healthcare Information     33   0.97    8.08%   ####
Heavy Construction         14   1.42   10.03%   ####
Homebuilding               28   1.45   10.17%   ####
Hotel/Gaming               74   1.74   11.45%   ####
Household Products         23   1.15    8.84%   ####
Human Resources            30   1.38    9.86%   ####
Industrial Services       168   1.07    8.51%   ####
Information Services       29   1.28    9.44%   ####
Insurance (Life)           31   1.38    9.84%   ####
Insurance (Prop/Cas.)      85   0.92    7.85%   ####
Internet                  239   1.04    8.38%   ####
Investment Co.             19   0.76    7.16%   ####
Investment Co.(Foreign)    16   1.39    9.89%   ####
Machinery                 130   1.32    9.60%   ####
Manuf. Housing/RV          15   1.21    9.11%   ####
Maritime                   53   1.38    9.87%   ####
Medical Services          162   0.97    8.08%   ####
Medical Supplies          264   1.04    8.39%   ####
Metal Fabricating          36   1.54   10.55%   ####
Metals & Mining (Div.)     79   1.23    9.18%   ####
Natural Gas (Div.)         32   1.29    9.47%   ####
Natural Gas Utility        24   0.68    6.78%   ####
Newspaper                  15   1.94   12.31%   ####
Office Equip/Supplies      25   1.19    9.05%   ####
Oil/Gas Distribution       19   0.89    7.71%   ####
Oilfield Svcs/Equip.      113   1.45   10.18%   ####
Packaging & Container      31   1.20    9.06%   ####
Paper/Forest Products      39   1.63   10.96%   ####
Petroleum (Integrated)     24   1.24    9.26%   ####
Petroleum (Producing)     198   1.16    8.90%   ####
Pharmacy Services          21   0.88    7.66%   ####
Power                      77   1.23    9.20%   ####
Precious Metals            78   1.18    8.99%   ####
Precision Instrument       98   1.24    9.23%   ####
Property Management        20   1.63   10.95%   ####
Public/Private Equity       9   2.40   14.29%   ####
Publishing                 30   1.43   10.09%   ####
R.E.I.T.                  143   1.60   10.80%   ####
Railroad                   15   1.29    9.48%   ####
Recreation                 65   1.43   10.07%   ####
Reinsurance                 8   1.07    8.51%   ####
Restaurant                 68   1.34    9.70%   ####
Retail (Special Lines)    157   1.43   10.09%   ####
Retail Automotive          15   1.46   10.22%   ####
Retail Building Supply      7   0.95    7.98%   ####
Retail Store               43   1.35    9.71%   ####
Retail/Wholesale Food      32   0.73    7.01%   ####
Securities Brokerage       30   1.18    8.96%   ####
Semiconductor             125   1.56   10.64%   ####
Semiconductor Equip      14   1.93   12.24%   ####
Shoe                     19   1.34    9.66%   ####
Steel (General)          20   1.61   10.84%   ####
Steel (Integrated)       15   1.85   11.93%   ####
Telecom. Equipment      115   1.15    8.84%   ####
Telecom. Services       140   1.10    8.64%   ####
Thrift                  227   0.73    7.03%   ####
Tobacco                  12   0.78    7.25%   ####
Toiletries/Cosmetics     19   1.23    9.19%   ####
Trucking                 33   1.30    9.52%   ####
Utility (Foreign)         5   1.07    8.50%   ####
Water Utility            15   0.82    7.40%   ####
Wireless Networking      60   1.50   10.40%   ####
Total Market           7036   1.17    8.93%   ####
                 Cost of Debt Lookup Table (based on std dev in stock prices)
                                       Standard Deviation
                                            0                               0.2
                                           0.2                             0.25
      No                                  0.25                              0.3
     40%                                   0.3                              0.4
                                           0.4                              0.5
                                           0.5                              0.6
                                           0.6                              10


Std Dev in Stock Cost of Debt                                            Tax Rate
     121.35%                                                     7.84%   ####
      66.36%                                                     7.84%   ####
      81.01%                                                     7.84%   ####
      76.57%                                                     7.84%   ####
      90.53%                                                     7.84%   ####
      74.38%                                                     7.84%   ####
      49.04%                                                     6.34%   ####
      28.26%                                                     5.34%   ####
      45.15%                                                     6.34%   ####
      73.45%                                                     7.84%   ####
     104.46%                                                     7.84%   4.46%
      85.39%                                                     7.84%   ####
      73.64%                                                     7.84%   ####
      36.29%                                                     5.84%   ####
      53.62%                                                     6.84%   ####
      56.56%                                                     6.84%   ####
      82.15%                                                     7.84%   ####
      62.27%                                                     7.84%   ####
      81.44%                                                     7.84%   ####
      95.69%                                                     7.84%   8.65%
      66.46%                                                     7.84%   ####
     106.23%                                                     7.84%   5.62%
      65.57%                                                     7.84%   ####
      66.15%                                                     7.84%   ####
      29.47%                                                     5.34%   ####
      28.68%                                                     5.34%   ####
      25.06%                                                     5.34%   ####
      80.10%                                                     7.84%   ####
      94.87%                                                     7.84%   ####
      93.66%                                                     7.84%   ####
      90.65%                                                     7.84%   6.28%
      93.51%                                                     7.84%   ####
      85.56%                                                     7.84%   ####
      56.31%                                                     6.84%   ####
      36.76%                                                     5.84%   ####
      40.49%                                                     6.34%   ####
      81.55%                                                     7.84%   ####
 73.79%   7.84%   ####
 51.88%   6.84%   ####
 80.36%   7.84%   1.42%
104.09%   7.84%   ####
 48.71%   6.34%   ####
 68.14%   7.84%   ####
 74.47%   7.84%   ####
 54.92%   6.84%   ####
 81.20%   7.84%   ####
 40.47%   6.34%   ####
111.16%   7.84%   5.94%
 43.18%   6.34%   0.00%
 36.18%   5.84%   2.10%
 68.56%   7.84%   ####
 78.83%   7.84%   ####
 76.15%   7.84%   9.70%
 79.09%   7.84%   ####
 79.82%   7.84%   ####
 81.30%   7.84%   ####
116.66%   7.84%   7.41%
 52.52%   6.84%   ####
 29.74%   5.34%   ####
 89.84%   7.84%   ####
 63.47%   7.84%   ####
 55.25%   6.84%   7.15%
 57.28%   6.84%   ####
 63.84%   7.84%   ####
 80.18%   7.84%   7.70%
 45.16%   6.34%   ####
 89.88%   7.84%   ####
 51.58%   6.84%   ####
 96.52%   7.84%   7.00%
 79.62%   7.84%   8.41%
 68.69%   7.84%   ####
 51.41%   6.84%   9.03%
 79.62%   7.84%   0.80%
 65.19%   7.84%   ####
 61.39%   7.84%   0.72%
 43.76%   6.34%   ####
 96.94%   7.84%   ####
 35.62%   5.84%   4.17%
 75.60%   7.84%   ####
 81.24%   7.84%   ####
 54.23%   6.84%   ####
 38.69%   5.84%   ####
 69.17%   7.84%   ####
 43.97%   6.34%   ####
 66.47%   7.84%   ####
 75.05%   7.84%   ####
64.97%   7.84%   ####
56.36%   6.84%   ####
53.15%   6.84%   ####
67.12%   7.84%   ####
80.02%   7.84%   ####
82.51%   7.84%   ####
46.79%   6.34%   ####
63.16%   7.84%   ####
68.11%   7.84%   ####
55.24%   6.84%   ####
33.85%   5.84%   ####
47.29%   6.34%   ####
84.03%   7.84%   9.92%
74.99%   7.84%   ####
   Basis Spread
            0.50%
            1.00%
            1.50%
            2.00%
            2.50%
            3.00%
            4.00%


After-tax Cost of Debt   D/(D+E)   Cost of Capital
               6.82%     ####            9.14%
               6.27%     ####            8.51%
               6.46%     ####            7.64%
               6.54%     ####            8.95%
               6.80%     ####            8.58%
               6.89%     ####            9.91%
               5.23%     ####            5.86%
               4.54%     ####            7.18%
               5.03%     ####            6.46%
               6.89%     ####            8.15%
               7.49%     ####            8.47%
               6.70%     ####            8.57%
               6.13%     ####            8.88%
               4.26%     ####            7.85%
               5.36%     ####            8.70%
               5.41%     ####            9.10%
               6.83%     ####            8.88%
               6.81%     ####           10.30%
               7.05%     5.32%           8.22%
               7.16%     9.86%           9.23%
               6.36%     ####            7.50%
               7.40%     ####            8.52%
               6.78%     8.04%           8.79%
               5.95%     6.73%           7.04%
               3.62%     ####            5.43%
               3.54%     ####            5.52%
               3.61%     ####            5.46%
               6.74%     ####            9.52%
               7.01%     ####            8.50%
               6.92%     ####            9.99%
               7.35%     ####            9.35%
               6.72%     ####            7.62%
               6.54%     ####            7.37%
               5.66%     ####            7.16%
               5.21%     ####            7.96%
               4.80%     ####            7.50%
               6.47%     ####            9.36%
6.44%   ####     7.88%
4.53%   7.05%    9.64%
7.73%   ####     8.93%
6.83%   ####     9.31%
4.76%   ####     8.09%
5.99%   ####     9.41%
6.44%   ####     7.99%
5.52%   ####     8.69%
6.08%   ####     8.83%
5.35%   ####     7.36%
7.37%   2.23%    8.36%
6.34%   ####     6.85%
5.72%   8.58%    9.53%
6.24%   ####     8.53%
6.68%   3.83%    9.01%
7.08%   ####     8.15%
6.36%   ####     7.56%
6.96%   ####     8.25%
6.42%   ####     9.90%
7.26%   ####     8.94%
5.13%   ####     8.07%
4.01%   ####     5.55%
5.70%   ####     9.95%
6.07%   ####     7.97%
6.35%   ####     7.19%
5.33%   ####     9.18%
6.41%   ####     8.06%
7.24%   ####     9.24%
4.25%   ####     8.63%
6.96%   ####     8.48%
5.17%   ####     7.25%
7.29%   ####     8.23%
7.18%   7.82%    8.85%
7.02%   ####     8.94%
6.22%   ####     7.84%
7.78%   ####    10.19%
6.62%   ####     8.66%
7.78%   ####     9.58%
4.60%   ####     8.27%
6.52%   ####     8.89%
5.60%   ####     8.07%
6.28%   ####     9.07%
6.39%   ####     9.58%
4.60%   ####     8.49%
4.26%   ####     7.38%
6.40%   ####     9.01%
4.41%   ####     6.47%
6.23%   ####     6.95%
6.99%   7.46%   10.37%
6.53%   6.79%   11.86%
5.33%   3.43%    9.51%
5.32%   ####     9.54%
6.04%   ####    10.27%
6.76%   9.83%    8.63%
6.84%   ####     8.06%
5.59%   ####     6.77%
5.80%   ####     6.98%
5.78%   ####     8.48%
4.73%   ####     7.31%
5.13%   ####     6.80%
4.36%   ####     5.98%
7.06%   ####     9.85%
6.74%   ####     8.20%

				
DOCUMENT INFO
Description: Debt Management Firms document sample