Exercise-10 (Computation of net cash flows from operating activities – indirect method)

Exercise-10(a):

The following information have been taken from income statement and balance sheet of Virginia Inc.

Income statement

• Net income: $192,500
• Depreciation expense: $62,500
• Amortization of intangible assets: $20,000
• Gain on sale of equipment: $45,000
• Loss on sale of investments: $17,500

Balance sheet:

• Accounts receivable on January 1, 2017: $190,000
• Accounts receivable on December 31, 2017: $167,500
• Inventory on January 1, 2017: $287,500
• Inventory on December 31, 2017: $251,500
• Prepaid expenses on January 1, 2017: $5,000
• Prepaid expenses on December 31, 2017: $11,000
• Accounts payable on January 1, 2017: $205,000
• Accounts payable on December 31, 2017: $189,500
• Accrued expenses payable on January 1, 2017: $77,500
• Accrued expenses payable on December 31, 2017: $90,000

Accounts payable given above relate to suppliers of merchandise.

Required: Using above information, compute net cash flows from operating activities under indirect method.

Solution:

The increase or decrease in working capital accounts have been computed below:

• N/1 – Decrease in accounts receivable: $190,000 – $167,500
• N/2 – Decrease in inventory: $287,500 – $251,500
• N/3 – Increase in accrued expenses payable: $90,000 – $77,500
• N/4 – Increase in prepaid expenses: $11,000 – $5,000
• N/5 – Decrease in accounts payable: $205,000 – $189,500

Exercise-10(b):

The income statement of VG company for the year ended December 31, 2017 is given below:

The following additional information is also provided to you:

1. The depreciation expense of $15,000 is included in the administrative expenses shown in the above income statement.
2. Accounts receivable decreased by $90,000 during the year.
3. Accounts payable decreased by $68,750 during the year.
4. Prepaid expenses increased by $42,500 during the year.
5. Accrued expenses decreased by $25,000 during the year.

You are requested to compute the net cash flow from operating activities of VG Company using income statement and additional information given above.

Solution

*Decrease in inventory has been computed by taking beginning inventory and ending inventory figures from income statement: $475,000 – $400,000 = $75,000