![Excel Applications for Accounting Principles](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
![Gemstone Distributors reports net income of $63,000. Included in that number is depreciation expense of $14,000 and a loss on the
sale of land of $5,800. A comparison of this year's and last year's balance sheets reveals a decrease in accounts receivable of
$33,000, a decrease in inventory of $19,000, and an increase in accounts payable of $53,000.
Required:
Prepare the operating activities section of the statement of cash flows using the indirect method. (Amounts to be deducted should be
indicated with a minus sign.)
GEMSTONE DISTRIBUTORS
Statement of Cash Flows (partial)
Cash flows from operating activities:
Adjustments to reconcile net income to net cash flows from operating activities:
Net cash flows from operating activities](https://content.bartleby.com/qna-images/question/1765d600-8655-4a72-b587-0952f1971cb0/039a358f-6437-46b0-aaca-16b34ee9bf41/fktzchdp_thumbnail.png)
Transcribed Image Text:Gemstone Distributors reports net income of $63,000. Included in that number is depreciation expense of $14,000 and a loss on the
sale of land of $5,800. A comparison of this year's and last year's balance sheets reveals a decrease in accounts receivable of
$33,000, a decrease in inventory of $19,000, and an increase in accounts payable of $53,000.
Required:
Prepare the operating activities section of the statement of cash flows using the indirect method. (Amounts to be deducted should be
indicated with a minus sign.)
GEMSTONE DISTRIBUTORS
Statement of Cash Flows (partial)
Cash flows from operating activities:
Adjustments to reconcile net income to net cash flows from operating activities:
Net cash flows from operating activities
Expert Solution
![Check Mark](/static/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
![Blurred answer](/static/blurred-answer.jpg)
Knowledge Booster
Similar questions
- Gemstone Distributors reports net income of $60,000. Included in that number is depreciation expense of $12,500 and a loss on the sale of land of $5,500. A comparison of this year's and last year's balance sheets reveals a decrease in accounts receivable of $30,000, a decrease in inventory of $17,500, and an increase in accounts payable of $50,000. Required: Prepare the operating activities section of the statement of cash flows using the indirect method. (Amounts to be deducted should be indicated with a minus sign.) Cash flows from operating activities: GEMSTONE DISTRIBUTORS Statement of Cash Flows (partial) Adjustments to reconcile net income to net cash flows from operating activities: Net cash flows from operating activitiesarrow_forwardSoftware Distributors reports net income of $65,000. Included in that number is depreciation expense of $15,000 and a loss on the sale of land of $6,000. A comparison of this year’s and last year’s balance sheets reveals a decrease in accounts receivable of $28,000, a decrease in inventory of $37,000, and an increase in accounts payable of $45,000. Required: Prepare the operating activities section of the statement of cash flows using the indirect method. Do you see a pattern in Software Distributors’ adjustments to net income to arrive at operating cash flows? What might this imply?arrow_forwardThe net income reported on the income statement for the current year was $73,600. Depreciation recorded on store equipment for the year amounted to $27,400. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of YearCash $23,500 $18,700Accounts receivable (net) 56,000 48,000Merchandise inventory 35,500 40,000Prepaid expenses 4,750 7,000Accounts payable (merchandise…arrow_forward
- The income statement disclosed the following items for the year: Depreciation expense $40,700 Gain on disposal of equipment 23,760 Net income 254,700 The changes in the current asset and liability accounts for the year are as follows: Increase (Decrease) Accounts receivable $6,340 Inventory (3,610) Prepaid insurance (1,350) Accounts payable (4,300) Income taxes payable 1,350 Dividends payable 950 a. Prepare the Cash Flows from (used for) Operating Activities section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash outflows, cash payments, decreases in cash, or any negative adjustments. Statement of Cash Flows (partial) Cash flows from (used for) operating activities: Adjustments to reconcile net income to net cash flows from (used for) operating activities: Changes in current operating assets and liabilities: Net cash flows from operating activities b. Why is net cash flows from operating activities different than net income? Cash flows…arrow_forwardThe income statement disclosed the following items for the year: Line Item Description Amount Depreciation expense $43,900 Gain on disposal of equipment 25,610 Net income 292,200 The changes in the current asset and liability accounts for the year are as follows: Line Item Description Increase (Decrease) Accounts receivable $6,840 Inventory (3,890) Prepaid insurance (1,460) Accounts payable (4,640) Income taxes payable 1,460 Dividends payable 1,020 Question Content Area a. Prepare the "Cash flows from (used for) 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. blankStatement of Cash Flows (partial) Line Item Description Amount Amount Cash flows from (used for) operatingactivities: $Net income Adjustments to reconcile net incometo net cash flows from (used for) operating…arrow_forwardThe net income reported on the income statement for the current year was $152,300. Depreciation recorded on store equipment for the year amounted to $25,100. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: Line Item Description End of Year Beginning of Year Cash $61,530 $55,990 Accounts receivable (net) 44,120 41,380 Inventories 60,240 62,990 Prepaid expenses 6,770 5,320 Accounts payable (merchandise creditors) 57,650 52,970 Wages payable 31,500 34,600 Question Content Area a. Prepare the “Cash flows from (used for) operating activities” section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash outflows, cash payments, decreases in cash, or any negative adjustments. blankblank Line Item Description Amount Amount Cash flows from (used for) operating activities: $Net income Adjustments to reconcile net income to net cash flows from…arrow_forward
- The net income reported on the income statement for the current year was $143,700. Depreciation recorded on store equipment for the year amounted to $23,700. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $55,900 $51,430 Accounts receivable (net) 40,080 38,010 Inventories 54,730 57,860 Prepaid expenses 6,150 4,890 Accounts payable (merchandise creditors) 52,380 48,650 Wages payable 28,620 31,780 a. 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 outflows, cash payments, decreases in cash, or any negative adjustments.arrow_forwardThe net income reported on the income statement for the current year was $149,900. Depreciation recorded on store equipment for the year amounted to $24,700. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: ETT End of Year Beginning of Year Cash $59,660 $54,290 Accounts receivable (net) 42,780 40,120 Inventories 58,410 61,080 Prepaid expenses 6,560 5,160 Accounts payable (merchandise creditors) 55,900 51,360 Wages payable 30,550 33,550 a. 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 outflows, cash payments, decreases in cash, or any negative adjustments. 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 b. Cash flows from…arrow_forwardThe net income reported on the income statement for the current year was $142,900. Depreciation recorded on store equipment for the year amounted to $23,600. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $55,020 $50,070 Accounts receivable (net) 39,450 37,000 Inventories 53,860 56,330 Prepaid expenses 6,050 4,760 Accounts payable (merchandise creditors) 51,550 47,370 Wages payable 28,170 30,940 a. 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 outflows, cash payments, decreases in cash, or any negative adjustments. 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…arrow_forward
- Dundee Co. reported the following for the current year: net sales of $80,000; cost of goods sold of $60,000; beginning balance of total assets of $115,000; and ending balance of total assets of $85,000. Compute total asset turnover. Round to one decimal.arrow_forwardThe net income reported on the income statement for the current year was $311,700. Depreciation recorded on equipment and a building amounted to $93,200 for the year. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: Line Item Description End of Year Beginning of Year Cash $78,550 $83,260 Accounts receivable (net) 99,600 102,740 Inventories 196,380 177,010 Prepaid expenses 10,920 11,740 Accounts payable (merchandise creditors) 87,740 92,920 Salaries payable 12,650 11,570 Question Content Area a. Prepare the "Cash flows from (used for) operating activities" section of the statement of cash flows, using the indirect method. Use the minus sign to indicate cash outflows, cash payments, decreases in cash, or any negative adjustments. blankblankStatement of Cash Flows (partial) Line Item Description Amount Amount Cash flows from (used for) operating activities: $Net income…arrow_forwardThe net income reported on the income statement for the current year was $73,600. Depreciation recorded on store equipment for the year amounted to $27,400. Balances of the current asset and current liability accounts at the beginning and end of the year are as follows: End of Year Beginning of Year Cash $23,500 $18,700 Accounts receivable (net) 56,000 48,000 Merchandise inventory 35,500 40,000 Prepaid expenses 4,750 7,000 Accounts payable (merchandise creditors) 21,800 16,800 Wages payable 4,900 5,800 A.Prepare the Cash Flows from (used for) Operating Activities section of the statement of cash flows, using the indirect method. B.Briefly explain why net cash flows from operating activities is different from net income.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Excel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage LearningSurvey of Accounting (Accounting I)AccountingISBN:9781305961883Author:Carl WarrenPublisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111581565/9781111581565_smallCoverImage.gif)
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305961883/9781305961883_smallCoverImage.gif)
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning