Function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Calculate Operating Cash Flows PROBLEM The comparative balance sheets for Gale Company show these changes in noncash current asset accounts and net income for the period. Accounts receivable decrease Prepaid expenses increase Inventories increase Net income $80,000 28,000 40,000 186,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Use the SUM function with cell references to this work area for the total. Compute net cash provided by operating activities using the indirect method. Net income Adjustments to reconcile net income to net cash provided by operating activities Net cash provided by operating activities $186,000

Function: SUM; Formula: Add, Subtract; Cell Referencing Using Excel to Calculate Operating Cash Flows PROBLEM The comparative balance sheets for Gale Company show these changes in noncash current asset accounts and net income for the period. Accounts receivable decrease Prepaid expenses increase Inventories increase Net income $80,000 28,000 40,000 186,000 Student Work Area Required: Provide input into cells shaded in yellow in this template. Use mathematical formulas with cell references to the Problem area. Use the SUM function with cell references to this work area for the total. Compute net cash provided by operating activities using the indirect method. Net income Adjustments to reconcile net income to net cash provided by operating activities Net cash provided by operating activities $186,000

Cornerstones of Financial Accounting

4th Edition

ISBN:9781337690881

Author:Jay Rich, Jeff Jones

Publisher:Jay Rich, Jeff Jones

Chapter11: The Statement Of Cash Flows

Section: Chapter Questions

Problem 39E: Reporting Net Cash Flow from Operating Activities The following information is available for...

See similar textbooks

Similar questions

