4_Vershire - Alcoa_Inc_DuPont

4_Vershire - Alcoa_Inc_DuPont - 11/09/2011 16:54:54

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: 11/09/2011 16:54:54 3caf773674f24dcf3f33a11cfc0b66194a6b1e88.xlsx Alcoa, Inc Formula Annual Revenue $ millions $20,871 $22,609 $25,568 $30,379 $30,748 $26,901 ROE Net Income/Equity 7.8% 9.8% 9.2% 15.4% 16.0%-0.6% Leverage Assets/Equity 2.63 2.45 2.52 2.54 2.42 3.22 ROA Net Income/Assets 3.0% 4.0% 3.7% 6.0% 6.6%-0.2% Asset Turns Sales/Assets 0.7x 0.7x 0.8x 0.8x 0.8x 0.7x Profit Margin Net Income/Sales 4.5% 5.8% 4.8% 7.4% 8.3%-0.3% Asset Turns DSO 365*AR/Sales 43.6 43.5 37.3 33.5 30.9 25.5 Inventory Weeks 52*Inventory/COGS 7.8 8.6 8.0 7.5 7.1 7.6 PP&E Turns Sales/Net Prop. & Equip. 1.7 1.8 2.0 2.2 1.8 1.5 Profit Margin Gross Margin % GM$/Sales 20.4% 20.7% 19.0% 23.1% 21.1% 17.6% SG&A % SG&A$/Sales 11.4% 10.5% 10.0% 8.8% 8.8% 8.9% R&D% R&D$/Sales 0.9% 0.8% 0.8% 0.7% 0.8% 0.9% Oper. Profit % OP$/Sales 8.1% 9.4% 8.3% 13.6% 11.6% 7.7% Leverage LTD/LTD + Equity LTD/(LTD + Equity) 0.36 0.29 0.28 0.29 0.28 0.42 12 months Dec-31-2003 12 months Dec-31-2004 12 months Dec-31-2005 12 months Dec-31-2006 12 months Dec-31-2007 Press Release 12 months Dec-31-2008 Alcoa, Inc. (NYSE:AA) > Financials > Ratios Restatement: Latest Filings Period: Annual Order: Latest on Right Decimals: Capital IQ (Default) Ratios Profitability Return on Assets % 3.4% 4.1% 4.0% 7.3% 5.9% 3.4% Return on Capital % 5.2% 6.4% 6.3% 11.5% 8.9% 5.1% Return on Equity % 9.3% 10.8% 9.4% 15.4% 16.8% 1.7% Margin Analysis Gross Margin % 20.4% 20.7% 19.0% 23.1% 21.1% 17.6% SG&A Margin % 5.9% 5.3% 5.1% 4.6% 4.6% 4.3% EBITDA Margin % 13.7% 14.7% 13.2% 17.8% 15.7% 12.3% EBITA Margin % 8.4% 9.7% 8.5% 13.8% 11.8% 7.7% EBIT Margin % 8.1% 9.4% 8.3% 13.6% 11.6% 7.7% Earnings from Cont. Ops Margin % 4.9% 6.1% 4.9% 7.1% 8.4% 0.9% Net Income Margin % 4.5% 5.8% 4.8% 7.4% 8.3% (0.3%) Net Income Avail. for Common Margin % 4.9% 6.0% 4.9% 7.1% 8.4% 0.9% Normalized Net Income Margin % 4.5% 5.6% 4.8% 8.1% 6.6% 4.0% Levered Free Cash Flow Margin % 5.5% 5.0% 0.9% (0.7%) (0.6%) (4.7%) Unlevered Free Cash Flow Margin % 6.4% 5.8% 1.8% 0.1% 0.2% (3.8%) Asset Turnover Total Asset Turnover 0.7x 0.7x 0.8x 0.9x 0.8x 0.7x Fixed Asset Turnover 1.7x 1.8x 2.1x 2.3x 2.0x 1.6x Accounts Receivable Turnover 8.6x 8.7x 9.6x 11.2x 11.4x 12.0x Inventory Turnover 6.8x 6.6x 6.7x 7.1x 7.2x 6.8x Short Term Liquidity Current Ratio 1.3x 1.2x 1.2x 1.2x 1.1x 1.1x Quick Ratio 0.7x 0.5x 0.5x 0.5x 0.5x 0.5x Cash from Ops. to Curr. Liab. 0.5x 0.4x 0.2x 0.4x 0.4x 0.2x Avg. Days Sales Out. 42.4 42.0 37.9 32.5 32.0 30.5 Avg. Days Inventory Out. 54.0 55.9 54.3 51.3 50.5 54.2 Avg. Days Payable Out. 39.1 41.6 40.4 37.4 39.2 44.0 Avg. Cash Conversion Cycle 57.4 56.3 51.7 46.4 43.3 40.7 Long Term Solvency Total Debt/Equity 60.2% 47.4% 48.9% 49.4% 49.9% 90.1% Total Debt/Capital 35.1% 30.0% 30.7% 30.5% 30.2% 42.5% LT Debt/Equity 55.4% 40.2% 39.5% 40.4% 39.8% 72.5% LT Debt/Capital 32.4% 25.4% 24.8% 25.0% 24.1% 34.2% Total Liabilities/Total Assets 61.9% 59.2% 60.3% 60.7% 58.7% 69.0% EBIT / Interest Exp. 5.4x 7.9x 6.3x 10.8x 8.9x 5.1x EBITDA / Interest Exp. 9.1x9....
View Full Document

Page1 / 7

4_Vershire - Alcoa_Inc_DuPont - 11/09/2011 16:54:54

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online