Chapter 12, Problem 7BP

a.

To determine

Calculate the change in cash during 2016.

Explanation of Solution

$\begin{array}{c}\text{Change in cash }=\left(\begin{array}{l}\text{Cash balance in December 31, 2016}\\ -\text{Cash balance in December 31, 2015}\end{array}\right)\\ =\$32,000-\$33,000\\ =\$\left(1,000\right)\end{array}$

Conclusion

Thus, the change in cash during 2016 is $(1,000).

b.

To determine

Prepare a statement of cash flow for S Corporation for the year ended December 31, 2016.

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.

Cash flows from operating activities: Cash flows from operating activity represent the net cash flows from the general operation of the business by comparing the cash receipt and cash payments.

Direct method: The direct method uses the cash basis of accounting for the preparation of the statement of cash flows. It takes into account those revenues and expenses for which cash is either received or paid.

The below table shows the way of calculation of cash flows from operating activities using direct method:

Cash flows from operating activities (Direct method)

Add: Cash receipts.

Cash receipt from customer

Less: Cash payments:

To supplier

Interest expense

For operating expenses

Income tax expenses

Net cash provided from or used by operating activities

Table (1)

Cash flows from investing activities: Cash provided by or used in investing activities is a section of statement of cash flows. It includes the purchase or sale of equipment or land, or marketable securities, which is used for business operations.

Cash flows from investing activities

Add: Proceeds from sale of fixed assets

Sale of marketable securities / investments

Dividend received

Deduct: Purchase of fixed assets/long-lived assets

Purchase of marketable securities

Net cash provided from or used by investing activities

Table (2)

Cash flows from financing activities: Cash provided by or used in financing activities is a section of statement of cash flows. It includes raising cash from long-term debt or payment of long-term debt, which is used for business operations.

Cash flows from financing activities

Add: Issuance of common stock

Proceeds from borrowings

Proceeds from sale of treasury stock

Proceeds from issuance of debt

Deduct: Payment of dividend

Repayment of debt

Interest paid

Redemption of debt

Purchase of treasury stock

Net cash provided from or used by financing activities

Table (3)

A statement of cash flow for S Corporation for the year ended December 31, 2016.

Schedule in the Change of Current Assets and Liabilities
S Corporation
Statement of Cash Flows - Indirect Method
For the year ended December 31, 2016
Details	Amount ($)	Amount ($)
Cash flows from operating activities:
Cash receipts:
From customer	925,000
Total cash receipts		925,000
Cash payments:
To supplier	(548,000)
To employees	(207,000)
For interest	(7,000)
Insurance	(11,000)
Income tax	(64,000)
Total cash payment		(837,000)
Net cash used in operating activities		88,000
Cash flows from investing activities:
Acquisition of plant asset (See Note 1)	(174,000)
Cash received from disposition of plant asset	27,000
Net cash used for investing activities		(147,000)
Cash flows from financing activities:
Issuance of bonds payable (See note 2)	65,000
Issuance of common stock (See note 3)	75,000
Purchase of treasury stock	(52,000)
Cash payment of dividends	(30,000)
Net cash provided by financing activities		58,000
Net increase (decrease) in Cash		(1,000)
Add: Cash balance, December 31, 2015		33,000
Cash balance, December 31, 2016		$32,000

Table (4)

Working notes:

Calculate the cash receipts and cash payments

1.

Calculate the amount of cash receipts from customers.

Cash receipts from customers: It represents the total amount of cash received from the sales as well as from the accounts receivables.

$\left(\begin{array}{l}\text{Cash}\text{receipts}\text{from}\\ \text{Customers}\end{array}\right)=\text{Sales}\text{revenue }\left(\begin{array}{l}+\text{Decrease in Accounts Receivable}\\ \text{OR}\\ -\text{Increase in Accounts Receivable}\end{array}\right)$

Calculate the amount of cash receipts from customers.

$\begin{array}{c}\text{Cash}\text{receipts}\text{from}\text{Customers}=\left(\begin{array}{c}\text{Sales}\text{revenue}\\ -\text{Increase in Accounts Receivable}\end{array}\right)\\ =\text{\$950,000}-\$25,000\\ =\$925,000\end{array}$

2.

Calculate the cash payments to suppliers.

Cash Payments to suppliers: It represents the total amount of cash paid for the purchase as well as to the accounts payable.

