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,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
  Cash $ 130,680 $ 181,640
  Accounts receivable 155,600 121,160
  Merchandise inventory 623,200 575,600
  Prepaid expenses 12,140 24,000
  Equipment 359,280 256,400
  Accumulated depreciation 87,560 108,560
  Accounts payable 189,500 243,240
  Current notes payable 32,400 24,000
  Notes payable 210,000 122,400
  Common shares 460,800 360,000
  Retained earnings 300,640 300,600

Additional information regarding ICE Drilling’s activities during 2017:
1. Loss on sale of equipment is $13,480.
2. Paid $72,280 to reduce a long-term note payable.
3. Equipment costing $115,000, with accumulated depreciation of $73,000, is sold for cash.
4. Equipment costing $217,880 is purchased by paying cash of $58,000 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 $141,160.

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.)

ICE DRILLING INC.
Statement of Cash Flows
For Year Ended December 31, 2017
Cash flows from operating activities:
Adjustments to reconcile profit to net cash inflows from operating activities:
$0
Cash flows from investing activities:
0
Cash flows from financing activities:
0
$0

Solutions

Expert Solution

notes payable purchased
ending balance on 2017 210,000
ending balance on 2016 122,200
Redeemed during the year -72,280 49,920
notes payable for Equipment purchase 160,080
Cash from sale of Equipment
original cost 115,000
less accumulated dep -73,000
book value 42,000
less loss on sale -13,480
Cash from sale of Equipment 28,520
Statement of cash flow
Cash from operating activities
net income for the year 141,200
Adjustments to reconcile profit to
cash flows from operating activities
Depreciation expense 52,000
loss on sale of Equipment 13,480
increase in account receivable -34440
increase in merchandise inventory -47600
decrease in prepaid expense 11860
Decrease in accounts payable -53740
Cash flow from operating activities 82,760
Cash flow from investing activities
cash from sale of Equipment 28,520
Cash paid for purchase of Equipment -58,000
Cash used by investing activities -29,480
Cash flow from financing activity
cash paid to reduce long term note -72,280
cash from short term note payable 8,400
Cash from stock issue 100800
Cash dividend -141,160
Cash used by financing activity -104,240 -104,240
Net decrease in cash -50,960
Cash at the beginning of the year 181,640
Cash at year end 130,680

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,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...
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