Question

In: Accounting

Statement of Cash Flows—Indirect Method The income statement for Astro Inc. for 2017 is as follows:...

Statement of Cash Flows—Indirect Method

The income statement for Astro Inc. for 2017 is as follows:

For the Year Ended
December 31, 2017
Sales revenue $500,000
Cost of goods sold 400,000
  Gross profit $100,000
Operating expenses 180,000
  Loss before interest and taxes $(80,000)
Interest expense 20,000
  Net loss $(100,000)

Presented here are comparative balance sheets:

December 31
2017 2016
Cash $95,000 $80,000
Accounts receivable 50,000 75,000
Inventory 100,000 150,000
Prepayments 55,000 45,000
   Total current assets $300,000 $350,000
Land $475,000 $400,000
Plant and equipment 870,000 800,000
Accumulated depreciation (370,000) (300,000)
   Total long-term assets $975,000 $900,000
   Total assets $1,275,000 $1,250,000
Accounts payable $125,000 $100,000
Other accrued liabilities 35,000 45,000
Interest payable 15,000 10,000
   Total current liabilities $175,000 $155,000
Long-term bank loan payable $340,000 $250,000
Common stock $450,000 $400,000
Retained earnings 310,000 445,000
  Total stockholders' equity $760,000 $845,000
  Total liabilities and stockholders' equity $1,275,000 $1,250,000

Other information is as follows:

Dividends of $35,000 were declared and paid during the year.

Operating expenses include $70,000 of depreciation.

Land and plant and equipment were acquired for cash, and additional stock was issued for cash. Cash also was received from additional bank loans.

The president has asked you some questions about the year's results. He is disturbed with the $100,000 net loss for the year. He notes, however, that the cash position at the end of the year is improved. He is confused about what appear to be conflicting signals: "How could we have possibly added to our bank accounts during such a terrible year of operations?"

Required:

1. Prepare a statement of cash flows for 2017 using the indirect method in the Operating Activities section. Use the minus sign to indicate net loss, cash payments, cash outflows, or decreases in cash.

Astro Inc.
Statement of Cash Flows
For the Year Ended December 31, 2017
Cash Flows from Operating Activities
$
Adjustments to reconcile net income to net cash provided by operating activities:
$
$
Cash Flows from Investing Activities
$
$
Cash Flows from Financing Activities
$
$
$
Cash balance, December 31, 2016
Cash balance, December 31, 2017 $

2. Despite a net loss for the year, Astro was able to increase its cash at the end of the year

     

     Astro can increase its net profits by

     

Solutions

Expert Solution

Required: Statement of cash flows for 2017 using the indirect method in the Operating Activities section only

Solution:

Amount in $
Cash flow from operating activities:
Net loss as per income statement       -1,00,000
Add: Non cash items of income statement
Depreciation           70,000
Add: Items of Financing activities
Interest           20,000
Adjustment for changes in working capital
Account receivables           25,000
Prepayments          -10,000
Inventory           50,000
Accounts payables           25,000
Other accrured liabilities          -10,000
Net cash inflow from operating activities before tax           70,000
Less: Tax paid if any                  -  
Net cash inflow from operating activities after tax         70,000

As above the statement of cash flow showing net cash inflow from operating activities is $70,000.


Related Solutions

