Answer the following questions based off of the excel provided...

$1.$What is the forecast dollar amount of sales for the $2020$ operating year?

$2.$Based on the $2019$ financial information, what is the firm$$s internal growth rate?

$3.$What dollar amount of account receivable will the firm be holding at the end of $2020?$

$4.$In the first iteration $($first forecast$),$ what is the dollar amount of AFN?

$5.$What is the forecast balance of retained earnings in the first iteration?

$6.$In the second iteration $($projection$),$ what is dollar amount of additional common stock funding?

$7.$In the second iteration of the forecast, what is the dollar amount of dividends $($total$).$

$8.$In the final solution $($last iteration$),$ what is the dollar amount of total assets?

$9.$What is the total amount of new Line of Credit funding in the final solution?

$10.$In the final solution, what is the total amount of dividends paid?

$11.$In the final solution what is the balance of retained earnings?

$12.$How much new funding from all sources will the firm have at the end of $2020?($Hint: Do accruals provide funding to the firm?$)$

$13.$How many sets of completed pro forma financial statements are contained in your solution spreadsheet for this project? $($Hint: A balance sheet must balance.$)$