Using Excel to Calculate Cash Flows from Operations Using the Indirect MethodPROBLEMThe following is financial information for three companies.Sales revenueCost of goods soldSelling and administrativeDepreciation expenseInterest expenseIncome tax expenseDividends paidIncrease /(Decrease) inAccounts receivableInventoryProperty, plant, and equipmentAccounts payableInterest payableIncome tax payableNotes payableCommon sharesBlue spruce$Marx Ltd. Tamarisk Ltd.458,300 $ 689,500 $1,123,600250,90079,8007,5002,70023,00011,000(2,900)3,40060,9006,400(1,400)396,900112,20021,9001,20042,0006,2007,200(10,100)(13,400)(10,500)1,8004,200(2,800)23,300 (47,800)35,300(4,400)743,400126,50034,4004,20056,80031,400(9,900)18,60071,3003,940(500)9,10010,000(95,200) Student Work AreaRequired: Provide input into cells shaded in yellow in this template. Input therequired mathematical formulas or functions with cell references to the Problemarea or work area as indicated.For each company, calculate net income and cash flow from operations using theindirect method.Net IncomeCash flow from operationsBlue Spruce Ltd. Marx Ltd.Tamarisk Ltd.

A Cash flow statement is a financial statement that provides the summarised information regarding…

Using Excel to Calculate Cash Flows from Operations Using the Indirect Method PROBLEM The following is financial information for three companies. Sales revenue Cost of goods sold Selling and administrative Depreciation expense Interest expense Income tax expense Dividends paid Increase /(Decrease) in Accounts receivable Inventory Property, plant, and equipment Accounts payable Interest payable Income tax payable Notes payable Common shares Blue spruce $ Marx Ltd. Tamarisk Ltd. 458,300 $ 689,500 $1,123,600 250,900 79,800 7,500 2,700 23,000 11,000 (2,900) 3,400 60,900 6,400 (1,400) 4,200 23,300 35,300 396,900 112,200 21,900 1,200 42,000 6,200 7,200 (10,100) (13,400) (10,500) 1,800 (2,800) (47,800) (4,400) 743,400 126,500 34,400 4,200 56,800 31,400 (9,900) 18,600 71,300 3,940 (500) 9,100 10,000 (95,200)

Using Excel to Calculate Cash Flows from Operations Using the Indirect Method PROBLEM The following is financial information for three companies. Sales revenue Cost of goods sold Selling and administrative Depreciation expense Interest expense Income tax expense Dividends paid Increase /(Decrease) in Accounts receivable Inventory Property, plant, and equipment Accounts payable Interest payable Income tax payable Notes payable Common shares Blue spruce $ Marx Ltd. Tamarisk Ltd. 458,300 $ 689,500 $1,123,600 250,900 79,800 7,500 2,700 23,000 11,000 (2,900) 3,400 60,900 6,400 (1,400) 4,200 23,300 35,300 396,900 112,200 21,900 1,200 42,000 6,200 7,200 (10,100) (13,400) (10,500) 1,800 (2,800) (47,800) (4,400) 743,400 126,500 34,400 4,200 56,800 31,400 (9,900) 18,600 71,300 3,940 (500) 9,100 10,000 (95,200)

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

