Chapter 12, Problem 1AP

a.

To determine

Calculate the change in cash that occurred during 2013.

Explanation of Solution

Calculate the change in cash during 2013.

Cash balance as of 31^st December 2012 is $5,000

Cash balance as of 31^st December 2013 is $11,000

$\begin{array}{c}\text{Change in cash }=\text{Cash balance in 2013}-\text{Cash balance in 2012}\\ =\$11,000-\$5,000\\ =\$6,000\end{array}$

Hence, the change in cash during 2013 is $6,000.

b.

To determine

Prepare a statement of cash flows using indirect method for Company W.

Explanation of Solution

Statement of cash flows: Statement of cash flows 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.

Indirect method: Under this method, the following amounts are to be adjusted from the Net Income to calculate the net cash provided from operating activities.

Prepare a statement of cash flows using indirect method for Company W.

Company W
Statement of Cash Flows – Indirect Method
For the year ended December 31, 2013
Details	Amount ($)	Amount ($)
Cash flows from operating activities:
Net income		56,000
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation expense	17,000
Increase in accounts receivable	(9,000)
Increase in merchandise inventory	(30,000)
Decrease in prepaid insurance	2,000
Decrease in accounts payable	(3,000)
Increase in wages payable	3,000
Decrease in income tax payable	(1,000)	(21,000)
Net cash provided by operating activities		35,000
Cash flows from investing activities:
Acquisition of plant asset (1)	(55,000)
Net cash used for investing activities		(55,000)
Cash flows from financing activities:
Issuance of bonds payable (2)	55,000
Cash payment of dividends	(29,000)
Net cash provided by financing activities		26,000
Net increase (decrease) in Cash		6,000
Cash balance, December 31, 2012		5,000
Cash balance, December 31, 2013		11,000

Table (1)

Working note:

Prepare the schedule in the change of current assets and liabilities.

Schedule in the Change of Current Assets and Liabilities
Details	Amount ($)			Effect on Operating Activities
	2013 ($)	2012 ($)	Increase/ (Decrease) ($)
Accounts receivable	41,000	32,000	9,000	Less
Inventory	90,000	60,000	30,000	Less
Prepaid insurance	5,000	7,000	(2,000)	Add
Accounts payable	7,000	10,000	(3,000)	Less
Wages payable	9,000	6,000	3,000	Add
Income tax payable	7,000	8,000	(1,000)	Less

Table (2)

Calculate the acquisition of plant:

Plant account
Beginning balance	$195,000
Acquisition	$55,000
Ending balance	$250,000

(1)

Calculate the issue of bonds payable for cash:

Bonds payable in 2013 = $130,000

Bonds payable in 2012 = $75,000

$\begin{array}{c}\text{Issunace of bonds payable for cash }=\$130,000-\$75,000\\ =\$55,000\end{array}$ (2)

Thus, the cash balance of Company S is $11,000.

c.

To determine

Compute the free cash flow for Company W.

Explanation of Solution

Free cash flow:

Free cash flow signifies cash that is provided by the operations of the Company after making capital expenditures for acquiring or expanding its assets.

Formula to calculate free cash flow:

$\text{Free cash flow}=\left(\begin{array}{l}\text{Net cash flows from operating activities}\\ -\text{ Dividends }-\text{ Net capital expenditures}\end{array}\right)$

Compute free cash flow:

Amount of net cash flow from operating activities is $35,000

Amount of Net capital expenditure is $55,000

Amount of dividend is $29,000

$\begin{array}{c}\text{Free cash flow}=\left(\begin{array}{l}\text{Net cash flows from operating activities}\\ -\text{ Dividends }-\text{ Net capital expenditures}\end{array}\right)\\ =\$35,000-\$29,000-\$55,000\\ =\left(\$49,000\right)\end{array}$

Thus, the free cash flow of Company S is (49,000).

d.

To determine

Compute the operating cash flow to current liabilities ratio for Company W.

Explanation of Solution

Operating cash flow to current liabilities ratio measures the capability of the company to pay it current liabilities. In this, higher the ratio shows that the company has sufficient cash flow to pay its debts.

Formula to calculate the operating cash flow to current liabilities ratio is:

$\begin{array}{l}\text{Operating cash flows}\\ \text{ to current liabilities ratio}\end{array})=\frac{\text{Cash flows from operating activities}}{\text{Average current liabilities}}$

Compute the Operating cash flow to current liabilities ratio.

Amount of cash flow from operating activities is $60,000

Amount of average current liabilities is $23,500 (3)

$\begin{array}{c}\begin{array}{l}\text{Operating cash flows}\\ \text{ to current liabilities ratio}\end{array})=\frac{\text{Cash flows from operating activities}}{\text{Average current liabilities}}\\ =\frac{\$35,000}{\$23,500}\\ =1.49\end{array}$

Working note:

Calculate the average current liabilities:

$\begin{array}{c}\text{Average current liabilities }=\frac{\left(\begin{array}{l}\text{Current liabilities, 2012 }\\ +\text{ Current liabilities, 2013}\end{array}\right)}{2}\\ =\frac{\left(\begin{array}{l}\$10,000+\$6,000\\ +\$8,000\end{array}\right)+\left(\begin{array}{l}\$7,000+\$9,000\\ +\$7,000\end{array}\right)}{2}\\ =\$23,500\end{array}$ (3)

Thus, the operating cash flow to current liabilities ratio of Company W is 1.49.

e.

To determine

Compute the operating cash flow to capital expenditure ratio for Company W.

Explanation of Solution

Operating cash flow to capital expenditure ratio measures the capability of the company to finance its capital investments from the operating cash flow.

Formula to calculate cash flow to capital expenditure ratio is:

$\begin{array}{l}\text{Operating cash flows}\\ \text{ to capital expenditure ratio}\end{array})=\frac{\text{Cash flows from operating activities}}{\text{Annual net capital expenditure}}$

Compute the operating cash flow to capital expenditure ratio.

Cash flow from operating activities is $35,000

Amount of capital expenditure is $55,000

$\begin{array}{c}\begin{array}{l}\text{Operating cash flows}\\ \text{ to capital expenditure ratio}\end{array})=\frac{\text{Cash flows from operating activities}}{\text{Annual net capital expenditure}}\\ =\frac{\$35,000}{\$55,000}\\ =0.64\end{array}$

Thus, the operating cash flow to expenditure ratio of Company W is 0.64.