Question

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%

earnings Choice 2: Ratios and Financial Planning After Hans analysis of LSUS corporation cash flow, Amanda, the CEO of the

2019 Bulance Sheet LSUS Corpuration Current liabilities Current assets S 44,461,550 6.123,200 $50,584,750 Cash and equivalent

Merpret this ratio? How does LSUS corporation compare to the industry average for this ratio? 4. Calculate the sustainable gr

0 0
Add a comment Improve this question Transcribed image text
Answer #1

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%

Add a comment
Know the answer?
Add Answer to:
Q4. Calculate the sustainable growth rate for LSUS corporation. Calculate external funds needed (EFN) and prepare...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • eamings $44,461,550 6.123.200 S 50,584,750 2019 Balance Sheet LSUS Corporation Current Assets Current liabilities Cash and...

    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),...

    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

    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...

    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...

    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...

    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...

    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...

    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 cu...

    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 cu...

    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...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT