Fill out the cells on this worksheet then create a Cash Flow Statement with a reconciliation of net income to net cash flows from operating activities.

C N O P Q R S U V W X Y Z AA AB D E F G Cash Cash Difference Cash Received Paid J K L M Interest Interest Income Received Paid Tax Paid Financing Investing Depreciation 1,917 194 944 1,872 1,367 532 17 1,883 894 5,915 1,098 1,277 16 524 14 70 2.999 B 1 2 3 Cash 157 4 Accounts Receivable 486 5 Inventory 6 Investments 1,200 7 Prepaid expenses 55 8 Interest receivable 16 9 Fixed assets 1,489 10 Accumulated depreciation 657 11 Total assets 4,663 12 13 Accounts payable 697 14 Line of credit 1,000 15 Income taxes payable 27 16 Payroll taxes and fringes 216 17 Interest payable 11 18 Long term debt 489 19 Total liabilities 2,440 20 21 Common stock 100 22 Additional paid in capital 586 23 Retained earnings 1,537 24 Total equity 2,223 25 Total liabilities and equity 4,663 26 27 Sales 28 Cost of goods sold 29 Gross profit 30 Interest revenue 31 Interest expense 32 Depreciation 33 Bad debts 34 Other expenses 35 Net income before tax 36 Income tax 37 Net income 38 39 Proceeds from the sale of fixed assets 40 115 772 2,029 2916 5,915 5315 3119 2,196 94 71 452 48 904 815 145 670 228 C N O P Q R S U V W X Y Z AA AB D E F G Cash Cash Difference Cash Received Paid J K L M Interest Interest Income Received Paid Tax Paid Financing Investing Depreciation 1,917 194 944 1,872 1,367 532 17 1,883 894 5,915 1,098 1,277 16 524 14 70 2.999 B 1 2 3 Cash 157 4 Accounts Receivable 486 5 Inventory 6 Investments 1,200 7 Prepaid expenses 55 8 Interest receivable 16 9 Fixed assets 1,489 10 Accumulated depreciation 657 11 Total assets 4,663 12 13 Accounts payable 697 14 Line of credit 1,000 15 Income taxes payable 27 16 Payroll taxes and fringes 216 17 Interest payable 11 18 Long term debt 489 19 Total liabilities 2,440 20 21 Common stock 100 22 Additional paid in capital 586 23 Retained earnings 1,537 24 Total equity 2,223 25 Total liabilities and equity 4,663 26 27 Sales 28 Cost of goods sold 29 Gross profit 30 Interest revenue 31 Interest expense 32 Depreciation 33 Bad debts 34 Other expenses 35 Net income before tax 36 Income tax 37 Net income 38 39 Proceeds from the sale of fixed assets 40 115 772 2,029 2916 5,915 5315 3119 2,196 94 71 452 48 904 815 145 670 228