Prepare statement of cash flows using the indirect method. The income statement for 2017 and the...
Prepare statement of cash flows using the indirect method. The income statement for 2017 and the balance sheets for 2017 and 2016 are presented for GibsonGibson ​Industries, Inc. LOADING... ​(Click the icon to view the income​ statement.)                                             LOADING... ​(Click the icon to view the balance​ sheets.) LOADING... ​(Click the icon to view additional​ information.) Requirement Prepare a statement of cash flows for GibsonGibson ​Industries, Inc., for the year ended December​ 31,2017​, using the indirect method. Prepare the statement one section...
Prepare statement of cash flows using the indirect method. The income statement for 2017 and the...
Prepare statement of cash flows using the indirect method. The income statement for 2017 and the balance sheets for 2017 and 2016 are presented for Gibson​ Industries, Inc. ​ ​ LOADING... ​(Click the icon to view additional​ information.) Requirement Prepare a statement of cash flows for Gibson Industries, Inc., for the year ended December​ 31,2017​, using the indirect method. Prepare the statement one section at a time. ​(Use parentheses or a minus sign for numbers to be subtracted and for...
Statement of Cash Flows—Indirect Method The following statement of cash flows for Shasta Inc. was not...
Statement of Cash Flows—Indirect Method The following statement of cash flows for Shasta Inc. was not correctly prepared. The cash balance at the beginning of the year was $240,000. All other amounts are correct, except the cash balance at the end of the year. Shasta Inc. Statement of Cash Flows For the Year Ended December 31, 20Y9 Cash flows from operating activities: Net income $360,000 Adjustments to reconcile net income to net cash flow from operating activities:    Depreciation 100,800    Gain...
Operating Section of Statement of Cash Flows (Indirect Method) Assume following are the income statement and...
Operating Section of Statement of Cash Flows (Indirect Method) Assume following are the income statement and balance sheet for Nike for the year ended May 31, 2012, and a forecasted income statement and balance sheet for 2013. Income Statement ($ millions) 2012 actual 2013 Est. Revenues $ 18,627.0 $ 21,253.0 Cost of sales 10,239.6 11,689.0 Gross margin 8,387.4 9,564.0 Selling and administrative expense 5,953.7 6,801.0 Operating profit 2,433.7 2,763.0 Interest income, net 77.1 77.1 Other (expense) income, net (7.9) (7.9)...
Operating Section of Statement of Cash Flows (Indirect Method) Assume following are the income statement and...
Operating Section of Statement of Cash Flows (Indirect Method) Assume following are the income statement and balance sheet for Nike for the year ended May 31, 2012, and a forecasted income statement and balance sheet for 2013. Income Statement ($ millions) 2012 actual 2013 Est. Revenues $ 18,627.0 $ 21,253.0 Cost of sales 10,239.6 11,689.0 Gross margin 8,387.4 9,564.0 Selling and administrative expense 5,953.7 6,801.0 Operating profit 2,433.7 2,763.0 Interest income, net 77.1 77.1 Other (expense) income, net (7.9) (7.9)...
Prepare a statement of cash flows, using the indirect method, with the information which follows: ABC...
Prepare a statement of cash flows, using the indirect method, with the information which follows: ABC Company reports the following comparative balance sheet: ABC Company Balance Sheet Dec 2018/2017 Assets 2017 2018 Cash 37,000 54,000 Accounts Receivable 26,000 68,000 Inventory - 54,000 Prepaid expenses 6,000 4,000 Land 70,000 45,000 Buildings 200,000 200,000 Accumulated Depreciation - buildings (11,000) (21,000) equipment 68,000 193,000 Accumulated Depreciation - equipment (10,000) (28,000) total assets 386,000 569,000 In addition, ABC Company reports the following income statement...
Statement of Cash Flows (Indirect Method) The Rainbow Company's income statement and comparative balance sheets as...
Statement of Cash Flows (Indirect Method) The Rainbow Company's income statement and comparative balance sheets as of December 31 of 2013 and 2012 follow: RAINBOW COMPANY Income Statement For the Year Ended December 31, 2013 Sales Revenue $825,000 Dividend Income 16,500 841,500 Cost of Goods Sold $484,000 Wages and Other Operating Expenses 143,000 Depreciation Expense 42,900 Patent Amortization Expense 7,700 Interest Expense 14,300 Income Tax Expense 48,400 Loss on Sale of Equipment 5,500 Gain on Sale of Investments (11,000) 734,800...
Statement of Cash Flows (Indirect Method) The Wolff Company’s income statement and comparative balance sheets at...
Statement of Cash Flows (Indirect Method) The Wolff Company’s income statement and comparative balance sheets at December 31 of 2016 and 2015 are shown below: WOLFF COMPANY Income Statement For the Year Ended December 31, 2016 Sales Revenue $645,000 Cost of Goods Sold $430,000 Wages Expense 86,000 Insurance Expense 12,000 Depreciation Expense 13,000 Interest Expense 12,000 Income Tax Expense 29,000 582,000 Net Income $63,000 WOLFF COMPANY Balance Sheets Dec. 31, 2016 Dec. 31, 2015 Assets Cash $52,000 $8,000 Accounts Receivable...
Statement of Cash Flows (Indirect Method) Arctic Company's income statement and comparative balance sheets as of...
Statement of Cash Flows (Indirect Method) Arctic Company's income statement and comparative balance sheets as of December 31 of 2013 and 2012 follow: ARCTIC COMPANY Income Statement For the Year Ended December 31, 2013 Sales Revenue $873,600 Cost of Goods Sold $640,800 Wages Expense 228,000 Advertising Expense 37,200 Depreciation Expense 26,400 Interest Expense 21,600 Gain on Sale of Land (30,000) 924,000 Net Loss $(50,400) ARCTIC COMPANY Balance Sheets Dec. 31, 2013 Dec. 31, 2012 Assets Cash $48,720 $33,600 Accounts Receivable...
Statement of Cash Flows (Indirect Method) The Wolff Company's income statement and comparative balance sheets at...
Statement of Cash Flows (Indirect Method) The Wolff Company's income statement and comparative balance sheets at December 31 of 2013 and 2012 are shown below: WOLFF COMPANY Income Statement For the Year Ended December 31, 2013 Sales Revenue $889,000 Cost of Goods Sold $602,000 Wages Expense 120,400 Insurance Expense 11,200 Depreciation Expense 23,800 Interest Expense 12,600 Income Tax Expense 40,600 810,600 Net Income $78,400 WOLFF COMPANY Balance Sheets Dec. 31, 2013 Dec. 31, 2012 Assets Cash $15,400 $7,000 Accounts Receivable...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT