Financial Analysis data problem Assignement for smith_comp

profilejayabe
copy_of_walmart_2013_0513.xlsx
Home>Business & Finance homework help>Accounting homework help>Financial Analysis data problem Assignement for smith_comp

Walmart Income Statement

Wal-Mart Stores Inc., Consolidated Income Statement
USD $ in millions
12 months ended Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009 Jan 31, 2008 Jan 31, 2007
Net sales 443,854 418,952 405,046 401,244 374,526 344,992
Cost of sales -335,127 -315,287 -304,657 -306,158 -286,515 -264,152
Gross profit 108,727 103,665 100,389 95,086 88,011 80,840
Membership and other income 3,096 2,897 3,168 4,363 4,273 3,658
Operating, selling, general and administrative expenses -85,265 -81,020 -79,607 -76,651 -70,288 -64,001
Operating income 26,558 25,542 23,950 22,798 21,996 20,497
Interest (debt and capital leases) -2,322 -2,205 -2,065 -2,184 -2,103 -1,809
Interest income 162 201 181 284 305 280
Interest, net -2,160 -2,004 -1,884 -1,900 -1,798 -1,529
Income from continuing operations before income taxes 24,398 23,538 22,066 20,898 20,198 18,968
Provision for income taxes -7,944 -7,579 -7,139 -7,145 -6,908 -6,365
Income from continuing operations 16,454 15,959 14,927 13,753 13,290 12,603
Income (loss) from discontinued operations, net of tax -67 1,034 -79 146 -153 -894
Consolidated net income 16,387 16,993 14,848 13,899 13,137 11,709
Consolidated net income attributable to noncontrolling interest -688 -604 -513 -499 -406 -425
Consolidated net income attributable to Walmart 15,699 16,389 14,335 13,400 12,731 11,284
Source: Wal-Mart Stores Inc., Annual Reports
Stock Analysis on Net (www.stock-analysis-on.net)
Copyright © 2012 EBIT Financial Analyses Center

Walmart Balance Sheet

Wal-Mart Stores Inc., Consolidated Statement of Financial Position
USD $ in millions
ASSETS Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009 Jan 31, 2008 Jan 31, 2007
Cash and cash equivalents 6,550 7,395 7,907 7,275 5,569 7,373
Receivables, net 5,937 5,089 4,144 3,905 3,654 2,840
Inventories 40,714 36,318 33,160 34,511 35,180 33,685
Prepaid expenses and other 1,685 2,960 2,980 3,063 3,182 2,690
Current assets of discontinued operations 89 131 140 195 – –
Current assets 54,975 51,893 48,331 48,949 47,585 46,588
Property and equipment, net, excluding property under capital leases 109,603 105,098 99,544 92,856 93,875 85,390
Property under capital leases, net 2,721 2,780 2,763 2,797 3,142 3,050
Property and equipment, net 112,324 107,878 102,307 95,653 97,017 88,440
Goodwill 20,651 16,763 16,126 15,260 16,071 13,759
Other assets and deferred charges 5,456 4,129 3,942 3,567 2,841 2,406
Non-current assets 138,431 128,770 122,375 114,480 115,929 104,605
Total assets 193,406 180,663 170,706 163,429 163,514 151,193
LIABILITIES Jan 31, 2012 Jan 31, 2011 Jan 31, 2010 Jan 31, 2009 Jan 31, 2008 Jan 31, 2007
Short-term borrowings 4,047 1,031 523 1,506 5,040 2,570
Accounts payable 36,608 33,557 30,451 28,849 30,370 28,090
Accrued wages and benefits 5,089 5,895 5,986 5,577 5,247 5,347
Self-insurance 3,638 3,447 3,224 3,108 2,907 2,954
Other 9,427 9,359 9,524 9,427 7,645 6,374
Accrued liabilities 18,154 18,701 18,734 18,112 15,799 14,675
Accrued income taxes 1,164 157 1,365 677 1,016 706
Long-term debt due within one year 1,975 4,655 4,050 5,848 5,913 5,428
Obligations under capital leases due within one year 326 336 346 315 316 285
Current liabilities of discontinued operations 26 47 92 83 – –
Current liabilities 62,300 58,484 55,561 55,390 58,454 51,754
Long-term debt, excluding due within one year 44,070 40,692 33,231 31,349 29,799 27,222
Long-term obligations under capital leases 3,009 3,150 3,170 3,200 3,603 3,513
Deferred income taxes and other 7,862 6,682 5,508 6,014 5,111 4,971
Non-current liabilities 54,941 50,524 41,909 40,563 38,513 35,706
Total liabilities 117,241 109,008 97,470 95,953 96,967 87,460
STOCKHOLDERS EQUITY
Redeemable noncontrolling interest 404 408 307 397 – –
Preferred stock ($0.10 par value; none issued) – – – – – –
Common stock ($0.10 par value) 342 352 378 393 397 413
Capital in excess of par value 3,692 3,577 3,803 3,920 3,028 2,834
Retained earnings 68,691 63,967 66,638 63,660 57,319 55,818
Accumulated other comprehensive income (loss) -1,410 646 -70 -2,688 3,864 2,508
Walmart shareholders’ equity 71,315 68,542 70,749 65,285 64,608 61,573
Noncontrolling interest 4,446 2,705 2,180 1,794 1,939 2,160
Total equity 75,761 71,247 72,929 67,079 66,547 63,733
Total liabilities and equity 193,406 180,663 170,706 163,429 163,514 151,193

Ratio Analysis

Instructions: You will solve 10 ratios for the year 2011 and 10 for the year 2012, using the data available on the Walmart Income Statement and the Walmart Balance Sheet included in this file. Step 1: Provide the formula for the ratio in text format (T) in Column B Step 2: Provide the formula for the ratio in excel/computation (C) format in Column D and Column F
Wal-Mart Ratio Analysis 2011 2012
Ratio (text) Ratio (calculation) Ratio (calculation)
Liquidity Ratios (solve both) Click on .89 for required excel format
Current Ratio Current assets / Current liabilities 0.89
Quick Ratio T C C
Activity Ratios (choose 2)
Total Asset Turnover T C C
Inventory Turnover T C C
Average Collection Period T C C
Debt Ratios (choose 2)
Debt Ratio T C C
Debt-Equity Ratio T C C
Times Interest earned T C C
Profitability Ratios (choose 2)
Gross Profit Margin T C C
Operating Profit Margin T C C
Net Profit Margin T C C
Earnings per Share* T C C
Use for PE below
Return on Total Assets T C C
Return on Equity T C C
Market Ratios (solve both)
PE Ratio T C C
MB Ratio T C C
* To calculate Outstanding Shares: Divide the total cost of common stock by the cost per share.