$\begin{array}{c}\text{Cash Payments to Suppliers}=\left(\begin{array}{c}\text{Cost of goods sold }\\ -\text{Increase in} \text{Accounts Payable }\\ +\text{Increase in Merchandised Inventory}\end{array}\right)\\ =\$507,000-\$10,000+\$51,000\\ =\$548,000\end{array}$

3.

Calculate the cash payments for Wages expenses.

It represents the total amount of cash paid for the wages.

$\left(\begin{array}{l}\text{Cash payments }\\ \text{for Wages}\end{array}\right)=\text{Wages expense}\left(\begin{array}{l}+\text{Decrease in wages payable}\\ \text{OR}\\ -\text{Increase in wages payable}\end{array}\right)$

Calculate the amount of cash payment made to employees.

Increase/ or decrease in wages payable = $0

$\begin{array}{c}\left(\begin{array}{l}\text{Cash payments }\\ \text{for Wages}\end{array}\right)=\text{Wages expense}\left(\begin{array}{l}\text{+Decrease in wages payable}\\ \text{OR}\\ -\text{Increase in wages payable}\end{array}\right)\\ =\$207,000+/-\$0\\ =\$207,000\end{array}$

4.

Calculate the cash payments for Interest expense.

It represents the total amount of cash paid for the interest expense.

$\left(\begin{array}{l}\text{Cash payments }\\ \text{for Interest}\end{array}\right)=\text{Interest expense}\left(\begin{array}{l}+\text{Decrease in interest payable}\\ \text{OR}\\ -\text{Increase in interest payable}\end{array}\right)$

Calculate the amount of cash payment made for interest.

$\begin{array}{c}\begin{array}{l}\text{Cash payments }\\ \text{for interest}\end{array}\}=\left(\begin{array}{c}\text{Interest expense}\\ -\text{Increase in interest payable}\end{array}\right)\\ =\$12,000-\$5,000\\ =\$7,000\end{array}$

5.

Calculate the cash payments for insurance expense.

It represents the total amount of cash paid for the insurance.

$\left(\begin{array}{l}\text{Cash payments }\\ \text{for insurance}\end{array}\right)=\text{Insurance expense}\left(\begin{array}{l}+\text{Incresae in prepaid insurance}\\ \text{OR}\\ -\text{Decrease in prepaid prepaid insurance}\end{array}\right)$

Calculate the amount of cash payment made for income tax.

$\begin{array}{c}\begin{array}{l}\text{Cash payment}\\ \text{for insurance}\end{array}\}=\left(\begin{array}{c}\text{Insurance expense}\\ -\text{Decrease in prepaid insurance}\end{array}\right)\\ =\$13,000-\$2,000\\ =\$11,000\end{array}$

6.

Calculate the cash payments for income taxes.

It represents the total amount of cash paid for the income tax.

$\left(\begin{array}{l}\text{Cash payments }\\ \text{for Income taxes}\end{array}\right)=\text{Income tax expense}\left(\begin{array}{l}+\text{Decrease in income tax payable}\\ \text{OR}\\ -\text{Increase in income tax payable}\end{array}\right)$

Calculate the amount of cash payment made for income tax.

$\begin{array}{c}\begin{array}{l}\text{Cash payments }\\ \text{for income taxes}\end{array}\}=\left(\begin{array}{c}\text{Income tax expense}\\ +\text{Decrease in income tax payable}\end{array}\right)\\ =\$57,000+\$7,000\\ =\$64,000\end{array}$

Note 1: Calculate the acquisition of plant asset.

Prepare plant asset account:

Plant asset comes under the assets section of the accounting equation; therefore, a debit increases plant account balance and a credit decreases plant account balance.

Plant asset Account
Date	Details	Debit ($)		Date	Details	Credit ($)
	Beginning balance	770,000			disposed	57,000
	Acquisition	174,000
	Ending balance	887,000

Table (5)

$\begin{array}{c}\text{Acquisation }=\left(\$887,000-\$770,000\right)+\$57,000\\ =\$174,000\end{array}$

Note 2: Calculate Issue of bonds payable for cash

$\begin{array}{c}\text{Issunace of bonds payable for cash }=\$145,000-\$80,000\\ =\$65,000\end{array}$

Note 3: Calculate Issue of common stock for cash

$\begin{array}{c}\text{Issunace of common stock for cash }=\$660,000-\$585,000\\ =\$75,000\end{array}$