Question

In: Accounting

ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income...

ICE Drilling Inc.’s balance sheet information and income statement are as follows:

ICE Drilling Inc.
Income Statement
For Year Ended December 31, 2017
  Sales $ 1,113,200
  Cost of goods sold 568,000
  Gross profit $ 545,200
  Operating expenses:
     Depreciation expense $ 50,000
     Other expenses 307,360
     Total operating expenses 357,360
  Profit from operations 187,840
  Loss on sale of equipment   13,080
  Profit before taxes $ 174,760
  Income taxes 28,760
  Profit $ 146,000
ICE Drilling Inc.
Comparative Balance Sheet Information
December 31
2017 2016
  Cash $ 128,680 $ 179,640
  Accounts receivable 153,600 119,160
  Merchandise inventory 621,200 573,600
  Prepaid expenses 12,120 22,000
  Equipment 358,880 254,400
  Accumulated depreciation 85,560 106,560
  Accounts payable 191,080 246,840
  Current notes payable 30,400 22,000
  Notes payable 210,000 122,000
  Common shares 458,800 358,000
  Retained earnings 298,640 293,400


Additional information regarding ICE Drilling’s activities during 2017:
1. Loss on sale of equipment is $13,080.
2. Paid $71,880 to reduce a long-term note payable.
3. Equipment costing $113,000, with accumulated depreciation of $71,000, is sold for cash.
4. Equipment costing $217,480 is purchased by paying cash of $57,600 and signing a long-term note payable for the balance.
5. Borrowed $8,400 by signing a short-term note payable.
6. Issued 10,080 common shares for cash at $10 per share.
7. Declared and paid cash dividends of $140,760.


Required:
Prepare a statement of cash flows for 2017 that reports the cash inflows and outflows from operating activities according to the indirect method. (List any deduction in cash and cash outflows as negative amounts.)

Solutions

Expert Solution

Answer-

ICE DRILLING INC.
STATEMENT OF CASH FLOWS (USING INDIRECT METHOD)
FOR THE YEAR ENDED 31 DECEMBER,2017
Particulars Amount
$
Cash flow from operating activities
Net Income 146000
Adjustments to reconcile net income to net cash provided by operating activities
Adjustment for non cash effects
Depreciation expenses 50000
Loss on sale of equipment 13080
Change in operating assets & liabilities
Increase in accounts receivable -34440
Increase in merchandise inventory -47600
Decrease in prepaid expenses 9880
Decrease in accounts payable -55760
Net cash flow from operating activities (a) 81160
Cash Flow from Investing activities
New equipment purchased -57600
Old equipment sold 28920
Net cash Flow from Investing activities (b) -28680
Cash Flow from Financing activities
Cash dividends paid -140760
Common stock issued 100800
Short term notes issued 8400
Long term notes paid -71880
Net cash Flow from Financing activities (c) -103440
Net Change in cash c=a+b+c -50960
Beginning cash balance 179640
Closing cash balance 128680
Schedule of non cash investing & financing activities
Issuance of long term notes for purchase of equipment ($217480-$57600) 159880

