# Q4. Calculate the sustainable growth rate for LSUS corporation. Calculate external funds needed (EFN) and prepare...

###### 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 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 Selling, general, and administrative Depreciation 431,006,000 73.085,700 19.958.400 ЕВIT $87.531,900 Interest expense 11.000,900 S 76,531,000 ЕBT 30.612 400 Таxes Net income S 45,918,600$ 17,374.500 S 28.544.100 Dividends Retained earnings
##### RS w RE R3 VI WW R7 For the circuit in the figure above, Vi=12 V.R,...
RS w RE R3 VI WW R7 For the circuit in the figure above, Vi=12 V.R, -50. Ry -100, R, -8 0, R=20 R\$ - 3. R-70 and Ry -90. What are the currents through and potentials across each of the resistors?...
##### All answers are numbers which consist only of the digits 0 to 9. Symbols or punctuation marks should NOT be incorporated in answers Every cell must be completed Complete the following bank reconcilia...
All answers are numbers which consist only of the digits 0 to 9. Symbols or punctuation marks should NOT be incorporated in answers Every cell must be completed Complete the following bank reconciliation and one journal entry to take up all relevant adjustments. The Cash at Bank account in the Gener...
##### 3m Susand a) A block with a mass of 10.0 kg is AS released from rest...
3m Susand a) A block with a mass of 10.0 kg is AS released from rest at the top of an 1 00.kg inclined track (0 = 30°), at point A, 3.0m above the horizontal (see the figure). The track A to B has a coefficient of kinetic friction of 0.10. The horizontal portion of the track, B to C, is 4.Om lon...
##### Discuss one tool that has been developed to mitigate foreign exchange rate fluctuation and instability.
Discuss one tool that has been developed to mitigate foreign exchange rate fluctuation and instability....
##### I need proof of this numerical analysis theorem. This theorem is from Burden's Numerical analysis book....
I need proof of this numerical analysis theorem. This theorem is from Burden's Numerical analysis book. Please give me the detailed solution of this theorem. Theorem If {00, ... , ºn} is an orthogonal set of functions on an interval [a, b] with respect to the weight function w, then the lea...
##### 24-19 24.3. Exercises 317 : 24.19. Suppose a density fx(2) increases linearly from (16,0) to Exercise...
24-19 24.3. Exercises 317 : 24.19. Suppose a density fx(2) increases linearly from (16,0) to Exercise 24.1 (24,1/4). a. Find the CDF of X. What is the value of a so that PCX al = 0.752...
##### Assignment Score: 0.00 Save Submit Assignment for Grading si2nc15h ch09.02 Question of 5 is released from...
Assignment Score: 0.00 Save Submit Assignment for Grading si2nc15h ch09.02 Question of 5 is released from fat cells and helps to create the feeling of satiety and Select produced in the stomach, is the hunger-stimulating hormone. Conversely, Select suppresses appetite. Question 2015 0 Icon Key Sunt ...
##### **Please Do Not Forget The Visual Representation. Thank you!!** Problem Statement Light strikes a 5.0-cm thick...
**Please Do Not Forget The Visual Representation. Thank you!!** Problem Statement Light strikes a 5.0-cm thick sheet of glass at an angle of incidence in air of 50°. The sheet has parallel faces and the glass has an index of refraction 1.50. (a) What is the angle of refraction in the glass? (b) ...
##### An annual marathon covers a route that has a distance of approximately 26 miles. Winning times...
An annual marathon covers a route that has a distance of approximately 26 miles. Winning times for this marathon are all over 2 hours. The following data are the minutes over 2 hours for the winning male runners over two perlods of 20 years each Larlier Period 14 14 7 13 17 13 13 18 12 19 12 16 10 2...
##### How have risk management concepts influenced the health care industry? Provide an example.
How have risk management concepts influenced the health care industry? Provide an example....
##### Arbitra Inc.'s current capital structure is 30% debt and 70% equity. The expected return on its...
Arbitra Inc.'s current capital structure is 30% debt and 70% equity. The expected return on its debt is 5%, its equity Beta is 1.1. The riskfree rate is 2%, and the expected return on the market is 10%. Consider now the following additional information. The government of Bigland, where Arbitra I...