Cash flow indirect method | ||
Cash flow from operating activities | ||
Net income | 60700 | |
Adjustments to reconcile the net income | ||
Depreciation and amortization expense | 15300 | |
Gain on sale of equipment | ||
Changes in current asset and liabilities | ||
decrease in accounts receivable | 1100 | |
Increase in inventory | -3800 | |
decrease in accounts payable | -1500 | |
Increase in accrued liabilities | 1100 | |
12200 | ||
Cash flow from operating activities | 72900 | |
Cash flow from Investing activities | ||
Land purchased | -25500 | |
Building purchased | -22200 | |
Cash flow from Investing activities | -47700 |
Cash flow from Financing activities | |||
Common stock | 8700 | ||
Dividend | -28800 | ||
Notes payable paid | -18000 | ||
Notes payable issued | |||
Cash flow from Financing activities | -38100 | ||
Net Cash and cash equivalent | -12900 | ||
Add | Beginning cash and cash equivalent | 15600 | |
Ending cash and cash equivalent | 2700 |
120,600 19,900 51,800 lders' Equity $ 256,300 $ 278,500 ent of Cash Flows: ctivit Data Table...
9. Michael, Inc.'s accountant has partially completed the spreadsheet for the statement of cash flows. Fill in the remaining missing information. (lf a bax is not used in the statement, leave the box emply do not select a label or enter a zero, Dot check your answer until bath Panel A and Panel B have been completed) (Click the icon to view the information) Balance 12/31/2018 Michael, Inc. Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Balance...
Spreadsheet for Statement of Cash Flows Year Ended December 31, 2018 Transaction Analysis Balance Balance 12/31/2017 Panel A Balance Sheet: DEBIT CREDIT 12/31/2018 Cash Accounts Receivable 15,300 4,330 14,600 (500) 33,730 19,800 5,330 16,300 (700) Plant Assets 1,700 Accumulated Depreciation 40,730 Total Assets Accounts Payable 6,700 5,400 Common Stock, no par 5,300 28,130 22,830 4,200 33,730 5,500 Retained Earnings 7,200 40,730 Total Liabilities and Stockholders' Equity Panel B_Statement of Cash Flows: 200 Cash Flows from Operating Activities: Net Income Adjustments...
Complete the statement one section at a time, beginning with the cash flows from operating activities. Grand Tree, Inc. Statement of Cash Flows Year Ended December 31, 2018 Grand Tree, Inc. Income Statement Year Ended December 31, 2018 Net Sales Revenue $ 442,000 Cost of Goods Sold 210,200 Gross Profit 231,800 Operating Expenses Salaries Expense 78,400 Depreciation Expense-Plant Assets 14,700 Other Operating Expenses 11,000 104,100 Total Operating Expenses Operating Income 127.700 Other Income and (Expenses): Interest Revenue 8,300 Interest Expense...
The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018. The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value during 2018 EEE (Click the icon to view the comparative balance sheet.) EEB (Click the icon to view the income statement.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows...
Data Table Press Exercise Equipment, Inc. Income Statement Year Ended December 31, 2018 Net Sales Revenue $ 717,000 340,000 377,000 Cost of Goods Sold Gross Profit Operating Expenses: Depreciation Expense $ 46,000 180,000 Other Operating Expenses Total Operating Expenses 226,000 $ 151,000 Net Income i Data Table Press Exercise Equipment, Inc. Comparative Balance Sheet December 31, 2018 and 2017 2018 2017 Assets Current Assets: Cash Accounts Receivable 18,000 $ 56,000 83,000 14,000 49,000 86,000 Merchandise Inventory Long-term Assets: Plant Assets...
The income statement and additional data of Supplements Plus, Inc. follow: (Click the icon to view the income statement.) i (Click the icon to view the additional data.) Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. Use the transaction references in Panel B when selecting the transaction references in Panel Alf a box is not used in the spreadsheet, leave the box emoty: do not select a label...
Spreadsheet for Statement of Cash Flows Balance 7/1/18 Balance 12/31/18 Panel A Balance Sheet 0 Cash Accounts Receivable Inventory Office Equipment Truck Accumulated Depreciation-Plant Assets Total Assets Transaction Analysis Debit Credit 95,700 $ 12.000 4,400 6,000 5,000 6,000 123,100 6000 $ 95,700 12,000 4,400 6,000 5,000 (6,000) 117,100 0 $ $ o 5,500 10,000 5,500 10,000 Accounts Payable Note Payable-Short Term Note Payable - Long Term Total Liabilities 0 15500 15,500 100,000 Common Stock Retained Earnings Total Liabilities and Stockholders'...
MONTGOMERY, INC Statement of Cash Flows (Indirect Method) For Year Ended December 31, 2018 Cash flows from operating activities Net income Adjustments to reconcile net income to net cash provided by operations: Changes in current operating assets and liabilities Depreciation expense Decrease in accounts receivable Decrease in accounts payable Decrease in salaries payable Increase in inventory Net cash used in operating activities Cash flows from investing activities 0) Cash flows from financing activities 0 0 Cash balance at beginning of...
The 2018 comparative balance sheet and income statement of Allen Group, Inc. follow. Allen disposed of a plant asset at book value during 2018 .Prepare the spreadsheet for the 2018 statement of cash flows. Format cash flows from operating activities by the indirect method. A plant asset was disposed of for $0. The cost and accumulated depreciation of the disposed asset was $ 12,600. There were no sales of land, no retirement of common stock, and no treasury stock transactions....
put together a Spreadsheet for Statement of Cash Flows for the same problem 16B-45B. Format the spreadsheet as shown in Exhibit 16B-1. P16B-45B Using a spreadsheet to prepare the statement of cash flows-indirect method The 2018 comparative balance sheet and income statement of Attleboro Group, Inc. follow. Attleboro disposed of a plant asset at book value in 2018. ATTLEBORO GROUP, INC. Income Statement Year Ended December 31, 2018 $441,000 205,400 235,600 $ 76,300 15,300 49,600 Net Sales Revenue Cost of...