HELP WITH EXTERNAL FINANCING PLEASE

The $2022$ financial statements for Growth Industries are presented below. Sales and costs are projected to grow at $20\%$ a year for at

least the next $4$ years. Both current assets and accounts payable are projected to rise in proportion to sales. The firm is currently

operating at full capacity, so it plans to increase fixed assets in proportion to sales. Interest expense will equal $10\%$ of long$-$term debt

outstanding at the start of the year. The firm will maintain a dividend payout ratio of $0\mathrm{.}60.$

Required:

Construct a spreadsheet model for Growth Industries similar to the one in Spreadsheet $18\mathrm{.}1.$

a$.$ How much external capital will the company require in $2026?$

b$.$ What will be the company's debt ratio at the end of $2026?$

Assessment Tool iFrame

a$.$ How much external capital will the company require in $2026?$

Note: Enter your answers in whole dollars.

b$.$ What will be the company's debt ratio at the end of $2026?$

Note: Round intermediate values to $1$ decimal place. Round your answer to $2$ decimal places.

Show less