I need help with the statement of cash flow using the following template. Thank you in advance!

ACCOUNTING SOCIETY Templates for Part 1 follow: Statement of Cash Flow Template Please prepare a statement of Cash Flow as shown below using Excel. Input answers in the last column. After you answer all questions on Blackboard upload the Statement of Cash Flows, prepared in Excel, to Blackboard. Answers Pete's Patriotic Flags, Inc. Statement of Cash Flow For the Year Ended December 31, 2021 295, oso Cash Flows from Operating Activities Net Income Adjustments to reconcile net income to net cash flow from Operating activities Depreciation Amortization Gain or Loss Changes in current operating assets and liabilities Net Cash Flow from Operating Activities Cash Flows from Investing Activities Cash received from sale Less cash used for purchases Net Cash Flow from Investing Activities 6 Part ACCOUNTING SOCIETY Cash Flow from Financing Activities Cash received from Issuance of stock Less cash paid dividends or long-term debt Net Cash Flow from Financing Activities Increase or decrease in cash Cash at the beginning of the year Cash at the end of the year CO ACCOWTING OCTETY COMPARATIVE INCOME STATEMENT Pete's Patriotic Flags, Inc. Comparative Statement of income For the Years Ended December 31, 2021 and 2020 2021 2020 1.600,000 1.040.00 5560,000 940,000 693.000 5247,000 50,000 Sales Cost of Goods Sold Gross Margin Operating Expenses Salaries and Wages Expense Rent Expense Depreciation Expense Total Operating Expenses Income from Operations Loss on sale of Equipment Interest Expense increase Decrease in Operating income Income before Takes Federal income Taxes Net Income 80,000 20.000 22.000 $130,000 $430,000 1500 18.000 20,000 24,000 594,000 $153,000 421,500 12.50 $295,050 13,000 2020 150,000 145.000 $105,000 123 ACCOUNTING SOCIETY 2020 110,000 95.000 COMPARATIVE STATEMENT OF STOCKHOLDERS' EQUITY Pete's Patriotic Flags, Inc. Comparative Statement of Stockholders' Equity For the Years Ended December 31, 2021 and 2020 2021 Common Stock 365.000 Fietained Earnings, Beginning 190.000 of Year Net Income 295,050 Less Dividends Retained Earnings, End of Year $451,520 Total Stockholders' Equity $616,520 1. Equipment with a cost of $20,000 was sold for $9,500 cash. 2. Stock was issued for cash 3. The dividends were paid in cash. 4. The tax rate is 30% 105,000 20,000 $190,000 $300,000 ACCOUNTING SOCIETY COMPRATIVE BALANCE SHEET Pete's Patriotic Flass, Inc Comparative Balance Sheet December 31, 2021and 2020 2021 2020 Assets CA Carth Asunt cele mai Merchandise inventory Print Total Current Assets 166,520 16000 130,000 20.00 $726.520 90,000 170.000 70,000 $180,000 Property. Plant, and Time Cam Les Accumulated Depreciation.timent Tot plant and met Total Assets 790,000 1000 $180.000 5905.520 260,000 140.0001 $220.000 9400.000 10 PA ACCOUNTING OCTETY 2021 2020 90,000 55,000 Bobines and Sociers' Equity Grenlab Accounts Payable Didien Page Uneaed Rever iespai Federal Income Taxes Payable Current sites 20,000 70.000 30.000 5210,000 80,000 50,000 15.000 $200,000 Los Temables Hond Payable 100,000 20,000 50.000 $290,000 Total Liabilities $300,000 Stockholders Cavity Coco Sox S10 Pa Paid in Capital in Excess of Par Hendamine Total Stockholders' Equity Totabilities and Stockholders' Equity 550,000 15,000 457529 $616,520 $906,520 100,000 10.000 . $300,000 $600,000