Question

In: Accounting

1. Prepare a schedule for the calculation of cash generated from operating activities for Kennington Company...

1. Prepare a schedule for the calculation of cash generated from operating activities for Kennington Company for the year ended December 31, 20-2.

2. Prepare a partial statement of cash flows for Kennington Company reporting cash from operating activities under the direct method for the year ended December 31, 20-2. Use a minus to indicate any decreases in cash or cash outflows.

Schedule for Calculation of Cash Generated From Operating Activities

Kennington Company's condensed income statement for the year ended December 31, 20-2, was as follows:

Net sales $800,000
Cost of goods sold 475,000
Gross profit $325,000
Operating expenses 148,000
Income before taxes $177,000
Income tax expense 62,000
Net income $115,000

Additional information obtained from Kennington's comparative balance sheet as of December 31, 20-2 and 20-1, was as follows:

20-2 20-1
Cash $75,000    $20,000   
Accounts receivable 50,000    75,000   
Merchandise inventory 70,000    110,000   
Accounts payable 25,000    50,000   

1. Prepare a schedule for the calculation of cash generated from operating activities for Kennington Company for the year ended December 31, 20-2.

Kennington Company
Schedule for the Calculation of Cash Generated from Operating Activities
For Year Ended December 31, 20-2
Income Statement Additions Deductions Cash Flows
Net sales $800,000 $ $
Cost of goods sold 475,000 $
Gross profit $325,000 $
Operating expenses 148,000
Income before taxes $177,000 $
Income tax expense 62,000
Net income $115,000 $

2. Prepare a partial statement of cash flows for Kennington Company reporting cash from operating activities under the direct method for the year ended December 31, 20-2. Use a minus to indicate any decreases in cash or cash outflows.

Kennington Company
Statement of Cash Flows (Partial)
For Year Ended December 31, 20-2
Cash flows from operating activities:
Cash received from customers $
Cash paid for merchandise $
Cash paid for operating expenses
Cash paid for income taxes
Total cash disbursed for operating activities
Net cash provided by operating activities $

Solutions

Expert Solution

1 Kennington Company
Schedule for the Calculation of Cash Generated from Operating Activities
For Year Ended December 31, 20-2
Income Statement Additions Deductions Cash Flows
Net sales                   800,000              25,000        825,000
Cost of goods sold                   475,000         15,000        460,000
Gross profit                   325,000        365,000
Operating expenses                   148,000        148,000
Income before taxes                   177,000        217,000
Income tax expense                     62,000         62,000
Net income                   115,000        155,000
2 Kennington Company
Statement of Cash Flows (Partial)
For Year Ended December 31, 20-2
Cash flows from operating activities:
Cash received from customers             825,000
Cash paid for merchandise                  (460,000)
Cash paid for operating expenses                  (148,000)
Cash paid for income taxes                   (62,000)
Total cash disbursed for operating activities           (670,000)
Net cash provided by operating activities             155,000
Working
Cash collected from customers
Beginning AR                   75,000
+ Sales                 800,000
- Ending AR                  (50,000)
                825,000
Purchase from suppliers
- Beginning Inventory                (110,000)
+ cost of goods sold                 475,000
+ Ending Inventory                   70,000
                435,000
Cash paid for suppliers
Beginning AP                   50,000
+ purchase from suppliers                 435,000
- Ending AP                  (25,000)
                460,000

Related Solutions

