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

Complete the balance sheet and sales information using the following financial data: Balance sheet Cash ________ Current liabilities _________ Accounts Receivable ________ Long-term debt 120,000 Inventories ________ Common stock _________ Total assets $600,000 Retained earnings 195,000 Total liabilities and equity _________ Sales ________ Cost of good sold ____40%sales__ Current ratio: 2.o X…
Following information are taken from financial statements of a company. What is the interest coverage ratio? Sales Revenue $1,000,000 Tax Rate 20% Net Income $200,000 Operating Income $280,000
Cauce Corporation is preparing its year-end balance sheet. The company records show the following selected amounts at the end of the year: Total assets $ 620,000 Total noncurrent assets 314,000 Liabilities: Notes payable (8%, due in 5 years) 24,000 Accounts payable 55,000 Income taxes payable 10,000 Liability for withholding taxes 1,000 Rent revenue collected in advance 9,000 Bonds payable (due in 15 years) 109,000 Wages payable 9,000 Property taxes payable 5,000 Note payable (10%, due in 6 months) 15,000 Interest payable 800 Common stock 180,000 Required: 1-a. What is the amount of current liabilities? 1-b. Compute working capital. 2. Would your computation be different if the company reported $350,000 worth of contingent liabilities in the notes to its financial statements?
Vishnu
A company reports the following:Income before income tax $4,000,000Interest expense 400,000Determine the times interest earned ratio. Round to one decimal place.
Here are simplified financial statements for Watervan Corporation: INCOME STATEMENT (Figures in $ millions) Net sales $ 887.00 Cost of goods sold 747.00 Depreciation 37.00 Earnings before interest and taxes (EBIT) $ 103.00 Interest expense 18.00 Income before tax $ 85.00 Taxes 17.85 Net income $ 67.15 BALANCE SHEET (Figures in $ millions) End of Year Start of Year Assets Current assets $ 375 $ 324 Long-term assets 270 228 Total assets $ 645 $ 552 Liabilities and shareholders’ equity Current liabilities $ 200 $ 163 Long-term debt 114 127 Shareholders’ equity 331 262 Total liabilities and shareholders’ equity $ 645 $ 552 The company’s cost of capital is 8.5%. Required: What is the company’s return on capital? (Use start-of-year rather than average capital.) Note: Do not round intermediate calculations. Enter your answer as a percent rounded to 2 decimal places. P.S- Answer is not 26.48%
Condensed financial data are presented below for the Tulsa Corporation: Accounts receivable Inventory C. d. Total current assets Total assets Current liabilities Long-term liabilities Sales Cost of goods sold Interest expense Net income Tax rate 2021 $277,500 310,000 675,000 800,000 700,000 250,000 200,000 77,500 75,000 1,640,000 985,000 10,000 130,000 25% 2020 $230,000 250,000 565,000 The profit margin used to calculate return on assets for 2021 is (rounded): a. b. 8.9% 16.3% 17.2% 18.3%
Net income of Fernandez Co The following selected accounts and their current balances appear in the ledger of Fernandez Co. at the end of its fiscal year. Cash $250,000 Retained Earnings 2,850,000 Accounts Receivable 1,197,000 Dividends 50,000 Inventory 1,790,000 Sales 9,350,000 Estimated Returns Inventory 23,500 Cost of Goods Sold 5,840,000 Office Supplies 14,000 Sales Salaries Expense 820,000 Prepaid Insurance 8,500 Advertising Expense 350,000 Office Equipment 870,000 Depreciation Expense-Store Equipment 120,000 Accumulated Depreciation-Office Equipment 580,000 Miscellaneous Selling Expense 58,000 Store Equipment 2,600,000 office Salaries Expense 550,000 Accumulated Depreciation-Store Equipment 820,000 Rent Expense 104,000 Accounts Payable 336,000 Depreciation Expense-Office Equipment 60,000 Customer Refunds Payable 39,000 Insurance Expense 50,000 Salaries Payable 43,000 office Supplies Expense 26,000 Notes Payable (long-term) 200,000 Miscellaneous Administrative Expense 12,000…
The following are selected account balances of Rule Corporation at the end of the current year: Debit Credit Operating Expenses $3,200 Sales Revenue $17,780 Cost of Goods Sold 8,500 Interest Expense 790 Gain on Sale of Land 590 Rule is subject to a 30% income tax rate, and shareholders own 1,200 shares of its capital stock. Required: Prepare the income statement for Rule. RULE CORPORATION Income Statement For the Year Ended December 31, Current Year Other items: Earnings per share
The following data were abstracted from the records of Ballistic Corporation for the year: Sales 1,080,000 Interest expense 75,000 Income taxes 240,000 Net income 360,000 Compute interest coverage ratio.
Lydex Company’s financial statements for the last two years are as follows: Lydex Company Comparative Balance Sheet This Year Last Year Assets Current assets: Cash $ 1,020,000 $ 1,260,000 Marketable securities 0 300,000 Accounts receivable, net 2,940,000 2,040,000 Inventory 3,660,000 2,100,000 Prepaid expenses 270,000 210,000 Total current assets 7,890,000 5,910,000 Plant and equipment, net 9,640,000 9,110,000 Total assets $ 17,530,000 $ 15,020,000 Liabilities and Stockholders' Equity Liabilities: Current liabilities $ 4,070,000 $ 3,100,000 Note payable, 10% 3,700,000 3,100,000 Total liabilities 7,770,000 6,200,000 Stockholders' equity: Common stock, $75 par value 7,500,000 7,500,000 Retained earnings 2,260,000 1,320,000 Total stockholders' equity 9,760,000 8,820,000 Total liabilities and stockholders' equity $ 17,530,000 $ 15,020,000 Lydex Company Comparative Income Statement and Reconciliation This…
Use the following balance sheet data to compute the net operating working capital. Cash Accounts Receivable Inventory Current Assets Net fixed assets Total assets $60 160 200 $420 $700 $1,120 Account payable Accruals Notes payable Current liabilities Long-term debt Common equity Retained earnings Total liabilities and equity $180 110 200 $490 250 160 220 $1,120

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