Garden State Container Corporation Financial Analysis and Forecasting Directed Garden State Container Corporation manufactures boxes and other containers primarily for farm products. More than 85 percent of the company's sales come from the northeastern part of the United States, especially Pennsylvania, New Jersey, New York, and Maryland, although the company's patented egg cartons are distributed throughout the United States. Jim Jackson, the founder and pres- ident, recently received a call from Martha Menendez, vice president of Atlantic First National Bank. Menendez told him that a negative report had been generated by the bank's computerized analysis system; the report showed that Garden State's financial position was bad and getting worse. The bank requires quarterly financial statements from each of its major loan customers. Infor- mation from these statements is fed into the computer, which then calculates key ratios for each customer and charts trends in these ratios. The system also compares the statistics for each com- pany with the average ratios of other firms in the same industry and against any protective covenants in the loan agreements. If any ratio is significantly worse than the industry average, reflects a marked adverse trend, or fails to meet contractual requirements, the computer highlights the deficiency. The latest report on Garden State revealed a number of adverse trends and several potentially serious problems (see Tables 1 through 6 for Garden State's historical financial statements). Partic- ularly disturbing were the 1992 current, quick, and debt ratios, all of which failed to meet the con- tractual limits of 2.0, 1.0, and 55 percent, respectively. Technically, the bank had a legal right to call all the loans it had extended to Garden State for immediate repayment and, if the loans were not repaid within ten days, to force the company into bankruptcy. Martha hoped to avoid calling the loans if at all possible, as she knew this would back Gar- den State into a corner from which it might not be able to emerge. Still, her own bank's examiners had recently become highly sensitive to the issue of problem loans, because the recent spate of bank failures had forced regulators to become more strict in their examination of bank loan portfo- lios and to demand earlier identification of potential repayment problems. One measure of the quality of a loan is the Altman Z score, which for Garden State was 3.04 for 1992, slightly below the 3.20 minimum that Martha's bank uses to differentiate strong firms with little likelihood of bankruptcy in the next two years from those deemed likely to go into default. This will put the bank under increased pressure to reclassify Garden State's loans as "problem loans," to set up a reserve to cover potential losses, and to take whatever steps are necessary to reduce the bank's exposure. Setting up the loss reserve would have a negative effect on the bank's profits and reflect badly on Martha's performance. To keep Garden State's loan from being reclassified as a "problem loan," the Senior Loan Committee will require strong and convincing evidence that the company's present difficulties are only temporary. Therefore, it must be shown that appropriate actions to overcome the problems have been taken and that the chances of reversing the adverse trends are realistically good. Martha now has the task of collecting the necessary information, evaluating its implications, and preparing a recommendation for action. The recession that plagued the U.S. economy in the early 1990s caused severe, though hope- fully temporary, problems for companies like Garden State. On top of this, disastrous droughts for two straight summers had devastated vegetable crops in the area, leading to a drastic curtailment of demand for produce shipping containers. In light of the softening demand, Garden State had aggres- sively reduced prices in 1991 and 1992 to stimulate sales. Higher sales, the company believed, would allow it to realize greater economies of scale in production and to ride the learning, or experience, curve down to a lower cost position. Garden State's management had full confidence that normal weather and national economic policies would revive the ailing economy and that the downtum in demand would be only a short-term problem. Consequently, production continued unabated, and inventories increased sharply. In a further effort to reduce inventory, Garden State relaxed its credit standards in early 1992 and improved its already favorable credit terms. As a result, sales growth did remain high by indus- try standards through the third quarter of 1992, but not high enough to keep inventories from con- tinuing to rise. Further, the credit policy changes had caused accounts receivable to increase dramatically by late 1992. dramatic To finance its rising inventories and receivables, Garden State turned to the bank for a long- term loan in 1991 and also increased its short-term credit lines in both 1991 and 1992. However, this expanded credit was insufficient to cover the asset expansion, so the company began to delay pay- ments of its accounts payable until the second late notice had been received. Management realized that this was not a particularly wise decision for the long run, but they did not think it would be necessary to follow the policy for very longthe 1992 summer vegetable crop looked like a record breaker, and it was unlikely that a severe drought would again hurt the crop. They also predicted that the national economy would pull out of the weak growth scenario in late 1992. Thus, the company was optimistic that its stable and profitable markets of the past would soon reappear. After Martha's telephone call, and the subsequent receipt of a copy of the bank's financial analysis of Garden State, Jim began to realize just how precarious his company's financial position had become. As he started to reflect on what could be done to correct the problems, it suddenly dawned on him that the company was in even more trouble than the bank imagined. Jim had recently signed a firm contract for a plant expansion that would require an additional $12,750,000 of capital during the first quarter of 1993, and he had planned to obtain this money with a short-term loan from the bank to be repaid from profits expected in the last half of 1993 as a result of the expansion. In his view, once the new production facility went on line, the company would be able to increase output in several segments of the shipping container market. It might have been possible to cut back on the expansion plans and to retrench, but because of the signed construction contracts and the cancellation charges that would be imposed if the plans were canceled, Jim correctly regards the $12,750,000 of new capital as being essential for Garden State's very survival. Jim quickly called his senior management team in for a meeting, explained the situation, and asked for their help in formulating a solution. The group concluded that if the company's current business plan were carried out, Garden State's sales would grow by 10 percent from 1992 to 1993 and by another 15 percent from 1993 to 1994. Further, they concluded that Garden State should reverse its recent policy of aggressive pricing and easy credit, returning to pricing that fully cov- ered costs plus normal profit margins and to standard industry credit practices. These changes should enable the company to reduce the cost of goods sold from over 85 percent of sales in 1992 to about 82.5 percent in 1993 and then to 80 percent in 1994. Similarly, the management group felt that the company could reduce administrative and selling expenses from almost 9 percent of sales in 1992 to 8 percent in 1993 and then to 7.5 percent in 1994. Significant cuts should also be possible in miscellaneous expenses, which should fall from 2.92 percent of 1992 sales to approximately 1.75 percent of sales in 1993 and to 1.25 percent in 1994. These cost reductions represented "trimming the fat," so they were not expected to degrade the quality of the firm's products or the effectiveness of its sales efforts. Further, to appease suppliers, future bills would be paid more promptly, and to convince the bank how serious management is about correcting the company's problems, cash div- idends would be eliminated until the firm regains its financial health. Assume that Jim has hired you as a consultant to first verify the bank's evaluation of the company's current financial situation and then to put together a forecast of Garden State's expected performance for 1993 and 1994. Jim asks you to develop some figures that ignore the possibility of a reduction in the credit lines and that assume the bank will increase the line of credit by the $12,750,000 needed for the expansion and supporting working capital. Also, you and Jim do not expect the level of interest rates to change substantially over the two-year forecast period; how- ever, you both think that the bank will charge 12 percent on both the additional short-term loan, if it is granted, and on the existing short-term loans, if they are extended. The assumed 40 percent com- bined federal and state tax rate should also hold for two years. Finally, if the bank cooperates, and if Jim is able to turn the company around, the P/E ratio should be 12 in 1993 and should rise to 14 in 1994 Your first task is to construct a set of pro forma financial statements that Jim and the rest of the Garden State management team can use to assess the company's position and also to convince Martha that her bank's loan is safe, provided the bank will extend the firm's line of credit. Then, you must present your projections, with recommendations for future action, to Garden State's manage- ment and to Martha. To prepare for your presentations, answer the following questions, keeping in mind that the Garden State managers and particularly, Martha and her bosses, could ask you some tough questions about your analysis and recommendations. Put another way, the following questions are designed to help you focus on the issues, but they are not meant to be a complete and exhaus- tive list of all the relevant points. TABLE 1 Historical and Pro Forma Balance Sheets for Years Ended December 31 (in Thousands of Dollars) Proforma 1990 1991 1992 1993 1994 $ 9.930 34,196 39,791 $ 83.888 $ 7.363 36,924 69,361 $113,647 $ 6.550 58,714 97.984 $ 163,249 X X X X X X $ 34.634 (5,992) $ 28,642 $112.530 $ 39,19 19,308) $29.887 $143.534 $ 44,604 (13,388) $ 31.216 $194,465 $ 57.036 (18,234) $ 38.802 $215.375 $58,746 (21.880) $36.866 X Assets: Cash and marketable securities Accounts receivable Inventory Current assets Land, buildings, plant, and equipment Accumulated depreciation Nel fixed assets Total assets Liabilities and Equity: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term debt Total liabilities Common stock Retained earnings Total cquity Total liabilities and equity $ 6,376 13.528 6,886 $ 26,790 $ 13,388 5.738 S 19.126 $ 45,916 $ 46,538 20,076 S 66,614 $112,530 $ 10,200 21.012 10,200 $ 41,412 $ 20,082 5,202 $ 25,284 $ 66,696 $ 46,538 30,300 S 76,838 $143,534 $ 36,466 39.996 14.662 $ 91,124 $20,082 4,680 $ 24,762 $115,886 $ 46,538 32,041 S 78.579 $194,465 31.990 18,602 $ 20,082 4,208 24,290 X $ 46,538 X X $33,590 23,252 $20,082 3.788 $23.870 X $46.538 X X Notes: 17,000,000 shares of common stock were outstanding throughout the period 1990 through 1992. b. Market price of shares: 1990-$17.78; 1991-$9.70: 1992-93.74. c. Price/carnings (P/E) ratios: 19906.29: 19914.98: 1992-11.28. The 1992 P/E ratio is high because of the depressed earnings that year. d. Assume that all changes in interest-hearing loans and gross fixed assets occur at the start of the relevant years. e. The mortgage loan is secured by a first-mortgage bond on land and huildings. TABLE 2 Historical and Pro Forma Income Statements for Years Ended December 31 (Thousands of Dollars) 1990 Pro Forma 1993 1994 1991 1992 $378,549 311.110 67.439 $401.251 342.016 $ 59.235 $441,376 364.135 $ 77.241 S507,583 X S101,517 Net sales $350,546 Cost of goods sold 282.252 Gross profit 68,294 Administration and selling expenses $ 25,580 Depreciation 3.188 Miscellaneous expenses 4.054 Total operating expenses $ 32.822 EBIT $ 35,472 Interest on short-term loans $ 638 Interest on long-term lours 1.339 Interest on mortgage Total interest $ 2,493 Before-tax earnings $ 32,979 Taxes 13.192 Net income $ 19.787 Dividends on stock 4,947 Additions to retained earnings $14.841 $ 30,690 3.316 7.114 $ 41.120 $ 26,319 $ 1,122 2.008 468 $ 3,598 $ 22.721 9.088 $ 13.632 3,408 $ 10.224 516 $ 33,762 4.080 11.450 $ 49.292 $ 9.943 $ 3,647 2.008 421 $ 6,076 $ 3,867 1.547 $ 2.320 580 $ 1.740 X 4.846 X $ 29,361 $ 5,906 1.912 379 8.197 X 3,646 6,345 S 5,906 1,912 341 S 8.159 S 45,298 18.119 X X X 0 X Notes: a. Eamings per share (EPS): 1990-$2.69: 1991-$1.81: 1992-S0.22. b. Interest rates on borrowed funds: Short-term loan: 1990-1098; 1991-11%1992-10%. Long-lern lount: 10% for each year, Mortgage: 9% for each year. c. For purposes of this case, assume that expenses other than depreciation and interest are totally variable with sales. TABLE 3 Common-Size Balance Sheets for Years Ended December 31 1990 1991 1992 Assets: Cash and marketable securities Accounts receivable Inventory Current assets I.and, buildings, plant, and equipment Accumulated depreciation Net fixed assets Total assets 8.82% 30.39 35.36 74.559 30.78% (5.32) 25.45% 100.00% 5.136 25.72 48.32 79.18% 27.31% (6.48) 20.82% 100.00% 3.37% X 50.39 X (6.88) 16.05% 100.00% Liabilities and Equities: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term delt Total liabilities Common stock Retained carnings Total cquity Total liabilities and equity 18.75% 20.57 7.54 46,86% X 2.41 5.67% 12.02 6.12 23.81% 11.90% 5.10 17.00% 40.80% 41.36% 17.84 59.20% 100.00% 7.11% 14.64 7.11 28.85% 13.99% 3.62 17.62% 46.47% 32.42% 21.11 53.53% 100.00% 59.59% 23.93% 40.41% 100.00% Note: Rounding dillerences occur in this table. TABLE4 Common-Size Income Statements for Years Ended December 31 1990 1991 1992 Nt sales Cost of gouds sold Gross profit Administrative and selling expenses Depreciation Miscellaneous expenses Total operating experises EBIT Interest on short-term loans Interest on long-term loans Interest on mortgage Total interest Beforc-tax carnings Taxes Net income Dividends on stock Additions to retained earnings 100.00% 80.52 19.48% 7.30% 0.91 1.16 9.36% 10.12% 0.18% 0.38 0.15 0.71 100.00% 82.18 17.826 8.11% 0.88 1.88 10.86% 6,956 0.30% 0.53 012 0.95% 6.00 2.40 3.60% 100.00% X 14.768 8.41% 2.85 2.28% 2.48% 010 1.51 0.96 0.58% 3.76 5.64% 1.419 4.23% 0.90% 2.70% 0.14% 0.43% TABLE 5 Statement of Cash Flows for Years Ended December 31 (in Thousands of Dollars) 1991 1992 $378,549 (2.728) $375.821 (311.110) (29,570) 7,484 3.314 ($329,882) $45.939 (30,690) (7.114) (9.088) ($953) $401,251 X $379.461 (342,016) (28,623) 18,984 X X X ($33,762) (11.450) (1,547) Cash Flow from Operations: Sales Increase in receivables Cash sales Cost of goods sold Increase in inventories Increase in accts payable Increase in accruals Cash cost of goods Cash margin Administrative and selling expenses Miscellaneous expenses Taxes Net Cash How from operations Cash Flow from Fixed Assel Investment: Investment in fixed assets Cash Flow from Financing Activities: Increase in short-term debt Increase in long-term debt Repayment of mortgage Interest expense Common dividends Net Cash Flow from financing activities Increase (decrease) in cash and marketable securities (54.561) ($5,409) S3.824 6,694 (536) (3,598) (3.408) $26.266 X (522) (6,076) (580) $2,976 $19,088 (S2.539) Historical and Pro Forma Ratio Analysis for Years Ended December 31 1990 1991 Pro Forma 1993 1994 Industry Average 1992 Liquidity Ratios: Current ratio Quick ratio 3.13 2.74 1.07 X X 2.50 1.00 1.65 0.72 Leverage Ratios: Debt ratio TIE coverage 40.80% 14.23 46,470 7.31 52.319 6.55 50.000 7.70 1.64 3.49 Asset Managment Ralios: Inventory turnover (cost) 7.09 Inventory turnover (sale) 8.81 Fixed asset turnover 12.24 Total asset tumover 3.12 Days sale outstanding (ACPy35.12 4.49 5.46 12.67 2.64 35.11 5.70 11.38 2.05 12.85 X 5.70 13.77 32.00 5.70 7.00 12.00) 52.68 32.00 Profilability Ratin: Prulit murgin Gross profil murgin Return on total assets ROF 5.645 19.485 17.58% 29.709 3,60% 17.82% 9.50% 17.746 0.58% 14.7645 X 2.950 X 17.508 5.905 20.00% 10.94% X 2.90 18.09 8.804 17.500 Other Ratio Altman Z score! Payout ratio 5.42 6.64 25.00% 4.75 25.00 25.00% 3.95 0.00% 4.65 20.00% Notes: a Uses cost of goods sold as the numerator 6. Uscs net sales is the numerator C. Assume a 30-day year d. Alman's function is calculators Z = 0.0128, +0.014X, +0.033X3 +0.005X +0.999X; Here, X = net working capitullotal ussels X = retained earningstal assets X3 = EBIT/total assets X, = market value of common and preferred stock book value of all debt X = sales total assets. The "Altman Z score" range of 1.81-2.99 represents the so-called "zone of ignorance." Note that the first four variables are expressed as percentages. Refer to Chapter 26 of Eugene F. Brigham and Louis C. Gapenski, Intermediate Pinuncia Munagement, iurih Edition (Fort Worth: Dryden Press, 1993), for details. e. Year-end balance sheet values were used throughout in the cuerputation of ralius embodying balance sheet items. 1. Assume constant industry average rutix throughout the period 1990 through 1994. QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected data in the 1993 and 1994 columns. If you are using the Lotus model, use it to complete the tables. Be sure you understand all the numbers, as it would be most embarrassing and harm- ful to your career) if you were asked how you got a particular number, and you could not give a meaningful response. 2. Based on the information in the case and on the results of your calculations in Question 1, prepare a list of Garden State's strengths and weaknesses. In essence, you should look at the common-size statements and each group of key ratios (for example, the liquidity ratios) and see what those ratios indicate about the company's operations and financial condition. As a part of your answer, use the extended Du Pont equation to highlight the key relationships. 3. Recognizing that you might want to revise your opinion later, does it appear, based on your analysis to this point, that the bank should lend the requested money to Garden State? Explain 4. Now complete the tables to develop pro forma financial statements for 1993 and 1994. For these calculations, assume that the bank is willing to maintain the present credit lines and to grant an additional $12,750,000 of short-term credit on January 1, 1993. In the analysis, take account of the amounts of inventory and accounts receivable that would be carried if inven- tory utilization (based on the cost of goods sold) and days sales outstanding were set at industry-average levels. Also, assume in your forecast that all of Garden State's plans and predictions concerning sales and expenses materialize and that the firm pays no cash divi- dends during the forecast period. Finally, in your calculations use the cash and marketable securities account as the residual balancing figure. In responding to Questions 5 through 8, no Lotus model modifications are required. Answers should be based solely on the data contained in the financial statements developed in response to Question 4. 5. Assume Garden State has determined that its optimal cash balance is 5 percent of sales and that funds in excess of this amount will be invested in marketable securities which, on aver- age, will earn 7 percent interest. Based on your forecasted financial statements, will Garden State be able to invest in marketable securities in 1993 and 1994? If so, what is the amount of excess funds Garden State should invest in marketable securities? Do your financial fore- casts reveal any developing conditions that should be corrected? 6. Based on the forecasts developed earlier, would Garden State be able to retire all of the out- standing short-term loans by December 31, 1993? 7. If the bank decides to withdraw the entire line of credit and to demand immediate repayment of the two existing loans (the short-term and long-term loans) extended to Garden State, what alternatives would be available to Garden State? 8. Under what circumstances might the validity of comparative ratio analysis be questionable? Answer this question in general, not just for Garden State, but use Garden State data to illus- trate your points. 11. On the basis of your analyses, do you think Martha should recommend that the bank extend the existing short and long-term loans and grant the additional $12,750,000 loan or that the bank demand immediate repayment of all existing loans? If she does recommend continu- ing to support the company, what conditions (for example, collateral, guarantees, or other safeguards) might the bank impose to help protect against losses should Garden State's plans go awry? Garden State Container Corporation Financial Analysis and Forecasting Directed Garden State Container Corporation manufactures boxes and other containers primarily for farm products. More than 85 percent of the company's sales come from the northeastern part of the United States, especially Pennsylvania, New Jersey, New York, and Maryland, although the company's patented egg cartons are distributed throughout the United States. Jim Jackson, the founder and pres- ident, recently received a call from Martha Menendez, vice president of Atlantic First National Bank. Menendez told him that a negative report had been generated by the bank's computerized analysis system; the report showed that Garden State's financial position was bad and getting worse. The bank requires quarterly financial statements from each of its major loan customers. Infor- mation from these statements is fed into the computer, which then calculates key ratios for each customer and charts trends in these ratios. The system also compares the statistics for each com- pany with the average ratios of other firms in the same industry and against any protective covenants in the loan agreements. If any ratio is significantly worse than the industry average, reflects a marked adverse trend, or fails to meet contractual requirements, the computer highlights the deficiency. The latest report on Garden State revealed a number of adverse trends and several potentially serious problems (see Tables 1 through 6 for Garden State's historical financial statements). Partic- ularly disturbing were the 1992 current, quick, and debt ratios, all of which failed to meet the con- tractual limits of 2.0, 1.0, and 55 percent, respectively. Technically, the bank had a legal right to call all the loans it had extended to Garden State for immediate repayment and, if the loans were not repaid within ten days, to force the company into bankruptcy. Martha hoped to avoid calling the loans if at all possible, as she knew this would back Gar- den State into a corner from which it might not be able to emerge. Still, her own bank's examiners had recently become highly sensitive to the issue of problem loans, because the recent spate of bank failures had forced regulators to become more strict in their examination of bank loan portfo- lios and to demand earlier identification of potential repayment problems. One measure of the quality of a loan is the Altman Z score, which for Garden State was 3.04 for 1992, slightly below the 3.20 minimum that Martha's bank uses to differentiate strong firms with little likelihood of bankruptcy in the next two years from those deemed likely to go into default. This will put the bank under increased pressure to reclassify Garden State's loans as "problem loans," to set up a reserve to cover potential losses, and to take whatever steps are necessary to reduce the bank's exposure. Setting up the loss reserve would have a negative effect on the bank's profits and reflect badly on Martha's performance. To keep Garden State's loan from being reclassified as a "problem loan," the Senior Loan Committee will require strong and convincing evidence that the company's present difficulties are only temporary. Therefore, it must be shown that appropriate actions to overcome the problems have been taken and that the chances of reversing the adverse trends are realistically good. Martha now has the task of collecting the necessary information, evaluating its implications, and preparing a recommendation for action. The recession that plagued the U.S. economy in the early 1990s caused severe, though hope- fully temporary, problems for companies like Garden State. On top of this, disastrous droughts for two straight summers had devastated vegetable crops in the area, leading to a drastic curtailment of demand for produce shipping containers. In light of the softening demand, Garden State had aggres- sively reduced prices in 1991 and 1992 to stimulate sales. Higher sales, the company believed, would allow it to realize greater economies of scale in production and to ride the learning, or experience, curve down to a lower cost position. Garden State's management had full confidence that normal weather and national economic policies would revive the ailing economy and that the downtum in demand would be only a short-term problem. Consequently, production continued unabated, and inventories increased sharply. In a further effort to reduce inventory, Garden State relaxed its credit standards in early 1992 and improved its already favorable credit terms. As a result, sales growth did remain high by indus- try standards through the third quarter of 1992, but not high enough to keep inventories from con- tinuing to rise. Further, the credit policy changes had caused accounts receivable to increase dramatically by late 1992. dramatic To finance its rising inventories and receivables, Garden State turned to the bank for a long- term loan in 1991 and also increased its short-term credit lines in both 1991 and 1992. However, this expanded credit was insufficient to cover the asset expansion, so the company began to delay pay- ments of its accounts payable until the second late notice had been received. Management realized that this was not a particularly wise decision for the long run, but they did not think it would be necessary to follow the policy for very longthe 1992 summer vegetable crop looked like a record breaker, and it was unlikely that a severe drought would again hurt the crop. They also predicted that the national economy would pull out of the weak growth scenario in late 1992. Thus, the company was optimistic that its stable and profitable markets of the past would soon reappear. After Martha's telephone call, and the subsequent receipt of a copy of the bank's financial analysis of Garden State, Jim began to realize just how precarious his company's financial position had become. As he started to reflect on what could be done to correct the problems, it suddenly dawned on him that the company was in even more trouble than the bank imagined. Jim had recently signed a firm contract for a plant expansion that would require an additional $12,750,000 of capital during the first quarter of 1993, and he had planned to obtain this money with a short-term loan from the bank to be repaid from profits expected in the last half of 1993 as a result of the expansion. In his view, once the new production facility went on line, the company would be able to increase output in several segments of the shipping container market. It might have been possible to cut back on the expansion plans and to retrench, but because of the signed construction contracts and the cancellation charges that would be imposed if the plans were canceled, Jim correctly regards the $12,750,000 of new capital as being essential for Garden State's very survival. Jim quickly called his senior management team in for a meeting, explained the situation, and asked for their help in formulating a solution. The group concluded that if the company's current business plan were carried out, Garden State's sales would grow by 10 percent from 1992 to 1993 and by another 15 percent from 1993 to 1994. Further, they concluded that Garden State should reverse its recent policy of aggressive pricing and easy credit, returning to pricing that fully cov- ered costs plus normal profit margins and to standard industry credit practices. These changes should enable the company to reduce the cost of goods sold from over 85 percent of sales in 1992 to about 82.5 percent in 1993 and then to 80 percent in 1994. Similarly, the management group felt that the company could reduce administrative and selling expenses from almost 9 percent of sales in 1992 to 8 percent in 1993 and then to 7.5 percent in 1994. Significant cuts should also be possible in miscellaneous expenses, which should fall from 2.92 percent of 1992 sales to approximately 1.75 percent of sales in 1993 and to 1.25 percent in 1994. These cost reductions represented "trimming the fat," so they were not expected to degrade the quality of the firm's products or the effectiveness of its sales efforts. Further, to appease suppliers, future bills would be paid more promptly, and to convince the bank how serious management is about correcting the company's problems, cash div- idends would be eliminated until the firm regains its financial health. Assume that Jim has hired you as a consultant to first verify the bank's evaluation of the company's current financial situation and then to put together a forecast of Garden State's expected performance for 1993 and 1994. Jim asks you to develop some figures that ignore the possibility of a reduction in the credit lines and that assume the bank will increase the line of credit by the $12,750,000 needed for the expansion and supporting working capital. Also, you and Jim do not expect the level of interest rates to change substantially over the two-year forecast period; how- ever, you both think that the bank will charge 12 percent on both the additional short-term loan, if it is granted, and on the existing short-term loans, if they are extended. The assumed 40 percent com- bined federal and state tax rate should also hold for two years. Finally, if the bank cooperates, and if Jim is able to turn the company around, the P/E ratio should be 12 in 1993 and should rise to 14 in 1994 Your first task is to construct a set of pro forma financial statements that Jim and the rest of the Garden State management team can use to assess the company's position and also to convince Martha that her bank's loan is safe, provided the bank will extend the firm's line of credit. Then, you must present your projections, with recommendations for future action, to Garden State's manage- ment and to Martha. To prepare for your presentations, answer the following questions, keeping in mind that the Garden State managers and particularly, Martha and her bosses, could ask you some tough questions about your analysis and recommendations. Put another way, the following questions are designed to help you focus on the issues, but they are not meant to be a complete and exhaus- tive list of all the relevant points. TABLE 1 Historical and Pro Forma Balance Sheets for Years Ended December 31 (in Thousands of Dollars) Proforma 1990 1991 1992 1993 1994 $ 9.930 34,196 39,791 $ 83.888 $ 7.363 36,924 69,361 $113,647 $ 6.550 58,714 97.984 $ 163,249 X X X X X X $ 34.634 (5,992) $ 28,642 $112.530 $ 39,19 19,308) $29.887 $143.534 $ 44,604 (13,388) $ 31.216 $194,465 $ 57.036 (18,234) $ 38.802 $215.375 $58,746 (21.880) $36.866 X Assets: Cash and marketable securities Accounts receivable Inventory Current assets Land, buildings, plant, and equipment Accumulated depreciation Nel fixed assets Total assets Liabilities and Equity: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term debt Total liabilities Common stock Retained earnings Total cquity Total liabilities and equity $ 6,376 13.528 6,886 $ 26,790 $ 13,388 5.738 S 19.126 $ 45,916 $ 46,538 20,076 S 66,614 $112,530 $ 10,200 21.012 10,200 $ 41,412 $ 20,082 5,202 $ 25,284 $ 66,696 $ 46,538 30,300 S 76,838 $143,534 $ 36,466 39.996 14.662 $ 91,124 $20,082 4,680 $ 24,762 $115,886 $ 46,538 32,041 S 78.579 $194,465 31.990 18,602 $ 20,082 4,208 24,290 X $ 46,538 X X $33,590 23,252 $20,082 3.788 $23.870 X $46.538 X X Notes: 17,000,000 shares of common stock were outstanding throughout the period 1990 through 1992. b. Market price of shares: 1990-$17.78; 1991-$9.70: 1992-93.74. c. Price/carnings (P/E) ratios: 19906.29: 19914.98: 1992-11.28. The 1992 P/E ratio is high because of the depressed earnings that year. d. Assume that all changes in interest-hearing loans and gross fixed assets occur at the start of the relevant years. e. The mortgage loan is secured by a first-mortgage bond on land and huildings. TABLE 2 Historical and Pro Forma Income Statements for Years Ended December 31 (Thousands of Dollars) 1990 Pro Forma 1993 1994 1991 1992 $378,549 311.110 67.439 $401.251 342.016 $ 59.235 $441,376 364.135 $ 77.241 S507,583 X S101,517 Net sales $350,546 Cost of goods sold 282.252 Gross profit 68,294 Administration and selling expenses $ 25,580 Depreciation 3.188 Miscellaneous expenses 4.054 Total operating expenses $ 32.822 EBIT $ 35,472 Interest on short-term loans $ 638 Interest on long-term lours 1.339 Interest on mortgage Total interest $ 2,493 Before-tax earnings $ 32,979 Taxes 13.192 Net income $ 19.787 Dividends on stock 4,947 Additions to retained earnings $14.841 $ 30,690 3.316 7.114 $ 41.120 $ 26,319 $ 1,122 2.008 468 $ 3,598 $ 22.721 9.088 $ 13.632 3,408 $ 10.224 516 $ 33,762 4.080 11.450 $ 49.292 $ 9.943 $ 3,647 2.008 421 $ 6,076 $ 3,867 1.547 $ 2.320 580 $ 1.740 X 4.846 X $ 29,361 $ 5,906 1.912 379 8.197 X 3,646 6,345 S 5,906 1,912 341 S 8.159 S 45,298 18.119 X X X 0 X Notes: a. Eamings per share (EPS): 1990-$2.69: 1991-$1.81: 1992-S0.22. b. Interest rates on borrowed funds: Short-term loan: 1990-1098; 1991-11%1992-10%. Long-lern lount: 10% for each year, Mortgage: 9% for each year. c. For purposes of this case, assume that expenses other than depreciation and interest are totally variable with sales. TABLE 3 Common-Size Balance Sheets for Years Ended December 31 1990 1991 1992 Assets: Cash and marketable securities Accounts receivable Inventory Current assets I.and, buildings, plant, and equipment Accumulated depreciation Net fixed assets Total assets 8.82% 30.39 35.36 74.559 30.78% (5.32) 25.45% 100.00% 5.136 25.72 48.32 79.18% 27.31% (6.48) 20.82% 100.00% 3.37% X 50.39 X (6.88) 16.05% 100.00% Liabilities and Equities: Short-term bank loans Accounts payable Accruals Current liabilities Long-term bank loans Mortgage Long-term delt Total liabilities Common stock Retained carnings Total cquity Total liabilities and equity 18.75% 20.57 7.54 46,86% X 2.41 5.67% 12.02 6.12 23.81% 11.90% 5.10 17.00% 40.80% 41.36% 17.84 59.20% 100.00% 7.11% 14.64 7.11 28.85% 13.99% 3.62 17.62% 46.47% 32.42% 21.11 53.53% 100.00% 59.59% 23.93% 40.41% 100.00% Note: Rounding dillerences occur in this table. TABLE4 Common-Size Income Statements for Years Ended December 31 1990 1991 1992 Nt sales Cost of gouds sold Gross profit Administrative and selling expenses Depreciation Miscellaneous expenses Total operating experises EBIT Interest on short-term loans Interest on long-term loans Interest on mortgage Total interest Beforc-tax carnings Taxes Net income Dividends on stock Additions to retained earnings 100.00% 80.52 19.48% 7.30% 0.91 1.16 9.36% 10.12% 0.18% 0.38 0.15 0.71 100.00% 82.18 17.826 8.11% 0.88 1.88 10.86% 6,956 0.30% 0.53 012 0.95% 6.00 2.40 3.60% 100.00% X 14.768 8.41% 2.85 2.28% 2.48% 010 1.51 0.96 0.58% 3.76 5.64% 1.419 4.23% 0.90% 2.70% 0.14% 0.43% TABLE 5 Statement of Cash Flows for Years Ended December 31 (in Thousands of Dollars) 1991 1992 $378,549 (2.728) $375.821 (311.110) (29,570) 7,484 3.314 ($329,882) $45.939 (30,690) (7.114) (9.088) ($953) $401,251 X $379.461 (342,016) (28,623) 18,984 X X X ($33,762) (11.450) (1,547) Cash Flow from Operations: Sales Increase in receivables Cash sales Cost of goods sold Increase in inventories Increase in accts payable Increase in accruals Cash cost of goods Cash margin Administrative and selling expenses Miscellaneous expenses Taxes Net Cash How from operations Cash Flow from Fixed Assel Investment: Investment in fixed assets Cash Flow from Financing Activities: Increase in short-term debt Increase in long-term debt Repayment of mortgage Interest expense Common dividends Net Cash Flow from financing activities Increase (decrease) in cash and marketable securities (54.561) ($5,409) S3.824 6,694 (536) (3,598) (3.408) $26.266 X (522) (6,076) (580) $2,976 $19,088 (S2.539) Historical and Pro Forma Ratio Analysis for Years Ended December 31 1990 1991 Pro Forma 1993 1994 Industry Average 1992 Liquidity Ratios: Current ratio Quick ratio 3.13 2.74 1.07 X X 2.50 1.00 1.65 0.72 Leverage Ratios: Debt ratio TIE coverage 40.80% 14.23 46,470 7.31 52.319 6.55 50.000 7.70 1.64 3.49 Asset Managment Ralios: Inventory turnover (cost) 7.09 Inventory turnover (sale) 8.81 Fixed asset turnover 12.24 Total asset tumover 3.12 Days sale outstanding (ACPy35.12 4.49 5.46 12.67 2.64 35.11 5.70 11.38 2.05 12.85 X 5.70 13.77 32.00 5.70 7.00 12.00) 52.68 32.00 Profilability Ratin: Prulit murgin Gross profil murgin Return on total assets ROF 5.645 19.485 17.58% 29.709 3,60% 17.82% 9.50% 17.746 0.58% 14.7645 X 2.950 X 17.508 5.905 20.00% 10.94% X 2.90 18.09 8.804 17.500 Other Ratio Altman Z score! Payout ratio 5.42 6.64 25.00% 4.75 25.00 25.00% 3.95 0.00% 4.65 20.00% Notes: a Uses cost of goods sold as the numerator 6. Uscs net sales is the numerator C. Assume a 30-day year d. Alman's function is calculators Z = 0.0128, +0.014X, +0.033X3 +0.005X +0.999X; Here, X = net working capitullotal ussels X = retained earningstal assets X3 = EBIT/total assets X, = market value of common and preferred stock book value of all debt X = sales total assets. The "Altman Z score" range of 1.81-2.99 represents the so-called "zone of ignorance." Note that the first four variables are expressed as percentages. Refer to Chapter 26 of Eugene F. Brigham and Louis C. Gapenski, Intermediate Pinuncia Munagement, iurih Edition (Fort Worth: Dryden Press, 1993), for details. e. Year-end balance sheet values were used throughout in the cuerputation of ralius embodying balance sheet items. 1. Assume constant industry average rutix throughout the period 1990 through 1994. QUESTIONS 1. Complete the 1992 columns of Tables 3 through 6, disregarding for now the projected data in the 1993 and 1994 columns. If you are using the Lotus model, use it to complete the tables. Be sure you understand all the numbers, as it would be most embarrassing and harm- ful to your career) if you were asked how you got a particular number, and you could not give a meaningful response. 2. Based on the information in the case and on the results of your calculations in Question 1, prepare a list of Garden State's strengths and weaknesses. In essence, you should look at the common-size statements and each group of key ratios (for example, the liquidity ratios) and see what those ratios indicate about the company's operations and financial condition. As a part of your answer, use the extended Du Pont equation to highlight the key relationships. 3. Recognizing that you might want to revise your opinion later, does it appear, based on your analysis to this point, that the bank should lend the requested money to Garden State? Explain 4. Now complete the tables to develop pro forma financial statements for 1993 and 1994. For these calculations, assume that the bank is willing to maintain the present credit lines and to grant an additional $12,750,000 of short-term credit on January 1, 1993. In the analysis, take account of the amounts of inventory and accounts receivable that would be carried if inven- tory utilization (based on the cost of goods sold) and days sales outstanding were set at industry-average levels. Also, assume in your forecast that all of Garden State's plans and predictions concerning sales and expenses materialize and that the firm pays no cash divi- dends during the forecast period. Finally, in your calculations use the cash and marketable securities account as the residual balancing figure. In responding to Questions 5 through 8, no Lotus model modifications are required. Answers should be based solely on the data contained in the financial statements developed in response to Question 4. 5. Assume Garden State has determined that its optimal cash balance is 5 percent of sales and that funds in excess of this amount will be invested in marketable securities which, on aver- age, will earn 7 percent interest. Based on your forecasted financial statements, will Garden State be able to invest in marketable securities in 1993 and 1994? If so, what is the amount of excess funds Garden State should invest in marketable securities? Do your financial fore- casts reveal any developing conditions that should be corrected? 6. Based on the forecasts developed earlier, would Garden State be able to retire all of the out- standing short-term loans by December 31, 1993? 7. If the bank decides to withdraw the entire line of credit and to demand immediate repayment of the two existing loans (the short-term and long-term loans) extended to Garden State, what alternatives would be available to Garden State? 8. Under what circumstances might the validity of comparative ratio analysis be questionable? Answer this question in general, not just for Garden State, but use Garden State data to illus- trate your points. 11. On the basis of your analyses, do you think Martha should recommend that the bank extend the existing short and long-term loans and grant the additional $12,750,000 loan or that the bank demand immediate repayment of all existing loans? If she does recommend continu- ing to support the company, what conditions (for example, collateral, guarantees, or other safeguards) might the bank impose to help protect against losses should Garden State's plans go awry