Get Solve
Cash Flows from Operating Activities—Indirect Method Staley Inc. reported the following data: Net income $480,300 Depreciation expense 69,400 Loss on disposal of equipment 37,600 Increase in accounts receivable 10,300 Increase in accounts payable 10,300 Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments. Staley Inc. Statement of Cash Flows (partial) Cash flows from operating activities: Net income $fill in the blank 2 Adjustments to reconcile net income to net cash flow from operating activities: Depreciation fill in the blank 4 Loss on disposal of equipment fill in the blank 6 Changes in current operating assets and liabilities: Increase in accounts receivable fill in the blank 8 Increase in accounts payable fill in the blank 10 Net cash flow…
25.
Cash Flows from Operating Activities—Indirect Method Staley Inc. reported the following data: Net income $446,400 Depreciation expense 59,100 Loss on disposal of equipment 39,800 Increase in accounts receivable 27,200 Increase in accounts payable 10,700 Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments. Staley Inc. Statement of Cash Flows (partial) Cash flows from operating activities: $ Adjustments to reconcile net income to net cash flow from operating activities: Changes in current operating assets and liabilities: Net cash flow from operating activities $
1. What is the cash flow statement using the indirect method? 2. What is the free cash flow for this year?
Statement of cash flows—indirect method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Line Item Description December 31, 20Y9 December 31, 20Y8 Assets Cash $305,280 $281,690 Accounts receivable (net) 110,590 101,170 Inventories 312,180 299,530 Investments 0 116,050 Land 160,130 0 Equipment 344,450 264,830 Accumulated depreciation—equipment (80,640) (71,410) Total assets $1,151,990 $991,860 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $208,510 $195,400 Accrued expenses payable (operating expenses) 20,740 25,790 Dividends payable 11,520 8,930 Common stock, $10 par 62,210 48,600 Paid-in capital in excess of par—common stock 233,850 134,890 Retained earnings 615,160 578,250 Total liabilities and stockholders' equity $1,151,990 $991,860 Additional data obtained from an examination of the accounts in the ledger for 20Y9 are as follows: Equipment and land…
Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash $226,390 $211,080 Accounts receivable (net) 82,010 75,810 Inventories 231,510 224,450 Investments 0 86,960 Land 118,750 0 Equipment 255,440 198,450 Accumulated depreciation—equipment (59,800) (53,510) Total assets $854,300 $743,240 Liabilities and Stockholders' Equity Accounts payable $154,630 $146,420 Accrued expenses payable 15,380 19,320 Dividends payable 8,540 6,690 Common stock, $10 par 46,130 36,420 Paid-in capital: Excess of issue price over par-common stock 173,420 101,080 Retained earnings 456,200 433,310 Total liabilities and stockholders’ equity $854,300 $743,240 Additional data obtained from an examination of the accounts in the ledger for 20Y9 are as follows: Equipment and…
Statement of cash flows—indirect method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Line Item Description December 31, 20Y9 December 31, 20Y8 Assets Cash $230,690 $215,090 Accounts receivable (net) 83,570 77,250 Inventories 235,920 228,730 Investments 0 88,610 Land 121,010 0 Equipment 260,290 202,220 Accumulated depreciation—equipment (60,940) (54,530) Total assets $870,540 $757,370 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $157,570 $149,200 Accrued expenses payable (operating expenses) 15,670 19,690 Dividends payable 8,710 6,820 Common stock, $10 par 47,010 37,110 Paid-in capital in excess of par—common stock 176,720 103,000 Retained earnings 464,860 441,550 Total liabilities and stockholders' equity $870,540 $757,370 Additional data obtained from an examination of the accounts in the ledger for 20Y9 are as follows: Equipment and land were…
Statement of cash flows—indirect method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Line Item Description December 31, 20Y9 December 31, 20Y8 Assets Cash $269,900 $253,670 Accounts receivable (net) 97,780 91,110 Inventories 276,000 269,750 Investments 0 104,510 Land 141,570 0 Equipment 304,530 238,490 Accumulated depreciation—equipment (71,290) (64,310) Total assets $1,018,490 $893,220 Liabilities and Stockholders' Equity Accounts payable (merchandise creditors) $184,350 $175,960 Accrued expenses payable (operating expenses) 18,330 23,220 Dividends payable 10,180 8,040 Common stock, $10 par 55,000 43,770 Paid-in capital in excess of par—common stock 206,750 121,480 Retained earnings 543,880 520,750 Total liabilities and stockholders' equity $1,018,490 $893,220 Additional data obtained from an examination of the accounts in the ledger for 20Y9 are as follows: Equipment and land…
Cash Flows from Operating Activities—Indirect Method Staley Inc. reported the following data: Net income $298,400 Depreciation expense 59,600 Loss on disposal of equipment 24,800 Increase in accounts receivable 13,200 Increase in accounts payable 11,800 Prepare the Cash Flows from Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash out flows, cash payments, decreases in cash, or any negative adjustments.
Statement of Cash Flows—Indirect Method The comparative balance sheet of Merrick Equipment Co. for December 31, 20Y9 and 20Y8, is as follows: Dec. 31, 20Y9 Dec. 31, 20Y8 Assets Cash $239,460 $223,010 Accounts receivable (net) 86,750 80,100 Inventories 244,880 237,150 Investments 0 91,870 Land 125,600 0 Equipment 270,190 209,660 Accumulated depreciation—equipment (63,250) (56,540) Total assets $903,630 $785,250 Liabilities and Stockholders' Equity Accounts payable $163,560 $154,690 Accrued expenses payable 16,270 20,420 Dividends payable 9,040 7,070 Common stock, $10 par 48,800 38,480 Paid-in capital: Excess of issue price over par-common stock 183,440 106,790 Retained earnings 482,520 457,800 Total liabilities and stockholders’ equity $903,630 $785,250 Additional data obtained from an examination of the accounts in the ledger for 20Y9 are as follows: Equipment and…
Need answer