Problem 12-4AA (60 minutes)
FORTEN COMPANY
Spreadsheet for Statement of Cash Flows
For Year Ended December 31, 2015
December
31, 2014
Analysis of Changes
December
31, 2015
Debit
Credit
Balance sheet—debits
Cash ……………………………………………..….
$ 73,500
$ 49,800
Accounts receivable ……………………..….
50,625
(b)
$15,185
65,810
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-4AA (Concluded)
FORTEN COMPANY
Statement of Cash Flows
For Year Ended December 31, 2015
Cash flows from operating activities
Net income ………………………………………………………………………………
$114,975
Adjustments to reconcile net income to net
cash provided by operating activities:
Income statement items not affecting cash
Depreciation expense …………………………..………………………..…
20,750
Loss on disposal of equipment ……………………………………..……
5,125
Changes in current assets and current liabilities
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)
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 2015 ……………………………………………
73,500
Cash balance at end of 2015 ………………………………………………..……
$ 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-5AB (40 minutes)
FORTEN COMPANY
Statement of Cash Flows
For Year Ended December 31, 2015
Cash flows from operating activities
Cash received from customers (Note 1) ………………..
$567,315
Cash paid for inventory (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, 2014 ……………………....
73,500
Cash balance at December 31, 2015 ……………………....
$ 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
(2) Cost of Increase in Decrease in
(3) Other expenses – Decrease in prepaid expenses = $132,400 – ($1,875 – $1,250)
+
+
Problem 12-6A (35 minutes)
GOLDEN CORPORATION
Statement of Cash Flows
For Year Ended December 31, 2015
Cash flows from operating activities
Net income ………………………………………………………………………..
$136,000
Adjustments to reconcile net income to net
cash provided by operating activities
Income statement items not affecting cash
Depreciation expense ………………………………………………....
54,000
Changes in current assets and current liabilities
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
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, 2014…………………………………...
107,000
Cash balance at December 31, 2015…………………………………...
$164,000
Problem 12-7AA (50 minutes)
GOLDEN CORPORATION
Spreadsheet for Statement of Cash Flows
For Year Ended December 31, 2015
December
31, 2014
Analysis of Changes
December
31, 2015
Debit
Credit
Balance sheet—debits
Cash …………………………..………………….….
$ 107,000
$ 164,000
Accounts receivable ……………………..….
71,000
(b)
$ 12,000
83,000
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
Problem 12-7AA (Concluded)
GOLDEN CORPORATION
Statement of Cash Flows
For Year Ended December 31, 2015
Cash flows from operating activities
Net income ………………………………………………………………………..
$136,000
Adjustments to reconcile net income to net
cash provided by operating activities
Income statement items not affecting cash
Depreciation expense ………………………………………………....
54,000
Changes in current assets and current liabilities
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
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 beginning of 2015 ……………………………………..
107,000
Cash balance at end of 2015 …………………………..…………………..
$164,000
Problem 12-8AB (35 minutes)
GOLDEN CORPORATION
Statement of Cash Flows
For Year Ended December 31, 2015
Cash flows from operating activities
Cash received from customers (Note 1) ………….….
$1,780,000
Cash paid for inventory (Note 2) ……………………….
(1,145,000)
Cash paid for other operating expenses ……….….
(494,000)
Cash paid for income taxes (Note 3) ………………….
(19,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 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, 2014 …………………….
107,000
Cash balance at December 31, 2015 …………………….
$164,000
Supporting calculations
(1) Sales – Increase in receivables = $1,792,000 – ($83,000 – $71,000) = $1,780,000
(2) Cost of Increase in Increase in
(3) Income taxes expense – Increase in income taxes payable
+
–
©2016 by McGraw–Hill Education. This is proprietary material solely for authorized instructor use. Not authorized for sale or distribution in any
manner. This document may not be copied, scanned, duplicated, forwarded, distributed, or posted on a website, in whole or par t.
Financial and Managerial Accounting, 6th Edition
712
PROBLEM SET B
Problem 12-1B (35 minutes)
SALT LAKE COMPANY
Cash Flows from Operating Activities—Indirect Method
For Year Ended December 31, 2015
Cash flows from operating activities
Net income ………………………………………………………………….…
$ 20,000
Adjustments to reconcile net income to net cash
provided by operating activities
Income statement items not affecting cash
Depreciation expense …………………………………………….…
$32,000
Changes in current operating assets and liabilities
Increase in accounts receivable ……………………………..…
(600
)
Decrease in inventory …………………………………………….…
120
Decrease in accounts payable ………………………………..…
(200
)
Increase in salaries payable ………………………………………
300
Increase in utilities payable …………………………………….…
200
Decrease in prepaid insurance ……………………………….…
40
Decrease in prepaid rent ………………………………………..…
100
31,960
Net cash provided by operating activities …………………….…
$ 51,960
Problem 12-2BB (35 minutes)
SALT LAKE COMPANY
Cash Flows from Operating Activities—Direct Method
For Year Ended December 31, 2015
Cash flows from operating activities
Cash receipts from customers (1) ………………………………………….…….
$ 155,400
Cash payments to suppliers (2) ……………………………………………..…….
(72,080
)
Cash payments for salaries (3) …………………………………………………….
(19,700
)
Cash payments for rent (4) …………………………………………………….…
(4,900
)
Cash payments for insurance (5)…………………………..……………….…….
(2,560
)
Cash payments for utilities (6) ……………………………………………….…….
(1,800
)
Cash payments for interest ……………………………………………………….
(2,400
)
Net cash provided by operating activities …………………………………..…….
$ 51,960
Supporting calculations
(1) Sales – Increase in receivables = $156,000 – ($3,600 – $3,000) = $155,400
(2) Cost of Decrease in Decrease in
(3) Salaries expense – Increase in salaries payable
(4) Rent expense – Decrease in prepaid rent
(5) Insurance expense – Decrease in prepaid insurance
(6) Utilities expense – Increase in utilities payable
–
+
Problem 12-3B (40 minutes)
Part 1
GAZELLE CORPORATION
Statement of Cash Flows
For Year Ended December 31, 2015
Cash flows from operating activities
Net income ………………………………………………………………………………
$158,100
Adjustments to reconcile net income to net
cash provided by operating activities
Income statement item not affecting cash
Depreciation expense …………………………..………………………..…
38,600
Loss on disposal of equipment ……………………………………..……
2,100
Changes in current assets and current liabilities
Decrease in accounts receivable ($80,750 – $77,100) ……….……
3,650
Decrease in inventory ($250,700 – $240,600) ……………………
10,100
Decrease in prepaid expenses ($17,000 – $15,100) …………..……
1,900
Decrease in accounts payable ($102,000 – $17,750) ………………
(84,250)
Net cash provided by operating activities …………………………..
$130,200
Cash flows from investing activities
Cash received from sale of equipment ……………………………..……
26,050
Cash paid for equipment ……………………………………………………….
(43,250)
Net cash used in investing activities ………………………………………
(17,200)
Cash flows from financing activities
Cash borrowed on short-term note …………………………………..……
5,000
Cash paid on long–term note ……………………………………………..……
(47,500)
Cash received from issuing stock (3,000 x $15) ………………….……
45,000
Cash paid for dividends …………………………………………………….…
(53,600)
Net cash used in financing activities ………………………………………
(51,100)
Net increase in cash……………………………………………………………..……
$ 61,900
Cash balance at December 31, 2014…………………………………….……
61,550
Cash balance at December 31, 2015…………………………………….……
$123,450
Noncash investing and financing activities
Purchased equipment for $113,250 by signing a $70,000 long–term note
payable and paying $43,250 in cash.