Financial & Managerial Accounting, 5th Edition
682
Exercise 12–10 (Part 1 continued)
(1)
Cost of equipment sold (Given) ………………………………………………………..…
$ 48,600
Accumulated depreciation of equipment sold* …………………………………..…
(40,600)
Book value of equipment sold ………………………………………………………….…
8,000
Gain on sale of equipment (Given) …………………………..……………………….…
2,000
Cash receipt from sale of equipment ……………………………………………………
$ 10,000
Cost of equipment sold ………………………………………………………………………
$ 48,600
Plus net increase in the equipment account balance …………………………..
9,000
Cash paid for new equipment (given) ………………………………………………..…
$ 57,600
Equipment
Accumulated Depreciation, Equipment
Bal., 6/30/2012
Bal., 6/30/2012
9,000
Purchase
Sale 48,600
Sale (plug) *40,600
Depr. Expense
58,600
Bal., 6/30/2013
Bal., 6/30/2013
27,000
(2)
Carrying value of notes retired ……………………………………………………………
$ 30,000
Cash payment to retire notes ………………………………………………………………
$ 30,000
(3)
Retained Earnings
Bal., 6/30/2012
24,100
Dividends (plug)
90,310
Net income
99,510
Bal., 6/30/2013
33,300
Part 2
Cash flow on total assets ratio = Operating cash flows / Average total assets
Exercise 12–11B (40 minutes)
Part 1
IKIBAN, INC.
Statement of Cash Flows (Direct Method)
For Year Ended June 30, 2013
Cash flows from operating activities
Cash received from customers (Note 1) ………..
$664,000
Cash paid for merchandise (Note 2) ……………..
(393,300)
Cash paid for operating expenses (Note 3) ……
(75,000)
Cash paid for income taxes (Note 4) ……………..
(44,290)
Net cash provided by operating activities ……..
$151,410
Cash flows from investing activities
Cash received from sale of equip. (Note 5) ……
10,000
Cash paid for equipment (Note 5—given) ……..
(57,600)
Net cash used in investing activities …………….
(47,600)
Cash flows from financing activities
Cash received from stock issuance ………………
60,000
Cash paid to retire notes (Note 6) …………………
(30,000)
Cash paid for dividends (Note 7) …………………..
(90,310)
Net cash used in financing activities …………….
(60,310)
Net increase in cash ……………………………………….
$ 43,500
Cash balance at prior year-end ……………………….
44,000
Cash balance at current year-end ……………………
$ 87,500
(See notes on next page)
Bal., 6/30/2012
24,100
Dividends (plug)
Net income
99,510
Bal., 6/30/2013
33,300
Exercise 12–11B (continued)
Notes
(1)
Sales …………………………………………………………………………………………………
$678,000
Less increase in accounts receivable ……………………………………………….…
(14,000)
Cash received from customers ……………………………………………………………
$664,000
(2)
Cost of goods sold …………………………………………………………………………..…
$411,000
Less decrease in merchandise inventory ………………………………………….…
(22,700)
Purchases ……………………………………………………………………………………….…
388,300
Plus decrease in accounts payable …………………………………………………..…
5,000
Cash paid for merchandise …………………………………………………………………
$393,300
(3)
Other operating expenses ………………………………………………………………..…
$ 67,000
Plus decrease in wages payable ……………………………………………………….
9,000
Less decrease in prepaid expenses ………………………………………………….…
(1,000)
Cash paid for other operating expenses ………………………………………………
$ 75,000
(4)
Income taxes expense ……………………………………………………………………..…
$ 43,890
Plus decrease in income taxes payable …………………………………………….…
400
Cash paid for income taxes …………………………………………………………………
$ 44,290
(5)
Cost of equipment sold (Given) ………………………………………………………..…
$ 48,600
Accumulated depreciation of equipment sold* …………………………………..…
(40,600)
Book value of equipment sold …………………………..……………………………..…
8,000
Gain on sale of equipment …………………………..…………………………………..…
2,000
Cash receipt from sale of equipment ……………………………………………………
$ 10,000
Cost of equipment sold ………………………………………………………………………
$ 48,600
Plus net increase in the equipment account balance …………………………..
9,000
Cash paid for new equipment (given) ………………………………………………..…
$ 57,600
Equipment
Accumulated Depreciation, Equipment
Bal., 6/30/2012
115,000
Bal., 6/30/2012
9,000
Purchase
57,600
Sale 48,600
Sale *40,600
Depr. Expense
58,600
Bal., 6/30/2013
124,000
Bal., 6/30/2013
27,000
(6)
Carrying value of notes retired ……………………………………………………………
$ 30,000
Cash payment to retire notes ………………………………………………………………
$ 30,000
Exercise 12-12 (20 minutes)
Cash flows from operating activities—indirect method
Net income …………………………………………………………………………………...
$ 24,000
Depreciation expense …………………………………………………………………..…..
12,000
Accounts receivable increase ……………………………………………………….
(10,000
)
Inventory decrease …………………………………………………………………………..
16,000
Salaries payable increase …………………………………………………………….…..
1,000
Net cash provided by operating activities ……………………………………..…..
$ 43,000
Exercise 12-13 (30 minutes)
1.
Cash flows from operating activities—indirect method
Net income (loss) …………………………………………………………………….……….
$ (16,000
)
Depreciation expense ……………………………………………………………………….
14,600
Accounts receivable decrease ……………………………………………………….
24,000
Salaries payable increase ………………………………………………………………….
18,000
Accrued liabilities decrease ……………………………………………………....
(8,000
)
Net cash provided by operating activities ………………………………………….
$ 32,600
2. One reason for the net loss was depreciation expense. Depreciation
expense is added to net income to adjust for the effects of a noncash
3. Differences between cash flow from operations and net income can be
Financial & Managerial Accounting, 5th Edition
686
Exercise 12–14A (30 minutes)
SCORETECK CORPORATION
Spreadsheet for Statement of Cash Flows
For Year Ended December 31, 2013
December
31, 2012
Analysis of Changes
December
31, 2013
Debit
Credit
Balance sheet—debit bal. accounts
Cash ………………………………………………....
$ 80,000
$ 60,000
Accounts receivable ………………………...
120,000
(f)
$ 70,000
190,000
Merchandise inventory ……………………..
250,000
(g)
$ 20,000
230,000
Plant assets ……………………………………...
600,000
(d)
70,000
670,000
$1,050,000
$1,150,000
Balance sheet—credit bal. accounts
Accum. depreciation—Plant assets ....
$ 100,000
(c)
70,000
$ 170,000
Accounts payable ……………………………..
150,000
(h)
10,000
140,000
Notes payable …………………………..……....
370,000
(e)
20,000
390,000
Common stock ………………………………....
200,000
200,000
Retained earnings……………………………..
230,000
(b)
80,000
(a)
100,000
250,000
$1,050,000
$1,150,000
Statement of cash flows
Operating activities
Net income ………………………………………..
(a)
100,000
Increase in accounts receivable ……...
(f)
70,000
Decrease in merch. inventory …………..
(g)
20,000
Decrease in accounts payable ………....
(h)
10,000
Depreciation expense ……………………....
(c)
70,000
Investing activities
Payment for plant assets…………………..
(d)
70,000
Financing activities
Paid cash dividends ………………………....
(b)
80,000
Issued note payable ………………………....
(e)
20,000
_______
$440,000
$440,000
Exercise 12–15B (20 minutes)
FERRON COMPANY
Statement of Cash Flows
For Year Ended December 31, 2013
Cash flows from operating activities
Receipts from customers …………………………………....
$ 495,000
Receipts of interest……………………………………………..
3,500
Payments for merchandise ………………………………....
(254,500)
Payments for salaries ………………………………………....
(76,500)
Payments for other expenses ……………………………...
(20,000)
Net cash provided by operating activities …………....
$147,500
Cash flows from investing activities
Receipt from sale of equipment …………………………..
60,250
Payment for store equipment ……………………………...
(24,750)
Net cash provided by investing activities …………....
35,500
Cash flows from financing activities
Payment to retire long-term notes payable …………..
(100,000)
Receipt from borrowing on six-month note ………....
35,000
Payment of cash dividends ………………………………...
(10,000)
Net cash used in financing activities …………………...
(75,000)
Net increase in cash and cash equivalents ……………..
$108,000
Cash and cash equivalents at prior year-end ………....
40,000
Cash and cash equivalents at current year-end ……...
$148,000
Note No. ___
Financial & Managerial Accounting, 5th Edition
688
Exercise 12–16B (40 minutes)
1.
THOMAS CORPORATION
Statement of Cash Flows
For Year Ended December 31, 2013
Cash flows from operating activities
Cash received from customers ………………………………….
$5,000,000
Cash received from dividends ……………………………….….
208,400
Cash paid for merchandise ……………………………………….
(2,590,000)
Cash paid for wages ……………………………………………..….
(550,000)
Cash paid for rent ………………………………………………….….
(320,000)
Cash paid for interest ……………………………………………….
(218,000)
Cash paid for taxes ……………………………………………….….
(450,000)
Net cash provided by operating activities ………………….
$1,080,400
Cash flows from investing activities
Cash paid for purchases of machinery …………………..….
(2,236,000)
Cash paid for purchases of long-term investments ..….
(1,260,000)
Cash received from sale of land …………………………….….
220,000
Cash received from sale of machinery ……………………….
710,000
Net cash used in investing activities ………………………….
(2,566,000)
Cash flows from financing activities
Cash received from issuing stock …………………………..
1,540,000
Cash received from borrowing ………………………………….
3,600,000
Cash paid for note payable ……………………………………….
(386,000)
Cash paid for dividends …………………………………………….
(500,000)
Cash paid for treasury stock purchases. ………………..….
(218,000)
Net cash provided by financing activities ……………….….
4,036,000
Net increase in cash………………………………………………..….
$2,550,400
Beginning balance of cash ………………………………………….
333,000
Ending balance of cash …………………………………………..….
$2,883,400
2.
a. (i) Financing section reported the largest cash inflow of $4,036,000.
(ii) Investing section reported the largest cash outflow of $2,566,000.
b. The largest individual item among the investing cash outflows is the purchase
Exercise 12-17 (15 minutes)
~10%). Further, the ratio improved from 8.3% to 9.2%, which is a good increase.
Exercise 12-18 (20 minutes)
PEUGEOT S.A.
Statement of Cash Flows (Indirect Method)
For Year Ended December 31, 2011
Cash flows from operating activities
Net income ……………………………………………………………...
€ 784
Adjustments to reconcile net income to net cash
provided by operating activities
Net change (decrease) in working capital ………………...
(1,183)
Depreciation and amortization ………………………………...
3,037
Gains on disposals and other ………………………………....
(883)
Net cash from operating activities …………………………..
€ 1,755
Cash flows from investing activities
Cash from disposal of plant assets & intangibles……..
189
Cash paid for plant assets and intangibles ……………....
(3,921)
Net cash used in investing activities ………………………..
(3,732)
Cash flows from financing activities
Cash from purchases of treasury stock …………………...
(199)
Cash paid for dividends …………………………………………..
(290)
Cash paid for other financing activities …………………...
(2,282)
Net cash from financing activities …………………………..
(2,771)
Net decrease in cash ………………………………………………....
€ (4,748)
Cash and cash equivalents, Dec 31, 2010 …………………...
10,442
Cash and cash equivalents, Dec 31, 2011 …………………...
€ 5,694
Financial & Managerial Accounting, 5th Edition
690
PROBLEM SET A
Problem 12-1A (50 minutes)
Part 1
FORTEN COMPANY
Statement of Cash Flows
For Year Ended December 31, 2013
Cash flows from operating activities
Net income ………………………………………………………………………………
$114,975
Adjustments to reconcile net income to net
cash provided by operating activities:
Increase in accounts receivable ($65,810 – $50,625) ………..……
(15,185)
Increase in inventory ($275,656 – $251,800) ………………………..…
(23,856)
Decrease in prepaid expenses ($1,875 – $1,250) ……………………
625
Decrease in accounts payable ($114,675 – $53,141) ………………
(61,534)
Depreciation expense …………………………………………………….…
20,750
Loss on disposal of equipment ……………………………………..……
5,125
Net cash provided by operating activities …………………………..
$ 40,900
Cash flows from investing activities
Cash received from sale of equipment ……………………………..……
11,625
Cash paid for equipment ……………………………………………………….
(30,000)
Net cash used in investing activities ………………………………………
(18,375)
Cash flows from financing activities
Cash borrowed on short–term note …………………………………..……
4,000
Cash paid on long–term note ……………………………………………..……
(50,125)
Cash received from issuing stock (2,500 x $20) ………………….……
50,000
Cash paid for dividends …………………………………………………….…
(50,100)
Net cash used in financing activities ………………………………………
(46,225)
Net decrease in cash …………………………………………………………………
$(23,700)
Cash balance at December 31, 2012 …………………………………….……
73,500
Cash balance at December 31, 2013 …………………………………….……
$ 49,800
Noncash investing and financing activities
Purchased equipment for $96,375 by signing a $66,375 long-term note payable
and paying $30,000 in cash.
Problem 12-1A (Concluded)
Part 2
Forten Company’s operations provide a positive net cash inflow of $40,900—a
good result. At the same time, the cash balance decreased by $23,700 (32%)
Financial & Managerial Accounting, 5th Edition
692
Problem 12–2AA (60 minutes)
FORTEN COMPANY
Spreadsheet for Statement of Cash Flows
For Year Ended December 31, 2013
December
31, 2012
Analysis of Changes
December
31, 2013
Debit
Credit
Balance sheet—debits
Cash ………………………………………………….
$ 73,500
$ 49,800
Accounts receivable ……………………..….
50,625
(b)
$15,185
65,810
Merchandise inventory ………………….….
251,800
(c)
23,856
275,656
Prepaid expenses …………………………..
1,875
(d)
$ 625
1,250
Equipment …………………………………….….
108,000
(h)
96,375
(g)
46,875
157,500
$485,800
$550,016
Balance sheet—credits
Accum. depreciation—Equip. ……….….
$ 46,000
(g)
30,125
(f)
20,750
$ 36,625
Accounts payable …………………………..
114,675
(e)
61,534
53,141
Short–term notes payable ……………..….
6,000
(j)
4,000
10,000
Long–term notes payable ………………….
48,750
(k)
50,125
(i)
66,375
65,000
Common stock, $5 par value ………..….
150,250
(l)
12,500
162,750
Paid–in capital in excess of
par value, common stock …………..….
0
(l)
37,500
37,500
Retained earnings …………………………..
120,125
(m)
50,100
(a)
114,975
185,000
$485,800
$550,016
Statement of cash flows
Operating activities
Net income ……………………………………….
(a)
114,975
Increase in accts. receivable …………….
(b)
15,185
Increase in merch. inventory …………….
(c)
23,856
Decrease in prepaid expenses ………….
(d)
625
Decrease in accounts payable ………….
(e)
61,534
Depreciation expense ……………………….
(f)
20,750
Loss on sale of equipment ……………….
(g)
5,125
Investing activities
Receipt from sale of equipment …….….
(g)
11,625
Payment to purchase equipment ….….
(h)
30,000
Financing activities
Borrowed on short–term note………..….
(j)
4,000
Payment on long-term note …………..….
(k)
50,125
Issued common stock for cash …….….
(l)
50,000
Payments of cash dividends …………….
(m)
50,100
Noncash investing and
financing activities
Purchase of equip. financed
by long-term note payable ………
(i)
66,375
(h)
66,375
$600,775
$600,775
Problem 12–2AA (Concluded)
FORTEN COMPANY
Statement of Cash Flows
For Year Ended December 31, 2013
Cash flows from operating activities
Net income ………………………………………………………………………………
$114,975
Adjustments to reconcile net income to net
cash provided by operating activities:
Increase in accounts receivable ($65,810 – $50,625) ………..……
(15,185)
Increase in inventory ($275,656 – $251,800) ………………………..…
(23,856)
Decrease in prepaid expenses ($1,875 – $1,250 ) ……………..……
625
Decrease in accounts payable ($114,675 – $53,141) ………………
(61,534)
Depreciation expense …………………………………………………….…
20,750
Loss on disposal of equipment ……………………………………..……
5,125
Net cash provided by operating activities …………………………..
$ 40,900
Cash flows from investing activities
Cash received from sale of equipment ……………………………..……
11,625
Cash paid for equipment ……………………………………………………….
(30,000)
Net cash used in investing activities ………………………………………
(18,375)
Cash flows from financing activities
Cash borrowed on short–term note …………………………………..……
4,000
Cash paid on long–term note ……………………………………………..……
(50,125)
Cash received from issuing stock (2,500 x $20) ………………….……
50,000
Cash paid for dividends …………………………………………………….…
(50,100)
Net cash used in financing activities ………………………………………
(46,225)
Net decrease in cash …………………………………………………………………
$(23,700)
Cash balance at beginning of 2013 ……………………………………………
73,500
Cash balance at end of 2013 ………………………………………………..……
$ 49,800
Noncash investing and financing activities
Purchased equipment for $96,375 by signing a $66,375 long-term note payable
and paying $30,000 in cash.
Problem 12–3AB (40 minutes)
FORTEN COMPANY
Statement of Cash Flows
For Year Ended December 31, 2013
Cash flows from operating activities
Cash received from customers (Note 1) ………………..
$567,315
Cash paid for merchandise (Note 2) ……………………..
(370,390)
Cash paid for other expenses (Note 3) ………………....
(131,775)
Cash paid for income taxes ………………………………...
(24,250)
Net cash provided by operating activities …………....
$ 40,900
Cash flows from investing activities
Cash received from sale of equipment ………………...
11,625
Cash paid for equipment ……………………………………..
(30,000)
Net cash used in investing activities …………………...
(18,375)
Cash flows from financing activities
Cash borrowed on short-term note ……………………...
4,000
Cash paid on long-term note ……………………………....
(50,125)
Cash received from issuing stock (2,500 x $20) ……..
50,000
Cash paid for dividends ……………………………………...
(50,100)
Net cash used in financing activities …………………..
(46,225)
Net decrease in cash ……………………………………………..
$(23,700)
Cash balance at December 31, 2012 ……………………....
73,500
Cash balance at December 31, 2013 ……………………....
$ 49,800
Noncash investing and financing activities
Purchased equipment for $96,375 by signing a $66,375 long-term note payable
and paying $30,000 in cash.
Supporting calculations
(1) Sales – Increase in receivables = $582,500 – ($65,810 – $50,625) = $567,315
Problem 12-4A (35 minutes)
GOLDEN CORPORATION
Statement of Cash Flows
For Year Ended December 31, 2013
Cash flows from operating activities
Net income ………………………………………………………………………..
$136,000
Adjustments to reconcile net income to net
cash provided by operating activities
Increase in accounts receivable ($83,000 – $71,000) ………..
(12,000)
Increase in inventory ($601,000 – $526,000) ……………………...
(75,000)
Increase in accounts payable ($87,000 – $71,000) …………....
16,000
Increase in taxes payable ($28,000 – $25,000) …………………..
3,000
Depreciation expense …………………………………………………....
54,000
Net cash provided by operating activities ………………………..
$122,000
Cash flows from investing activities
Cash paid for equipment …………………………………………………..
(36,000)
Cash flows from financing activities
Cash received from issuing stock (12,000 x $5) ………………...
60,000
Cash paid for cash dividends …………………………………………...
(89,000)
Net cash used in financing activities ………………………………..
(29,000)
Net increase in cash…………………………………………………………....
$ 57,000
Cash balance at December 31, 2012 …………………………..……...
107,000
Cash balance at December 31, 2013 …………………………..……...
$164,000
Financial & Managerial Accounting, 5th Edition
696
Problem 12–5AA (50 minutes)
GOLDEN CORPORATION
Spreadsheet for Statement of Cash Flows
For Year Ended December 31, 2013
December
31, 2012
Analysis of Changes
December
31, 2013
Debit
Credit
Balance sheet—debits
Cash ………………………………………………….
$ 107,000
$ 164,000
Accounts receivable ……………………..….
71,000
(b)
$ 12,000
83,000
Merchandise inventory ………………….….
526,000
(c)
75,000
601,000
Equipment …………………………………….….
299,000
(g)
36,000
335,000
$1,003,000
$1,183,000
Balance sheet—credits
Accum. depreciation—Equip. ……….….
$ 104,000
(f)
$ 54,000
$ 158,000
Accounts payable …………………………..
71,000
(d)
16,000
87,000
Income taxes payable ……………………….
25,000
(e)
3,000
28,000
Common stock, $2 par value …………….
568,000
(h)
24,000
592,000
Paid–in capital in excess of
par value, common stock ……………….
160,000
(h)
36,000
196,000
Retained earnings …………………………..
75,000
(i)
89,000
(a)
136,000
122,000
$1,003,000
$1,183,000
Statement of cash flows
Operating activities
Net income …………………………………….….
(a)
136,000
Increase in accounts receivable …..….
(b)
12,000
Increase in merch. inventory …………….
(c)
75,000
Increase in accounts payable ………..….
(d)
16,000
Increase in income tax payable ……..….
(e)
3,000
Depreciation expense ……………………….
(f)
54,000
Investing activities
Payment for equipment …………………….
(g)
36,000
Financing activities
Issued common stock for cash …….….
(h)
60,000
Paid cash dividends ………………………….
________
(i)
89,000
$481,000
$481,000