Please include the excel formulas in the answer so I know how to do it! :))

this is all the info i was given to complete the table

A. B C D E F F H 1 Aescta: b. Thw compowy did not purthate ary equipment or imeatmesce during the year 4. The esmpany did not eall ary land theing the vear. id The conpewy did not tane out wy addidonul iowne dering the pear, Based on the financial statements below, complete amounts in the the statement of cash flow Enter amounts in columns S, T, and U. Make no entries in gray cells. You will not need entrie: o. The condisy del fee awi ary tand dowd the ytw at log4cos2c Moms Compery income staremint Based on the financial statements below, complete amounts in the the statement Enter amounts in columns S, T, and U. Make no entries in gray cells You will not Cument assets Cash Accounts receivable Merchandise inventor Prepaid insurance Long-term assets Investment in stock Equipment Accumulated deprecia thand Total assets Curront llabilites ifccounts payable Wages payable SCash dividends payabl Long-term llablities Note payable NOTES: a. All investing and financin b. The company did not pur c. The company did not sell d. The company did not takt plete amounts in the the statement of cash flows. to entries in gray cells. You will not need entries in all the white cells; use only those needed. Incl a. All investing and financing activities were for cash. b. The company did not purchase any equipment or investments during the year. Cash at the beginning c. The company did not seil any land during the year d. The company did not take out any additional loans during the year. nly those needed. Include relevant subtotals. A. B C D E F F H 1 Aescta: b. Thw compowy did not purthate ary equipment or imeatmesce during the year 4. The esmpany did not eall ary land theing the vear. id The conpewy did not tane out wy addidonul iowne dering the pear, Based on the financial statements below, complete amounts in the the statement of cash flow Enter amounts in columns S, T, and U. Make no entries in gray cells. You will not need entrie: o. The condisy del fee awi ary tand dowd the ytw at log4cos2c Moms Compery income staremint Based on the financial statements below, complete amounts in the the statement Enter amounts in columns S, T, and U. Make no entries in gray cells You will not Cument assets Cash Accounts receivable Merchandise inventor Prepaid insurance Long-term assets Investment in stock Equipment Accumulated deprecia thand Total assets Curront llabilites ifccounts payable Wages payable SCash dividends payabl Long-term llablities Note payable NOTES: a. All investing and financin b. The company did not pur c. The company did not sell d. The company did not takt plete amounts in the the statement of cash flows. to entries in gray cells. You will not need entries in all the white cells; use only those needed. Incl a. All investing and financing activities were for cash. b. The company did not purchase any equipment or investments during the year. Cash at the beginning c. The company did not seil any land during the year d. The company did not take out any additional loans during the year. nly those needed. Include relevant subtotals