Concept explainers
1.
Prepare a spreadsheet to support the
1.
Explanation of Solution
Worksheet: A worksheet is a spreadsheet used while preparing a financial statement. It is a type of form having multiple columns and it is used in the adjustment process. The use of a worksheet is optional for any organization. A worksheet can neither be considered as a journal nor a part of the general ledger.
Statement of cash flows: Statement of cash flow reports all the cash transactions which are responsible for inflow and outflow of cash and result of these transactions is reported as ending balance of cash at the end of reported period. Statement of cash flows includes the changes in cash balance due to operating, investing, and financing activities.
Prepare a spreadsheet entry to support the cash flow statement.
Table (1)
Table (2)
Working notes:
a. Calculate the Changes in accounts receivable.
b. Calculate the changes in inventory.
c. Calculate the change in prepaid item.
d. Calculate the changes in accounts payable.
e. Calculate the changes in salaries payable.
f. Calculate the changes in miscellaneous current payable.
g-1) Understated of depreciation expenses for the last year by $1,800.
g-2) Received income tax refund of $500.
h) Calculate the additional paid in capital received through treasury stock.
i). Calculate the premium on bonds payable.
j-1) Common stock issued to convert the preferred stock by $3,000.
j-2) Preferred stock converted into common stock for $3,000.
k) Calculate the Premium on common stock.
l) Cash dividend paid by $4,000.
m) Amortization of premium on bonds payable by $100.
n) Cash increased by $200.
2.
Prepare a cash flow statement under indirect method of B Company for the year 2016 and show operating cash flow in the separate schedule.
2.
Explanation of Solution
Operating activities: Operating activities include
Financing activities: Financing activities includes cash inflows and outflows from issuance of common stock and debt, payment of debt and dividends.
Investing activities: Investing activities includes cash inflows and
Indirect method: Under indirect method, net income is reported first, and then non-cash expenses, losses from fixed assets, and changes in opening balances and ending balances of current assets are adjusted to reconcile the net income balance.
Prepare the cash flow statement under indirect method.
B company | ||
Statement of cash flow | ||
For the year end 2016 | ||
Particulars | Amount ($) | Amount ($) |
Operating activities: | ||
Net cash provided by operating activities ( schedule 1) | $22,950 | |
Investing activities: | ||
Proceeds from sale of land | $3,800 | |
Payment for loan on note receivable | (1,000) | |
Payment for purchase of land | (9,000) | |
Payment for purchase of equipment | (32,000) | |
Net cash used for investing activities | ($38,200) | |
Financing activities: | ||
Proceeds from sale of | $ 1,800 | |
Proceeds from issuance of 12% bonds payable | 7,750 | |
Proceeds from issuance of common stock | 9,900 | |
Payment of dividends | (4,000) | |
Net cash provided by financing activities | 15,450 | |
Net increase in cash (Schedule 2) | $200 | |
Cash, January 1, 2016 | 1,800 | |
Cash, December 31, 2016 | $2,000 | |
Schedule 1: Cash flows from operating activities | ||
Net income | $11,500 | |
Adjustment for non-cash income items: | ||
Add: | 6,000 | |
Patent amortization expense | 400 | |
Less: Amortization of bond premium | (100) | |
Gain on sale of equipment | (900) | |
Adjustment for cash flow effects from | ||
Increase in accounts receivable | (120) | |
Decrease in inventories | 2,300 | |
Decrease in prepaid items | 320 | |
Increase in accounts payable | 2,210 | |
Increase in salaries payable | 900 | |
Increase in interest payable | 140 | |
Decrease in miscellaneous current payables | (200) | |
Income tax refund | 500 | |
Net cash provided by operating activities | $22,950 | |
Schedule 2: Investing and Financing activities not affecting cash | ||
Financing activities: | ||
Conversion of | ($3,000) | |
Issuance of common stock to convert preferred stock | 3,000 |
Table (3)
Therefore cash balance as on December 31, 2016 is $2,000.
Want to see more full solutions like this?
Chapter 21 Solutions
Cengagenowv2, 1 Term Printed Access Card For Wahlen/jones/pagach’s Intermediate Accounting: Reporting And Analysis, 2017 Update, 2nd
- In the current year, Harrisburg Corporation had net income of 35,000, a 9,000 decrease in accounts receivable, a 7,000 increase in inventory, an 8,000 increase in salaries payable, a 13,000 decrease in accounts payable, and 10,000 in depreciation expense. Using the indirect method, prepare the operating activities section of its statement of cash flows based on this information.arrow_forwardSalud Company reports the following information. Selected Annual Income Statement Data Selected Year-End Balance Sheet Data Net income $ 470,000 Accounts receivable increase $ 49,600 Depreciation expense 97,000 Prepaid expenses decrease 15,900 Gain on sale of machinery 26,900 Accounts payable increase 7,400 Wages payable decrease 2,100 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_forwardSalud Company reports the following information. Selected Annual Income Statement Data Selected Year-End Balance Sheet Data $ 500,000 Accounts receivable increase 97,500 Prepaid expenses decrease 26,600 Accounts payable increase Wages payable decrease $ 53,200 12,600 Net income Depreciation expense Gain on sale of machinery 7,200 3,500 Use the indirect method to prepare the operating activities section of its statement of cash flows for the year ended December 31. (Amounts to be deducted should be indicated with a minus sign.) Statement of Cash Flows (partial) es Cash flows from operating activities Adjustments to reconcile net income to net cash provided by operating activities Income statement items not affecting cash Changes in current operating assets and liabilitiesarrow_forward
- JSW Corp. reported net income on the income statement for the current year of $59,000. Depreciation recorded on fixed assets for the year was $24,000. Balances of the current asset and current liability accounts at the end and beginning of the year are listed below. Prepare the cash flows from operating activities section of a statement of cash flows using the indirect method. End Beginning Cash $65,000 $ 70,000 Accounts receivable (net) 70,000 57,000 Inventories 86,000 102,000 Prepaid expenses 4,000 4,500 Accounts payable (merchandise creditors) 50,000 58,000 Cash dividends payable 4,500 6,500 Salaries payable 6,000 7,500 Statement of Cash Flows Cash Flows from Operating Activities: Net Income, per income statement $59,000 Add: Deduct:…arrow_forwardNet Cash Provided by Operating Activities Wiley Company’s income statement for Year 2 follows: The company’s selling and administrative expense for Year 2 includes $7,500 of depreciation expense. Selected balance sheet accounts for Wiley at the end of Years 1 and 2 are as follows: Required: 1. Using the direct method, convert the company’s income statement to a cash basis. 2. Assume that during Year 2 Wiley had a $9,000 gain on sale of investments and a $3,000 loss on the sale of equipment. Explain how these two transactions would affect your computations in (1) above.arrow_forwardCurwen Inc. reported net cash flow from operating activities of $357,500 on its statement of cash flows for a recent year ended December 31. The following information was reported in the Cash flows from operating activities section of the statement of cash flows, using the indirect method: Decrease in income taxes payable $ 7,700Decrease in inventories 19,140Depreciation 29,480Gain on sale of investments 13,200Increase in accounts payable 5,280Increase in prepaid expenses 2,970Increase in accounts receivable 14,300a. Determine the net income reported by Curwen Inc. for the year ended December 31.b. Briefly explain why Curwen’s net income is different from net cash flow from operating activities.arrow_forward
- Use the following F/S information to answer problems 15 and 16. In its 20X1 annual report to shareholders, Heitzman & Co. provided the following Statement of Cash Flows: Years ended December 31 ($ in millions) 20X1 20X0 Operating Activities Cash Inflows: Cash received from customers $3,102 Progress payments Other collections $1.438 11,148 7,003 Proceeds from litigation settlement Interest received 220 17 17 Income tax refunds received 23 15 Other cash receipts Cash provided by operating activities Cash Outflows: 24 10 14,534 8,483 Cash paid to suppliers and employees Interest paid Income taxes paid Other cash payments Cash used in operating activities Net cash provided by operating activities 13.251 7,250 333 165 126 57 1 7,473 13,717 817 1,010 Investing Activities Payment for businesses purchased, net of cash acquired Additions to property, plant, and equipment (3,061) (393) (510) (274) Collection of note receivable 148 Proceeds from sale of property, plant, and equipment Proceeds…arrow_forwardBarclays Company is preparing the company's statement of cash flows for the fiscal year just ended. The following information is available: Retained earnings balance at the beginning of the year $ 328,000 Cash dividends declared for the year 73,750 Proceeds from the sale of equipment 126,800 Gain on the sale of equipment 7,350 Cash dividends payable at the beginning of the year 32,450 Cash dividends payable at the end of the year 39,500 Net income for the year 162,250 The amount of cash paid for dividends was:arrow_forwardA company reports net income of $560,000 that Includes depreciation expense of $82,000. Also, cash of $59,000 was borrowed on a 6-year note payable. Based on this data, total cash inflows from operating activities are: Multiple Cholce $478,000. $642,000. $619,000. $701,000.arrow_forward
- Alvarez Company is preparing the company's statement of cash flows for the fiscal year just ended. The following information is available: Retained earnings balance at the beginning of the year $ 233,000 Cash dividends declared for the year Proceeds from the sale of equipment Gain on the sale of equipment Cash dividends payable at the beginning of the year Cash dividends payable at the end of the year Net income for the year The ending balance in retained earnings is: 10 $343,000. $297,500. $301,000. $293,000. $213,000. 50,000 85,000 4,500 22,000 30,000 110,000arrow_forwardA company reports net income of $9,300 for the year. During the year, the company reports an $1,060 loss from retirement of notes and a gain of $1,590 from the sale of equipment. Also, depreciation expense is $3,320. The only change in current assets and current liabilities was a $530 increase in inventory. Compute net cash provided by operating activities using the indirect method. Note: Amounts to be deducted should be indicated with a minus sign. Cash Flows from Operating Activities (Indirect) Net income Adjustments to reconcile net income to net cash provided by operating activities Income statement items not affecting cash Loss on retirement of notes Gain on sale of equipment Depreciation expense Changes in current assets and current liabilities $ $ 7,040 7,040arrow_forwardences Hampton Company reports the following information for its recent calendar year. Income Statement Data Sales Expenses: Cost of goods sold Salaries expense Depreciation expense Net income $ 160,000 Accounts receivable increase Inventory decrease Salaries payable increase 100,000 24,000 12,000 $ 24,000 Selected Year-End Balance Sheet Data Required: Prepare the operating activities section of the statement of cash flows using the indirect method. Note: Amounts to be deducted should be indicated with a minus sign. Statement of Cash Flows (partial) Cash flows from operating activities-indirect method Adjustments to reconcile net income to net cash provided by operating activities Income statement items not affecting cash Changes in current operating assets and liabilities $ 10,000 16,000 1,000arrow_forward
- Intermediate Accounting: Reporting And AnalysisAccountingISBN:9781337788281Author:James M. Wahlen, Jefferson P. Jones, Donald PagachPublisher:Cengage LearningManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub