Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please assist with this question. Statement of cash flows. Work out in detailed in Excel and show all work. Comparative Balance Sheet 2018 2017 Cash

Please assist with this question. Statement of cash flows. Work out in detailed in Excel and show all work.

image text in transcribed
Comparative Balance Sheet 2018 2017 Cash Assets Accounts receivable (net) $ 46,000 $ 31,000 Prepaid insurance 70,000 60,000 Land 25,000 17,000 Equipment 18,000 40,000 Accumulated depreciation 70,000 60,000 Total Assets (20,000) (13,000) $209,000 $195,000 Accounts payable Liabilities and Stockholders' Equity Bonds payable $ 11,000 $ 6,000 27,000 19,000 Common stock 140,000 115,000 Retained earnings 31,000 55,000 Total liabilities and stockholders' equity $209,000 $195,000 Additional information: 1. Net loss for 2018 is $10,000. 2./ Cash dividends of $14,000 were declared and paid in 2018. 3., kand was sold for cash at a loss of $4,000. This was the only land transaction during the year. 4. Equipment with a cost of $15,000 and accumulated depreciation of $10,000 was sold for $5,000 cash. 5. $22,000 of bonds were retired during the year at carrying (book) value. 6. Equipment was acquired for common stock. The fair market value of the stock at the time of the exchange was $25,000. Instructions Prepare a statement of cash flows for the year ended 2018, using the indirect method. SHOW ALL YOUR WORK

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

John E Freunds Mathematical Statistics With Applications

Authors: Irwin Miller, Marylees Miller

8th Edition

978-0321807090, 032180709X, 978-0134995373

Students also viewed these Accounting questions

Question

State the uses of job description.

Answered: 1 week ago

Question

Explain in detail the different methods of performance appraisal .

Answered: 1 week ago