I am having issues with the balance sheet.

PROBLEM 6-10 WHITE \& PINKMAN CORPORATION Forecasting Assumptions: Sales growth 20% given Cost of Goods Sold Selling \& Admin Expenses \begin{tabular}{l|l|} \hline Cash & These items are projected to remain the same \\ Marketable Securities \\ icentage of sales in 2022 as they were in 2021. That \\ Accounts Receivable the same as saying that in 2022 the items will grow \\ Inventory \\ Prepaid Expenses \\ Accounts Payable \\ Accrued Expenses \\ Acthe rate as sales. \\ \hline \end{tabular} Depreciation Expense Interest Expense Gross Plant \& Equipment These items are projected to remain the Notes Payable same value in 2022 as they were in 2021 . Long-Term Debt Common Stock 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 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 indicated (Note: You may disdregard any additional interest expense associated with the new debt). Finally, proceed to the next tab to answer the remaining items in Question 2. YHITE Historical and Projected Income Statements YHITE \& PINKMAN CORPORATION Historical and Projected Balance Sheets PROBLEM 6-10 WHITE \& PINKMAN CORPORATION Forecasting Assumptions: Sales growth 20% given Cost of Goods Sold Selling \& Admin Expenses \begin{tabular}{l|l|} \hline Cash & These items are projected to remain the same \\ Marketable Securities \\ icentage of sales in 2022 as they were in 2021. That \\ Accounts Receivable the same as saying that in 2022 the items will grow \\ Inventory \\ Prepaid Expenses \\ Accounts Payable \\ Accrued Expenses \\ Acthe rate as sales. \\ \hline \end{tabular} Depreciation Expense Interest Expense Gross Plant \& Equipment These items are projected to remain the Notes Payable same value in 2022 as they were in 2021 . Long-Term Debt Common Stock 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 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 indicated (Note: You may disdregard any additional interest expense associated with the new debt). Finally, proceed to the next tab to answer the remaining items in Question 2. YHITE Historical and Projected Income Statements YHITE \& PINKMAN CORPORATION Historical and Projected Balance Sheets