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 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
Get step-by-step solutions from verified subject matter experts