nu messageQ&A notifications account_circle Business FinanceQ&A LibraryPlease classify each of the following accounts into its right category of cash flow activities. Which of the following item(s) belong to Operation Activities? (This question may contain multiple answers) Depreciation Fixed assets expenses Change in Inventories Change in Accounts Payable Payment of cash dividends Change in Notes Payable Payment of long-term debt Change in marketable securities Net income Change in Account Receivables Please classify each of the following accounts into its right category of cash flow activities. Which of the following item(s) belong to Operation Activities? (This question may contain multiple answers) Depreciation Fixed assets expenses Change…
Evie Excellent is trying to create financial statements for her start-up company, Stinky Soaps. Evie began the business on Jan 1, 2023 with a $1,000 investment from her parents. The year 2023 is over, and Evie needs help to generate a profit and loss statement (Income statement) and Balance sheet. She is only able to ascertain that her cash is about even with what she started the year with ($1,000). Evie has two products, bar and liquid soap. She purchased initial inventory of 100 units of each product in mid - January, 2023. The bar soap cost $2 per bar and the liquid was a bit more expensive at $4 per unit. Sales have been good. Evie advertises solely on her internet website. Stinky has sold 60 bars and 80 liquid soap dispensers. She charges $5 and $10 each for the products, respectively. Her website hosting site charges $.60 for each unit sold. Evie has replenished her inventory by purchasing 50 units of each type of soap from the manufacturer at the same cost as her initial…
Given the following balance sheet data, calculate net working capital: cash = OMR25, accounts receivable %3D = OMR80, inventory = OMR120, %3D net fixed assets = OMR400, %3D accounts payable = OMR15, short- %3D
Match (by letter) the following items with the description or example that best fits. Each letter is used only once.Terms1. Operating activities.2. Investing activities.3. Financing activities.4. Noncash activities.5. Indirect method.6. Direct method.7. Depreciation expense.8. Cash return on assets.Descriptionsa. Begins with net income and then lists adjustments to net income in order to arrive at operating cash flows.b. Item included in net income, but excluded from net operating cash flows.c. Net cash flows from operating activities divided by average total assets.d. Cash transactions involving lenders and investors.e. Cash transactions involving net income.f. Cash transactions for the purchase and sale of long-term assets.g. Purchase of long-term assets by issuing stock to seller.h. Shows the cash inflows and outflows from operations such as cash received from customers and cash paid for inventory, salaries, rent, interest, and taxes.
Zoogle has the following selected data ($ in millions):Net sales $24,651Net income 6,620Operating cash flows 9,326Total assets, beginning 41,768Total assets, ending 50,497Required:1. Calculate the return on assets.2. Calculate the cash return on assets.3. Calculate the cash flow to sales ratio and the asset turnover ratio.
CONTINUING PROBLEM: FRONT ROW ENTERTAINMENT The income statement and comparative balance sheet for Front Row Entertainment are shown below: What conclusions can you draw about Front Row from the observed pattern of cash flows?
Reporting Net Cash Flow from Operating Activities The following information is available for Cornelius Inc: Required: 1. Compute the net cash flows from operating activities using the indirect method. 2. CONCEPTUAL CONNECTION Explain why Cornelius was able to report net cash flow from operating activities that was higher than net income. 3. CONCEPTUAL CONNECTION What could the difference between net income and cash flow from operating activities signal to financial statement users?
Which of the following shows how paying cash to purchase suppites will affect a company's financial statements? Multiple Choice Assets Assets Balance Sheet Llab, + NA Assets Balance Sheet Liab. + Equity NA Balance Sheet Assets - Llab -10 NA Equity NA Balance Sheet Llab. NA Equity NA Equity Rev NA Rev. NA Rev NA Rev. NA Income Statement Exp NA Net Inc. NA Income Statement - Exp. Net Inc. Income Statement Exp NA -Net Inc. NA Income Statement Exp NA Net Inc. NA Statement of Cash Flows - OA Statement of Cash Flows NA Statement of Cash Flows NA Statement of Cash Flows
INSTRUCTIONS: Use the account information below to construct (1) 2023 multi-step income statement, (2) 2023 classified balance sheet, and (3) 2023 statement of cash flow--indirect. 12/31/2023 Account Title Accounts Payable Accounts Receivable Accrued Expenses Payable Accumulated Depreciation Additional Paid-in Capital in Excess of par Administrative Expense Available-for-sale securities Buildings Cash Common Stock ($2 par/share) Cost of Goods Sold Cumulative Comprehensive Income Items Deferred Revenue---deposits by customers Depreciation Expense Dividend Revenue Dividends declared on common stock Dividends paid on preferred stock Dividends Payable Equipment Franchise Gain (gross) on asset sale of discontinued division Gain on sale of trading securities Goodwill Hold-to-maturity securities Income tax payable Income Tax Provision--expense Interest Expense Inventories Interest Revenue Land Land held for expansion Operating Loss (gross) of discontinued division Note Payable in 2030 Note…
View Policies Current Attempt in Progress The following information is available for Ivanhoe Company for the year ended December 31, 2022. Beginning cash balance Accounts payable decrease Depreciation expense Accounts receivable increase Inventory increase Net income Cash received for sale of land at book value Cash dividends paid Income taxes payable increase Cash used to purchase building Cash used to purchase treasury stock Cash received from issuing bonds Cash Flows from Operating Activities Net Income $78,750 Adjustments to reconcile net income to 6,475 Net Cash Provided by Operating Activities 283,500 14,350 19,250 497,175 61,250 21,000 Prepare a statement of cash flows using the indirect method. (Show amounts that decrease cash flow with either a-sign e.g.-15 parenthesis e.g. (15,000).) 8,225 505,750 45,500 Ivanhoe Company Statement of Cash Flows-Indirect Method For the Year Ended December 31, 2022 350,000 MacBook Air
Use the following data to construct a statement of cash flows using the direct method. Balances 20X19 20X18 Statement of Financial Position Cash Accounts receivables Prepaid insurance Inventory Fixed asset Accumulated depreciation Total assets Accounts payable Wages payable Note payable Capital Retained earnings Total liability and equity Statement of P/L and other comprehensive income Sales Cost of sales Depreciation expense Insurance expense Wage expense Net income 4,000 25,000 5,000 37,000 316,000 (45,000) 342,000 18,000 4,000 173,000 88,000 59,000 342,000 200,000 (123,000) (15,000) (11,000) (50,000) 1,000 14,000 32,500 7,000 34,000 270,000 (30,000) 327,500 16,000 7,000 160,000 84,000 60,500 327,500 Additional information Dividends declared and paid in 20X19 for R2,500 R46,000 was paid for new fixed assets in 20X19 Accounts payable was used only for inventory No debt was retired during 20X19
PARNELL COMPANY Income Statement For the Year Ended December 31, 2021 ($ in thousands) Revenues and gains: Sales $890 11 $901 Gain on sale of building Expenses and loss: Cost of goods sold Salaries $ 345 129 53 Insurance 132 Depreciation Interest expense Loss on sale of equipment 59 13 731 170 Income before tax 85 Income tax expense $ 85 Net income PARNELL COMPANY Selected Accounts from Comparative Balance Sheets December 31, 2021 and 2020 ($ in thousands) Year Change $ 61 2021 2020 Cash 152 91 Accounts receivable Inventory 342 207 135 312 57 228 120 78 181 (131) (49) 120 36 17 (37) 443 Prepaid insurance Accounts payable Salaries payable Deferred tax liability Bond discount 106 108 84 61 218