Please fill out this excel sheet and show your work in excel

Sales Growth COGSGrowth SG\&A Growth Dther Costs Growth PP\&E Purchases at beginning of the year Same depreciation for existing assets as 2023 . New assets depreciates straight line in years Corporate tan rate Interest rate on Long-Term Debt Payout ratio New Debt issuance Account ReceivablesiSales InventoryicDGS Account PayablesiCDGS Fill in the shaded cell referencing all your calculations to precedent cells Cash Flow Statement CASH FROM OPERATING Net Income Depreciation Cash From Acoounts Receivable Cash From Inventory Cash From Acoounts Payable Subtotal CASH FROM INVESTING Capital Expenditure Subtotal CASH FROM FINANCING Change in Long-Term Debt Change in Common Equity Dividends Subtotal NET CHANGE IN CASH CASH BALANCE Beginning of the Year Increase l( Decrease) End of the Year Balance Sheet ASSETS Cash Acoounts Receivable Inventories Total Current Assets Property Plant \& Equipment TotalAssets LIABILITIES Accounts Payable Total Current Liabilities Long-Term Debt EQUITY Common Equity RetainedEarnings Tota/Liabilies \& Equity Check B 1 C D E F G H I J k L M N 12 66 67 68 69 7170 7271 72 73 7473 \begin{tabular}{l} 74 \\ \hline 75 \\ \hline \end{tabular} 76 77 7978 80 81 82 83 85 \begin{tabular}{l} 86 \\ \hline 87 \end{tabular} 8887 89 90 91 92 93 \begin{tabular}{l} 94 \\ \hline 95 \end{tabular} 95 96 97 Existing assets depreciation New assets depreciation Total assets depreciation PP\&E Schedule Net PP\&E at the beginning of the year Asset purchases Depreciation Net PP\&E at the end of the year Debt and Insterest Schedule Debt at the beginnig of the year New debt (Payments) Debt at the end of the year Interests on debt Net Working Capital Schedu Account Receivables Changes in Acoounts Receivables Inventory Changes in Inventory Account Payables Changes in Accounts Payables