Ratio Analysis
Liquidity Ratios
Current ratio= current assets/ current liabilities
This ratio evaluates the ability of the company to meet its short term obligations (Smart & Gitman 2004).
Liquidity Ratios |
|||||||||||
Current Ratio |
|||||||||||
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
|
Current Assets |
395 |
423 |
376 |
343 |
331 |
274 |
387 |
485 |
733 |
892 |
506 |
Current Liabilities |
238 |
227 |
146 |
241 |
206 |
78 |
137 |
155 |
135 |
176 |
249 |
Ratio |
1.6596639 |
1.86344 |
2.57534 |
1.42324 |
1.6068 |
3.51282 |
2.82482 |
3.12903 |
5.42963 |
5.06818 |
2.03213 |
The ratio indicates that the company was able to meet its short term obligations for each of the years. This is because the value of current assets was higher than the value of current liabilities. A further analysis on the ratio gives the following trend;
The trend of the ratio shows that the company was at risk of not meeting its current obligations before filing for bankruptcy. However, from April, the liquidity position of the company significantly improved.
Quick ratio= (current-inventory/stock)/ current liabilities
This ratio indicates the ability of the company to convert its assets to cash so as it can meet its short term obligations.
Quick ratio |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Current Assets |
395 |
423 |
376 |
343 |
331 |
274 |
387 |
485 |
733 |
892 |
506 |
Less: Inventory |
143 |
169 |
153 |
155 |
152 |
123 |
162 |
139 |
138 |
169 |
277 |
252 |
254 |
223 |
188 |
179 |
151 |
225 |
346 |
595 |
723 |
229 |
|
Current Liabilities |
238 |
227 |
146 |
241 |
206 |
78 |
137 |
155 |
135 |
176 |
249 |
Ratio |
1.0588235 |
1.11894 |
1.5274 |
0.78008 |
0.86893 |
1.9359 |
1.64234 |
2.23226 |
4.40741 |
4.10795 |
0.91968 |
A further analysis on the quick ratio shows the following trend;
Similarly to the current ratio, the position of the company improved after it filed for bankruptcy.
Profitability ratios
Gross profit margin = value of gross income/ value of sales
This ratio indicates the margin of gross profit that was raised from the sales revenue (Berk & Demarzo 2007).
Profitability Ratios |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Gross Profit Margin |
|||||||||||
Gross Income |
61 |
98 |
-6 |
-11 |
82 |
-50 |
172 |
219 |
281 |
251 |
193 |
Sales |
1054 |
1151 |
755 |
772 |
1049 |
681 |
934 |
1001 |
1103 |
1147 |
1103 |
Ratio |
0.0578748 |
0.08514 |
-0.0079 |
-0.0142 |
0.07817 |
-0.0734 |
0.18415 |
0.21878 |
0.25476 |
0.21883 |
0.17498 |
The company’s gross profits declined significantly from 1982 up to 1985. After this, the gross profit levels significantly improved. Sales also were declining until 1985; after which they improved. As such, the trend analysis of the gross profit margin is as follows;
During the years 1982, 1983, and 1985, the gross profit was negative; as a result, the ratio was also negative.
Net profit margin ratio = value of net income / value of sales
This ratio evaluates the amount of sales that is converted to net income after all the expenses, taxes, and interest have been accounted for.
Net Profit Margin |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Net Income |
15 |
60 |
-59 |
-54 |
-59 |
-303 |
-251 |
-66 |
259 |
179 |
-51 |
Sales |
1054 |
1151 |
755 |
772 |
1049 |
681 |
934 |
1001 |
1103 |
1147 |
1103 |
Ratio |
0.0142315 |
0.05213 |
-0.0781 |
-0.0699 |
-0.0562 |
-0.4449 |
-0.2687 |
-0.0659 |
0.23481 |
0.15606 |
-0.0462 |
The company had negative net income from the year 1982 to 1987. As a result, the ratio indicates that the value of the sales converted to net income was negative. Furthermore, the ratio indicates that the company had been incurring high expenses compared to its revenues. The trend analysis shows the value of the ratio as follows;
The company’s ratio was worst during 1985 when it filed for bankruptcy. However, after this, the company’s position started improving.
Financial Leverage Ratios
Total debt to assets ratio= value of total debt/ value of total assets
This ratio evaluates the financial leverage position of the company. That is whether the company’s assets were able to cover the total debt (Berk & Demarzo 2007).
Financial Leverage Ratios |
|||||||||||
Total Debt To Total Assets Ratio |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Total Debt |
564 |
641 |
761 |
853 |
862 |
1011 |
1111 |
1269 |
1294 |
1214 |
968 |
Total Assets |
938 |
1,119 |
1207 |
1241 |
1220 |
1061 |
911 |
1002 |
1286 |
1486 |
1218 |
Ratio |
0.6012793 |
0.57283 |
0.63049 |
0.68735 |
0.70656 |
0.95287 |
1.21954 |
1.26647 |
1.00622 |
0.81696 |
0.79475 |
According to the above ratio, the company’s assets could not cover the total debt. As a result, the company was at risk of undergoing bankruptcy. The trend analysis of the ratio is as follows;
Total debt to equity ratio = value of total debt/ total value of equity
The ratio evaluates whether the amount of total debt has been covered by total equity.
Total Debt To Equity Ratio |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Total Debt |
564 |
641 |
761 |
853 |
862 |
1011 |
1111 |
1269 |
1294 |
1214 |
968 |
Total Shareholders’ Equity |
353 |
411 |
348 |
285 |
254 |
-49 |
-300 |
-366 |
-108 |
72 |
250 |
Ratio |
1.5977337 |
1.55961 |
2.18678 |
2.99298 |
3.3937 |
-20.633 |
-3.7033 |
-3.4672 |
-11.981 |
16.8611 |
3.872 |
The value of total equity covered total debts up to 1984. However, from 1985 to 1988 the total equity was negative, and thus, the ratio was negative. This can be attributed to negative retained earnings from the income statement. The trend analysis shows the following;
Return Ratios
Return on equity ratio = value of net income/ total equity (Smart & Gitman 2004)
The ratio evaluates the amount of return that equity shareholders gain from the net income. The ratio is given as a percentage.
Return On Equity Ratio |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Net Income |
15 |
60 |
-59 |
-54 |
-59 |
-303 |
-251 |
-66 |
259 |
179 |
-51 |
Total Equity |
353 |
411 |
348 |
285 |
254 |
-49 |
-300 |
-366 |
-108 |
72 |
250 |
Ratio |
4% |
15% |
-17% |
-19% |
-23% |
618% |
84% |
18% |
-240% |
249% |
-20% |
A further analysis of the return on equity ratio shows the following trend;
The graph illustrates the impact of the return to equity shareholders that was the highest in 1985 although the amounts of net income and equity were negative.
Return on assets ratio = value of net income / value of total assets (Ross & Jaffe 2002).
Return On Assets |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Net Income |
15 |
60 |
-59 |
-54 |
-59 |
-303 |
-251 |
-66 |
259 |
179 |
-51 |
Total Assets |
938 |
1119 |
1207 |
1241 |
1220 |
1061 |
911 |
1002 |
1286 |
1486 |
1218 |
Ratio |
2% |
5% |
-5% |
-4% |
-5% |
-29% |
-28% |
-7% |
20% |
12% |
-4% |
The trend analysis on the ratios shows the following;
Activity ratios
Inventory turnover ratio = value of cost of goods sold/ value of inventory.
Activity Ratios |
|||||||||||
Inventory Turnover Ratio |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Cost Of Goods Sold |
993 |
1053 |
762 |
783 |
967 |
731 |
762 |
782 |
822 |
896 |
910 |
Inventory |
143 |
169 |
153 |
155 |
152 |
123 |
162 |
139 |
138 |
169 |
277 |
Ratio |
6.9440559 |
6.23077 |
4.98039 |
5.05161 |
6.36184 |
5.94309 |
4.7037 |
5.6259 |
5.95652 |
5.30178 |
3.2852 |
The value of total assets turnover = sales/ total assets
Total Assets Turnover |
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Sales |
1054 |
1151 |
755 |
772 |
1049 |
681 |
934 |
1001 |
1103 |
1147 |
1103 |
Total Assets |
938 |
1119 |
1207 |
1241 |
1220 |
1061 |
911 |
1002 |
1286 |
1486 |
1218 |
Ratio |
1.1236674 |
1.0286 |
0.62552 |
0.62208 |
0.85984 |
0.64185 |
1.02525 |
0.999 |
0.8577 |
0.77187 |
0.90558 |
Z-Score
The Z-Score illustrates whether a company is financially healthy. As such, it gives a single value in each year. The value below 1.8 indicates that the company is at risk of becoming bankrupt over the next two years. If the value is above 3, the company is financially healthy. The Z-Scores are calculated by the below formula
Z= 1.2(Working Capital/Total Assets) + 1.4(Retained Earnings/ Total Assets) + 3.3(EBIT/ Taxes) + 0.6(MVOE/Total Liabilities) +1.0(Sales/Total Assets) (Smart & Gitman 2004)
Z-SCORES |
||||||||||
1980 |
1981 |
1982 |
1983 |
1984 |
1985 |
1986 |
1987 |
1988 |
1989 |
1990 |
Z-SCORES |
-1.71 |
-2.91 |
-3.41 |
-8.58 |
-11.15 |
-7.01 |
-1.94 |
-0.66 |
The above graph illustrates the trend of the calculated Z-Scores. It shows that since 1981 the company was at a risk of becoming a bankrupt. The company’s financial problems were worsening until 1986 before it filed for bankruptcy. However, the company’s financial matters improved from 1987 to 1990 although it was still at a risk of becoming a bankrupt.
Stock Price Performance Analysis
The above were the stock prices of the company by the end of each year from 1980 to 1990 for the period ended at December 31st. The graphical analysis illustrates the trend in the stock prices that declined from 1983 to 1988. The prices increased slightly in 1989; however, in 1990, the prices were split and ended at a lower price (Berk & Demarzo 2007).
The company filed for bankruptcy under chapter eleven of the Federal Bankruptcy Code in the US district court. The bankruptcy was filed on 16th April, 1985. The stock prices before and after the filing of bankruptcy were as follows;
4/8/1985 |
4/15/1985 |
4/16/1985 |
4/18/1985 |
4/22/1985 |
11.75 |
8.75 |
7.25 |
6.62 |
8.62 |
The stock price was at $11.75 on 8th April and reduced to $8.75 on 15th April. On the day the company filed for bankruptcy, the stock price was at $7.52. As a result of filing for bankruptcy, the price fell again to $6.62. However, because of the fact that the Fed had protected the company against all its liabilities, the company’s stock price improved to $8.62.
Weighted Average Cost of Capital
This is a discount rate averaged from the expected returns of different sources of capital. A higher value of the discount rate is expected in this analysis. The WACC is calculated as follows;
WACC= market value of equity/ market value of equity and debt * cost of equity+ market value of the debt/ market value of debt and equity * cost of debt (Smart & Gitman 2004).
Cost of equity is calculated using capital assets pricing model. This will be calculated as follows;
The unlevered beta = market value of stock/ market value of debt + market value of preferred stock (Berk & Demarzo 2007).
Return on equity= risk free rate+ beta *(risk premium-risk free rate) (Ross & Jaffe 2002).
As such, the risk free rate and the risk premium can be assumed to be 4% and 7% respectively (Vuuren, 1998). The risk free rate has been obtained from the lowest yielding government bonds in the steel industry during the years 1980-1989 as presented by the US treasury. The value of the risk premium is the industrial average from the steel industry in 1980-1989.
Return on equity= 4% + 1.55%* (7%-4%) = 8.65%
WACC= 250/1218* 8.65%+ 968/1218*19.55%= 17.31%
The value of beta is 1.55%, and it explains the high level of volatility in the steel industry, leading to uncertainties in some companies (Vuuren, 1998). The value resulted from the covariance of the S&P 400 and the stock prices divided by the variance of the S&P 400 index level. The weighted average cost of capital is evaluated through considering the cost of debt and equity.
Projected cash flows
1991 |
1992 |
1993 |
1994 |
1995 |
1996 |
1997 |
1998 |
1999 |
2000 |
|
Revenues |
1103 |
1158.15 |
1216.06 |
1276.86 |
1340.70 |
1407.74 |
1478.13 |
1552.03 |
1629.63 |
1711.12 |
Costs Of Goods Sold |
910 |
928.20 |
946.76 |
965.70 |
985.01 |
1004.71 |
1024.81 |
1045.30 |
1066.21 |
1087.53 |
Operating Income |
193 |
229.95 |
269.29 |
311.16 |
355.69 |
403.03 |
453.32 |
506.73 |
563.42 |
623.58 |
Selling And Administration Costs |
62 |
63.24 |
64.50 |
65.79 |
67.11 |
68.45 |
69.82 |
71.22 |
72.64 |
74.10 |
Depreciation |
49 |
48.95 |
48.46 |
48.41 |
48.36 |
48.32 |
48.27 |
48.22 |
48.17 |
48.12 |
Earnings Before Interest and Tax |
82 |
117.76 |
156.33 |
196.95 |
240.21 |
286.26 |
335.23 |
387.29 |
442.61 |
501.36 |
Non-Operating Income |
58 |
59.16 |
60.34 |
61.55 |
62.78 |
64.04 |
65.32 |
66.62 |
67.96 |
69.32 |
Interest Expense |
0 |
20.00 |
20.20 |
20.40 |
20.61 |
20.81 |
21.02 |
21.23 |
21.44 |
21.66 |
Earnings Before Tax |
140 |
156.92 |
196.47 |
238.10 |
282.39 |
329.48 |
379.52 |
432.68 |
489.12 |
549.02 |
Tax Provision |
42 |
47.08 |
58.94 |
71.43 |
84.72 |
98.84 |
113.86 |
129.80 |
146.74 |
164.71 |
Net Income |
98 |
109.84 |
137.53 |
166.67 |
197.67 |
230.64 |
265.67 |
302.88 |
342.39 |
384.31 |
The above analysis shows the projected income statement of the company. The revenues of the company are expected to grow at a rate of 5%. This is attributed to the market conditions and the aggressiveness of management in order to come out of bankruptcy and secure some debts. The costs of goods sold will also increase. However, the increase in the costs will be at a lower rate of 3% given the economies of scale in purchasing more goods (Smart & Gitman 2004).
The is using the reducing balance approach of depreciation, as such the depreciation will be reducing approximately at a rate of 1%. The non-operating income of the company has been increasing over the previous decade and is expected to continue. As such, the non-operating income is approximate to increase by 2%. As a result of filing for bankruptcy, the company was not paying any interest expenses. However, it is projected that the company will recover from bankruptcy till the second year in the new decade. As such, the company will incur interest costs that are expected to increase at a modest rate. In addition, the company is making profits that are taxable at the provision rate of 30% (Ross & Jaffe 2002).