Cash Flow
Below is an example of what I am looking for
A B D E F G H I J K L Cash Cash Received Paid Interest Interest Received Paid Inc Tax Financing Investing Depreciation Paid 2020 4,043 3,093 8,211 9,797 34 210 8,730 144,131 94,722 132,446 115,137 140,525 2021 4,505 4,660 10,379 13,108 51 381 10,170 149,744 103,267 180,027 83,154 116,238 1 Balance Sheet 2 Cash Flow 4 3 December 31, 2021 , 4 5 Cash 6 Accounts receivable 7 Inventory 8 Investments 9 Interest receivable 10 Prepaid expenses 11 Land 12 Buildings 13 Equipment 14 Accumulated derpreciation 15 Net fixed assets 16 Total assets 17 18 Accounts payable 19 Accrued expenses 20 Interest payable 21 Line of credit 22 Notes payable 23 Total liabilities 24 Common stock 25 Additional paid in capital 26 Retained earnings 27 Total shareholders' equity 28 Total liabilities and shareholders' equity 29 30 Income Statement 31 Cash Flow 4 32 For the Year Ended December 31, 2021 , 33 34 Sales 35 Cost of goods sold 36 Gross profit 37 Selling expenses 38 Administrative expenses 39 Depreciation 40 Interest revenue 41 Interest expense 42 Net income before tax 43 Income tax benefit 44 Net income 45 46 47 Proceeds from the sale of fixed assets 15,683 2,122 663 14,695 75,798 108,961 485 6,003 25,076 31,564 140,525 19,490 3,515 471 23,294 79,810 126,580 678 7,446 (18,466) (10,342) 116,238 403,891 339,173 64,718 25,692 14,429 52,616 (1,066) 4,239 (31,192) (8,740) (22,452) 26,300 Sheet1 + + Cash Cash Received 4,000 Cash Paid Cash Flows Dividends Interest Received Received Interest Paid IT tax Paid Financing Investing Depreciation 4,000 30,500 (30,500) 8,000 (8,000) 750 (750) 1,000 6,000 (1,000) (6,000) (1,200) 1,200 9,000 22,000 9,000 22,000 4,000 4,000 2,500 2,500 Cash Accounts Receivable Inventory Prepaid expenses Investments Equipment Accumulated depreciation Accounts payable Notes payable Income taxes payable Common stock Additional paid in capital Retained earnings Sales Dividend revenue Interest revenue Cost of goods sold Salary expense Depreciation expense Insurance expense Interest expense 7,500 7,500 43,000 43,000 200 200 100 100 17,000 7,000 (17,000) (7,000) 1,200 (1,200) 2,250 (2,250) 300 (300) Cash Flows (5,500) Other expense 5,500 Income tax expense Dividends (4,000) 4,000 2,000 88,300 | 88,300 4,000 12,500 (31,500) 200 (2,000) 30,000 100 (300) - (7,000) 2019 Interest Received Interest Paid Taxes Financing Investing Paid Depreciation Difference Cash Cash Cash Received | Paid 1,106 1,106 (642) (642) 1,106 642 464 (153) (48) Sales, Boats and Supplies Cost of goods sold Gross margin Expenses Depreciation Interest Bad debt expense Other expenses Total expenses Ordinary income Loss from the sale of fixed assets Net income before taxes Income tax expense Net income (153) (48) (12) (131) (12) (131) 153 48 12 131 344 120 10 110 48 62 (10) (10) (48) (48) (62) (62) 50 50 1,089 (741) (46) (41) (142) (49) (20)
