ABCDEFGHIJKLM
1
Avon Products, Inc. (NYS: AVP)
2
3
Exchange rate used is that of the Year End reported date
4
5
6
As Reported Annual Balance Sheet Ratios for Avon 2007-2011
7
20112010200920082007
8
Report Date12/31/201112/31/201012/31/200912/31/200812/31/2007Profitablity Ratios
9
CurrencyUSDUSDUSDUSDUSDROE32.66%36.43%47.86%NANA
10
Audit StatusNot QualifiedNot QualifiedNot QualifiedNot QualifiedNot QualifiedROA6.69%7.74%9.19%14.41%9.28%
11
ConsolidatedYesYesYesYesYesProfit Margin4.66%5.68%6.11%8.27%5.39%
12
ScaleThousandsThousandsThousandsThousandsThousands
13
Cash1,245,1001,179,9001,311,6001,104,700963,400Liquidity Ratios
14
Accounts receivable, gross936,0001,058,300945,200815,700981,500Current1.4181.4151.8421.2211.151
15
Less allowance174,500232,000165,500127,900141,100Quick1.0161.0251.3720.8750.810
16
Accounts receivable, net761,500826,300779,700687,800840,400Cash0.4310.3990.5770.3790.316
17
Raw materials361,700371,600335,900292,700337,800Operating Cash Flow
18
Finished goods799,600781,300731,600715,200704,000
19
Inventories1,161,3001,152,9001,067,5001,007,9001,041,800Leverage Ratios
20
Deferred tax assets319,000347,400303,200194,600-Debt/Equity0.1550.1310.146NANA
21
Receivables other than trade142,800145,900143,300127,100-Interest Coverage 8.81611.6939.64812.9647.719
22
Prepaid taxes & tax refunds receivables192,000247,100296,900156,500-Debt0.7950.7880.8080.8890.876
23
Prepaid brochure costs, paper & other literature126,900121,400122,800126,000-
24
Short-term investments18,00017,10026,80040,100-Efficiency Ratios
25
Property held for sale4,70012,8008,200--Total Asset Turnover1.4371.3631.5051.7431.722
26
Interest-rate swap agreements interest18,800----Inventory Turnover9.5699.3089.63410.5069.450
27
Deferred charge--36,900--
28
Other prepaid expenses & other current assets108,700133,50092,400112,200-Market Value Ratios
29
Prepaid expenses & other current assets930,9001,025,2001,030,500756,500-EPS1.2031.4211.4722.0531.224
30
Prepaid expenses & other current assets----669,800P/E13.26111.22410.8397.76913.0278
31
Total current assets4,098,8004,184,3004,189,3003,556,9003,515,400DividendPayout0.7650.6190.5710.390.6044
32
Land65,40069,200144,30085,30071,800Price-to-Book0.00001020.000009630.00001250.00002360.0000224
33
Buildings & improvements1,150,4001,140,2001,048,1001,000,700972,700Dividend Yield0.05770.05520.05270.05010.0464
34
Equipment1,493,0001,541,5001,506,9001,353,9001,317,900
35
Property, plant & equipment, gross2,708,8002,750,9002,699,3002,439,9002,362,400
36
Less: accumulated depreciation1,137,3001,123,5001,169,7001,096,0001,084,200
37
Property, plant & equipment, net1,571,5001,627,4001,529,6001,343,9001,278,200
38
Goodwill473,100675,100---
39
Other intangible assets, net279,900368,300---
40
Deferred tax assets759,500544,300527,300502,500-
41
Goodwill--224,800224,500-
42
Intangible assets--13,80028,600-
43
Pension assets---2,200-
44
Investments44,40047,60049,800108,900-
45
Deferred software176,700140,600112,00098,300-
46
Interest rate swap agreements153,600124,80054,900103,700-
47
Other assets177,500161,300131,200104,500-
48
Total other assets1,311,7001,018,6001,113,8001,173,200-
49
Other assets----922,600
50
Total assets7,735,0007,873,7006,832,7006,074,0005,716,200
51
Notes payable-214,100122,800125,40076,000
52
Commercial paper---499,700701,600
53
Yen credit facility---102,00096,300
54
Euro credit facility----32,800
55
7.15% notes---300,000-
56
Current portion of long-term debt-513,50015,3004,30022,800
57
Debt maturing within one year849,300727,600138,1001,031,400929,500
58
Accounts payable850,200809,800754,700724,300800,300
59
Accrued compensation217,100293,200291,000234,400285,800
60
Other accrued liabilities663,600771,600697,100581,900713,200
61
Sales & taxes other than income212,400207,600259,200212,200222,300
62
Income taxes98,400146,500134,700128,000102,300
63
Total current liabilities2,891,0002,956,3002,274,8002,912,2003,053,400
64
Unsecured notes1,715,9002,354,0002,208,1001,361,9001,160,700
65
Senior notes535,000393,000---
66
Other long term debt77,50080,70087,40014,70031,000
67
Total long-term debt2,328,4002,827,7002,295,5001,376,6001,191,700
68
Adjustments for debt with fair value hedges147,60094,40027,60083,900(1,000)
69
Less current portion16,900513,50015,3004,30022,800
70
Long-term debt2,459,1002,408,6002,307,8001,456,2001,167,900
71
Employee benefit plans603,000561,300588,900665,400388,700
72
Long-term income taxes67,000128,900173,800168,900208,700
73
Other liabilities129,700146,000174,800196,400185,900
74
Total liabilities6,149,8006,201,1005,520,1005,399,1005,004,600
75
Common stock187,300186,600186,100185,600184,700
76
Additional paid-in capital2,077,7002,024,2001,941,0001,874,1001,724,600
77
Retained earnings 4,726,1004,610,8004,383,9004,118,9003,586,500
78
Foreign currency translation adjustments(325,000)(147,400)(198,600)(406,200)(62,500)
79
Unrealized gains (loss) on available-for-sale securities, net---(300)400
80
Pension & postretirement adjustment, net(515,900)(443,800)(475,200)--
81
Unrecognized actuarial losses, prior service credit & transition obligation---(532,200)(337,200)
82
Net derivative gain (loss) on cash flow hedges, net(13,500)(14,600)(18,800)(27,200)(17,700)
83
Accumulated other comprehensive income (loss)(854,400)(605,800)(692,600)(965,900)(417,000)
84
Treasury stock, at cost4,566,3004,559,3004,545,8004,537,8004,367,200
85
Total Avon shareholders' equity1,570,4001,656,5001,272,600674,900711,600
86
Noncontrolling interest14,80016,10040,000--
87
Total shareholders' equity1,585,2001,672,6001,312,600--
88
89
As Reported Annual Income Statement
90
91
Report Date12/31/201112/31/201012/31/200912/31/200812/31/2007
92
CurrencyUSDUSDUSDUSDUSD
93
Audit StatusNot QualifiedNot QualifiedNot QualifiedNot QualifiedNot Qualified
94
ConsolidatedYesYesYesYesYes
95
ScaleThousandsThousandsThousandsThousandsThousands
96
Net sales11,112,00010,731,30010,284,70010,588,9009,845,200
97
Other revenue179,600131,50098,100101,20093,500
98
Total revenue11,291,60010,862,80010,382,80010,690,1009,938,700
99
Cost of sales4,148,6004,041,3003,888,3003,949,1003,941,200
100
Selling, general & administrative expenses6,025,4005,748,4005,476,3005,401,7005,124,800