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
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 2019 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
Prepare the cash flow statement under indirect method.
B company | ||
Statement of cash flow | ||
For the year end 2019 | ||
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, 2019 | 1,800 | |
Cash, December 31, 2019 | $2,000 | |
Schedule 1: Cash flows from operating activities | ||
Net income | $11,500 | |
Adjustment for non-cash income items: | ||
Add: Depreciation expense | 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, 2019 is $2,000.
Want to see more full solutions like this?
Chapter 21 Solutions
Intermediate Accounting: Reporting And Analysis
- 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_forwardWhat amount should be reported as net cash provided by operating 1 po activities? Kollar Corporation reported net income of P6,500,000 for the current year. Changes in certain accounts during the current year are: Investment in Gold shares carried on the equity basis Accumulated depreciaiton, cause by major repair to equipment Unearned interest income Premium on bonds payable 380,000 increase 210,000 decrease 50,000 decrease 120,000 decrease Deferred tax liability 180,000 increase Your answerarrow_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_forward
- Apex Company prepared the statement of cash flows for the current year that is shown below: Apex CompanyStatement of Cash Flows—Indirect Method Operating activities: Net income $ 40,400 Adjustments to convert net income to cash basis: Depreciation $ 20,200 Increase in accounts receivable (60,900) Increase in inventory (25,100) Decrease in prepaid expenses 9,600 Increase in accounts payable 53,700 Decrease in accrued liabilities (10,500) Increase in income taxes payable 4,300 (8,700) Net cash provided by (used in) operating activities 31,700 Investing activities: Proceeds from the sale of equipment 15,200 Loan to Thomas Company (41,100) Additions to plant and equipment (121,100) Net cash provided by (used in) investing activities (147,000) Financing activities: Increase in bonds payable 89,700 Increase in common stock 39,300 Cash dividends (29,600) Net cash provided by (used in) financing…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_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
- Hampton Company reports the following information for its recent calendar year. Selected Year-End Balance Sheet Data Accounts receivable increase $ 77,000 Inventory decrease 41,000 Salaries payable increase 12,000 4,000 $ 20,000 Income Statement Data Sales Expenses: Cost of goods sold Salaries expense Depreciation expense Net income 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 $ 5,000 5,000 900 Changes in current operating assets and liabilitiesarrow_forwardUse 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_forward
- Reporting Net Cash Flow from Operating Activities The following information is available for Bernard Corporation: Net income $189,000 Decrease in income taxes payable $4,270 Decrease in accounts receivable 6,800 Increase in notes payable (due in 5 years) 50,000 Increase in inventory 18,300 Depreciation expense 44,700 Decrease in prepaid rent 2,100 Loss on disposal of equipment 11,000 Increase in salaries payable 4,410 Required: Compute the net cash flows from operating activities using the indirect method.arrow_forwardFitz Company reports the following information. Use the indirect method to prepare the operating activi- ties section of its statement of cash flows for the year ended December 31. Selected Annual Income Statement Data Net income .. Depreciation expense Amortization expense.. Gain on sale of plant assets. Selected Year-End Balance Sheet Data $374,000 44,000 Accounts receivable decrease.. $17,100 Inventory decrease..... Prepaid expenses increase.. Accounts payable decrease Salaries payable increase.. 42,000 7,200 4,700 6,000 8,200 1,200arrow_forwarded information [The following information applies to the questions displayed below.] A recent annual report for BubbliCo contained the following information for the period (dollars in millions): Net income Depreciation and amortization Increase in accounts receivable Increase in inventory Increase in prepaid expense Increase in accounts payable Decrease in taxes payable Increase in other current liabilities Cash dividends paid Share repurchases BUBBLICO Statement of Cash Flows (Partial) $5,144 1,551 569 362 Cash flows from operating activities: Required: 1. Compute cash flows from operating activities for BubbliCo using the indirect method. Note: List cash outflows as negative amounts. Enter your answers in millions. 68 727 199 743 Adjustments to reconcile net income to cash flow from operating activities: 2,559 4,721 $ 0arrow_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