Question: Please i need help with that question. Prepare a complete statement of cash flows using a spreadsheet under the indirect method. [The following information applies

Please i need help with that question. Prepare a complete statement of cash flows using a spreadsheet under the indirect method.
Please i need help with that question. Prepare a complete statement of
cash flows using a spreadsheet under the indirect method. [The following information

[The following information applies to the questions displayed below.) Golden Corporation's current year income statement, comparative balance sheets, and additional information follow. For the year. (1) all sales are credit sales, (2) all credits to Accounts Receivable reflect cash receipts from customers, (3) all purchases of inventory are on credit. (4) all debits to Accounts Payable reflect cash payments for inventory, and (5) any change in Income Taxes Payable reflects the accrual and cash payment of taxes. GOLDEN CORPORATION Comparative Balance Sheets December 31 Current Year Prior Year Assets Cash $164,000 $ 107,000 Accounts receivable 83,000 71,000 Inventory 601,000 526,000 Total current assets 848,000 704,000 Equipment 335,000 299,000 Accumulated depreciation-Equipment (158,000) (104,000 Total assets $ 1,025,000 $ 899,000 Liabilities and Equity Accounts payable $ 87,000 $ 71,000 Income taxes payable 28,000 25,000 Total current liabilities 115,000 96,000 Equity Common stock, $2 par value 592,000 568,000 Paid-in capital in excess of par value, common stock 196,000 160,000 Retained earnings 122,800 75,000 Total liabilities and equity $ 1,025,000 $ 899,000 GOLDEN CORPORATION Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit Operating expenses (excluding depreciation) Depreciation expense Income before taxes Income taxes expense Net Income $ 1,792,000 1,086,000 706,000 494,000 54,000 158,000 22,000 $ 136,000 83,000 601,000 848,000 335,000 (158,000) $ 1,025,000 71,000 526,800 784,000 299,000 (104,000) $ 899,000 $ 87,000 28,000 115,000 $ 71,000 25,000 96,000 Accounts receivable Inventory Total current assets Equipment Accumulated depreciation Equipment Total assets Liabilities and Equity Accounts payable Income taxes payable Total current liabilities Equity Common stock, $2 par value Paid-in capital in excess of par value, common stock Retained earnings Total liabilities and equity GOLDEN CORPORATION Income Statement For Current Year Ended December 31 Sales $ 1,792,000 Cost of goods sold 1,086,000 Gross profit 706,000 Operating expenses (excluding depreciation) 494,000 Depreciation expense 54,000 Income before taxes 158,000 Income taxes expense 22,000 Net income $ 136,000 592,000 196,000 122,000 $ 1,025,000 568,000 160,000 75,000 $ 899,000 Additional Information on Current Year Transactions a. Purchased equipment for $36,000 cash. b. Issued 12,000 shares of common stock for $5 cash per share. c. Declared and paid $89,000 in cash dividends. Required: Prepare a complete statement of cash flows using a spreadsheet under the indirect method (Enter all amounts as positive values.)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!