CCC13 The comparative balance sheet of Cookie & Coffee Creations Inc. at October
ID: 2473236 • Letter: C
Question
CCC13 The comparative balance sheet of Cookie & Coffee Creations Inc. at October 31, 2018 for the years 2018 and 2017, and the income statements for the years ended October 31, 2017 and 2018, are presented below.
COOKIE & COFFEE CREATIONS INC.
Balance Sheet
October 31
Assets
2018
2017
Cash
$ 22,324
$ 5,550
Accounts receivable
3,250
2,710
Inventory
7,897
7,450
Prepaid expenses
5,800
6,050
Equipment
102,000
75,500
Accumulated depreciation
(25,200)
(9,100)
Total assets
$116,071
$88,160
Liabilities and Stockholders’ Equity
Accounts payable
$ 1,150
$ 2,450
Income taxes payable
9,251
7,200
Dividends payable
27,000
27,000
Salaries and wages payable
7,250
1,280
Interest payable
188
0
Note payable—current portion
4,000
0
Note payable—long-term portion
6,000
0
Preferred stock, no par, $6 cumulative—
3,000 and 2,800 shares issued,
respectively
15,000
14,000
Common stock, $1 par—25,180
shares issued
25,180
25,180
Additional paid in capital—treasury stock
250
250
Retained earnings
20,802
10,800
Total liabilities and stockholders’ equity
$116,071
$88,160
COOKIE & COFFEE CREATIONS INC.
Income Statement
Year Ended October 31
2018
2017
Sales
$485,625
$462,500
Cost of goods sold
222,694
208,125
Gross profit
262,931
254,375
Operating expenses
Salaries and wages expense
147,979
146,350
Depreciation expense
17,600
9,100
Other operating expenses
48,186
42,925
Total operating expenses
213,765
198,375
Income from operations
49,166
56,000
Other expenses
Interest expense
413
0
Loss on disposal of plant assets
2,500
0
Total other expenses
2,913
0
Income before income tax
46,253
56,000
Income tax expense
9,251
14,000
Net income
$ 37,002
$ 42,000
Instructions
(b) Prepare a horizontal analysis of the income statement for Cookie & Coffee Creations Inc. using 2017 as a base year.
Assets
2018
2017
Cash
$ 22,324
$ 5,550
Accounts receivable
3,250
2,710
Inventory
7,897
7,450
Prepaid expenses
5,800
6,050
Equipment
102,000
75,500
Accumulated depreciation
(25,200)
(9,100)
Total assets
$116,071
$88,160
Liabilities and Stockholders’ Equity
Accounts payable
$ 1,150
$ 2,450
Income taxes payable
9,251
7,200
Dividends payable
27,000
27,000
Salaries and wages payable
7,250
1,280
Interest payable
188
0
Note payable—current portion
4,000
0
Note payable—long-term portion
6,000
0
Preferred stock, no par, $6 cumulative—
3,000 and 2,800 shares issued,
respectively
15,000
14,000
Common stock, $1 par—25,180
shares issued
25,180
25,180
Additional paid in capital—treasury stock
250
250
Retained earnings
20,802
10,800
Total liabilities and stockholders’ equity
$116,071
$88,160
Explanation / Answer
Horizontal Analysis Income statement Cookie & Coffee Creations Inc 2018 2017 Increase/ ( Decrease) Percentage( Increase/ Decrease*100/ 2017) Sales 485625 462500 23125 5% Cost of goods sold 222694 208125 14569 7% Gross Profit 262931 254375 8556 3.36% Salaries & Wages 147979 146350 1629 1.11% Depreciation 17600 9100 8500 93.40% Other operating Expenses 48186 42925 5261 12.25% Total Operating Expenses 213765 198375 15390 7.75% Income from operations 49166 56000 -6834 -12.20% Interest Expense 413 0 413 100% Loss on disposal of plant 2500 0 2500 100% Total Other Expenses 2913 0 2913 100% Income before Income Tax 46253 56000 -9747 -17.40% Income Tax Expense 9251 14000 -4749 -33.92% Net Income 37002 42000 -4998 -11.9