Question: Please solve parts a and b using excel. Thank you. The financial statements of Eagle Sport Supply are shown in the table below. For simplicity,

 Please solve parts a and b using excel. Thank you. The

Please solve parts a and b using excel. Thank you.

financial statements of Eagle Sport Supply are shown in the table below.

The financial statements of Eagle Sport Supply are shown in the table below. For simplicity, "Costs" include interest. Assume that Eagle's assets are proportional to its sales. Assume a growth rate of 20% in revenue, expenses, and assets in 2020. The tax rate will remain constant. Income Statement Sales $1, 150 Costa 350 Pretax income 800 Taxes (at 30.08) 240 Net income 560 Balance Sheet, Year-End 2019 2018 2019 2018 Net assets $3, 200 $2,900 Debt $ 1, 100 $1,000 Equity 2, 100 1,900 Total $ 3, 200 $ 2,900 Total $ 3, 200 $2,900 a. Assume that the dividend payout ratio is fixed at 50% and the equity-to-asset ratio is fixed. What is the internal growth rate for 2020? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) nternal growth rate b. What is the sustainable growth rate for 2020? (Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places.) Sustainable growth rate

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!