Prepare a schedule of net cash provided by operating activities.- Prepare the Operating Activities Section of a Statement of Cash Flows using the Indirect. ?FILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSigCalibri-11A A%Alignment Number Conditional Format as CellFormatting Table StylesPasteBIUCellsEditingClipboardFontStylesA1feThe following information is for FloorCo, Inc. for the year just ended:ABDEG1 The followng information is for FloorCo, Inc. for the year just ended:3Beginning of4End of yearyear5 Current assets:Cash75,000 $90,0007.Accounts receivable158,000140,0008Inventory285,000246,0009.Prepaid expenses11,00016,0001011 Current liabilities12Accounts payable284,000302,00013Accrued liabiities9,50011,20014Income taxes payable27,00024,0001516Net income2$94,5001718Accumulated depreciation19total credits45,0002021 Floor Company did not record any gains or losses during the year.2223 Prepare a schedule of net cash provided by operating activities.Use the income statement and balance sheet to prepare a statement of cash flows using the indirect methodPrepare a statement of cash flows using the indirect method - ExcelFILEHOMEINSERTPAGE LAYOUTFORMULASDATAREVIEWVIEWSign InCalibri-11A A%PasteBIUAlignment NumberConditional Format asCellCellsEditingFormatting Table StylesClipboardFontStylesB13feABDEF1 Required:2 Complete the statement of cash flows (indirect method) shown below by using formulas that reference3 data from the income statement and balance sheet (found by clicking the tabs at the bottom of this4 worksheet. Note: Blank cells may be included in calculations.INNOVATION ELECTRONICS, INC.Statement of Cash Flows8.For the Year Ended December 31, 20X29 Cash Flows from Operating Activities:10 Net income11 Adjustments to reconcile net income to net cash12 provided by operating activities:13 Depreciation expense14 Gain (on sale of land)15 Changes in current assets and current liabilities:16 Accounts receivable17 Inventory18 Prepaid insurance19 Accounts payable20 Interest payable21 Income tax payable22 Net cash provided by (used in) operating activities2324 Cash Flows from Investing Activities:>67

Cash flow from operating activities (CFO) indicates the amount of money a company brings in from its…

Answered: The followng information is for…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

ces For the year just completed, Hanna Company had net income of $90,500. Balances in the company's current asset and current liability accounts at the beginning and end of the year were as follows: Current assets: Cash and cash equivalents Accounts receivable Inventory Prepaid expenses Current liabilities: Accounts payable Accrued liabilities Income taxes payable December 31 End of Year $ 55,000 $ 152,000 $ 451,000 $ 12,000 $ 356,000 $ 8,000 $ 35,000 Beginning of Year $ 83,000 $184,000 $ 343,000 $ 14,000 $ 400,000 $ 11,500 $ 27,000 The Accumulated Depreciation account had total credits of $58,000 during the year. Hanna Company did not record any gains or losses during the year. Required: Using the indirect method, determine the net cash provided by operating activities for the year. (List any deduction in cash and cash outflows as negative amounts.) Hanna Company Statement of Cash Flows-Indirect Method (partial) +
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $55,900; total assets, $189,400; common stock. $87,000, and retained earnings, $29,103.) Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets CABOT CORPORATION Income Statement For Current Year Ended December 311 $455,600 298,450 157,150 99,000 4,400 53,758 21,653 $ 32,097 Sales Cost of goods sold i Gross profit Operating expenses Interest expense Income before taxes Income tax expense. Net income CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity $10,000 Accounts payable 8,600 Accrued wages payable 30,400 Income taxes payable: 40,150 Long-term note payable, secured by mortgage on plant assets 2,550 Common stock 148,300 Retained earnings $ 240,000 Total liabilities and equity $ 17,500 5,000 3,900…
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $48,900; total assets, $189,400; common stock, $90,000; and retained earnings, $33,748.) Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Sales Cost of goods sold Gross profit $ 10,000 8,400 CABOT CORPORATION Income Statement For Current Year Ended December 31 Operating expenses Interest expense Income before taxes Income tax expense Net income 33,700 32,150 2,650 153,300 $ 240, 200 $448,600 297,250 151,350 98,600 4,100 48,650 19,598 $ 29,052 CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity Accounts payable Accrued wages payable Income taxes payable. Long-term note payable, secured by mortgage on plant assets Common stock Retained earnings Total liabilities and equity $ 17,500 3,200 3,300…
Moravec Company's net income last year was P46,000 and cash dividends declared and paid to the company's stockholders totaled P18,000. Changes in selected balance sheet accounts for the year appear below: Increases (Decreases) Debit balances: ... P 8,000 (5,000) Accounts receivable Inventory Credit balances: Accumulated depreciation . 26,000 10,000 (9,000) 4,000 60,000 Accounts payable Accrued liabilities Taxes payable Bonds payable Based solely on this information, the net cash provided by operations under the indirect method on the statement of cash flows would be:
following are the financial statements of Perfect Ltd for last year and this year: Income Statement for the year ended 31 December Last Year (000) This Year (000) Turnover 15,000 25,600 Cost of sales (7,496) (11,618) Gross profit 7,504 13,982 Operating expenses (4,410) (6,174) Operating profit 3,094 7,808 Interest payable (432) (912) Profit before taxation 2,662 6,896 Taxation (420) (780) Profit for the year 2,242 6,116 Balance sheet as at 31 December Last Year (000) This Year (000) Non-current assets 6,500 14,200 Current assets Inventories 2,418 4,820 Trade receivables 1,614 2,744 Other receivables 268 402 Cash 56 8 4,356 7,974 Total assets 10,856 22,174 Equity Ordinary shares of Rs. 0.50 each 3,600 3,600 Capital reserves 1,904 1,904 Retained profit 1,370 3,496 6,874 9,000 Non- current liabilities Loan notes 1,500 5,330 Current…
A company reports the following income statement and balance sheet information for the current year: Net income $180,000 Interest expense 20,000 Average total assets 2,000,000 Determine the return on total assets.fill in the blank 1 %
Savita
Green Caterpillar Garden Supplies Inc. has the following end-of-year balance sheet: Green Caterpillar Garden Supplies Inc. Balance Sheet For the Year Ended on December 31 Assets Liabilities Current Assets: Current Liabilities: Cash and equivalents $150,000 Accounts payable $250,000 Accounts receivable 400,000 Accrued liabilities 150,000 Inventories 350,000 Notes payable 100,000 Total Current Assets $900,000 Total Current Liabilities $500,000 Net Fixed Assets: Long-Term Bonds 1,000,000 Net plant and equipment $2,100,000 Total Debt $1,500,000 (cost minus depreciation) Common Equity Common stock 800,000 Retained earnings 700,000 Total Common Equity $1,500,000 Total Assets $3,000,000 Total Liabilities and Equity $3,000,000 The firm is currently in the process of forecasting sales, asset requirements, and required funding for the coming year. In the year that just ended, Green Caterpillar Garden Supplies Inc.…
Sherwood, Inc., had the following current assets and current liabilities at the end of two recent years: Year 2(in millions) Year 1(in millions) Cash and cash equivalents $4,165 $4,528 Short-term investments, at cost 2,958 8,408 Accounts and notes receivable, net 9,404 8,624 Inventories 1,771 787 Prepaid expenses and other current assets 590 291 Short-term obligations (liabilities) 315 3,342 Accounts payable and other current liabilities 7,453 6,813 a. Determine the (1) current ratio and (2) quick ratio for both years. Round to one decimal place. Year 2 Year 1 Current ratio fill in the blank 1 fill in the blank 2 Quick ratio fill in the blank 3 fill in the blank 4
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $51,900; total assets, $169,400; common stock, $85,000; and retained earnings, $45,550.) Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets CABOT CORPORATION Income Statement CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity $ 22,000 Accounts payable 8,800 Accrued wages payable 33,400 Income taxes payable 34,150 Long-term note payable, secured by mortgage on plant assets 2,850 152,300 Common stock Retained earnings $ 253,500 Total liabilities and equity For Current Year Ended December 31 Sales Cost of goods sold Gross profit Operating expenses Interest expense Income before taxes Income tax expense Net income $ 450,600 298,050 152,550 98,900 4,500 49,150 19,800 $ 29,350 $ 15,500 4,000 3,700…
! Required information [The following information applies to the questions displayed below.] Simon Company's year-end balance sheets follow. At December 31 Assets Cash Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets Liabilities and Equity Accounts payable Long-term notes payable Common stock, $10 par value Retained earnings Total liabilities and equity Interest expense Income tax expense Total costs and expenses Net income Earnings per share For both the current year and one year ago, compute the following ratios: The company's income statements for the current year and one year ago, follow. For Year Ended December 31 Sales Cost of goods sold Other operating expenses Current Year: 1 Year Ago: Current Year 1 Year Ago $ 27,988 81,119 106,155 9,197 259,602 $ 484,061 Current Year: 1 Year Ago: $ 383,860 195,076 Numerator: $ 118, 121 88,273 162,500 115,167 $ 484,061 Current Year Total liabilities 10,698 8,181 Numerator: Total equity Required 1…
Selected current year-end financial statements of Cabot Corporation follow. (All sales were on credit; selected balance sheet amounts at December 31 of the prior year were inventory, $52,900; total assets, $229,400; common stock, $82,000; and retained earnings, $45,833.) Assets Cash Short-term investments Accounts receivable, net Merchandise inventory Prepaid expenses Plant assets, net Total assets CABOT CORPORATION Income Statement For Current Year Ended December 31 Sales Cost of goods sold Gross profit $ 22,000 9,000 33,600 38,150 3,100 149, 300 $255,150 Operating expenses Interest expense Income before taxes Income tax expense Net income $ 455,600 297,650 157,950 99, 200 4,800 53,950 21,733 $32,217 CABOT CORPORATION Balance Sheet December 31 of current year Liabilities and Equity Accounts payable Accrued wages payable Income taxes payable Long-term note payable, secured by mortgage on plant assets Common stock Retained earnings Total liabilities and equity $ 18,500 2,800 3,400…

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS