question 6

Choice 2: Ratios and Financial Planning After Han's analysis of LSUS corporation' cash flow, Amanda, the CEO of the company, approached Han about the company's performance and future growth plans. First, Amanda wants to find out how LSUS corporation is performing relative to its peers. Additionally, she wants to find out the future financing necessary to fund the company's growth. In the past, corporation experienced difficulty in financing its growth plan, in large part because of poor planning. In fact, the company had to turn down several large jobs because its facilities were unable to handle the additional demand. Amanda hoped that Han would be able to estimate the amount of capital the company would have to raise next year so that LSUS corporation would be better prepared to fund its expansion plans. To get Han started with his analyses, Amanda provided the following financial statements. Han then gathered the industry ratios for the LSUS Corporation industry. 2019 Income Statement LSUS Corporation Sales $611,582.000 Cost of goods sold 431,006,000 Selling, general, and administrative 73.085.700 Depreciation 19.958.400 EBIT S 87,531,900 Interest expense 11.000,900 S 76,531.000 Taxes 30.612.400 Net income S 45.918.600 Dividends $ 17.374.500 Retained earnings S28.544 100 EBT $ 44,461,550 6.123.200 S 50,584,750 $169,260,000 $169,260,000 2019 Balance Sheet LSUS Corporation Current assets Current liabilities Cash and equivalents $ 11,119,700 Accounts payable Accounts receivable 18,681,500 Accrued expenses Inventory 20,149,650 Total current liabilities Other 1,172,200 Total current assets $ 51,123,050 Fixed assets Long-term debt Property, plant, and equipment 5457,509,600 Total long-term liabilities Less accumulated depreciation (113.845.900) Net property, plant, and equipment $343663,700 Intangible assets and others 6,772,000 Stockholders' equity Total fixed assets $350,435,700 Preferred stock Common stock Capital surplus Accumulated retained 64 140 - Less treasury stock Total equity Total assets S401.558.750 Total liabilities and shareholders' equity 5 1.970,000 37,583.700 28,116,300 161,564,000 (47.520,000) $181.714.000 $401.558.750 LSUS Corporation Industry Ratios LOWER QUARTILE MEDIAN 36 151 UPPER QUARTILE 1.10 12 10.25 12 1.27 1438 17.65 1.46 1643 221 Current ratio Quick ratio Total asset turnover Inventory turnover Receivables turnover Debt ratio Debi equity ratio Equity multiplier Interest Coverage Profit margin Return on acts Return on equity 113 114 14 LX 3.72 502 102 70 7.4 . 10.07 19.329 14 16 14.069 Uwauslase%201%20Analysis%20(2).pdf * Ind Before examining the case questions below, research on how the corporate financial policies could affect corporate outcomes such as profits, risks etc. Use proper references. 1. LSUS corporation uses a small percentage of preferred stock as a source of financing. In calculating the ratios for the company, should preferred stock be included as part of the company's total equity? 2. Calculate all of the ratios listed in the industry table for LSUS corporation 3. Compare the performance of LSUS corporation to the industry as a whole. For each ratio, comment on why it might be viewed as positive or negative relative to the industry, Suppose you create an inventory ratio calculated as inventory divided by current liabilities. How would you interpret this ratio? How does LSUS corporation compare to the industry average for this ratio? 4. Calculate the sustainable growth rate for LSUS corporation. Calculate external funds needed (EFN) and prepare pro forma income statements and balance sheets assuming growth at precisely this rate. Recalculate the ratios in the previous question. What do you observe? 5. As a practical matter, LSUS corporation is unlikely to be willing to raise external equity capital, in part because the shareholders don't want to dilute their existing ownership and control positions. However, LSUS corporation is planning for a growth rate of 20 percent next year. What are your conclusions and recommendations about the feasibility of LSUS corporation's expansion plans? 6. Most assets can be increased as a percentage of sales. For instance, cash can be increased by any amount. However, fixed assets often must be increased in specific amounts since it is impossible, as a practical matter, to buy part of a new plant or machine. In this case, a company has a "staircase" or "lumpy" fixed cost structure. Assume that the LSUS corporation is currently producing at 100 percent of capacity and sales are expected to grow at 20 percent. As a result, to expand production, the company must set up an entirely new line at a cost of 895,000,000. Prepare the pro forma income statement and balance sheet. What is the new EFN with these assumptions? What does this imply about capacity utilization for LSUS corporation next year? Choice 2: Ratios and Financial Planning After Han's analysis of LSUS corporation' cash flow, Amanda, the CEO of the company, approached Han about the company's performance and future growth plans. First, Amanda wants to find out how LSUS corporation is performing relative to its peers. Additionally, she wants to find out the future financing necessary to fund the company's growth. In the past, corporation experienced difficulty in financing its growth plan, in large part because of poor planning. In fact, the company had to turn down several large jobs because its facilities were unable to handle the additional demand. Amanda hoped that Han would be able to estimate the amount of capital the company would have to raise next year so that LSUS corporation would be better prepared to fund its expansion plans. To get Han started with his analyses, Amanda provided the following financial statements. Han then gathered the industry ratios for the LSUS Corporation industry. 2019 Income Statement LSUS Corporation Sales $611,582.000 Cost of goods sold 431,006,000 Selling, general, and administrative 73.085.700 Depreciation 19.958.400 EBIT S 87,531,900 Interest expense 11.000,900 S 76,531.000 Taxes 30.612.400 Net income S 45.918.600 Dividends $ 17.374.500 Retained earnings S28.544 100 EBT $ 44,461,550 6.123.200 S 50,584,750 $169,260,000 $169,260,000 2019 Balance Sheet LSUS Corporation Current assets Current liabilities Cash and equivalents $ 11,119,700 Accounts payable Accounts receivable 18,681,500 Accrued expenses Inventory 20,149,650 Total current liabilities Other 1,172,200 Total current assets $ 51,123,050 Fixed assets Long-term debt Property, plant, and equipment 5457,509,600 Total long-term liabilities Less accumulated depreciation (113.845.900) Net property, plant, and equipment $343663,700 Intangible assets and others 6,772,000 Stockholders' equity Total fixed assets $350,435,700 Preferred stock Common stock Capital surplus Accumulated retained 64 140 - Less treasury stock Total equity Total assets S401.558.750 Total liabilities and shareholders' equity 5 1.970,000 37,583.700 28,116,300 161,564,000 (47.520,000) $181.714.000 $401.558.750 LSUS Corporation Industry Ratios LOWER QUARTILE MEDIAN 36 151 UPPER QUARTILE 1.10 12 10.25 12 1.27 1438 17.65 1.46 1643 221 Current ratio Quick ratio Total asset turnover Inventory turnover Receivables turnover Debt ratio Debi equity ratio Equity multiplier Interest Coverage Profit margin Return on acts Return on equity 113 114 14 LX 3.72 502 102 70 7.4 . 10.07 19.329 14 16 14.069 Uwauslase%201%20Analysis%20(2).pdf * Ind Before examining the case questions below, research on how the corporate financial policies could affect corporate outcomes such as profits, risks etc. Use proper references. 1. LSUS corporation uses a small percentage of preferred stock as a source of financing. In calculating the ratios for the company, should preferred stock be included as part of the company's total equity? 2. Calculate all of the ratios listed in the industry table for LSUS corporation 3. Compare the performance of LSUS corporation to the industry as a whole. For each ratio, comment on why it might be viewed as positive or negative relative to the industry, Suppose you create an inventory ratio calculated as inventory divided by current liabilities. How would you interpret this ratio? How does LSUS corporation compare to the industry average for this ratio? 4. Calculate the sustainable growth rate for LSUS corporation. Calculate external funds needed (EFN) and prepare pro forma income statements and balance sheets assuming growth at precisely this rate. Recalculate the ratios in the previous question. What do you observe? 5. As a practical matter, LSUS corporation is unlikely to be willing to raise external equity capital, in part because the shareholders don't want to dilute their existing ownership and control positions. However, LSUS corporation is planning for a growth rate of 20 percent next year. What are your conclusions and recommendations about the feasibility of LSUS corporation's expansion plans? 6. Most assets can be increased as a percentage of sales. For instance, cash can be increased by any amount. However, fixed assets often must be increased in specific amounts since it is impossible, as a practical matter, to buy part of a new plant or machine. In this case, a company has a "staircase" or "lumpy" fixed cost structure. Assume that the LSUS corporation is currently producing at 100 percent of capacity and sales are expected to grow at 20 percent. As a result, to expand production, the company must set up an entirely new line at a cost of 895,000,000. Prepare the pro forma income statement and balance sheet. What is the new EFN with these assumptions? What does this imply about capacity utilization for LSUS corporation next year