Student Name:
Class:
Requirement 1:
135,100$
78,400
56,700
14,100$
15,400
1,600 31,100
25,600
7,680
17,920$
Correct!
1.79$
Correct!
Requirement 2:
8.89
Correct!
Receivables turnover
Meaning of receivables turnover:
Income tax expense
Earnings per share on capital stock outstanding
Net income
Instructor
For the Year Ended December 31, 2014
Income Statement
TUNGSTEN COMPANY, INC.
The receivables turnover ratio measures the effectiveness of credit-granting and collection
activities.
Problem 06-05
McGraw-Hill/Irwin
Net sales revenue
Cost of goods sold
Gross profit on sales
Operating expenses:
Selling expenses
Administrative expenses
Bad debt expense
Income from operations
Debit Credit
33,600$
14,400
52,000
40,000
16,800$
24,000
72,000
9,280
147,100
5,600
78,400
14,100
15,400
1,600
6,400
7,680
269,180$ 269,180$
For the Year Ended December 31, 2014
Trial Balance
TUNGSTEN COMPANY, INC.
Given Data P06-05:
Accounts receivable (net)
Cash
Sales discounts
Income tax expense
Totals
Account Titles
Sales revenue
Sales returns and allowances
Cost of goods sold
Selling expense
Administrative expense
Bad debt expense
Inventory, ending
Operational assets
Accumulated depreciation
Liabilities
Capital stock
Retained earnings, January 1, 2014
Student Name:
Class:
23,900$ 26,070$
1,180 4,400
25,080 30,470
160 5,600
50 210
24,870$ 24,870$
Requirement 2:
Cash
Bank service charge expense
Cash
Accounts receivable
Interest revenue
Cash
Current Assets:
Explain need for these journal entries:
Requirement 4:
Requirement 3:
Cash account balance on May 1, 2014:
Cash account
Deductions:
Deposits in transit
Additions:
statement
Bank charges
NSF–A.B. Wright
Interest collected
Deductions:
Additions:
Ending balance per bank
Bank Statement
Requirement 1:
account
Ending balance per Cash
Company‘s Books
Correct cash balance
Outstanding checks
Problem 06–06
McGraw-Hill/Irwin
Instructor
Correct cash balance
Bank Reconciliation, April 30, 2014
JEFFERSON COMPANY
Student Name:
Class:
Problem 06–06
McGraw-Hill/Irwin
Instructor
Checks Deposits Balance
31,000$
36,100$ 67,100
1,180 68,280
44,500$ 23,780
160 23,620
50 23,570
23,570
April 1 Balance 23,500 April Checks written 41,100$
April Deposits 41,500
5,600$
–
?
Balance, April 1, 2014
April 30, 2014
Bank Statement
JEFFERSON COMPANY
Given Data P06-06:
Ledger Account Entries for April:
Deposits during April
Interest collected
Checks cleared during April
NSF check-A.B. Wright
Bank service charges
Balance, April 30, 2014
Other Information:
Outstanding checks at April 30
Deposits in transit from March
Deposits in transit from April
Cash (A)
Student Name:
Class:
20,370$ 18,190$
2,350 5,200
22,720 23,390
120 790
22,600$ 22,600$
Correct! Correct!
Requirement 4:
Account
2,350
2,350 Correct!
120
120 Correct!
Requirement 5:
22,600$
Correct!
Requirement 3:
Comparison of deposits listed in the Cash account with deposits listed on the bank statement
reveals a $5,200 deposit in transit on August 31.
statement
Ending balance per bank
These entries are necessary because of the changes in the regular Cash account that have not
yet been recorded by the company. The bank already has recorded them in its accounts. The
Cash account (and the other accounts in the entries) must be brought up to date for financial
statement purposes.
Comparison of the checks cleared on the bank statement with (a) outstanding checks from
July, and (b) checks written in August reveals two outstanding checks at the end of August
($280 + $510 = $790).
Interest collected
Service charges deducted from bank balance
Bank Reconciliation, August 31, 2014
ALLISON COMPANY
Company‘s Books
Bank service charge
Bank Statement
Correct cash balance
Problem 06–07
McGraw-Hill/Irwin
Instructor
Requirement 2:
Requirement 1:
Cash
Current Assets
Correct cash balance
Deductions:
Additions:
Interest collected
Cash
Bank service charge expense
Interest revenue
Cash
Ending balance per Cash
Outstanding checks
Deductions:
Deposits in transit
Additions:
account
Date Checks Deposits Balance
17,510$
320$ 17,190
11,700$ 28,890
430 28,460
270 28,190
880 27,310
250 27,060
4,000 31,060
350 30,710
20,400 10,310
6,500 16,810
850 15,960
2,350 18,310
120 18,190
Aug.1 Balance 16,490
Deposits Aug. 2 250
320$
–$
Outstanding checks at July 31:
Other Information:
Given Data P06-07:
Aug. 1
2
3
4
ALLISON COMPANY
August 31, 2014
Bank Statement
5
30
31
Ledger Account Entries for August:
30
9
10
15
21
24
25
Deposits in transit from July:
Cash Account
Checks written and electronic funds transfers
Required:
1.
2.
3.
This workbook is organized as follows:
Sheet Name Contents
CP6-3 (this worksheet) CP6-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
Urban Outfitters, Inc. Consolidated Statements of Income
Compute receivables turnover ratio for both companies for the most recent year.
Compare the receivables turnover ratio for each company for the most recent reporting year to the industry average.
Are these two companies doing better or worse than the industry average?
What do you think explains the difference in the ratios? Consider to whom the amounts are owed.
CP6-3 Comparing Companies within an 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
Other
Advertising-to-Sales
Sales Growth
Capital Acquisitions Ratio
Price/Earnings
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
Net Profit Margin
Signet Jewelers Ltd.
Return on Equity
Stage Stores Inc.
Return on Assets
The Buckle Inc.
Profitability
Guess? Inc.
Gross Profit Margin
Jos. A. Bank Clothiers Inc.
Operating Profit Margin
Saks Inc.
Total Asset Turnover
DSW Inc.
Accounts Payable Turnover
Foot Locker Inc.
Genesco Inc.
Receivables Turnover
Chico’s FAS Inc.
Average Collection Period
Collective Brands Inc.
Fixed Asset Turnover
Dillard’s Inc.
Activity
American Eagle Outfitters
Inventory Turnover
Ascena Retail Group, Inc.
Days to Sell Inventory
Brown Shoe Company
Current Ratio
Quick Ratio
Abercrombie & Fitch
Aeropostale Inc.
INDUSTRY RATIO REPORT
CP6-3 Home
Retail Family Clothing Stores
Liquidity
COMPANIES USED IN INDUSTRY ANALYSIS
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
Non-current deferred income taxes
Other assets
Total assets
Total current assets
Property and equipment, at cost, net of accumulated depreciation
Intangible assets, at cost, net of accumulated amortization
Goodwill
Short-term investments
Merchandise inventory
Accounts and note receivable
Prepaid expenses and other
Deferred income taxes
(in thousands, except per share amounts)
ASSETS
Current assets:
Cash and cash equivalents
AMERICAN EAGLE OUTFITTERS, INC.
CP6-3 Home
CONSOLIDATED BALANCE SHEETS
$ 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
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
Commitments and contingencies
Retained earnings
Treasury stock, 55,718 and 55,200 shares, respectively, at cost
Total stockholders‘ equity
Non-current liabilities:
Deferred lease credits
Non-current accrued income taxes
Other non-current liabilities
Total non-current liabilities
Unredeemed gift cards and gift certificates
Current portion of deferred lease credits
Other liabilities and accrued expenses
Total current liabilities
Current liabilities:
Accounts payable
Accrued compensation and payroll taxes
Accrued rent
Accrued income and other taxes
LIABILITIES AND STOCKHOLDERS’ EQUITY
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
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
AMERICAN EAGLE OUTFITTERS, INC.
CP6-3 Home
CONSOLIDATED STATEMENTS OF COMPREHENSIVE INCOME
For the Years Ended
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
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
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 30, 2010
Stock awards
Repurchase of common stock as part of publicly announced programs
Repurchase of common stock from employees
Reissuance of treasury stock
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)
(in thousands, except per share amounts)
Balance at January 31, 2009
Stock awards
AMERICAN EAGLE OUTFITTERS, INC.
CP6-3 Home
CONSOLIDATED STATEMENTS OF STOCKHOLDERS’ EQUITY
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
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
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
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
Total adjustments
Net cash provided by operating activities from continuing operations
Investing activities:
Capital expenditures for property and equipment
Acquisition of intangible assets
Accounts payable
Unredeemed gift cards and gift certificates
Deferred lease credits
Accrued income and other taxes
Accrued liabilities
Changes in assets and liabilities:
Merchandise inventory
Accounts receivable
Prepaid expenses and other
Other assets
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
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
(In thousands)
Operating activities:
Net income
Loss from discontinued operations, net of tax
AMERICAN EAGLE OUTFITTERS, INC.
CP6-3 Home
CONSOLIDATED STATEMENTS OF CASH FLOWS
For the Years Ended
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$
Additional paid-in capital
Retained earnings
Accumulated other comprehensive (loss) income
Total Shareholders’ Equity
Total 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
Deferred income taxes and other assets
Total Assets
LIABILITIES AND SHAREHOLDERS’ EQUITY
Prepaid expenses and other current assets
Deferred taxes
Total current assets
Property and equipment, net
Marketable securities
Cash and cash equivalents
Marketable securities
Accounts receivable, net of allowance for doubtful accounts of $1,614
and $1,015, respectively
Inventories
January 31,
ASSETS
Current Assets:
URBAN OUTFITTERS, INC.
CP6-3 Home
Consolidated Balance Sheets
(in thousands, except share and per share data)
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
Diluted
Net income
Net income per common share:
Basic
Diluted
Weighted average common shares outstanding:
Other income
Other expenses
Income before income taxes
Income tax expense
Basic
and occupancy costs
Gross profit
Selling, general and administrative expenses
Income from operations
Interest income
Fiscal Year Ended January 31,
Net sales
Cost of sales, including certain buying, distribution
URBAN OUTFITTERS, INC.
CP6-3 Home
Consolidated Statements of Income
(in thousands, except share and per share data)
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$
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
Tax effect of share exercises
Share Repurchases
Balances as of January 31, 2011
Net income
Foreign currency translation
Foreign currency translation
Unrealized losses on marketable securities, net of tax
Comprehensive income
Share-based compensation
Stock options and awards
Share-based compensation
Stock options and awards
Tax effect of share exercises
Balances as of January 31, 2010
Net income
Balances as of January 31, 2009
Net Income
Foreign currency translation
Unrealized gains on marketable securities, net of tax
Comprehensive income
Common Shares
URBAN OUTFITTERS, INC.
CP6-3 Home
Consolidated Statements of Shareholders’ Equity
(in thousands, except share data)
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$
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:
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
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
Loss on disposition of property and equipment, net
Changes in assets and liabilities:
Receivables
Inventories
Prepaid expenses and other assets
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
Fiscal Year Ended January 31,
Cash flows from operating activities:
Net income
URBAN OUTFITTERS, INC.
CP6-3 Home
Consolidated Statements of Cash Flows
(in thousands)