Q4. 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?
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, LSUS 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 $ 87,531,900
Interest expense 11,000,900
EBT $ 76,531,000
Taxes 30,612,400
Net income $ 45,918,600
Dividends $ 17,374,500
Retained earnings $ 28,544,100
2019 Balance Sheet LSUS
Corporation Current assets Current liabilities
Cash and equivalents $ 11,119,700
Accounts payable $ 44,461,550
Accounts receivable 18,681,500
Accrued expenses 6,123,200
Inventory 20,149,650
Total current liabilities $ 50,584,750
Other 1,172,200
Total current assets $ 51,123,050
Fixed assets
Long-term debt $169,260,000
Property, plant, and equipment $457,509,600
Total long-term liabilities $169,260,000
Less accumulated depreciation (113,845,900)
Net property, plant, and equipment $343,663,700
Intangible assets and others 6,772,000
Stockholders’ equity Total fixed assets $350,435,700
Preferred stock $ 1,970,000
Common stock 37,583,700
Capital surplus 28,116,300
Accumulated retained earnings 161,564,000
Less treasury stock (47,520,000)
Total equity $181,714,000
Total assets $401,558,750
Total liabilities and shareholders’ equity $401,558,750
LSUS Corporation Industry Ratios LOWER QUARTILE MEDIAN UPPER QUARTILE Current ratio .86 1.51 1.97 Quick ratio .43 .75 1.01 Total asset turnover 1.10 1.27 1.46 Inventory turnover 12.18 14.38 16.43 Receivables turnover 10.25 17.65 22.43 Debt ratio .32 .56 .61 Debt–equity ratio .83 1.13 1.44 Equity multiplier 1.83 2.13 2.44 Interest coverage 5.72 8.21 10.83 Profit margin 5.02% 7.48% 9.05% Return on assets 7.05% 10.67% 14.16% Return on equity 14.06% 19.32% 26.41%
Sustainable growth rate (g) = Retention ratio (b) * Return on Equity (r)
Retention ratio = Retained earnings/Net Income = 28544100/45918600 = 62.16%
Return on equity = Net income/Average Stockholder's equity
where Average Stockholder's equity = (Stockholder's equity at the beginning + Stockholder's equity at the end)/2
Stockholder's equity at the end = $181,714,000
Stockholder's equity at the beginning = $181,714,000 - $28,544,100 = $153,169,900
Average Stockholder's equity = ($153,169,900+$181,714,000)/2 = $167,441,950
Return on equity = $45,918,600/$167,441,950 = 27.42%
Sustaianable growth rate (g) = 62.16% * 27.42% = 17.05%
Q4. Calculate the sustainable growth rate for LSUS corporation. Calculate external funds needed (EFN) and prepare...
eamings $44,461,550 6.123.200 S 50,584,750 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 $457,509,600 Total long-term liabilities Less accumulated depreciation (113,845,900) Net property, plant, and equipment $343,663,700 Intangible assets and others 6.772.000 Stockholders' equity Total fixed assets $350.435,700 Preferred stock Common stock Capital surplus Accumulated retained $169,260.000...
After Dan’s analysis of East Coast Yachts’ cash flow (at the end of our previous chapter), Larissa approached Dan about the company’s performance and future growth plans. First, Larissa wants to find out how East Coast Yachts 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, East Coast Yachts experienced difficulty in financing its growth plan, in large part because of poor planning. In fact,...
the third picture is the question the 2 first are the informations We were unable to transcribe this imageEAST COAST YACHTS 2010 Balance Sheet Current liabilities S 24,546,000 Current assets 11,232,000 Accounts payable Cash and equivalents Accounts receivable Inventories Other 0,208,000 Notes payable 22,656,000 Accrued expenses 6,185,000 S 49,456,000 184,000 Total current liabilities 55,280,000 $146,560,000 $146,560,000 Total current assets Long-term debt Fixed assets Total long-term liabilities $462,030,000 (114,996,000) Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment...
Ratio Sustainable Technologies Comparison to Industry Example: Current ratio .7418 Less than median. Quick ratio 0.3900 Less than the median Cash ratio 0.1496 Less than the median. Total asset turnover 2.014 Inventory turnover 27.34 More than the upper quartile More than the upper quartile More than the upper quartile Receivables turnover 54.915 0.7477 Less than the median Debt-to-equity ratio Equity multiplier 1.748 Less than the median Times interest earned 6.365 Less than the median Cash coverage 9.227 Less than the...
Calculate LEE Corp.’s external funds needed (EFN) for the fiscal year of 2019 using the pro forma statement approach. Assume that the percentages of sales for cost of goods sold, current assets and current liabilities remain unchanged at their respective values in 2018. In addition, the dividend payout ratio is assumed to remain unchanged. It is also assumed that the plant capacity of LEE Corporation was underutilized in 2018 such that existing fixed assets can support the 10% projected growth...
External Funds Needed The Optical Scan Company has forecast a 20 percent sales growth rate for next year. The current financial statements are shown here: 3.8 Statement of Comprehensive Income Sales Costs Taxable income Taxes Net income $30,400,000 26,720,000 $ 3,680,000 1,288,000 $ 2,392,000 Dividends Addition to retained earnings $ 956,800 1,435,200 Statement of Financial Position Assets Liabilities and shareholder's equity Current assets 7,200,000 Short-term debt Fixed assets 17,600,000 Long-term debt Common stock $6,400,000 4,800,000 $3,200,000 10,400,000 $13,600,000 $24.800,000 Accumulated...
Calculate the internal and sustainable growth rates Integrated mihi-case Working with Financial Juma Listed are the 2021 financial statements for Garners' Platoon Mental Health Care, Inc. Spread the balance sheet and income statement. Calculate the financial ratios for the firm, including the internal and sustainable growth rates. Using the DuPont system of analysis and the industry ratios reported, evaluate the performance of the firm. GARNERS' PLATOON MENTAL HEALTH CARE, INC. Balance Sheet as of December 31, 2021 (in millions of...
Using the financial statements for the Snider Corporation, calculate the 13 basic ratios found in the chapter. MARNI CORPORATION Balance Sheet December 31, 2018 Assets Current assets: Cash $50,000 Accounts receivable 100,000 Inventory 200,000 Total current assets $350,000 Net plant and equipment $650,000 Total assets $1,000,000 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $100,000 Accrued expenses 90,000 Total current liabilities $190,000 Long-term liabilities: Long-term debt: 250,000 Total liabilities $440,000 Stockholders' equity: Common stock 100,000 Capital paid in excess of...
13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The current financial statements are shown here: Income Statement Sales $25,380,000 Costs 21,635,000 $ 3,745,000 Taxable income 1,498,000 Taxes $ 2,247,000 Net income $ 786,450 Dividends Addition to retained earnings 1,460,550 Balance Sheet Liabilities and Owners' Equity Assets $ 5,200,000 Current assets $7,200,000 Short-term debt 6,000,000 Long-term debt Fixed assets 17,600,000 $ 3,200,000 Common stock 10,400,000 Accumulated retained earnings Total...
13. External Funds Needed The Optical Scam Company has forecast a sales growth rate of 15 percent for next year. The current financial statements are shown here: Income Statement Sales $25,380,000 Costs 21,635,000 $3,745,000 Taxable income Taxes 1,498,000 Net income $2247,000 Dividends $786,450 Addition to retained earnings 1,460,550 Balance Sheet Liabilities and Owners' Equity Assets $ 5,200,000 Current assets $7,200,000 Short-term debt 6,000,000 Long-term debt Fixed assets 17.600,000 $3,200,000 Common stock 10,400,000 Accumulated retained earnings Total equity $13,600,000 Total assets...