OSearch 15e_PR 13-1A - Excel X AutoSave Off File Page Layout Formulas Review View Help Share Home Insert Data Comments X 4 Insertv 10A A Y ab Ce Arial Narrow Wrap Text X Delete L Paste a Sort & Find & Conditional Format as Cell Ideas Sensitivity Merge & Center $ % 8 48 0.00 00 A BIU Y Y Filter Select Format Table Styles Formatting Sensitivity Clipboard Font Alignment N Number Styles Cells Editing Ideas A P36 X AF A BC D E F G IJ K L M O P S T U YA AB AC AD AG AH Al AJ AK AL AM. AN 13 14 15 Livers Inc Statement of Cash Flows 16 17 For the Year Ended December 31, 20Y3 18 Cash flows from (used for) operating activities: 19 20 Net income Adjustments to reconoile net income to net cash flow from operating activities: 21 22 23 Depreciation 24 Gain on sale of investments 25 Changes in current operating assets and liabilities: Increase in accounts receivable 26 Increase in inventories 27 Increase in acoounts payable 28 29 Decrease in accrued expenses payable Net cash flow from operating activities 30 31 32 Cash flows from (used for) investing activities: 33 Cash received from sale of investments Cash paid for purohase of land Cash paid for purchase of equipment Net cash flow used for investing activities 34 35 36 37 38 Cash flows from (used for) financing activities: Cash received from sale of common stock 39 40 Cash paid for dividends Net cash flow from finanoing aotivities 41 42 43 Net increase (decrease) in cash 44 Cash balance, January 1, 20Y3 Cash balanoe, December 31, 20Y3 45 46 47 Pr. 13-1A 70% 1:21 PM Type here to search (?A X 11/25/2019 15e_PR 13-1A - Excel OSearch X AutoSave Off File Formulas Review View Help Share Home Insert Page Layout Data Comments X Insert 10A A Y ab Ce Arial Narrow Wrap Text X Delete L Paste a Sort & Find & Conditional Format as Cell Ideas Sensitivity I U Merge & Center $ % 8 48 0.00 00 A Y Y Format Table Styles Filter Select Formatting Editing Sensitivity Clipboard Font Alignment Number Styles Cells Ideas P36 X AF AG AH A A BCD Optional: J P U YA E F G H K L M N O T X AB AC AD AJ AK AL AM AN AO AP AQ AR AS 48 43 Lirers lac. 50 Spreadsheet (York Sheet] for Statement of Cash Flos For the Year Ended December 31, 20Y3 51 52 Traasactions Balanc Balanc, 53 Dec. 31, 2 T2 D bit Cradit Doc. 31, 20T3 150,000 54 Cash 155,000 Accounts receivable (net) Inventories 55 400,000 450,000 770,000 56 750,000 57 Investments 100,000 500,000 58 Land 53 Equipment Accum. depr. cquipment Accounts payable Accrued expandes payable Dividends payable 1,200,000 ##### (500,000) (300,000) (50,000) (25,000) (600,000) (175,000) (950,000 60 61 ##### (45,000) 62 63 (30,000) (T00,000) 64 Common stock, $4 par Paid-in capital in excess of par Retained earning 65 ##### 66 67 Totals Operating activities Net income 68 63 T0 Depreciation 71 Gain on sale of investments 72 Increase in accounte receivable Increase in inventorigp Increase in accounts payable Decrease in accrued expenoes payable Investing activities Purchase of equipment Purchase of land 73 74 75 76 77 78 Sale of investmente Financing activities 80 81 Declaration of cash dividenda Sale of common stock Increase in dividends payable 82 83 84 Net change in cash 85 Totals 86 Pr. 13-1A 60% 1:22 PM (?A Type here to search X 11/25/2019 O Photos-PR 13-1A data (1).pnq Add to Edit & Create See all photos PR 13-1AStatement of Cash Flows-Indirect Method Obj. 2, 3, 4, 5 The comparative balance sheet of Livers Inc. for December 31, 20Y3 and 20Y2, is shown as follows: + Dec. 31, 20Y2 Dec. 31, 20Y3 Assets 155,000 Cash * Accounts receivable (net) Inventories 150,000 400,000 450,000 770,000 750,000 Investments 0 100,000 Land.. 500,000 Equipment.. Accumulated depreciation-equipment Total assets. 1,400,000 1,200,000 (600,000 (500,000) $2,100,000 $2.675.000 Liabilities and Steckholders' Equity .. . Accounts payable (merchandise creditors) Accrued expenses payable (operating expenses) Dividends payable.. Common stock, S4 par. Pald-in capital In excess of par-common stock.... Retained earnings... 340,000 s 300,000 45.000 50,000 25,000 30,000 700,000 600,000 175,000 200,000 1,360,000 950,000 $2.675.000 $2,100,000 Total llabilities and stockholders' equity Additional data obtained from an examination of the accounts in the ledger for 20Y3 are as follows: a. The investments were sold for $175,000 cash b. Equipment and land were acquired for cash c. There were no disposals of equipment during the year. d. The common stock was issued for cash e. There was a $5o0,000 credit to Retained Earnings for net income. f. There was a $90,000 debit to Retained Earnings for cash dividends declared Instructions Prepare a statement of cash flows, using the indirect method of presenting cash flows from operating activities. |Answar Check Figure: Net cash flow from operating activities, $490,000 1:17 PM Type here to search x 11/25/2019 O