in the first picture it days to complete the cash flow worksheet

Chapter 16 Serial Problem - Excel FILE DATA REVIEW VIEW NITRO PRO Wrap Text General Normal 2 - Paste HOME INSERT PAGE LAYOUT FORMULAS * Cut Calibri 11 A A Copy Format Painter BIU-1A Clipboard Normal Check Cell te Merge & Center - $ % & Conditional Format as Calculation Formatting Table Font Alignment Number Styles A11 AB 1 Complete the Serial Problem using the proper worksheet. 2 You can complete the problems in Excel and submit the Excel spreadsheet in Canvas or you can print out the Excel spreadsheet and complete by hand. You will 3 then need to scan in your completed worksheets and submit those in Canvas. 4 This problem is worth 8 points. 7 Serial Problem 8. For this serial problem, you need to complete the cash flow worksheet. 9 You do not need to complete an actual cash flow statement, just the worksheet. Chapter 16 Serial 5. HOME INSERT PAGE LAYOUT FORMULAS DATA FILE REVIEW VIEW NITRO PRO Normal 2 General Wrap Text 12 Anal - A e Copy $ Merge & Center % A Conditional Format as Calculati Formatting Table Pe Format Painter BTU. Clipboard Alignment 012 013 XV fr 1 Chapter 16 Serial Problem Name AN BUSINESS SOLUTIONS Spreadsheet for Statement of Cash Flows For Current Year Ended December 31 Dec. 31. Pror Analysis of Changes Year Debit Credit Dec. 31. Current w Year 48,372 5,66B 8 Balance sheet-debits 9 Cash 10 Accounts receivable 11 Inventory 12 Computer Supplies 131 Prepaid Insurance 14 Prepaid Rent 15 Office Equipment 161 Computer Equipment 580 1,665 825 8,000 20,000 85,110 400 1.250 18 Balance sheet-credits 19 Accum. depreciation-Office Equip. 20 Accum. depreciation-Computer Equip 21 Accounts payable 22 Wages payable 22 Unearned computer service revenue Common stock 25 Retained earnings 1.100 500 1.500 73,000 7.360 85,110 WESEN 28 Statement of cash flows 30 Operating activities - Instructions Serial Problem Cash Flow 2:04 PM 3/23/2020 All 9 Wrap Text Aria * Cut Ee Copy $ Format Painter 12 - AA== - A. Paste BIU. Merge & Center - Alignment Font Clipboard D13 X 28 Statement of cash flows 29 30 Operating activities 44 Investing activities 09 so Financing activities Instructions Serial Problem Cash Flow Chapter 16 609 Reporting the Statement of Cash Flows tion in Problem 16-3B. vember VWcampered in Chapter 1 and continues through most of the os of the book. If previous chapter seg. ed, the serial problem can begin at this point, SERIAL PROBLEM Business Solutions (Indirect) P2 P3 close any noncash investing San Reyowner Although the sea the safement of oncash investing and of Business Solutions, decides to prepare a statement of cash flows for her serial problem allowed for various ownership changes in earlier chapters, we will of cash flows using the following financial data.) BUSINESS SOLUTIONS Comparative Balance Sheets December 31, 2019, and March 31, 2020 ts and additional information eunts Receivable reflect Il debits to Accounts Payable und (6) any change in Income Mar. 31, 2020 Dec 31, 2019 $48,372 5,668 OMPANY tatement ded December 31 $ 68,057 22,867 704 2,005 1,110 Alexander Image/Shutterstock 580 $750.800 269.230 481.600 supplies p itsurance stedet locumentarsets 825 95,568 8,000 1,665 825 57,110 8,000 BUSINESS SOLUTIONS Income Statement For Three Months Ended March 31, 2020 equipment Office (800) 20,000 $ 15,700 173,933 (400) 20,000 Lurated depreciation ment Drpoter equipment konulated depreciation- Computer equipment bassets. $25,307 18,693 44,000 189,633 291,967 89,200 $202,767 (2,500) $120,268 (1.250) $83,460 $14,052 400 $ Dibilities and Equity katunts payable... eges payable.. Dreamed computer service revenue .... tal current liabilities 0 875 $ 1,100 500 Computer services revenue..... Net sales. Total revenue ... Cost of goods sold...... Depreciation expense-Office equipment ... Depreciation expense- Computer equipment.... Wages expense........... Insurance expense.... Rent expense... Computer supplies expense Advertising expense. Mileage expense .. Repairs expense-Computer Total expenses ...... Net income.. 1,250 3,250 555 2,475 1,305 1,500 875 3,100 ar Transactions ash. k for $21 cash per 600 320 960 Common stock lesined eamings. bities and equity...... 98,000 21,393 $120,268 73,000 7.360 $83,460 25,167 $18,833 vidends. equired statement of cash flows for Business Solutions using the indirect method for the three months Ich 31, 2020. Recall that owner Santana Rey contributed $25,000 to the business in exchange for stock in the first quarter of 2020 and has received $4,800 in cash dividends. Check Cash flows used by operations: $(515) national stock in the first Chapter 16 Serial Problem - Excel FILE DATA REVIEW VIEW NITRO PRO Wrap Text General Normal 2 - Paste HOME INSERT PAGE LAYOUT FORMULAS * Cut Calibri 11 A A Copy Format Painter BIU-1A Clipboard Normal Check Cell te Merge & Center - $ % & Conditional Format as Calculation Formatting Table Font Alignment Number Styles A11 AB 1 Complete the Serial Problem using the proper worksheet. 2 You can complete the problems in Excel and submit the Excel spreadsheet in Canvas or you can print out the Excel spreadsheet and complete by hand. You will 3 then need to scan in your completed worksheets and submit those in Canvas. 4 This problem is worth 8 points. 7 Serial Problem 8. For this serial problem, you need to complete the cash flow worksheet. 9 You do not need to complete an actual cash flow statement, just the worksheet. Chapter 16 Serial 5. HOME INSERT PAGE LAYOUT FORMULAS DATA FILE REVIEW VIEW NITRO PRO Normal 2 General Wrap Text 12 Anal - A e Copy $ Merge & Center % A Conditional Format as Calculati Formatting Table Pe Format Painter BTU. Clipboard Alignment 012 013 XV fr 1 Chapter 16 Serial Problem Name AN BUSINESS SOLUTIONS Spreadsheet for Statement of Cash Flows For Current Year Ended December 31 Dec. 31. Pror Analysis of Changes Year Debit Credit Dec. 31. Current w Year 48,372 5,66B 8 Balance sheet-debits 9 Cash 10 Accounts receivable 11 Inventory 12 Computer Supplies 131 Prepaid Insurance 14 Prepaid Rent 15 Office Equipment 161 Computer Equipment 580 1,665 825 8,000 20,000 85,110 400 1.250 18 Balance sheet-credits 19 Accum. depreciation-Office Equip. 20 Accum. depreciation-Computer Equip 21 Accounts payable 22 Wages payable 22 Unearned computer service revenue Common stock 25 Retained earnings 1.100 500 1.500 73,000 7.360 85,110 WESEN 28 Statement of cash flows 30 Operating activities - Instructions Serial Problem Cash Flow 2:04 PM 3/23/2020 All 9 Wrap Text Aria * Cut Ee Copy $ Format Painter 12 - AA== - A. Paste BIU. Merge & Center - Alignment Font Clipboard D13 X 28 Statement of cash flows 29 30 Operating activities 44 Investing activities 09 so Financing activities Instructions Serial Problem Cash Flow Chapter 16 609 Reporting the Statement of Cash Flows tion in Problem 16-3B. vember VWcampered in Chapter 1 and continues through most of the os of the book. If previous chapter seg. ed, the serial problem can begin at this point, SERIAL PROBLEM Business Solutions (Indirect) P2 P3 close any noncash investing San Reyowner Although the sea the safement of oncash investing and of Business Solutions, decides to prepare a statement of cash flows for her serial problem allowed for various ownership changes in earlier chapters, we will of cash flows using the following financial data.) BUSINESS SOLUTIONS Comparative Balance Sheets December 31, 2019, and March 31, 2020 ts and additional information eunts Receivable reflect Il debits to Accounts Payable und (6) any change in Income Mar. 31, 2020 Dec 31, 2019 $48,372 5,668 OMPANY tatement ded December 31 $ 68,057 22,867 704 2,005 1,110 Alexander Image/Shutterstock 580 $750.800 269.230 481.600 supplies p itsurance stedet locumentarsets 825 95,568 8,000 1,665 825 57,110 8,000 BUSINESS SOLUTIONS Income Statement For Three Months Ended March 31, 2020 equipment Office (800) 20,000 $ 15,700 173,933 (400) 20,000 Lurated depreciation ment Drpoter equipment konulated depreciation- Computer equipment bassets. $25,307 18,693 44,000 189,633 291,967 89,200 $202,767 (2,500) $120,268 (1.250) $83,460 $14,052 400 $ Dibilities and Equity katunts payable... eges payable.. Dreamed computer service revenue .... tal current liabilities 0 875 $ 1,100 500 Computer services revenue..... Net sales. Total revenue ... Cost of goods sold...... Depreciation expense-Office equipment ... Depreciation expense- Computer equipment.... Wages expense........... Insurance expense.... Rent expense... Computer supplies expense Advertising expense. Mileage expense .. Repairs expense-Computer Total expenses ...... Net income.. 1,250 3,250 555 2,475 1,305 1,500 875 3,100 ar Transactions ash. k for $21 cash per 600 320 960 Common stock lesined eamings. bities and equity...... 98,000 21,393 $120,268 73,000 7.360 $83,460 25,167 $18,833 vidends. equired statement of cash flows for Business Solutions using the indirect method for the three months Ich 31, 2020. Recall that owner Santana Rey contributed $25,000 to the business in exchange for stock in the first quarter of 2020 and has received $4,800 in cash dividends. Check Cash flows used by operations: $(515) national stock in the first