Student Name:
Class:
2015 2014 Change
73,250$ 63,500$ 9,750 Correct!
15,250 21,350 (6,100) Correct!
23,450 18,000 5,450 Correct!
209,250 160,350 48,900 Correct!
(57,450) (45,750) (11,700) Correct!
263,750$ 217,450$
Correct! Correct!
16,500$ 19,000$ (2,500) Correct!
2,000 2,700 (700) Correct!
56,300 71,000 (14,700) Correct!
103,950 65,900 38,050 Correct!
85,000 58,850 26,150 Correct!
263,750$ 217,450$
Correct! Correct!
205,000$
123,500
11,700
43,000
26,800$
Correct!
Sharp Screen Films, Inc.
Sales
Cost of goods sold
Depreciation expense
Other expenses
Net income
Problem 12-01
Property and equipment
Less: Accumulated depreciation
Total
McGraw-Hill/Irwin
Instructor
Requirement 1:
Income statement for 2015
Balance Sheet at December 31
Cash
Accounts receivable
Merchandise inventory
Accounts payable
Wages payable
Note payable-long term
Contributed capital
Retained earnings
Total
26,800$
11,700$
6,100
(5,450)
(2,500)
(700) 9,150
35,950$ Correct!
(48,900) Correct!
(14,700)
(650)
38,050
22,700 Correct!
9,750
63,500
73,250$
Correct!
An overall increase in cash of $9,750 came from inflows of $35,950 from operating activities and a stock
issuance of $38,050. A large percentage of the cash inflows were invested in equipment ($48,900), with
$14,700 used to pay down long-term financing and $650 for dividends.
For the Year Ended December 31, 2015
Statement of Cash Flows
Sharp Screen Films, Inc.
Cash flows from financing activities:
Cash payments to purchase fixed assets
Cash receipts from issuing stock
Net cash provided by financing activities
Cash flows from investing activities:
Cash flows from operating activities:
Decrease in accounts payable
Decrease in wages payable
Net cash provided by operating activities
Net increase in cash during the year
Cash balance, January 1, 2015
Statement of cash flows evaluation:
Requirement 2:
Net income
Adjustments to reconcile net income to
net cash provided by operating activities:
Depreciation expense
Decrease in accounts receivable
Increase in merchandise inventory
Cash balance, December 31, 2015
Cash payments on long-term note
Cash payments for dividends
2015 2014
73,250$ 63,500$
15,250 21,350
23,450 18,000
209,250 160,350
(57,450) (45,750)
263,750$ 217,450$
16,500$ 19,000$
2,000 2,700
56,300 71,000
103,950 65,900
85,000 58,850
263,750$ 217,450$
205,000$
123,500
11,700
43,000
26,800$
48,900$
14,700
38,050
650
For the Year Ended December 31, 2015
Financial Statements
Sharp Screen Films, Inc.
Additional data:
Income statement for 2015:
Balance sheet at December 31:
Cash
Accounts receivable
Merchandise inventory
Property and equipment
Less: Accumulated depreciation
Total
Accounts payable
Wages payable
Notes payable, long-term
Contributed capital
Retained earnings
Total
Sales
Cost of goods sold
Depreciation expense
Other expenses
Other expenses all relate to wages
A/P include only inventory purchases
made on credit
Net income
Bought equipment for cash
Paid on long-term note payable
Issued new shares of stock for cash
Declared and paid cash dividend
Student Name:
Class:
7,000$
4,000$
2,000
(3,000)
6,000
500
9,500
16,500 Correct!
(12,000) Correct!
(6,000)
18,500
(2,000)
10,500 Correct!
15,000
Requirement 3:
Cash balance, January 1, 2016
For the Year Ended December 31, 2016
Statement of Cash Flows
HANKS COMPANY
Instructor
McGraw-Hill/Irwin
Problem 12-06
Requirement 2:
net cash provided by operating activities:
Total adjustments
Cash flows from financing activities:
Cash flows from investing activities:
Cash flows from operating activities:
Net income
Adjustments to reconcile net income to
Cash payments for dividends
Net cash provided by financing activities
Net increase in cash during the year
Depreciation expense
Decrease in accounts receivable
Increase in merchandise inventory
Increase in accounts payable
Decrease in wages payable
Net cash provided by operating activities
Cash payment to purchase fixed assets
Cash payments on long-term note
Cash receipts from issuing stock
2016 2015
33,000$ 18,000$
26,000 28,000
39,000 36,000
80,000 72,000
178,000$ 154,000$
27,000$ 21,000$
1,500 1,000
42,000 48,000
78,500 60,000
29,000 24,000
178,000$ 154,000$
80,000$
(43,000)
(30,000)
7,000$
12,000$
6,000
4,000
12,000
2,000
12,000
Sold unissued common stock for cash
Declared and paid cash dividend
Given Data P12-06:
Additional data:
Income statement for 2016:
Balance sheet at December 31:
Cash
Accounts receivable
Sales
Merchandise inventory
Fixed assets-net
Total
Accounts payable
Expenses
Net income
For the Year Ended December 31, 2013
Financial Statements
HANKS COMPANY
Bought fixed assets for cash
Wages payable
Notes payable, long-term
Common stock, no par
Retained earnings
Total
Cost of goods sold
Other expenses
Paid on long-term note payable
Depreciation expense
Wages expense
Taxes expense
Required:
1.
2.
3.
4.
This workbook is organized as follows:
Sheet Name Contents
CP12-3 (this worksheet) CP13-3 Problem Requirements and Workbook Layout
Industry Ratio Report Industry Ratio Report
AEO Balance Sheets American Eagle Outfitters, Inc. Consolidated Balance Sheets
AEO Income Statements American Eagle Outfitters, Inc. Consolidated Statements of Operations
AEO Stmts of Stockholders’ Eq American Eagle Outfitters, Inc. Consolidated Statements of Stockholders’ Equity
AEO Statements of Cash Flow American Eagle Outfitters, Inc. Consolidated Statements of Cash Flows
Urban Balance Sheets Urban Outfitters, Inc. Consolidated Balance Sheets
Urban Income Statements
Urban Stmts of Stockholders’ Eq Urban Outfitters, Inc. Consolidated Statements of Stockholders’ Equity
Urban Stmts of Cash Flow Urban Outfitters, Inc. Consolidated Statements of Cash Flows
CP12-3 Comparing Companies within an Industry
Urban Outfitters, Inc. Consolidated Statements of Income
Compute the quality of income ratio for both companies for the most recent reporting year. Which company has a better
quality of income ratio?
Compare the quality of income ratio for both companies to the industry average. Are these companies producing more
or less cash from operating activities relative to net income than the average company in the industry?
Compute the capital acquisitions ratio for both companies for the most recent reporting year. Compare their abilities to
finance purchases of property, plant, and equipment with cash provided by operating activities.
Compare the capital acquisitions ratio for both companies to the industry average. How does each company‘s ability to
finance the purchase of property, plant, and equipment with cash provided by operating activities compare with that of
other companies in the industry?
2.67
Company
Name
Ticker
Symbol
1.48 ANF
ARO
AEO
4.92 ASNA
100.820 days BWS
97.49 CHS
12.63 days PSS
7.43 DDS
1.75 DSW
11.55 FL
GCO
GES
42.47% JOSB
12.37% SKS
5.40% SIG
13.61% SSI
9.09% BKE
1.81 PLCE
FINL
MW
92.35 URBN
Total Debt/Total Equity
0.70
1.70
15.24%
1.49%
5.55%
8.87%
2.62
16.10
INDUSTRY RATIO REPORT
CP12-3 Home
Retail Family Clothing Stores
Liquidity
COMPANIES USED IN INDUSTRY ANALYSIS
Current Ratio
Quick Ratio
Abercrombie & Fitch
Aeropostale Inc.
Activity
American Eagle Outfitters
Inventory Turnover
Ascena Retail Group, Inc.
Days to Sell Inventory
Brown Shoe Company
Receivables Turnover
Chico’s FAS Inc.
Average Collection Period
Collective Brands Inc.
Fixed Asset Turnover
Dillard’s Inc.
Total Asset Turnover
DSW Inc.
Accounts Payable Turnover
Foot Locker Inc.
Genesco Inc.
Profitability
Guess? Inc.
Gross Profit Margin
Jos. A. Bank Clothiers Inc.
Operating Profit Margin
Saks Inc.
Net Profit Margin
Signet Jewelers Ltd.
Return on Equity
Stage Stores Inc.
Return on Assets
The Buckle Inc.
Quality of Income
The Children’s Place
The Finish Line Inc.
Leverage
The Men’s Warehouse Inc.
Times Interest Earned
Urban Outfitters
Total Assets/Total Equity
Dividends
Dividend Payout
Dividend Yield
Other
Advertising-to-Sales
Sales Growth
Capital Acquisitions Ratio
Price/Earnings
January 28, January 29,
2012 2011
$ 719,545 $ 667,593
25,499 67,102
378,426 301,208
40,310 36,721
74,947 53,727
48,761 48,059
1,287,488 1,174,410
582,162 643,120
39,832 7,485
11,469 11,472
13,467 19,616
16,384 23,895
$ 1,950,802 $ 1,879,998
AMERICAN EAGLE OUTFITTERS, INC.
CP12-3 Home
CONSOLIDATED BALANCE SHEETS
(in thousands, except per share amounts)
ASSETS
Current assets:
Cash and cash equivalents
Short-term investments
Merchandise inventory
Accounts and note receivable
Prepaid expenses and other
Deferred income taxes
Total current assets
Property and equipment, at cost, net of accumulated depreciation
Intangible assets, at cost, net of accumulated amortization
Goodwill
Non-current deferred income taxes
Other assets
Total assets
$ 183,783 $ 167,723
42,625 34,954
76,921 70,390
20,135 32,468
44,970 41,001
15,066 16,203
21,901 25,098
405,401 387,837
71,880 78,606
35,471 38,671
21,199 23,813
128,550 141,090
2,496 2,496
552,797 546,597
28,659 28,072
1,771,464 1,711,929
(938,565) (938,023)
1,416,851 1,351,071
$ 1,950,802 $ 1,879,998
LIABILITIES AND STOCKHOLDERS’ EQUITY
Current liabilities:
Accounts payable
Accrued compensation and payroll taxes
Accrued rent
Accrued income and other taxes
Unredeemed gift cards and gift certificates
Current portion of deferred lease credits
Other liabilities and accrued expenses
Total current liabilities
Non-current liabilities:
Deferred lease credits
Non-current accrued income taxes
Other non-current liabilities
Total non-current liabilities
Commitments and contingencies
Retained earnings
Treasury stock, 55,718 and 55,200 shares, respectively, at cost
Total stockholders‘ equity
Total liabilities and stockholders’ equity
Stockholders’ equity:
Preferred stock, $0.01 par value; 5,000 shares authorized; none issued and outstanding
Common stock, $0.01 par value; 600,000 shared authorized; 249,566 and 249,566 shares
issued; 193,848 and 194,366 shares outstanding , respectively
Contributed capital
Accumulated other comprehensive income
January 28, January 29, January 30,
2012 2011 2010
$ 151,705 $ 140,647 $ 169,022
(1,140) 14,506
7,541 940
587 4,833 15,781
587 11,234 31,227
$ 152,292 $ 151,881 $ 200,249
AMERICAN EAGLE OUTFITTERS, INC.
CP12-3 Home
CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME
For the Years Ended
Foreign currency translation gain
Other comprehensive income
Comprehensive income
(In thousands)
Net income
Other comprehensive :
Temporary (impairment) recovery related to investment securities, net of tax
Reclassification adjustment for realized losses in net income related to investment securities, net of tax
Accumulated
Shares Other
Outstanding Common Contributed Retained Treasury Comprehensive Stockholders’
(1) Stock Capital Earnings Stock (2) Income (loss) Equity
205,281 $ 2,485 $ 513,574 $ 1,694,161 $ (786,800) $ (14,389) $ 1,409,031
41 1 39,903 39,904
(18) (247) (247)
1,528 (15,228) 27,792 12,564
169,022 169,022
31,227 31,227
922 (83,906) (82,984)
206,832 2,486 554,399 1,764,049 (759,255) 16,838 1,578,517
997 10 36,229 36,239
(15,500) (216,070) (216,070)
(1,035) (18,041) (18,041)
3,072 (45,841) (7,791) 55,343 1,711
140,647 140,647
11,234 11,234
1,810 (184,976) (183,166)
194,366 2,496 546,597 1,711,929 (938,023) 28,072 1,351,071
10,532 10,532
(1,365) (15,160) (15,160)
(145) (2,189) (2,189)
992 (5,997) (4,261) 16,807 6,549
151,705 151,705
587 587
1,665 (87,909) (86,244)
$ 193,848 $ 2,496 $ 552,797 $ 1,771,464 $ (938,565) $ 28,659 $ 1,416,851
Note 1
Note2
AMERICAN EAGLE OUTFITTERS, INC.
CP12-3 Home
CONSOLIDATED STATEMENTS OF STOCKHOLDERS’ EQUITY
(in thousands, except per share amounts)
Balance at January 31, 2009
Stock awards
Repurchase of common stock from employees
Reissuance of treasury stock
Net income
Other comprehensive income, net of tax
Cash dividends and dividend equivalents ($0.40 per share)
Balance at January 30, 2010
Stock awards
Repurchase of common stock as part of publicly announced programs
Repurchase of common stock from employees
Reissuance of treasury stock
Net income
Other comprehensive income, net of tax
Cash dividends and dividend equivalents ($0.93 per share)
Balance at January 29, 2011
Cash dividends and dividend equivalents ($0.44 per share)
Balance at January 28, 2012
600,000 authorized, 249,566 issued and 193,848 outstanding, $0.01 par value common stock at January 28, 2012; 600,000 authorized, 249,566
issued and 194,366 outstanding, $0.01 par value common stock at January 29, 2011; 600,000 authorized, 249,561 issued and 206,832
outstanding (excluding 992 shares of non-vested restricted stock), $0.01 par value common stock at January 30, 2010; The Company has 5,000
authorized, with none issued or outstanding, $0.01 par value preferred stock at January 28, 2012, January 29, 2011, and January 30, 2010.
55,718 shares, 55,200 shares, and 41,737 shares at January 28, 2012, January 29, 2011, and January 30, 2010, respectively. During Fiscal
2011 and Fiscal 2010 and Fiscal 2009, 992 shares, 3,072 shares and 1,528 shares, respectively, were reissued from treasury stock for the
issuance of share-based payments.
Stock awards
Repurchase of common stock as part of publicly announced programs
Repurchase of common stock from employees
Reissuance of treasury stock
Net income
Other comprehensive income, net of tax
January 28, January 29, January 30,
2012 2011 2010
$ 151,705 $ 140,647 $ 169,022
41,287 44,376
$ 151,705 $ 181,934 $ 213,398
143,156 145,548 139,832
12,341 25,457 34,615
4,207 11,885 (36,027)
356 15,648 7,995
(373) (12,499) (2,812)
(325) 117 6,477
20,730
25,674 3,689
(77,311) 18,713 (33,699)
(3,589) (3,790) 6,656
(21,261) (9,045) 12,916
2,444 (1,380) 1,146
17,934 5,232 8,358
3,979 1,713 (3,591)
(7,837) (7,451) 4,667
Accrued compensation and payroll taxes
7,677 (19,618) 25,841
(15,515) 11,999 12,858
938 12,457 (1,993)
87,551 220,660 186,928
239,256 402,594 400,326
(100,135) (84,259) (127,080)
(34,187) (2,801) (2,003)
(193,851) (62,797)
240,797 177,472 80,353
(87,376) 27,615 (48,730)
(3,256) (2,590) (2,015)
(30,000) (45,000)
(15,160) (216,070)
Repurchase of common stock as part of publicly announced programs
(2,189) (18,041) (247)
5,098 7,272 9,044
373 12,499 2,812
(6,434) (1,414)
(85,592) (183,166) (82,985)
(100,726) (436,530) (119,805)
798 1,394 3,030
(21,434) (13,864)
(6) (339)
(21,440) (14,203)
51,952 (26,367) 220,618
667,593 693,960 473,342
$ 719,545 $ 667,593 $ 693,960
AMERICAN EAGLE OUTFITTERS, INC.
CP12-3 Home
CONSOLIDATED STATEMENTS OF CASH FLOWS
For the Years Ended
(In thousands)
Operating activities:
Net income
Loss from discontinued operations, net of tax
Income from continuing operations
Adjustments to reconcile income to net cash provided by operating activities:
Depreciation and amortization
Share-based compensation
Provision for deferred income taxes
Tax benefit from share-based payments
Excess tax benefit from share-based payments
Foreign currency transaction (gain) loss
Loss on impairment of assets
Realized investment losses
Changes in assets and liabilities:
Merchandise inventory
Accounts receivable
Prepaid expenses and other
Other assets
Accounts payable
Unredeemed gift cards and gift certificates
Deferred lease credits
Accrued income and other taxes
Accrued liabilities
Total adjustments
Net cash provided by operating activities from continuing operations
Investing activities:
Capital expenditures for property and equipment
Acquisition of intangible assets
Purchase of available-for-sale securities
Sale of available-for-sale securities
Net cash (used for) provided by investing activities from continuing operations
Financing activities:
Payments on capital leases
Repayment of note payable
Net cash used for financing activities
Repurchase of common stock from employees
Net proceeds from stock options exercised
Excess tax benefit from share-based payments
Cash used to net settle equity awards
Cash dividends paid
Net cash used for financing activities from continuing operations
Effect of exchange rates on cash
Cash flows of discontinued operations
Net cash used for operating activities
Net cash used for investing activities
Effect of exchange rates on cash
Net cash used for discontinued operations
Net (increase) decrease in cash and cash equivalents
Cash and cash equivalents – beginning of period
Cash and cash equivalents – end of period
2012 2011
$ 145,273 $ 340,257
89,854 116,420
36,673 36,502
250,073 229,561
69,876 66,886
5,243 14,351
596,992 803,977
684,979 586,346
126,913 351,988
74,824 52,010
1,483,708$ 1,794,321$
95,754 82,904
15,630 20,212
122,082 107,908
233,466 211,024
183,974 171,749
417,440 382,773
15 17
27,603
1,077,765 1,394,190
(11,512) (10,262)
1,066,268 1,411,548
1,483,708$ 1,794,321$
URBAN OUTFITTERS, INC.
CP12-3 Home
Consolidated Balance Sheets
(in thousands, except share and per share data)
January 31,
ASSETS
Current Assets:
Cash and cash equivalents
Marketable securities
Accounts receivable, net of allowance for doubtful accounts of $1,614
and $1,015, respectively
Inventories
Prepaid expenses and other current assets
Deferred taxes
Total current assets
Property and equipment, net
Marketable securities
Deferred income taxes and other assets
Total Assets
LIABILITIES AND SHAREHOLDERS’ EQUITY
164,413,427 issued and outstanding, respectively
Current Liabilities:
Accounts payable
Accrued compensation
Accrued expenses and other current liabilities
Total current liabilities
Deferred rent and other liabilities
Total Liabilities
Commitments and contingencies (see Note 12)
Shareholders’ equity:
Preferred shares; $.0001 par value, 10,000,000 shares authorized, none issued
Common shares; $.0001 par value, 200,000,000 shares authorized, 144,633,007 and
Additional paid-in capital
Retained earnings
Accumulated other comprehensive (loss) income
Total Shareholders’ Equity
Total Liabilities and Shareholders’ Equity
2012 2011 2010
2,473,801$ 2,274,102$ 1,937,815$
1,613,265 1,337,482 1,151,670
860,536 936,620 786,145
575,811 522,417 447,161
284,725 414,203 338,984
5,120 4,669 6,290
553 486 463
(1,567) (2,150) (1,331)
288,831 417,208 344,406
103,580 144,250 124,513
185,251$ 272,958$ 219,893$
1.20$ 1.64$ 1.31$
1.19$ 1.60$ 1.28$
154,025,589 166,896,322 168,053,502
156,191,289 170,333,550 171,230,245
URBAN OUTFITTERS, INC.
CP12-3 Home
Consolidated Statements of Income
(in thousands, except share and per share data)
Fiscal Year Ended January 31,
Net sales
Cost of sales, including certain buying, distribution
and occupancy costs
Gross profit
Selling, general and administrative expenses
Income from operations
Interest income
Other income
Other expenses
Income before income taxes
Income tax expense
Basic
Diluted
Net income
Net income per common share:
Basic
Diluted
Weighted average common shares outstanding:
Accumulated
Additional Other
Comprehensive Number of Par Paid-in Retained Comprehensive
Income Shares Value Capital Earnings Loss Total
167,712,088 17$ 170,166$ 901,339$ (17,747)$ 1,053,775$
219,893$ 219,893 219,893
7,173 7,173 7,173
1,480 1,480 1,480
228,546$
4,766 4,766
846,283 3,250 3,250
6,438 6,438
168,558,371 17 184,620 1,121,232 (9,094) 1,296,775
272,958 272,958 272,958
(429) (429) (429)
(739) (739) (739)
271,790$
10,725 10,725
2,256,273 24,129 24,129
12,847 12,847
(6,401,217) (204,718) (204,718)
164,413,427 17 27,603 1,394,190 (10,262) 1,411,548
185,251 185,251 185,251
(2,285) (2,285) (2,285)
1,035 1,035 1,035
184,001$
3,068 3,068
993,923 4,134 4,134
8,995 8,995
(20,774,343) (2) (43,800) (501,676) (545,478)
144,633,007 15$ $ 1,077,765$ (11,512)$ 1,066,268$
URBAN OUTFITTERS, INC.
CP12-3 Home
Consolidated Statements of Shareholders’ Equity
(in thousands, except share data)
Common Shares
Balances as of January 31, 2009
Net Income
Foreign currency translation
Unrealized gains on marketable securities, net of tax
Comprehensive income
Share-based compensation
Stock options and awards
Tax effect of share exercises
Balances as of January 31, 2010
Net income
Foreign currency translation
Unrealized losses on marketable securities, net of tax
Comprehensive income
Share-based compensation
Stock options and awards
Tax effect of share exercises
Share Repurchases
Balances as of January 31, 2011
Net income
Foreign currency translation
Balances as of January 31, 2012
Unrealized gains on marketable securities, net of tax
Comprehensive income
Share-based compensation
Stock options and awards
Tax effect of share exercises
Share repurchases
2012 2011 2010
185,251$ 272,958$ 219,893$
108,112 101,105 92,350
(12,150) (8,727) 2,161
(8,995) (12,847) (6,438)
3,068 10,725 4,766
857 119 339
(251) 1,835 (1,825)
(20,817) (43,372) (15,544)
6,317 14,825 (25,619)
21,310 48,492 55,311
282,702 385,113 325,394
(190,010) (143,642) (109,260)
(169,467) (463,129) (806,546)
414,769 571,236 421,040
55,292 (35,535) (494,766)
4,136 24,129 3,250
8,995 12,847 6,438
(545,478) (204,718)
(532,347) (167,742) 9,688
(631) (603) 2,673
(194,984) 181,233 (157,011)
340,257 159,024 316,035
145,273$ 340,257$ 159,024$
120,847$ 121,341$ 137,490$
21,955$ 8,077$ 12,960$
URBAN OUTFITTERS, INC.
CP12-3 Home
Consolidated Statements of Cash Flows
(in thousands)
Fiscal Year Ended January 31,
Cash flows from operating activities:
Net income
Adjustments to reconcile net income to net cash provided by operating activities:
Depreciation and amortization
Provision for deferred income taxes
Excess tax benefit on share-based compensation
Share-based compensation expense
Loss on disposition of property and equipment, net
Changes in assets and liabilities:
Receivables
Inventories
Prepaid expenses and other assets
Accounts payable, accrued expenses and other liabilities
Net cash provided by operating activities
Cash flows from investing activities:
Cash paid for property and equipment
Cash paid for marketable securities
Sales and maturities of marketable securities
Net cash provided by (used in) investing activities
Cash flows from financing activities:
Exercise of stock options
Excess tax benefit of stock options exercises
Share repurchases
Cash paid during the year for:
Income taxes
Non-cash investing activities – Accrued capital expenditures
Net cash (used in) provided by financing activities
Effect of exchange rate changes on cash and cash equivalents
(Decrease) increase in cash and cash equivalents
Cash and cash equivalents at beginning of period
Cash and cash equivalents at end of period
Supplemental cash flow information: