Use the five classifications of financial ratios, 1) Liquidity, 2) Activity, 3) Financing, 4) Profitability, and 5) Market to assess the financial performance for Walmart. Excellent resource material can be found in the Financial Statement Analysis Tables 2.4 to 2.8 in your text. Each of these classifications includes at least two respective financial ratios. You will calculate ratios for each classification, two ratios per classification, for the three years data. I.e., the Current ratio may have been 2.0 in year three and 1.5 the following year, and .75 in the most recent year. It is based on these results that you will measure financial performance, or trends from one year to the next. It is imperative that the ratios-numbers, and quantitative outcomes, support your analysis.

WalMart Analysis: This worksheet will support the findings presented in the final document: Compiler-Leader: Please embed in the final write up Team: Compiler Who will be the Compiler/Project Lead? 2015 2013 2014 Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your Student A Liquidity Current Ratio 1 Student A Liquidity Quick Ratio 2 comments in the final document Student B Accounts Receivable Turnover see the "Project Outline document Activity Ratios 3 Student B 4 Activity Ratios Inventory Turnover Student B Accounts Payable Turnover Activity Ratios 5 Student C Profitability Returns Return on Equity % 6 Assign Ratios to respective students, i.e. Student A, Student B, etc.: also need a compiler. This Excel spreadsheet needs to be completed and embedded in the final write up Student C Profitability Returns 7 Return on Assets % Student C Profitability Returns Net Profit Margin % 8 Student C Profitability Returns Operating Profit Margin Financing Debt to Equity% Student D 10 Student D Financing Debt to Assets % 11 Student D Financing Times Interest Earned 12 Student E Market Value 13 Earnings per Share $ Student E Price to Earnings ratio Market Value 14 Price per share 10.00 $ 9.00 $ 8.00 2015 2014 2013 D E F L C B K M WalMart Inc Balance sheet(s) WalMart Inc Income Statement(s) Period Ending ..2015 ..2014 ..2013 ..2015 ..2014 ..2013 Total Sales 468,651.000 Assets 485,651,000 476,294,000 (Supplier Purchases) Cost of Goods Sold Current Assets 365,086,000 358,069,000 352,297,000 116,354,000 120,565,000 Cash And Cash Equivalents 9,135,000 Gross Profit 7,281,000 7,781,000 118,225,000 Selling and General Administrative 93,418,000 27,147,000 113.000 Accounts Receivable 6,778,000 45,141.000 6,677,000 6,768,000 91,353,000 26,872,000 88,629,000 27,725,000 Operating Profit Inventory 44,858,000 43,803,000 Total Other Income/Expenses Net Other Current Assets 2,224,000 2,369,000 1,588,000 119,000 186,000 27,539,000 0 Earnings Before Interest And Taxes 27,034,000 26,753,000 2,335,000 24.418.000 Total Current Assets 63,278,000 61,185,000 59,940,000 1 Fixed Assets Interest Expense 116,655,000 117,907,000 116,681,000 2,461,000 2,249,000 2 Goodwill 3 Other Assets 4 Income Before Tax 18,102,000 19,510,000 20,497,000 24,573,000 25,290,000 8.105,000 16,313,000 Income Tax Expense Net Income From Continuing Ops Discontinued Operations 5,671,000 6,149,000 5,987,000 7,985,000 7,958,000 17,332,000 Total Assets 16,588,000 203,706,000 204,751,000 203,105,000 285,000 16,303,000 5 Liabilities 144,000 52,000 17,280,000 16,169,000 6 Current Liabilities 7 Net Income 14.000,000 shares outstanding USE THESE PRICES Price per share Accounts Payable 58,583,000 57,174,000 59,099,000 Earnings per share 8 . 12,082,000 S Current Portion Long Term Debt 6,689,000 12,719,000 196000 72.014,000 41,417,000 for ratio 7,613,000 10.00 9.00 8.00 Price to Earnings Ratio Other Current Liabilities- 89,000 69,345,000 44,559,000 0 65,272,000 43,692,000 Total Current Liabilities 1 Long Term Debt 2 Deferred Long Term Liability 3 Minority Interest 8,805,000 8,017,000 4,543,000 122,312,000 5,084,000 5,395,000 126,439.000 116,000 4 Total Liabilities 127,005,000 5 Misc Stocks Options Warrants 6 Common Stock 7 Retained Earnings 8 Capital Surplus 9 Other Stockholder Equity 0 323,000 85,777,000 323,000 202,000 72,978,000 4,000,000 -630,000 76,566,000 2,362,000 -1,505,000 77,746,000 2,462,000 -7,168,000 0 Total Stockholder Equity 81,394,000 76,666,000 Total Liabilities+ Stockholder Equity 2 203,706,000 204,751,000 203,105,000 4 WalMart Analysis: This worksheet will support the findings presented in the final document: Compiler-Leader: Please embed in the final write up Team: Compiler Who will be the Compiler/Project Lead? 2015 2013 2014 Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your Student A Liquidity Current Ratio 1 Student A Liquidity Quick Ratio 2 comments in the final document Student B Accounts Receivable Turnover see the "Project Outline document Activity Ratios 3 Student B 4 Activity Ratios Inventory Turnover Student B Accounts Payable Turnover Activity Ratios 5 Student C Profitability Returns Return on Equity % 6 Assign Ratios to respective students, i.e. Student A, Student B, etc.: also need a compiler. This Excel spreadsheet needs to be completed and embedded in the final write up Student C Profitability Returns 7 Return on Assets % Student C Profitability Returns Net Profit Margin % 8 Student C Profitability Returns Operating Profit Margin Financing Debt to Equity% Student D 10 Student D Financing Debt to Assets % 11 Student D Financing Times Interest Earned 12 Student E Market Value 13 Earnings per Share $ Student E Price to Earnings ratio Market Value 14 Price per share 10.00 $ 9.00 $ 8.00 2015 2014 2013 D E F L C B K M WalMart Inc Balance sheet(s) WalMart Inc Income Statement(s) Period Ending ..2015 ..2014 ..2013 ..2015 ..2014 ..2013 Total Sales 468,651.000 Assets 485,651,000 476,294,000 (Supplier Purchases) Cost of Goods Sold Current Assets 365,086,000 358,069,000 352,297,000 116,354,000 120,565,000 Cash And Cash Equivalents 9,135,000 Gross Profit 7,281,000 7,781,000 118,225,000 Selling and General Administrative 93,418,000 27,147,000 113.000 Accounts Receivable 6,778,000 45,141.000 6,677,000 6,768,000 91,353,000 26,872,000 88,629,000 27,725,000 Operating Profit Inventory 44,858,000 43,803,000 Total Other Income/Expenses Net Other Current Assets 2,224,000 2,369,000 1,588,000 119,000 186,000 27,539,000 0 Earnings Before Interest And Taxes 27,034,000 26,753,000 2,335,000 24.418.000 Total Current Assets 63,278,000 61,185,000 59,940,000 1 Fixed Assets Interest Expense 116,655,000 117,907,000 116,681,000 2,461,000 2,249,000 2 Goodwill 3 Other Assets 4 Income Before Tax 18,102,000 19,510,000 20,497,000 24,573,000 25,290,000 8.105,000 16,313,000 Income Tax Expense Net Income From Continuing Ops Discontinued Operations 5,671,000 6,149,000 5,987,000 7,985,000 7,958,000 17,332,000 Total Assets 16,588,000 203,706,000 204,751,000 203,105,000 285,000 16,303,000 5 Liabilities 144,000 52,000 17,280,000 16,169,000 6 Current Liabilities 7 Net Income 14.000,000 shares outstanding USE THESE PRICES Price per share Accounts Payable 58,583,000 57,174,000 59,099,000 Earnings per share 8 . 12,082,000 S Current Portion Long Term Debt 6,689,000 12,719,000 196000 72.014,000 41,417,000 for ratio 7,613,000 10.00 9.00 8.00 Price to Earnings Ratio Other Current Liabilities- 89,000 69,345,000 44,559,000 0 65,272,000 43,692,000 Total Current Liabilities 1 Long Term Debt 2 Deferred Long Term Liability 3 Minority Interest 8,805,000 8,017,000 4,543,000 122,312,000 5,084,000 5,395,000 126,439.000 116,000 4 Total Liabilities 127,005,000 5 Misc Stocks Options Warrants 6 Common Stock 7 Retained Earnings 8 Capital Surplus 9 Other Stockholder Equity 0 323,000 85,777,000 323,000 202,000 72,978,000 4,000,000 -630,000 76,566,000 2,362,000 -1,505,000 77,746,000 2,462,000 -7,168,000 0 Total Stockholder Equity 81,394,000 76,666,000 Total Liabilities+ Stockholder Equity 2 203,706,000 204,751,000 203,105,000 4