Troubled Computer Company
Another Product line that just didn't make it.
Memo (Analysis) |
||
Ratios (excel file) |
Memo (word file) |
What happened (word file) |
Financial Ratios and Cash Flow Statements
1992 |
1991 |
1990 |
Industry |
|
averages |
||||
Product gross margin |
33.14% |
42.86% |
39.91% |
|
service gross margin |
46.86% |
46.29% |
45.24% |
|
change in product rev |
-7.63% |
-23.42% |
-31.83% |
|
change in service rev |
-10.94% |
-5.93% |
18.47% |
|
overall change in rev |
-9.40% |
-14.96% |
-14.21% |
|
operating loss margin |
-17.02% |
-15.93% |
-20.54% |
|
current ratio |
98.07% |
116.86% |
124.30% |
|
curr. assets/total assets |
65.89% |
58.26% |
55.46% |
53% |
current liab./total assets |
67.18% |
49.85% |
44.62% |
44% |
l. t. debt/total assets |
42.46% |
35.23% |
28.67% |
|
total liab./total assets |
126.87% |
96.28% |
78.61% |
69% |
stckhlds equity/t.assets |
-26.87% |
3.72% |
21.39% |
31% |
A/r turnover (ending A/r) |
5.69 |
6.17 |
5.20 |
|
days sales O/S |
63.24 |
58.35 |
69.26 |
|
invt turnover (ending inv) |
5.11 |
3.42 |
3.11 |
|
days in inventory |
70.51 |
105.36 |
115.77 |
Cashflow statement - Direct Method |
||
Cash flow from operations |
92 |
91 |
Collected from customers |
1902.3 |
2227.2 |
paid for inventory |
-586 |
-564.3 |
paid for services provided |
-530.1 |
-601.5 |
other expenses |
-$703.0 |
-$698.0 |
research and development |
-131.9 |
-233.6 |
net cf from operations |
-48.7 |
129.8 |
Other expenses: |
||
as stated |
$678.7 |
$812.6 |
decrease in current assets |
-$33.7 |
-$96.7 |
decrease current liabilities |
$9.0 |
$31.2 |
restructuring/depreciation |
||
adjustment |
$49.0 |
-$49.1 |
$703.0 |
$698.0 |
Cash flow from operations |
92 |
91 |
Net loss |
-$322.7 |
-$333.5 |
decrease in accounts rec. |
$6.1 |
$134.3 |
decrease in inventory |
$45.0 |
$82.8 |
decrease other current assets |
$33.7 |
$96.7 |
dec. fixed assets/depreciation |
$228.3 |
$271.9 |
decrease accts payable |
-$30.1 |
-$91.2 |
decrese other cur. Liab. |
-$9.0 |
-$31.2 |
net cf from operations |
-$48.7 |
$129.8 |
Cashflow from financing |
||
s.t t. debt issued(paid) |
$48.4 |
-$36.2 |
l.t.debt issued (paid) |
-$46.9 |
-$56.6 |
mtg notes |
$24.7 |
$55.8 |
issuance of stock |
$18.2 |
$23.3 |
dividends |
-$34.6 |
-$52.0 |
$9.8 |
-$65.7 |
|
Net cashflow |
-$38.9 |
$64.1 |
beginning cash |
$233.2 |
$169.1 |
ending cash |
$194.3 |
$233.2 |
** restructuring write-offs |
Memo - Analysis of TCC's Situation
November 17, 1997
From: Audit Staff (Group 3: Michael Cohen, Alon Doitch, & Gavin Green)
Re: TCC, Inc.’s Financial Condition
This memorandum will address in detail the financial condition of Troubled Computer Company, Inc. (TCC). This memo will accomplish this goal by identifying significant trends, addressing the effectiveness of management’s corrective actions, and reviewing the alternative courses of action available to management.
Troubled Computer Company has been displaying several trends that should evoke ample concern regarding the immediate survival of the company. These disturbing trends can most clearly be highlighted by analyzing TCC’s liquidity ratios. Both the current and the quick ratios have been dropping steadily from what was a minimal level of working capital to a level that is now completely unacceptable. TCC’s 1992 current and quick ratio are both below one. That means that TCC actually has negative working capital. Its current liabilities are now greater than its current assets. These ratios demonstrate that TCC is in serious danger of either technical or actual insolvency within the new fiscal year (1993). The trend in these ratios is displayed in the following graph.
Whereas, the trends in the ratio between the current assets and current liabilities signal a danger for the company’s short-term operations, the trend in the ratio between its total assets and total liabilities signals a severe structural weakness under which no company can survive in the long run. Currently, TCC has total liabilities in excess of its total assets. In other words, a liquidation of all of TCC’s assets at book value would not yield enough cash to pay off its creditors. In light of TCC’s many recent write-downs of manufacturing assets, the sale of assets for much over book value is unlikely. Under these circumstances, it is needless to say that the stockholders would receive nothing. This is a situation that would not only raise the cost of additional capital, but rather, it is a situation that we believe would make additional procurements of capital either impossible or nearly impossible. The trend in the ratio of total liabilities to total assets can be viewed in the following graph.
The liabilities for TCC are now so great that its times interest earned ratio is now negative. Clearly TCC is a company that is in serious immediate danger. To answer the question of how much time TCC would have in a worse case scenario, we can turn our attention to its defensive interval ratio. This ratio has in fact been improving over the recent years as management has been decreasing TCC’s operating expenses. TCC now has a margin of safety of about 99 days in which it can pay its operating expenses without additional outside cash.
An analysis of the previous responses of TCC’s management to the crisis shows that they have in fact improved TCC’s inventory turnover ratio, improved its total asset turnover (because of its smaller asset base), and improved its collection of receivables (see the attached spreadsheet). Unfortunately, management has been unable to do anything about TCC’s underlying problems. The result has been that management has become more efficient at losing money! The main problem is that TCC has no products that are strengthening in the marketplace. We are in a period where mini-computers and the software that runs on them are becoming increasingly obsolete, and management’s decision to cut R&D expenses makes it impossible for TCC to get off of its sinking platform and onto another growth trend. The result has been continual restructuring of the company resulting in a severe decay in its total assets. Management’s retreat has been complicated by the fact that asset liquidations have not been successful at paying down liabilities, but rather, it has just been diminishing its equity. It can be seen on the attached spreadsheet that total assets have been diminishing at a far greater pace than has total liabilities.
This section will address the options available to TCC in light of its precarious position. These options are severely limited, because of TCC’s difficulties in obtaining additional financing. In order to make any meaningful turnaround for the company, TCC would need funds to discover and develop new products unrelated to the mini-computer. We believe that the only way that this would be possible would be with the cooperation of its existing creditors. Accordingly, an option for TCC is to go into negotiations with its current creditors in order to obtain a relaxation in credit terms, the avoidance of its current portion of long-term debt, and possible additional cash infusions if the creditors believe in management’s recovery plans. Another option would be to file for protection under Chapter 11 of the Bankruptcy Code. This would provide similar benefits to option number one, but it would make the process court supervised. It could also prevent minority creditors from blocking a potentially promising recovery plan. A final proposal of ours is to restructure one last time. This restructuring would end TCC’s product sales and only continue as a service organization. We believe that this option would return TCC back into a profitable but smaller company. All of these options would need much further analysis. Further analysis should also be directed at discovering additional options; however, we believe that in light of the severity of TCC’s financial condition, Chapter 11 bankruptcy protection will probably be the best option for TCC to take some time in the new fiscal year.
Thank you for the opportunity to let us be of service, and if you have any additional questions, then feel free to contact us at your convenience.
Sincerely,
The Audit Staff from Group #3.
What really happened:
A reorganization plan was confirmed by the Court about 13 month after the company entreed Chapter 11. The plan was developed with the help of the Creditor's Committee and had the following components:
Postscript
The company's plan of reorganization was approved by the Court in September 1993. The company has continued to pursue its new business strategy. Emphasizing acquisition of companies in the netweork support industry. The company spent almost $68 mil to acquire companies in the networking, imaging and data storage industries in 1995. In July 1996, it announced plans to acquire a networking company for $206 mil.
For the nine month period following confirmation of its plan the company and positive cashflow of $34 mil. (after restructuring expenditures of $84 mil.) and operating income before amortization of the fresh start intangibles of almost $45 mil. Although it reported revenues of almost $1.1 bil. for the year ended June 30, 1996 (a 15 % increase over the prior year), the company continued to report net losses. The 1996 net loss, however, was only $600 000, compared to a loss of $61.3 mil. In 1995. The company reported that the losses are now primarily due to costs of acquisitions and it remains optimistic as revenues continue to grow.
For the year ended 6/30/1997, the company reported revenue of $1,268 mil., net income of $69.9 mil (EPS: $1.44 ). Unfortunately, $76.6 mil of net income were attributable to a gain on discontinued operations. However, for the third quarter (9/97) revenues of $312.2 mil. Resulted in net income of $11.1 mil. Things do seem to be improving.