a. Using the information for the Seville Corporation above, calculation the cash flow from operating activities....
a. Using the information for the Seville Corporation above, calculation the cash flow from operating activities. b. Using the information for the Seville Corporation above, calculation the cash flow from investing activities. c. Using the information for the Seville Corporation above, calculation the cash flow from financing activities. Accounts payable increase            9,000 Accounts receivable increase            4,000 Accrued liabilities decrease            3,000 Amortization expenses            6,000 Cash balance Jan 1          22,000 Cash balance Dec 31            1,500 Cash...
15. Show your calculation for the Operating Cash Flows & Dividends Ratio (Cash generated by or...
15. Show your calculation for the Operating Cash Flows & Dividends Ratio (Cash generated by or (used in) operating activities/Dividends) to two decimal places for the most recent three years. 2017: $64,225/$13,735=4.68 2016: $66,231/$12,803=5.17 2015: $81,266/$12,188 =6.67 16. In one or two sentences, briefly explain what the calculations mean. What does the trend show? Hint: This ratio indicates whether or not enough money was generated from operations to cover the dividend payment. ? 17. . Show your calculation for the...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below for Macrosoft Corporation. MACROSOFT CORPORATION Income Statement For the Year Ended December 31, 2021 ($ in millions) Revenues and gains: Sales $ 320.00 Gain on sale of cash equivalents 2.50 Gain on sale of investments 24.50 $ 347.00 Expenses and loss: Cost of goods sold $ 125.00 Salaries 40.50 Interest expense 12.50 Insurance 20.50 Depreciation 10.50 Patent amortization 4.50 Loss on sale...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below ($ in thousands) for Peach Computers. PEACH COMPUTERS Income Statement For the Year Ended December 31, 2021 Sales $ 320.0 Cost of goods sold (160.0 ) Gross margin 160.0 Salaries expense $ 35.0 Insurance expense 12.0 Depreciation expense 5.0 Loss on sale of land 3.0 55.0 Income before tax 105.0 Income tax expense (52.5 ) Net income $ 52.5 Reconciliation of Net...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below for Mike Roe Computers. MIKE ROE COMPUTERS Income Statement For the Year Ended December 31, 2021 ($ in millions) Sales $ 150.20 Cost of goods sold (90.00 ) Gross margin 60.20 Salaries expense $ 18.20 Insurance expense 12.00 Depreciation expense 4.50 Interest expense 5.50 (40.20 ) Gains and losses: Gain on sale of equipment 11.00 Loss on sale of land (2.00 )...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below ($ in thousands) for Peach Computers. PEACH COMPUTERS Income Statement For the Year Ended December 31, 2021 Sales $ 500.0 Cost of goods sold (250.0 ) Gross margin 250.0 Salaries expense $ 59.0 Insurance expense 36.0 Depreciation expense 17.0 Loss on sale of land 15.0 127.0 Income before tax 123.0 Income tax expense (61.5 ) Net income $ 61.5 Reconciliation of Net...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below for Mike Roe Computers. MIKE ROE COMPUTERS Income Statement For the Year Ended December 31, 2021 ($ in millions) Sales $ 148.00 Cost of goods sold (89.00 ) Gross margin 59.00 Salaries expense $ 18.00 Insurance expense 11.00 Depreciation expense 4.00 Interest expense 5.30 (38.30 ) Gains and losses: Gain on sale of equipment 10.00 Loss on sale of land (1.00 )...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below ($ in millions) for Mike Roe Computers. MIKE ROE COMPUTERS Income Statement For the Year Ended December 31, 2018 Sales $ 148.20 Cost of goods sold (89.10 ) Gross margin 59.10 Salaries expense $ 18.20 Insurance expense 11.20 Depreciation expense 4.10 Interest expense 5.10 (38.60 ) Gains and losses: Gain on sale of equipment 10.20 Loss on sale of land (1.20 )...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below ($ in millions) for Mike Roe Computers. MIKE ROE COMPUTERS Income Statement For the Year Ended December 31, 2018 Sales $ 148.00 Cost of goods sold (89.00 ) Gross margin 59.00 Salaries expense $ 18.00 Insurance expense 11.00 Depreciation expense 4.00 Interest expense 5.30 (38.30 ) Gains and losses: Gain on sale of equipment 10.00 Loss on sale of land (1.00 )...
The income statement and a schedule reconciling cash flows from operating activities to net income are...
The income statement and a schedule reconciling cash flows from operating activities to net income are provided below ($ in millions) for Mike Roe Computers. MIKE ROE COMPUTERS Income Statement For the Year Ended December 31, 2018 Sales $ 148.40 Cost of goods sold (89.20 ) Gross margin 59.20 Salaries expense $ 18.40 Insurance expense 11.40 Depreciation expense 4.20 Interest expense 5.20 (39.20 ) Gains and losses: Gain on sale of equipment 10.40 Loss on sale of land (1.40 )...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT