P&G RATIO ANALYSIS
Currency in Jun 30 Jun 30 Jun 30 Jun 30
Millions of U.S. Dollars 2007 2008 2009 2010
As of: Restated Restated Restated USD
USD USD USD
Revenues 74,832.0 79,257.0 76,694.0 78,938.0
TOTAL REVENUES 74,832.0 79,257.0 76,694.0 78,938.0
Cost of Goods Sold 35,659.0 39,261.0 38,690.0 37,919.0
GROSS PROFIT 39,173.0 39,996.0 38,004.0 41,019.0
Selling General & Admin Expenses, Total 24,170.0 24,017.0 22,630.0 24,998.0
OTHER OPERATING EXPENSES, TOTAL 24,170.0 24,017.0 22,630.0 24,998.0
OPERATING INCOME 15,003.0 15,979.0 15,374.0 16,021.0
Interest Expense -1,304.0 -1,467.0 -1,358.0 -946.0
NET INTEREST EXPENSE -1,304.0 -1,467.0 -1,358.0 -946.0
Other Non-Operating Income (Expenses) 565.0 373.0 397.0 -28.0
EBT, EXCLUDING UNUSUAL ITEMS 14,264.0 14,885.0 14,413.0 15,047.0
EBT, INCLUDING UNUSUAL ITEMS 14,264.0 14,885.0 14,413.0 15,047.0
Income Tax Expense 4,201.0 3,594.0 3,733.0 4,101.0
Earnings from Continuing Operations 10,063.0 11,291.0 10,680.0 10,946.0
EARNINGS FROM DISCOUNTINUED OPERATIONS 277.0 784.0 2,756.0 1,790.0
NET INCOME 10,340.0 12,075.0 13,436.0 12,736.0
NET INCOME TO COMMON INCLUDING EXTRA ITEMS 10,179.0 11,899.0 13,244.0 12,517.0
NET INCOME TO COMMON EXCLUDING EXTRA ITEMS 9,902.0 11,115.0 10,488.0 10,727.0
Currency in As of: Jun 30 Jun 30 Jun 30 Jun 30
Millions of U.S. Dollars 2007 2008 2009 2010
Restated Restated Restated USD
USD USD USD
Assets
Cash and Equivalents 5,354.0 3,313.0 4,781.0 2,879.0
Short-Term Investments 202.0 -- -- --
TOTAL CASH AND SHORT TERM INVESTMENTS 5,556.0 3,313.0 4,781.0 2,879.0
Accounts Receivable 6,629.0 6,761.0 5,836.0 5,335.0
TOTAL RECEIVABLES 6,629.0 6,761.0 5,836.0 5,335.0
Inventory 6,819.0 8,416.0 6,880.0 6,384.0
Prepaid Expenses 3,300.0 4,013.0 3,199.0 3,194.0
Deferred Tax Assets, Current 1,727.0 2,012.0 1,209.0 990.0
TOTAL CURRENT ASSETS 24,031.0 24,515.0 21,905.0 18,782.0
Gross Property Plant and Equipment 34,721.0 38,086.0 36,651.0 37,012.0
Accumulated Depreciation -15,181.0 -17,446.0 -17,189.0 -17,768.0
NET PROPERTY PLANT AND EQUIPMENT 19,540.0 20,640.0 19,462.0 19,244.0
Goodwill 56,552.0 59,767.0 56,512.0 54,012.0
Long-Term Investments -- -- 212.0 57.0
Other Intangibles 33,626.0 34,233.0 32,606.0 31,636.0
Other Long-Term Assets 4,265.0 4,837.0 4,136.0 4,441.0
TOTAL ASSETS 138,014.0 143,992.0 134,833.0 128,172.0
LIABILITIES & EQUITY
Accounts Payable 5,710.0 6,775.0 5,980.0 7,251.0
Accrued Expenses 3,928.0 9,897.0 7,879.0 7,937.0
Short-Term Borrowings 9,495.0 11,338.0 9,379.0 7,908.0
Current Portion of Long-Term Debt/Capital Lease 2,544.0 1,746.0 6,941.0 564.0
Current Portion of Capital Lease Obligations -- -- -- 44.0
Current Income Taxes Payable 3,382.0 945.0 722.0 622.0
Other Current Liabilities, Total 5,658.0 257.0 -- --
TOTAL CURRENT LIABILITIES 30,717.0 30,958.0 30,901.0 24,282.0
Long-Term Debt 23,375.0 23,581.0 20,652.0 21,003.0
Capital Leases -- -- -- 357.0
Minority Interest -- -- 283.0 324.0
Pension & Other Post-Retirement Benefits 3,401.0 3,658.0 5,314.0 6,616.0
Deferred Tax Liability Non-Current 12,015.0 11,805.0 10,752.0 10,902.0
Other Non-Current Liabilities 1,746.0 4,496.0 3,832.0 3,573.0
TOTAL LIABILITIES 71,254.0 74,498.0 71,451.0 66,733.0
Preferred Stock Convertible 1,406.0 1,366.0 1,324.0 1,277.0
TOTAL PREFERRED EQUITY 1,406.0 1,366.0 1,324.0 1,277.0
Common Stock 3,990.0 4,002.0 4,007.0 4,008.0
Additional Paid in Capital 59,030.0 60,307.0 61,118.0 61,697.0
Retained Earnings 41,797.0 48,986.0 57,309.0 64,614.0
Treasury Stock -38,772.0 -47,588.0 -55,961.0 -61,309.0
Comprehensive Income and Other -691.0 2,421.0 -4,698.0 -9,172.0
TOTAL COMMON EQUITY 65,354.0 68,128.0 61,775.0 59,838.0
TOTAL EQUITY 66,760.0 69,494.0 63,382.0 61,439.0
TOTAL LIABILITIES AND EQUITY 138,014.0 143,992.0 134,833.0 128,172.0
CASH FLOW STATEMENT
Currency in As of: Jun 30 Jun 30 Jun 30 Jun 30
Millions of U.S. Dollars 2007 2008 2009 2010
Restated Restated Restated USD
USD USD USD
NET INCOME 10,340.0 12,075.0 13,436.0 12,736.0
Depreciation & Amortization 2,490.0 2,517.0 2,434.0 2,507.0
Amortization of Goodwill and Intangible Assets 640.0 649.0 648.0 601.0
DEPRECIATION & AMORTIZATION, TOTAL 3,130.0 3,166.0 3,082.0 3,108.0
(Gain) Loss from Sale of Asset -153.0 -284.0 -2,377.0 -2,670.0
Change in Accounts Receivable -729.0 432.0 415.0 -14.0
Change in Inventories -389.0 -1,050.0 721.0 86.0
Change in Accounts Payable -278.0 297.0 -742.0 2,446.0
Change in Other Working Capital -151.0 -1,270.0 -758.0 -305.0
CASH FROM OPERATIONS 13,410.0 15,008.0 14,919.0 16,072.0
Capital Expenditure -2,945.0 -3,046.0 -3,238.0 -3,067.0
Sale of Property, Plant, and Equipment 281.0 928.0 1,087.0 3,068.0
Cash Acquisitions -492.0 -381.0 -368.0 -425.0
Investments in Marketable & Equity Securities 673.0 -50.0 166.0 -173.0
CASH FROM INVESTING -2,483.0 -2,549.0 -2,353.0 -597.0
Short-Term Debt Issued 9,006.0 2,650.0 -- --
Long-Term Debt Issued 4,758.0 7,088.0 4,926.0 3,830.0
TOTAL DEBT ISSUED 13,764.0 9,738.0 4,926.0 3,830.0
Short Term Debt Repaid -- -- -2,420.0 -1,798.0
Long Term Debt Repaid -17,929.0 -11,747.0 -2,587.0 -8,546.0
TOTAL DEBT REPAID -17,929.0 -11,747.0 -5,007.0 -10,344.0
Issuance of Common Stock 1,499.0 1,867.0 681.0 721.0
Repurchase of Common Stock -5,578.0 -10,047.0 -6,370.0 -6,004.0
Common Dividends Paid -4,048.0 -4,479.0 -4,852.0 -5,239.0
Preferred Dividends Paid -161.0 -176.0 -192.0 -219.0
TOTAL DIVIDEND PAID -4,209.0 -4,655.0 -5,044.0 -5,458.0
CASH FROM FINANCING -12,453.0 -14,844.0 -10,814.0 -17,255.0
Foreign Exchange Rate Adjustments 187.0 344.0 -284.0 -122.0
NET CHANGE IN CASH -1,339.0 -2,041.0 1,468.0 -1,902.0
P&G Ratio data TTM as of 12/31/2010
Profitability - PROCTER & GAMBLE CO/THE (PG)
Return on Assets Return on Equity
Industry Comparison Industry Comparison
7.27% 16.73%
Return on Capital
Industry Comparison
9.99%
Margin Analysis - PROCTER & GAMBLE CO/THE (PG)
Gross Margin Levered Free Cash Flow Margin
Industry Comparison Industry Comparison
51.29% 10.60%
EBITDA Margin SG&A Margin
Industry Comparison Industry Comparison
23.45% 31.58%
Asset Turnover - PROCTER & GAMBLE CO/THE (PG)
Total Assets Turnover Accounts Receivables Turnover
Industry Comparison Industry Comparison
0.6x 12.2x
Fixed Assets Turnover Inventory Turnover
Industry Comparison Industry Comparison
4.0x 5.4x
Credit Ratios - PROCTER & GAMBLE CO/THE (PG)
Current Ratio Quick Ratio
Industry Comparison Industry Comparison
0.8x 0.4x
Long-Term Solvency - PROCTER & GAMBLE CO/THE (PG)
Total Debt/Equity Total Liabilities/Total Assets
Industry Comparison Industry Comparison
50.2x 51.8x
Growth Over Prior Year - PROCTER & GAMBLE CO/THE (PG)
Total Revenue Tangible Book Value
Industry Comparison Industry Comparison
3.63% 11.83%
EBITDA Gross Profit
Industry Comparison Industry Comparison
-2.54% 3.81%
Receivables Inventory
Industry Comparison Industry Comparison
0.11% 8.14%
Diluted EPS Before Extra Capital Expenditures
Industry Comparison Industry Comparison
4.37% -1.36%
Cash From Ops. Levered Free Cash Flow
Industry Comparison Industry Comparison
-20.88% -30.82%
