1 answer

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

2019 Bulance Sheet LSUS Corpuration Current liabilities Current assets S 44,461,550 6.123,200 $50,584,750 Cash and equivalents Accounts receivable $11,119,700 18,681,500 20,149,650 Accounts payable Accrued expenses Total current liabilities Inventory Other 1,172,200 $51,123,050 Total current assets Fixed assets Long-term debt Total long-term liabilities $169,260.000 $169,260,000 Property, plant, and equipment Less accumulated depreciation Net property, plant, and equipment Intangible assets and others Total fixed assets $457,509,600 (113,845,900) $343,663,700 Stockholders' equity 6,772,000 $350.435,700 S1,970,000 Preferred stock 37,583,700 Common stock 28,116,300 161.564,000 Capital surplus Accumulated retained earnings Less treasury stock Total equity Total liabilities and shareholders' equity (47.520,000) $181.714.000 $401,558.750 Total assets $401.558.750 LSUS Corporation Industry Ratios UPPER QUARTILE LOWER QUARTILE MEDIAN 86 1.51 Current ratio 1,97 43 75 127 Quick ratio 1.01 Total asset tumover I.10 146 12.18 10.25 14.38 Inventory turmover 16.43 Receivables turnover Debt ratio Debt equity ratio Equity multiplier Interest coverage Profit margin 17.65 22.43 32 56 61 83 13 213 N.21 1.44 I.83 244 5.72 10.83 5.02% 748u 9.05% 14.16 10679% 19329 7.05% Return on assels Return on equity 26.41% 14.06

Merpret 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. Recaleulate the ratios in the previous question. What do you observe?

1 answer
#####
A gas canister is rolling due west at 0.954 m/s along a floor when it exploded...

A gas canister is rolling due west at 0.954 m/s along a floor when it exploded into 3 pieces of equal mass. The first piece moved at 3.6 m/s, 20 degrees N of W. The second travels at 5.8 m/s 62 degrees S of W. Calculate the velocity of the third piece 14. A gas canister is rolling due west at 0...

1 answer
#####
Project 2: (Data fitting-interpolating) Write a code that uses Matlab to read the data form an...

Project 2: (Data fitting-interpolating) Write a code that uses Matlab to read the data form an excel file and try to fit the data to a polynomial of degree n, and then. Write down the analytical function that represent the data. Calculate the rms-error between the actual data and the fitted data. Pl...

1 answer
#####
Problem Set: Module Three ruckus sz 100 console port - Google Search is the domain the...

Problem Set: Module Three ruckus sz 100 console port - Google Search is the domain the yor - Google Search The cost in dollars of making 2 items is given by the function C(C) = 10x + 700. a. The fixed cost is determined when zero items are produced. Find the fixed cost for this item. Fixed cost = $ ...

1 answer
#####
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?...

1 answer
#####
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...

1 answer
#####
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...

1 answer
#####
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....

1 answer
#####
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...

1 answer
#####
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...

1 answer
#####
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 ...

1 answer
#####
**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) ...

1 answer
#####
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...

1 answer
#####
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....

1 answer
#####
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...

1 answer
#####
Expand 2 cos(24u) using a double angle identity in terms of sines.

Expand 2 cos(24u) using a double angle identity in terms of sines....

1 answer
#####
6. A 6.89-nC charge is located 1.65 m from a 4.22-nC point charge. (a) Find the...

6. A 6.89-nC charge is located 1.65 m from a 4.22-nC point charge. (a) Find the magnitude of the electrostatic force that one charge exerts on the other. N (b) Is the force attractive or repulsive? attractive/repulsive 6. -/2 points SerCP10 15.P.001 A 6.89-nC charge i...

1 answer
#####
What are three examples of proper units you could use to measure perimeter?

What are three examples of proper units you could use to measure perimeter?...

1 answer
#####
Write a function to return an average value of floats stored in a binary tree. In...

Write a function to return an average value of floats stored in a binary tree. In C...