highlighted blue sections (48) on the spreedsheet. The sheet is large multiple pics of the entire sheet. The selections from drop down boxes. This is one question. Thanks!
Complete the following Spreadsheet for the preparation of statement of cash flows under the indirect method. (The statement of cash flows is not required.) (Enter all amounts as positive values.) Additional information: a. Net Income for the year was $100,000. b. Dividends of $80,000 cash were declared and paid. c. The only noncash expense was $70,000 of depreciation. d. Purchased plant assets for $90,000 cash. e. Notes payable of $20,000 were issued for $20,000 cash. f. $50,000 increase in accounts receivable. g. $30,000 decrease in inventory. h. $10,000 decrease in accounts payable. SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows-Indirect Method. For Year Ended December 31, 2021 Analysis of Changes. Paramher. It
SCORETECK CORPORATION Spreadsheet for Statement of Cash Flows-Indirect Method For Year Ended December 31, 2021 Balance Sheet-Debit Balance Accounts Cash Accounts receivable Inventory Plant assets Balance Sheet-Credit Balance Accounts Accumulated depreciation Accounts payable Notes payable Common stock Retained earnings Statement of Cash Flows Operating activities December 31, 2020 $ $ $ S 80,000 120,000 250,000 600,000 1,050,000 100,000 150,000 370,000 200,000 230,000 1,050,000 Analysis of Changes Debit Credit December 31, 2021 $ $ $ 70,000 170,000 220,000 690,000 1,150,000 170,000 140,000 390,000 200,000 250,000 $ 1,150,000
Balance Sheet-Credit Balance Accounts Accumulated depreciation Accounts payable Notes payable Common stock Retained earnings Statement of Cash Flows Operating activities Investing activities Financing activities 3 $ $ 1,050,000 100,000 150,000 370,000 200,000 230,000 1,050,000 S $ 1,150,000 170,000 140,000 390,000 200,000 250,000 $ 1,150,000
Statement of Cash Flows Operating activities Cash from issuance of notes payable Cash from sale of plant assets Cash paid for dividends Cash paid on note payable Financing activities
Retained earnings tatement of Cash Flows Operating activities Cash paid to purchase plant assets Decrease in accounts payable Decrease in accounts receivable Decrease in inventory Depreciation expense Financing activities ---LI- $
atement of Cash Flows Operating activities Depreciation expense Increase in accounts payable Increase in accounts receivable Increase in inventory Net income Financing activities
highlighted blue sections (48) on the spreedsheet. The sheet is large multiple pics of the entire sheet. The selections
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am