(1)
Statement of
Direct method:
This method uses the basis of cash for preparing the cash flows of statement.
Operating activities:
Operating activities refer to the normal activities of a company to carry out the business. The examples for operating activities are purchase of inventory, payment of salary, sales, and others.
Investing activities:
Investing activities refer to the activities carried out by a company for acquisition of long term assets. The examples for investing activities are purchase of equipment, long term investment, sale of land, and others.
Financing activities:
Financing activities refer to the activities carried out by a company to mobilize funds to carry out the business activities. The examples for financing activities are purchase of bonds, issuance of common shares, and others.
To prepare: A spreadsheet for the preparation of thestatement of cash flow of NI Company under direct method for the year ended December 31, 2018.
(1)
Explanation of Solution
Spreadsheet:
The spreadsheet is a supplementary device which helps to prepare the
Spreadsheet for the Statement of cash flows of NI Company:
NI Company | ||||
Spreadsheet for the Statement of Cash Flows | ||||
Amount in Millions | ||||
Particulars | December 31,2017 Amount ($) | Changes | December 31,2018 Amount ($) | |
Debit ($) | Credit ($) | |||
Assets | ||||
Assets | ||||
Cash | 55 | (18) 2 | 57 | |
|
170 | (1) 11 | 181 | |
Less: Allowance | (6) | (1) 2 | (8) | |
Prepaid insurance | 12 | (8) 5 | 7 | |
Inventory | 165 | (4) 5 | 170 | |
Long term investment | 90 | (2) 6 | (3) 30 | 66 |
Land | 150 | 150 | ||
Buildings and equipment | 270 | (13) 80 X | (10) 60 | 290 |
Less: Acc. depreciation | (75) | (10) 15 | (6) 25 | (85) |
Trademark | 25 | (7) 1 | 24 | |
Total assets | 856 | 852 | ||
Liabilities and |
||||
Liabilities | ||||
Accounts payable | 45 | (4) 15 | 30 | |
salaries payable | 8 | (5) 5 | 3 | |
15 | (11) 3 | 18 | ||
Lease liability | 0 | (13) 12 | X (13) 80 | 68 |
Bonds payable | 275 | (14) 130 | 145 | |
Less: Discount | (25) | (9) 3 | (22) | |
Stockholders’ equity | ||||
Common Stock | 290 | (15) 20 | 310 | |
Paid in capital –ex of par | 85 | (15) 10 | 95 | |
0 | (16) 50 | 50 | ||
|
163 | (17) 30 | (12) 22 | 155 |
Total liabilities and stockholders’ equity | 856 | 852 | ||
Income Statement | ||||
Revenues | ||||
Sales revenue | (1) 320 | 320 | ||
Investment revenue | (2) 15 | 15 | ||
Gain on sale of investments | (3) 5 | 5 | ||
Expenses | ||||
Cost of goods sold | (4) 125 | (125) | ||
Salaries expense | (5) 55 | (55) | ||
Depreciation expense | (6) 25 | (25) | ||
Trademark amortization | (7) 1 | (1) | ||
Bad debt expense | (1) 7 | (7) | ||
Insurance expense | (8) 13 | (13) | ||
Bond Interest expenses | (9) 30 | (30) | ||
Loss on building fire | (10) 42 | (42) | ||
Income tax expense | (11) 20 | (20) | ||
Net income | (12) 22 | 22 | ||
Statement of Cash Flows | ||||
Operating activities: | ||||
Cash Inflows: | ||||
From customers | (1) 304 | |||
From investment revenue | (2) 9 | |||
To suppliers of goods | (4) 145 | |||
To employees | (5) 60 | |||
For insurance | (8) 8 | |||
For bond interest | (9) 27 | |||
For income taxes | (11) 17 | |||
Net cash flows | 56 | |||
Investing activities: | ||||
Sale of long term investment | (3) 35 | |||
Sale of building parts | (10) 3 | |||
Net cash flows | 38 | |||
Financing activities: | ||||
Payment on lease liability | (13) 12 | |||
Retirement of bonds payable | (14) 130 | |||
Sale of common stock | (15) 30 | |||
Sale of preferred stock | (16) 50 | |||
Payment of cash dividends | (17) 30 | |||
Net cash flows | (92) | |||
Net increase in cash | (18) 2 | 2 | ||
Total | 1,082 | 1,082 |
Table (1)
Note (X):
Purchase $80 million worth of equipment by 7-year lease is considered as non cash investing and financing activities.
(2)
To prepare: The statement of cash flows.
(2)
Explanation of Solution
The spreadsheet of NI Company shows the analysis of cash flows in the reporting year 2018.
NI Company | |||
Spreadsheet for the statement of cash flows | |||
Year ended December 31, 2018 | |||
Changes | |||
Details (December 31, 2017) | Debits ($) | Credits ($) | December 31, 2018 |
Statement of cash flows | |||
Operating activities: | |||
Cash inflows: | |||
From customers | 304 | ||
From investment revenue | 9 | ||
Cash outflows: | |||
To suppliers of goods | (145) | ||
To employees | (60) | ||
For insurance expense | (8) | ||
For bond interest expense | (27) | ||
For income taxes | (17) | ||
Net cash flows from operating activities | 56 | ||
Investing activities: | |||
Sale of long-term investment | 35 | ||
Sale of building parts | 3 | ||
Net cash flows from investing activities | 38 | ||
Financing activities: | |||
Payment on lease liability | (12) | ||
Retirement of bonds payable | (130) | ||
Sale of common stock | 30 | ||
Sale of preferred stock | 50 | ||
Payment of cash dividends | (30) | ||
Net cash flow from financing activities | (92) | ||
Net increase in cash | 2 | ||
Cash balance, January 1 | 55 | ||
Cash balance, December 31 | 57 |
Table (2)
Hence, the opening cash balance is $55 and the closing cash balance is $57.
Want to see more full solutions like this?
Chapter 21 Solutions
Loose Leaf Intermediate Accounting
- Exercise 21-31 (Static) Statement of cash flows; indirect method [LO21-4, 21-5, 21-6, 21-8, Appendix 21A] Comparative balance sheets for 2024 and 2023, a statement of income for 2024, and additional information from the accounting records of Red, Incorporated, are provided below: RED, INCORPORATED Comparative Balance Sheets December 31, 2024 and 2023 ($ in millions) 2024 2023 Assets Cash $ 24 $ 110 Accounts receivable 178 132 Prepaid insurance 7 3 Inventory 285 175 Buildings and equipment 400 350 Less: Accumulated depreciation (119) (240) $ 775 $ 530 Liabilities Accounts payable $ 87 $ 100 Accrued liabilities 6 11 Notes payable 50 0 Bonds payable 160 0 Shareholders’ Equity Common stock 400 400 Retained earnings 72 19 $ 775 $ 530 RED, INCORPORATED Statement of Income For Year Ended December 31, 2024 ($ in millions) Revenues Sales revenue $ 2,000 Expenses Cost of goods sold $ 1,400…arrow_forward! Required information Exercise 12-10A (Algo) Determining cash flows from investing activities LO 12-3 [The following information applies to the questions displayed below.] The following accounts and corresponding balances were drawn from Delsey Company's Year 2 and Year 1 year-end balance sheets: Account Title Investment securities Machinery Land Exercise 12-10A (Algo) Part c Year 2 $ 102, 100 527,300 143,500 Other information drawn from the accounting records: 1. Delsey incurred a $1,300 loss on the sale of investment securities during Year 2. 2. Old machinery with a book value of $4,070 (cost of $25,390 minus accumulated depreciation of $21,320) was sold. The income statement showed a gain on the sale of machinery of $4,220. 3. Delsey did not sell land during the year. Amount of cash flow Year 1 $ 112,700 427,100 98,000 c. Compute the amount of cash flow associated with the sale of machinery.arrow_forwardQUESTION 1 Given the following information Please calculate the Free Cash Flow to Equity EBIT Net Income Tax rate Depreciation Capital expenditure 2207.9 1513.5 21.80% 1807.1 954.6 Change in non-cash Working Capital -2176.3 Change in long term debt Interest Expense Liabilities Total Long Term debt Total Assets 4755 5470 3902 5628 927.6 395.3 24511.8 13220.6 26168.2arrow_forward
- Required Information Exercise 12-10A (Algo) Determining cash flows from Investing activities LO 12-3 [The following information applies to the questions displayed below.] The following accounts and corresponding balances were drawn from Delsey Company's Year 2 and Year 1 year-end balance sheets: Account Title Investment securities Machinery Land Other Information drawn from the accounting records: Year 2 $ 104,300 524,400 143,300 1. Delsey Incurred a $1,210 loss on the sale of Investment securities during Year 2. 2. Old machinery with a book value of $4,860 (cost of $25.120 minus accumulated depreciation of $20,260) was sold. The Income statement showed a gain on the sale of machinery of $4,670. 3. Delsey did not sell land during the year. Exercise 12-10A (Algo) Part e e. Prepare the investing activities section of the statement of cash flows. Note: Amounts to be deducted should be indicated with a minus sign. DEL SEY COMPANY Statement of Cash Flows (Investing Activities) For the Year…arrow_forward11 Compute Cash Flow from Operating Activities from the following details: Particulars Trade Receivables: Debtors CA Bills Receivable CA Trade Payables: Creditors CL Bills Payable CL L Expenses Outstanding Accrued Income CAT Depreciation on Fixed Assets No + Surplus, i.e., Balance in Statement of Profit & Loss 31st March, 2023 (R) 50,000 23,000 28,000 22,000 4,500 9,000 5,000 90,000 31st March 2022 ) 60,000 25,000 32,000 35,000 3,500 8,000 4,000 80,000arrow_forwardProblem 21-4 (Algo) Statement of cash flows; direct method [LO21-3, 21-8] The comparative balance sheets for 2021 and 2020 and the statement of income for 2021 are given below for Dux Company. Additional information from Dux's accounting records is provided also. DUX COMPANYComparative Balance SheetsDecember 31, 2021 and 2020($ in thousands) 2021 2020 Assets Cash $ 49 $ 24 Accounts receivable 46 53 Less: Allowance for uncollectible accounts (3 ) (2 ) Dividends receivable 3 2 Inventory 65 60 Long-term investment 21 18 Land 85 60 Buildings and equipment 273 290 Less: Accumulated depreciation (70 ) (90 ) $ 469 $ 415 Liabilities Accounts payable $ 35 $ 43 Salaries payable 3 7 Interest payable 7 2 Income tax payable 8 9 Notes payable 25 0 Bonds payable…arrow_forward
- Problem 4: Following are the comparative statements of financial position of CPA Company to add in preparing a statement of cash flows: ● CPA Company Statement of Financial Position December 31, 2021 and 2020 Assets Cash and cash equivalents Financial assets at FVPL Accounts receivable Inventory Long-term investments Property, plant and equipment Less: accumulated depreciation Patents Less: accumulated amortization Total assets Liabilities and Equity Accounts payable Income tax payable 12% bonds payable Less: discount on bonds payable Ordinary share capital Retained earnings The following events took place in 2021: 2021 P900,000 2020 P620,000 300,000 400,000 1,956,500 1,445,000 3,050,000 3,200,000 1,000,000 1,250,000 9,000,000 8,000,000 (2,200,000) (2,000,000) 600,000 600,000 (100,000) P14,606,500 P13,415,000 P2,200,000 P1,900,000 34,500 45,000 4,000,000 4,000,000 (250,000) (300,000) 7,500,000 6,500,000 1,122,000 1,270,000 P14,606,500 P13,415,000 CPA Company declared and paid cash…arrow_forward5 Required information Exercise 12-10A (Algo) Determining cash flows from investing activities LO 12-3 [The following information applies to the questions displayed below.] The following accounts and corresponding balances were drawn from Delsey Company's Year 2 and Year 1 year-end balance sheets: Account Title Investment securities. Machinery Land Exercise 12-10A (Algo) Part b Year 2 $ 102,100 527,300 143,500 Year 1 $ 112,700 Other information drawn from the accounting records: 1. Delsey incurred a $1,300 loss on the sale of investment securities during Year 2. 2. Old machinery with a book value of $4,070 (cost of $25,390 minus accumulated depreciation of $21,320) was sold. The income statement showed a gain on the sale of machinery of $4,220. 3. Delsey did not sell land during the year. Cost of machinery purchased 427, 100 98,000 b. Compute the amount of cash flow associated with the purchase of machinery.arrow_forwardProblem 17-4 (IAA) Pro Forest Company provided the following information for the preparation of a statement of cash flows for the current year Fear state 2020 2019 Cas! Accc Inve Inve Lan Pro Acc Goc 300,000 Cash and cash equivalents Trading securities Accounts receivable, net of allowance Inventory Property, plant and equipment (net) Goodwill Discount on bonds payable 603,000 300,000 200,000 600,000 900,000 2,000,000 200,000 72,000 520,000 840,000 2,100,000 200,000 100,000 4,675,000 4,260,000 Acc No Во Sh. Sh Re Tr 490,000 310,000 800,000 800,000 210,000 1,000,000 Accounts payable Accrued expenses Bonds payable Preference share capital, P100 par, each share convertible into two ordinary shares Ordinary share capital, P20 par Share premium Retained earnings 500,000 700,000 400,000 650,000 400,000 820,000 500,000 1,355,000 A 4,675,000 4,260,000 1. Additional information 2. 1. Net income for the current year was P1,705,000. 2. Cash dividend paid during the year totaled P1,000,000. 3. The…arrow_forward
- 1. How much is the net share in the profit or loss of the associate (investment income) in 2021? P480,000 P825,000 P420,000 P135,000 2. How much is the carrying amount of the investment as of December 31, 2021? P7,815,000 P8,025,000 P7,680,000 P7,125,000arrow_forward5 ! Required information Exercise 12-10A (Algo) Determining cash flows from investing activities LO 12-3 [The following information applies to the questions displayed below.] The following accounts and corresponding balances were drawn from Delsey Company's Year 2 and Year 1 year-end balance sheets: Account Title Investment securities Machinery Land Exercise 12-10A (Algo) Part b Year 2 $ 102,100 527,300 143,500 Other information drawn from the accounting records: 1. Delsey incurred a $1,300 loss on the sale of investment securities during Year 2. 2. Old machinery with a book value of $4,070 (cost of $25,390 minus accumulated depreciation of $21,320) was sold. The income statement showed a gain on the sale of machinery of $4,220. 3. Delsey did not sell land during the year. Year 1 $ 112,700 427,100 98,000 Cost of machinery purchased b. Compute the amount of cash flow associated with the purchase of machinery. Prev 4 5 6 7 - of 9 Nextarrow_forwardof 5 ok t ! Required information Exercise 12-10A (Algo) Determining cash flows from investing activities LO 12-3 [The following information applies to the questions displayed below.] The following accounts and corresponding balances were drawn from Delsey Company's Year 2 and Year 1 year-end balance sheets: Account Title Investment securities Machinery Land Exercise 12-10A (Algo) Part a Year 2 $ 102,100 527,300 143,500 Year 1 $ 112,700 Other information drawn from the accounting records: 1. Delsey incurred a $1,300 loss on the sale of investment securities during Year 2. 2. Old machinery with a book value of $4,070 (cost of $25,390 minus accumulated depreciation of $21,320) was sold. The income statement showed a gain on the sale of machinery of $4,220. 3. Delsey did not sell land during the year. Amount of cash flow 427,100 98,000 Required a. Compute the amount of cash flow associated with the sale of investment securities. S harrow_forward
- Financial Accounting: The Impact on Decision Make...AccountingISBN:9781305654174Author:Gary A. Porter, Curtis L. NortonPublisher:Cengage Learning