Excel Applications for Accounting Principles
4th Edition
ISBN: 9781111581565
Author: Gaylord N. Smith
Publisher: Cengage Learning
expand_more
expand_more
format_list_bulleted
Question
Expert Solution
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
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 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_forward
- The 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_forwardDundee 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_forwardFitz Company reports the following information. Selected Annual Income Statement Data Selected Year-End Balance Sheet Data Net income $ 391,000 Accounts receivable decrease $ 27,200 Depreciation expense 44,200 Inventory decrease 46,000 Amortization expense 8,000 Prepaid expenses increase 6,400 Gain on sale of plant assets 7,100 Accounts payable decrease 8,200 Salaries payable increase 1,900 Use the indirect method to prepare the operating activities section of its statement of cash flows for the year ended December 31. Note: Amounts to be deducted should be indicated with a minus sign.arrow_forward
- Prepare the company’s Statement of Profit or Loss for the year ended 31 March 20X3, in a form suitable for publication, together with its Statement of Financial Position as at that date. Support your response with full workings.arrow_forwardThe income statement disclosed the following items for the year: Depreciation expense $57,400 Gain on disposal of equipment 33,510 Net income 494,300 The changes in the current asset and liability accounts for the year are as follows: Increase(Decrease) Accounts receivable $8,950 Inventory (5,090) Prepaid insurance (1,910) Accounts payable (6,070) Income taxes payable 1,910 Dividends payable 1,340 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_forwardAneko Company reports the following: net sales of $17,500 for Year 2 and $16,625 for Year 1; end-of-year total assets of $18,000 for Year 2 and $16,500 for Year 1. 1. Compute its total asset turnover for Year 2. 2. Aneko's competitor has a turnover of 2.0. Is Aneko performing better or worse than its competitor based on total asset turnover? Complete this question by entering your answers in the tabs below. Required 1 Required 2 Compute its total asset turnover for Year 2. Choose Numerator: 1 1 1 Total asset turnover Choose Denominator: = = = Total asset turnover Total asset turnover timesarrow_forward
- Please provide answer the following requirementsarrow_forwardAneko Company reports the following: net sales of $18,000 for Year 2 and $17,100 for Year 1; end-of-year total assets of $18,200 for Year 2 and $16,800 for Year 1. Compute its total asset turnover for Year 2. Aneko’s competitor has a turnover of 2.0. Is Aneko performing better or worse than its competitor based on total asset turnover?arrow_forwardThe income statement disclosed the following items for the year: Depreciation expense $53,200 Gain on disposal of equipment 31,010 Net income 419,900 The changes in the current asset and liability accounts for the year are as follows: Increase (Decrease) Accounts receivable $8,280 Inventory (4,710) Prepaid insurance (1,770) Accounts payable (5,610) Income taxes payable 1,770 Dividends payable 1,240 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 out flows, cash payments, decreases in cash, or any negative adjustments.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
Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Survey of Accounting (Accounting I)
Accounting
ISBN:9781305961883
Author:Carl Warren
Publisher:Cengage Learning