Walmart financial analysis

Walmart financial analysis - Analysis of Walmart Financials...

Info iconThis preview shows page 1. Sign up to view the full content.

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

Unformatted text preview: Analysis of Walmart Financials Year (Numbers in $Mil) Revenue COGS SG&A Operating Income Net Income Total Assets Total Liabilities Total Equity COGS as % of Revenue SG&A as % of Revenue Operating Income as a % of Revenue Net Income as a % of Revenue Return on Assets Return on Equity Financial Leverage (Assets/Equity) 2001 2002 2003 2004 2005 $193,295 $205,823 $231,577 $258,681 $287,989 $150,255 $159,097 $178,299 $198,747 $219,793 $31,550 $35,147 $39,983 $44,909 $51,105 $11,311 $11,579 $13,295 $15,025 $17,091 $6,295 $6,592 $7,955 $9,054 $10,267 $78,130 $46,787 $31,343 77.7% 16.3% 5.9% 3.3% 8.1% 20.1% 2.49 $83,527 $48,425 $35,102 77.3% 17.1% 5.6% 3.2% 7.9% 18.8% 2.38 $94,808 $104,912 $120,223 $55,347 $61,289 $70,827 $39,461 $43,623 $49,396 77.0% 17.3% 5.7% 3.4% 8.4% 20.2% 2.40 76.8% 17.4% 5.8% 3.5% 8.6% 20.8% 2.40 76.3% 17.7% 5.9% 3.6% 8.5% 20.8% 2.43 COGS as % of Revenue 78.0% 77.7% 77.3% 77.5% 77.0% 76.8% 77.0% 76.3% 76.5% 76.2% 75.8% 76.0% 75.6% 75.5% 20.0% 19.0% 18.0% COGS as % of SG&A 17 17.4% 17.3% 17.1% COGS as % of Revenue 78.0% 77.7% 77.3% 77.5% 77.0% 76.8% 77.0% 76.3% 76.5% 76.2% 75.8% 76.0% 75.6% 75.5% 75.5% 75.0% 74.6% 74.5% 74.0% 73.5% 73.0% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 20.0% 19.0% 18.0% COGS as % of Revenue 17.0% 16.0% 15.0% 14.0% SG&A 17 17.4% 17.3% 17.1% 16.3% 2001 2002 2003 2004 2 Operating Income as a % of Revenue 6.0% 5.9% 5.9% 5.8% 5.7% 5.6% 5.5% 5.4% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 5.6% 5.7% 5.6% 5.8% 5.9% 5.9% 5.9% 5.8% Operating Income as a % of Revenue 5.9% 3.6% 3.5% 3.4% 3.3% 3.3% 3.2% 3.1% 3.0% Net Incom 3.5% 3.4% 3.6 3.2% 2001 2002 2003 2004 200 Return on Assets 8.8% 8.6% 8.4% 8.2% 8.1% 8.6% 8.4% 8.5% 8.1% 8.2% 8.4% 21.5% 21.0% 20.5% 20.1% 20.0% 20.2% Re 20 20.8% Return on Assets 8.8% 8.6% 8.5% 8.6% 8.4% 8.4% 8.4% 8.2% 8.1% 8.2% 8.1% 7.9% 8.0% 7.8% 7.8% 7.6% 7.5% 7.4% 7.2% 7.0% 6.8% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Re Return on Assets 21.5% 20 20.8% 21.0% 20.5% 20.1% 20.2% 20.0% 19.5% 18.8% 19.0% 18.5% 18.0% 17.5% 17.0% 16.5% 200120022003200420 Financial Leverage (Assets/Equity) 2.65 2.60 2.55 2.50 2.45 2.40 2.35 2.30 2.25 2.20 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2.38 2.49 2.40 2.40 2.43 2.46 2.60 2.53 2.50 Financial Leverage (Assets/Equity) 2.34 2006 2007 $315,654 $348,650 $240,391 $264,152 $56,733 $64,001 $18,530 $20,497 $11,231 $11,284 $138,187 $151,193 $85,016 $89,620 $53,171 $61,573 76.2% 18.0% 5.9% 3.6% 8.1% 21.1% 2.60 75.8% 18.4% 5.9% 3.2% 7.5% 18.3% 2.46 2008 $378,799 $286,515 $70,288 $21,996 $12,731 $163,514 $98,906 $64,608 75.6% 18.6% 5.8% 3.4% 7.8% 19.7% 2.53 2009 $405,607 $306,157 $76,651 $22,798 $13,400 $163,429 $98,144 $65,285 75.5% 18.9% 5.6% 3.3% 8.2% 20.5% 2.50 2010 $408,214 $304,657 $79,607 $23,950 $14,335 $170,706 $97,777 $72,929 74.6% 19.5% 5.9% 3.5% 8.4% 19.7% 2.34 SG&A as % of Revenue 19.5% 18.9% 18.6% 18.4% 18.0% 17.7% 17.4% 17.3% 17.1% SG&A as % of SG&A as % of Revenue 19.5% 18.9% 18.6% 18.4% 18.0% 17.7% 17.4% 17.3% 17.1% 16.3% SG&A as % of Revenue 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Net Income as a % of Revenue 3.6% 3.6% 3.5% 3.4% 3.4% 3.3% 3.2% 3.2% Net Income as a % of Revenue 3.5% 3.3% 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 Return on Equity 21.1% 20.8% 20.8% 20.1% 20.2% 20.5% 19.7% 19.7% Return on Equity 21.1% 20.8% 20.8% 20.1% 20.2% 20.5% 19.7% 19.7% Return on Equity 18.3% 18.8% 2001200220032004200520062007200820092010 ...
View Full Document

Ask a homework question - tutors are online