Related Solutions

ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income Statement For Year Ended December 31, 2017   Sales $ 1,113,600   Cost of goods sold 570,000   Gross profit $ 543,600   Operating expenses:      Depreciation expense $ 52,000      Other expenses 307,760      Total operating expenses 359,760   Profit from operations 183,840   Loss on sale of equipment   13,480   Profit before taxes $ 170,360   Income taxes 29,160   Profit $ 141,200 ICE Drilling Inc. Comparative Balance Sheet Information December 31 2017 2016...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income...
ICE Drilling Inc.’s balance sheet information and income statement are as follows: ICE Drilling Inc. Income Statement For Year Ended December 31, 2017   Sales $ 1,113,200   Cost of goods sold 568,000   Gross profit $ 545,200   Operating expenses:      Depreciation expense $ 50,000      Other expenses 307,360      Total operating expenses 357,360   Profit from operations 187,840   Loss on sale of equipment   13,080   Profit before taxes $ 174,760   Income taxes 28,760   Profit $ 146,000 ICE Drilling Inc. Comparative Balance Sheet Information December 31 2017 2016...
LAG Network Inc.’s balance sheet and income statement are as follows: LAG Network Inc. Income Statement...
LAG Network Inc.’s balance sheet and income statement are as follows: LAG Network Inc. Income Statement For Year Ended December 31, 2017   Sales $ 933,600   Cost of goods sold 561,200   Gross profit $ 372,400   Operating expenses:      Depreciation expense $   25,200      Other expenses 241,800         Total operating expenses 267,000   Profit from operations $ 105,400   Income taxes 23,600   Profit $ 81,800 LAG Network Inc. Comparative Balance Sheet Information December 31   Assets 2017 2016   Cash $ 81,240 $ 55,400   Accounts receivable 47,400 38,600...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for...
Selected balance sheet and income statement information follows for Snap Inc. and Golden Eagle Inc. for the fiscal year ended January 30, 2020. For Fiscal Year Ended Jan. 30, 2020 ($ millions) Snap Golden Eagle Income statement information: Interest expense $236 $6 Income before interest and taxes 9,296 1,932 Balance sheet information: Cash and cash equivalents 7,946 1,534 Accounts receivable 1,692 478 Current assets 24,309 4,410 Current liabilities 15,971 2,691 Total assets 46,333 9,833 Total liabilities 30,554 3,422 Total stockholders’...
Selected are recent balance sheet and income statement information from Coach Inc. and Ann Taylor follows:...
Selected are recent balance sheet and income statement information from Coach Inc. and Ann Taylor follows: ($ millions) Ann Taylor Coach Inc Sales $2,212 $4,763 Cost of goods sold 1,004 1,297 Average accounts receivable 19 159 Average inventory 204 463 Average total assets 907 2,870 Required For each company, compute the following: Accounts receivable turnover Inventory turnover Asset turnover Interpret and comment on any differences you observe between the turnover rates for these two companies, i.e. for each ratio, which...
The Income statement and Balance Sheet for Day Light Robbery Inc. is given as follows: INCOME...
The Income statement and Balance Sheet for Day Light Robbery Inc. is given as follows: INCOME STATEMENT Sales $5,650,000 COGS 3,865,000 Depreciations 650,100 EBIT 1,134,900 Interest Expense 325,000 Taxable Income 809,900 Taxes 161,980 Net Income 647,920 Dividends $ 259,168 BALANCE SHEET ASSETS LIABILITIES & OWNERS EQUITY Current Assets 1,251,000 Current Liabilities 975,000 Long Term Debt 900,000 Net Fixed Asset 8,734,000 Common Stock 6,975,000 Accumulated Retained Earnings 1,135,000 Total Owner’s Equity 8,110,000 Total Assets 9,985,000 Total Liabilities & Equity 9,985,000 The...
LAG network inc. balance sheet and income statement are as follows LAG network inc. income statemment...
LAG network inc. balance sheet and income statement are as follows LAG network inc. income statemment for year ended dec. 31 2020 sales                                             922600 cogs                                               550200 gross profit                                     $ 372400 operating expenses: depreciation expense    25200 other expenses                226800 total operating expenses                 252000 profit from operations                      $ 120400 invome taxes                                           12600 profit                                                       $107800              LAG network inc. comperative balance sheet information dec 31 assets                                    2020               2019 cash                                         81130        53200 acc. receviable                       40400       37200 merchandise inventory       283770       238600 equipment                              148400     137200 acc....
Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2016 2015...
Selected balance sheet and income statement information from Verizon Communications Inc. follows. $ millions 2016 2015 Current assets . . . . . . . . . . . . . . . . . . . . . . . . . $ 26,395 $ 22,355 Current liabilities. . . . . . . . . . . . . . . . . . . . . . . . 30,340 35,052 Total debt . . . ....
The balance sheet and income statement for Cruise Corporation are as follows:
The balance sheet and income statement for Cruise Corporation are as follows:                                                                                                                      Balance Sheet as of December 31, 2020                                                                                                                                ASSETS                                                                         LIABILITIES & EQUITY                          Cash & marketable securities $2,000             Accounts payable                    $30,000             Accounts Receivable               35,000             Taxes payable                         9,000             Inventory                                 15,000             Short-term borrowings           12,000             Total current assets                $52,000           Total current liabilities           $51,000             Net P,P & E                              $448,000         Long-term debt                       $200,000             TOTAL ASSETS                         $500,000         Total liabilities                        $251,000                                                                                     Common stock at par             $80,000                                                                                     Additional paid-in capital       $30,000                                                                                     Retained earnings                   $139,000                                                                         TOTAL LIABILITIES & EQUITY             ...
The latest income statement, balance sheet and other related information for ABC Company is as follows:...
The latest income statement, balance sheet and other related information for ABC Company is as follows: Net Sales Revenue = $1,000,000 COGS = $600,000 (60% of Sales) Operating Expenses = $200,000 (20% of Sales) Interest Expense = $20,000 (10% of Long Term Debt) Tax Expense = $54,000 (30% of Earnings Before Taxes) Net Income = $126,000 Addition to Retained Earnings = $88,200 (70% of Net Income) Current Assets = $700,000 (70% of Sales) Net Fixed Assets = $900,000 (90% of...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT