Hello, this is for BA 313 Financial Management and I would appreciate any help with solving these. I tried a couple of times but was not getting the correct AFN, directions instead of just answers would be greatly appreciated. Thank you in advance!

PROBLEM 6-10 WHITE \& PINKMAN CORPORATION Forecasting Assumptions: Sales growth 20% given Cost of Goods Sold 17 Selling \& Admin Expenses 18 Cash These items are projected to remain the same percentage of 19 Marketable Securities sales in 2022 as they were in 2021 . That is the same as saying 20 Accounts Receivable that in 2022 the items will grow at the same rate as sales. 21 Inventory 22 Prepaid Expenses 23 Accounts Payable 24 Accrued Expenses 25 26 Depreciation Expense 27 Interest Expense 28 Gross Plant \& Equipment These items are projected to remain the same 29 Notes Payable value in 2022 as they were in 2021. 30 Long-Term Debt 31 Common Stock 32 Capital in Excess of Par Tax rate 40% Dividends: pay same dollar amount in 2022 as in 2021 Bad Debt Allowance 17% of accounts receivable 39 Ready { i? Accessibility: Unavailable Student instructions: This worksheet is for problem 610. The problem begins with the forecasting assumptions on the previous tab. This tab contains Bright Future's financial statements and the pro forma forecast (Question 1), and Question 2a. Enter formulas in column C to complete the pro forma forecast for the year 2010. For Question 2a, incorporate Additonal Funds Needed (AFN) or Excess Financing into the balance sheet forecast in column D where Question 4, Recommendations: Recommendations: PROBLEM 6-10 WHITE \& PINKMAN CORPORATION Forecasting Assumptions: Sales growth 20% given Cost of Goods Sold 17 Selling \& Admin Expenses 18 Cash These items are projected to remain the same percentage of 19 Marketable Securities sales in 2022 as they were in 2021 . That is the same as saying 20 Accounts Receivable that in 2022 the items will grow at the same rate as sales. 21 Inventory 22 Prepaid Expenses 23 Accounts Payable 24 Accrued Expenses 25 26 Depreciation Expense 27 Interest Expense 28 Gross Plant \& Equipment These items are projected to remain the same 29 Notes Payable value in 2022 as they were in 2021. 30 Long-Term Debt 31 Common Stock 32 Capital in Excess of Par Tax rate 40% Dividends: pay same dollar amount in 2022 as in 2021 Bad Debt Allowance 17% of accounts receivable 39 Ready { i? Accessibility: Unavailable Student instructions: This worksheet is for problem 610. The problem begins with the forecasting assumptions on the previous tab. This tab contains Bright Future's financial statements and the pro forma forecast (Question 1), and Question 2a. Enter formulas in column C to complete the pro forma forecast for the year 2010. For Question 2a, incorporate Additonal Funds Needed (AFN) or Excess Financing into the balance sheet forecast in column D where Question 4, Recommendations: Recommendations