Need help answering the question with attached info.

Calculating internal growth ( attached info) for questions below:

Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 30 percent dividend payout ratio. What is the internal growth rate?

Chapter 4 Problems 5, 6, 20, 22 Input boxes in tan Output boxes in yellow Given data in blue Calculations in red Answers in green NOTE: Some functions used in these spreadsheets may require that the "Analysis ToolPak" or "Solver Add-In" be installed in Excel. To install these, click on the Office button then "Excel Options," "Add-Ins" and select "Go." Check "Analyis ToolPak" and "Solver Add-In," then click "OK." ets may require that nstalled in Excel. Chapter 4 Question 6 Input area: Sales Costs Taxable income Taxes Net income Payout ratio Tax rate $ $ $ 16,000 10,400 5,800 2,320 3,480 30% 40% Output area: Return on assets Retention ratio Internal growth rate 9.51% 70% 7.13% Current assets Fixed assets Total $ $ 10,100 Debt 26,500 Equity 36,600 Total $ $ 16,400 20,200 36,600 Calculating Internal Growth [LO3] The most recent financial statements for Schenkel Co. are shown here: Assets and costs are proportional to sales. Debt and equity are not. The company maintains a constant 30 percent dividend payout ratio. What is the internal growth rate