Complete the following Spreadsheet for the preparation of statement of cash flows under the indirect...

90.2K

Verified Solution

Question

Accounting

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:

  1. Net income for the year was $111,000.
  2. Dividends of $102,000 cash were declared and paid.
  3. The only noncash expense was $81,000 of depreciation.
  4. Purchased plant assets for $81,000 cash.
  5. Notes payable of $31,000 were issued for $31,000 cash.
  6. $81,000 increase in accounts receivable.
  7. $31,000 decrease in inventory.
  8. $21,000 decrease in accounts payable.
SCORETECK CORPORATION
Spreadsheet for Statement of Cash FlowsIndirect Method
For Year Ended December 31, 2019
Dec. 31, 2018 Analysis of Changes Dec. 31, 2019
Debit Credit
Balance SheetDebit Bal. Accounts
Cash $113,000 $82,000
Accounts receivable 131,000 212,000
Inventory 272,000 241,000
Plant assets 611,000 692,000
$1,127,000 $1,227,000
Balance SheetCredit Bal. Accounts
Accumulated depreciation $111,000 $192,000
Accounts payable 172,000 151,000
Notes payable 381,000 412,000
Common stock 211,000 211,000
Retained earnings 252,000 261,000
$1,127,000 $1,227,000
Statement of Cash Flows
Operating activities
Investing activities
Financing activities
$0 $0

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students