Continuing Cookie Chronicle 13- CCC13 The comparative balance sheet of Cookie and Coffee Creations Inc-ANSWER KEY (INSTANT DOWNLOAD)

INSTANT DOWNLOAD

Solution Guide / Answer Key:

Continuing Cookie Chronicle
(Note: This is a continuation of the Cookie Chronicle from Chapters 1 through 12.)

CCC13 The comparative balance sheet of Cookie & Coffee Creations Inc. at October 31, 2012 for the years 2012 and 2011, and the income statements for the years ended October 31, 2011 and 2012, are presented below.

COOKIE & COFFEE CREATIONS INC.
Balance Sheet
October 31
Assets 2012 2011
Cash $ 25,324 $ 5,550
Accounts receivable 3,250 2,710
Inventory 7,897 7,450
Prepaid expenses 5,800 6,050
Equipment 99,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 10,251 9,200
Dividends payable 28,000 25,000
Salaries payable 2,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—24,180
shares issued 24,180 24,180
Additional paid in capital—treasury stock 250 250
Retained earnings 24,802 11,800
Total liabilities and stockholders’ equity $116,071 $88,160

COOKIE & COFFEE CREATIONS INC.
Income Statement
Year Ended October 31
2012 2011
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,850 9,100
Other operating expenses 43,186 42,925
Total operating expenses 209,015 198,375
Income from operations 53,916 56,000
Other expenses
Interest expense 413 0
Loss on sale of computer equipment 2,250 0
Total other expenses 2,663 0
Income before income tax 51,253 56,000
Income tax expense 12,813 14,000
Net income $ 38,440 $ 42,000

Additional information:
Natalie and Curtis are thinking about borrowing an additional $20,000 to buy more kitchen equipment. The loan would be repaid over a 4-year period. The terms of the loan provide for equal semi-annual payments of $2,500 on May 1 and November 1 of each year, plus interest of 5% on the outstanding balance.

Instructions

(a) Calculate the following ratios for 2011 and 2012.
1. Current ratio
2. Debt to total assets
3. Gross profit rate
4. Profit margin
5. Return on assets (Total assets at November 1, 2010, were $33,180.)
6. Return on common stockholders’ equity (Total common stockholders’ equity at November 1, 2010, was $23,180. Dividends on preferred stock were $16,800 in 2011 and $18,000 in 2012).
(b) Prepare a horizontal analysis of the income statement for Cookie & Coffee Creations Inc. using 2011 as a base year.
(c) Prepare a vertical analysis of the income statement for Cookie & Coffee Creations Inc. for 2012 and 2011.
(d) Comment on your findings from parts (a) to (c).
(e) What impact would borrowing an additional $20,000 to buy more equipment have on each of the ratios in (a) above, assuming that no changes are expected on the income statement and balance sheet? Comment on your findings.
(f) What would justify a decision by Cookie & Coffee Creations Inc. to buy the additional equipment? What alternatives are there instead of bank financing?

FILE: PDF