(continued) P 12-75B
Req. 1
Noncash investing and financing activities:
Acquisition of equipment by issuing
long-term note payable ……………………………..
$13,600
Req. 2
Sally Fagan Design Studio, Inc.
Statement of Cash Flows
Year Ended June 30, 2016
Cash flows from operating activities:
Receipts:
Collections from customers ……………………..
$ 231,600
Interest received ………………………………………
1,200
Total cash receipts ……………………………….
Payments:
To suppliers …………………………………………….
$(95,100)
To employees …………………………………………..
(39,100)
For income tax …………………………………………
(12,100)
For interest ………………………………………………
Total cash payments …………………………….
Net cash provided by operating activities ………
Challenge Exercises and Problem
(20-30 min.) E 12-76
(All amounts in thousands)
Decrease in
Sales
+
Accounts Receivable
a.
Collections
=
$23,996
=
+
Cost
Increase in
Increase in
− Accounts
Payments for
inventory
=
$18,175
=
+
−
$183**
*$3,060 − $2,790 = $270
**$1,549 − $1,366 = $183
Other Operating
Increase in
c.
Payments for
Expenses
− Accrued Liabilities
expenses
Increase in
d.
Payment of
Tax Expense −
Income Tax Payable
income tax
=
=
e.
Proceeds from
Beg. Common
End. Common
issuance of
Stock
+
Issuance
= Stock
stock
=
$74
=
$446
+
X
= $520
= $74
Beg. Ret.
End. Ret.
Payment of
+
− Dividends
= Earnings
dividends
=
= $4,329
X
= $626
(20 min.) E 12-77
a.
(All in thousands)
Loss on sale of
Book value of
assets sold
Proceeds from
sale of assets
property and
=
−
equipment
=
−
Property & Equipment, Net
Bal., 12/31/15
9,640
Capital
Depreciation exp.
1,890
expenditures
4,130
Book value of
property and
Bal., 12/31/16
b.
Long-Term Notes Payable
Bal., 12/31/15
3,010
Repayment
150
Proceeds from
Issuance
1,175
LT debt issued
for something
other than cash
= 65
Bal. 12/31/16
P 12–78
Assets:
December
31, 2015
December
31, 2016
Cash and cash
equivalents
$14,000
$153,500
Given
Accounts receivable
(net)
95,000
28,700
($95,000 – $66,300)
Inventory
78,400
($60,500 + $17,900)
Prepaid expenses
3,900
($2,600 + $1,300)
Total assets
$345,500
$376,400
Liabilities:
Accounts payable
$40,300
$41,300
($40,300 + $1,000)
Unearned revenue
9,000
24,000
($9,000 + $15,000)
Dividends payable
-0-
6,000
($9,000 – $3,000)
Income taxes payable
6,000
1,300
($6,000 – $4,700)
Long-term debt
Total liabilities
139,400
141,700
Common stock, no par
Retained earnings
$9,000)
Total stockholders’ equity
206,100
234,700
Total liabilities and
stockholders’ equity
$345,500
$376,400
Decision Cases
(45-60 min.) Decision Case 1
Req. 1 (indirect method for operating activities)
T-Bar-M Camp, Inc.
Statement of Cash Flows
Year Ended December 31, 2016
Cash flows from operating activities:
(Thousands)
Net income ……………………………………………………………
$ 97
Adjustments to reconcile net income to
net cash provided by operating activities:
Depreciation expense ………………………………………
$ 46
Amortization of patents ……………………………………
Increase in accounts receivable ($72 − $61) ………
(11)
Increase in inventories ($194 − $181) ………………..
(13)
Increase in accounts payable ($63 − $56) ………….
Decrease in accrued liabilities ($17 − $12) ………..
35
Net cash provided by operating activities …………….
Cash flows from investing activities:
Purchase of property, plant, and
equipment ($369 − $259) ……………………………………..
$(110)
Purchase of long-term investments ($31 − $0) …………
(31)
Net cash used for investing activities ………………….
(141)
Cash flows from financing activities:
Issuance of common stock ($149 − $61) …………………
$ 88
Payment of cash dividends ($156 + $97 − $213) ………
(40)
Payment of long-term notes payable ($264 − $179) ….
(85)
Net cash used for financing activities ………………….
(37)
Cash balance, December 31, 2015 ……………………………..
Cash balance, December 31, 2016 ……………………………..
$ 17
(continued) Decision Case 1
Req. 2
The cash balance at the end of 2016 is low because:
• The camp paid $110,000 to buy new property, plant, and
equipment.
Req. 3
Year 2016 was a good year. Net income was $97,000, and operations
were the largest source of cash. Also, the company increased its
property, plant, and equipment by $110,000 and paid off $85,000 of debt.
(15-25 min.) Decision Case 2
Four-Star Catering looks like the better investment because:
1. Operations provide far more cash for Four-Star than for Applied
Technology. Operations should be the main source of cash for a
healthy company.
4. Four-Star is raising more cash by selling stock than Applied is. This
gives Four-Star more cash to invest in research and development of
new products and other innovations to enhance the company’s
competitiveness. Applied, on the other hand, is paying off debt. That
is not necessarily bad for Applied, but Four-Star appears to be a step
Ethical Issue
Req. 1
Cash flows from operating
activities:
Without
Reclassification
With
Reclassification
Net income ………………………
$ 37,000
$37,000
Increase in accounts
receivable ………………………..
Net cash (used for) provided
by operating activities …………..
$37,000
cash flow from operations is positive.
Req. 2
The issue is whether or not it is ethical to reclassify accounts receivable
from current assets to long-term assets.
Req. 3 and Req. 4
The stakeholders are Columbia, its officers, directors and employees, as
well as their present and future creditors and stockholders.
Economic analysis: The plan to reclassify accounts receivable would
have an immediate positive impact on Columbia and its employees
(continued) Ethical case
Legal analysis: To reclassify receivables when, in fact, they are not truly
collectible, even in the long run, might leave the company open later to a
lawsuit for damages suffered by creditors who loan Columbia money
based on false information.
Ethical analysis: To reclassify receivables when, in fact, they are not
truly collectible in the long run, deprives the banks of accurate
Req. 5
The receivables should be classified in the way that best describes their
collectability. In reality, most bank loan officers who know financial
Req. 6
Focus on Financials: Apple Inc.
(40-50 min.)
Req. 1
Apple uses the indirect method to report operating cash flows. You can
tell because the statement begins with net income.
Req. 2
The main source of cash is operating activities ($59,713 million). This
(continued) Apple Inc.
Req. 3
a. The Balance Sheet provides the balance of Allowance for Doubtful
accounts.
Gross Accounts Receivable, Vendors and Customers
Beg. Bal. ($13,102 + $99)
13,201
Sales (income statement)
Write-offs (see below)
End. Bal. ($17,460 + $86)
17,546
Beg. Bal.
Doubtful accounts expense
($182,795 x .005)
(continued) Apple Inc.
b. Using the format provided in Exhibit 12-15: (Amounts in millions)
Payments for
=
Cost of
+
Increase in
−
Increase in
inventory
sales
Inventory
Accounts Payable
$7,829
expenses
$16,361
=
$18,034
+
$2,924
−
$4,597
($9,806 − $6,882)
($18,453 – $13,856)
(continued) Apple Inc.
c. In 2014, for Apple Inc.,
• Net income increased from 2013 by $2,473 million.
($39,510 − $37,037)
Focus on Analysis: Under Armour, Inc.
(20-30 min.)
(All amounts are in millions)
Req. 1
The main source of cash is operating activities ($219 million). This is
good news. This indicates that Under Armour, Inc.’s basic operations
Req. 2
The three most significant differences between net income and net cash
provided by operations are:
1. Change in accounts receivable of $101 million.
(continued) Under Armour, Inc.
Req. 3
In 2014, Under Armour’s additions to property, plant, and equipment
were more than previous years’ additions. This is evident in the
Req. 4
The largest item in Under Armour’ financing section of their
consolidated statement of cash flows is the proceeds from its term loan.
This reveals that the company strategy is to expand through additional
Req. 5
Under Armour appears to have healthy cash flows indicating good
performance. Net cash flows from operations have increased overall
from 2012 – 2014. Additionally, they are able to spend cash on capital
assets to support the business and repayment of some of their debt.
Group Projects
(2-3 hours)
Student responses will vary on this assignment.