Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please answer in excel Data table 2018 2017 $ 107,200 $ 24,000 64,600 69,400 Current Assets: Cash Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable

please answer in excel
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Data table 2018 2017 $ 107,200 $ 24,000 64,600 69,400 Current Assets: Cash Accounts Receivable Merchandise Inventory Current Liabilities: Accounts Payable Income Tax Payable 79,000 77,000 57,900 55,900 14,500 16,500 Data table Transaction Data for 2018: Issuance of common stock for cash $ 35,000 Depreciation expense 16,000 Payment of notes payable $ 45,100 Payment of cash dividends 51.000 Issuance of notes payable to borrow cash 66,000 71.000 Purchase of equipment with cash Acquisition of land by issuing long-term notes payable Book value of building sold 123,000 Gain on sale of building 3,500 59.000 Net income 71,500 Accountants for Carlson, Inc. have assembled the following data for the year ended December 31, 2018: (Click the icon to view the current accounts.) (Click the icon to view the transaction data.) Prepare Carlson's statement of cash flows using the indirect method. Include an accompanying schedule of non-cash investing and financing activities. Complete the statement one section at a time, beginning with the cash flows from operating activities. (Use a minus sign or parentheses for amounts that result in a decrease in cash. If a box is not used in the statement, leave the box empty: do not select a label or enter a zero.) Carlson, Inc. Statement of Cash Flows Year Ended December 31, 2018 Cash Flows from Operating Activities: Net Income Adjustments to Reconcile Net Income to Net Cash Provided by (Used for) Operating Activities: Net Cash Provided by (Used for) Operating Activities Cash Flows from Investing Activities: Net Cash Provided by (Used for) Investing Activities Cash Flows from Financing Activities: Cash Flows from Finance mites. Net Cash Provided by (Used for) Financing Activities Net Increase (Decrease) in Cash Cash Balance, December 31, 2017 Cash Balance, December 31, 2018 Non-cash Investing and Financing Activities: Total Non-cash Investing and Financing Activities

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

More Books

Students also viewed these Accounting questions

Question

Do you understand my problem and my needs?

Answered: 1 week ago