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.
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 Inc Balance sheet(s) Walmart Inc Income Statement(s) ..2014 ..2013 7,281,000 6,677,000 44,858,000 2,369,000 61,185,000 117,907,000 19,510,000 6,149,000 204,751,000 7,781,000 6,768,000 43,803,000 1,588,000 59,940,000 116,681,000 20,497,000 5,987,000 203,105,000 Period Ending ..2015 Assets Current Assets Cash And Cash Equivalents 9,135,000 Accounts Receivable 6,778,000 Inventory 45,141,000 Other Current Assets 2,224,000 Total Current Assets 63,278,000 1 Fixed Assets 116,655,000 z Goodwill 18,102,000 3 Other Assets 5,671,000 Total Assets' 203,706,000 Liabilities 6 Current Liabilities Accounts Payable 58,583,000 Current Portion Long Term Debt 6,689,000 Other Current Liabilities - Total Current Liabilities 65,272,000 1 Long Term Debt 43,692,000 2 Deferred Long Term Liability 8.805,000 3 Minority Interest 4,543,000 Total Liabilities 122,312,000 5 Misc Stocks Options Warrants 6 Common Stock 323,000 7 Retained Earnings 85,777,000 8 Capital Surplus 2,462,000 9 Other Stockholder Equity -7,168,000 0 Total Stockholder Equity 81.394.000 Total Sales (Supplier Purchases) Cost of Goods Sold Gross Profit Selling and General Administrative Operating Profit Total Other Income/Expenses Net Earnings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Net Income From Continuing Ops Discontinued Operations Net Income 14,000,000 shares outstanding USE THESE PRICES Price per share ..2015 485,651,000 365,086,000 120,565,000 93,418,000 27,147,000 113,000 27,034,000 2,461,000 24,573,000 7,985,000 16,588,000 285,000 16,303,000 2014 476,294,000 358,069,000 118,225,000 91,353,000 26,872,000 119,000 26,753,000 2,335,000 24,418,000 8,105,000 16,313,000 144,000 16,169,000 ..2013 468,651,000 352,297,000 116,354,000 88,629,000 27,725,000 186,000 27,539,000 2,249,000 25,290,000 7,958,000 17,332,000 52,000 17,280,000 Earnings per share $ 8.00 Price to Earnings Ratio 59,099,000 12,719,000 196000 $ 10.00 $ 9.00 57,174,000 12,082,000 89,000 69,345,000 44,559,000 8,017.000 5,084,000 127,005,000 O 41.417.000 for ratio 7,613,000 5.395.000 126,439,000 116,000 202,000 72,978,000 4,000,000 -630,000 76.666,000 323,000 76,566,000 2,362,000 -1,505,000 77.746.000 Total Liabilities + Stockholder Equity 203,706,000 204,751,000 203,105,000 NIME 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 2014 2013 Student A Liquidity Current Ratio Student A Liquidity Quick Ratio Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments in the final document - see the "Project Outline" document. 3 Student B Activity Ratios Accounts Receivable Turnover Student B Activity Ratios Inventory Turnover 5 Student B Activity Ratios Accounts Payable Turnover Student C Profitability Returns Return on Equity % Return on Assets% Student C Student C Profitability Returns Profitability Returns Net Profit Margin % 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 Operating Profit Margin Debt to Equity % 9 10 11 12 Student D Student Financing Financing Debt to Assets % Student D Financing Times Interest Earned 13 Student E Market Value 14 Student E Market Value Earnings per Share $ Price to Earnings ratio Price per share $ 10.00 $ $ 8.00 9.00 2014 2015 2013 WalMart Inc Balance sheet(s) Walmart Inc Income Statement(s) ..2014 ..2013 7,281,000 6,677,000 44,858,000 2,369,000 61,185,000 117,907,000 19,510,000 6,149,000 204,751,000 7,781,000 6,768,000 43,803,000 1,588,000 59,940,000 116,681,000 20,497,000 5,987,000 203,105,000 Period Ending ..2015 Assets Current Assets Cash And Cash Equivalents 9,135,000 Accounts Receivable 6,778,000 Inventory 45,141,000 Other Current Assets 2,224,000 Total Current Assets 63,278,000 1 Fixed Assets 116,655,000 z Goodwill 18,102,000 3 Other Assets 5,671,000 Total Assets' 203,706,000 Liabilities 6 Current Liabilities Accounts Payable 58,583,000 Current Portion Long Term Debt 6,689,000 Other Current Liabilities - Total Current Liabilities 65,272,000 1 Long Term Debt 43,692,000 2 Deferred Long Term Liability 8.805,000 3 Minority Interest 4,543,000 Total Liabilities 122,312,000 5 Misc Stocks Options Warrants 6 Common Stock 323,000 7 Retained Earnings 85,777,000 8 Capital Surplus 2,462,000 9 Other Stockholder Equity -7,168,000 0 Total Stockholder Equity 81.394.000 Total Sales (Supplier Purchases) Cost of Goods Sold Gross Profit Selling and General Administrative Operating Profit Total Other Income/Expenses Net Earnings Before Interest And Taxes Interest Expense Income Before Tax Income Tax Expense Net Income From Continuing Ops Discontinued Operations Net Income 14,000,000 shares outstanding USE THESE PRICES Price per share ..2015 485,651,000 365,086,000 120,565,000 93,418,000 27,147,000 113,000 27,034,000 2,461,000 24,573,000 7,985,000 16,588,000 285,000 16,303,000 2014 476,294,000 358,069,000 118,225,000 91,353,000 26,872,000 119,000 26,753,000 2,335,000 24,418,000 8,105,000 16,313,000 144,000 16,169,000 ..2013 468,651,000 352,297,000 116,354,000 88,629,000 27,725,000 186,000 27,539,000 2,249,000 25,290,000 7,958,000 17,332,000 52,000 17,280,000 Earnings per share $ 8.00 Price to Earnings Ratio 59,099,000 12,719,000 196000 $ 10.00 $ 9.00 57,174,000 12,082,000 89,000 69,345,000 44,559,000 8,017.000 5,084,000 127,005,000 O 41.417.000 for ratio 7,613,000 5.395.000 126,439,000 116,000 202,000 72,978,000 4,000,000 -630,000 76.666,000 323,000 76,566,000 2,362,000 -1,505,000 77.746.000 Total Liabilities + Stockholder Equity 203,706,000 204,751,000 203,105,000 NIME 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 2014 2013 Student A Liquidity Current Ratio Student A Liquidity Quick Ratio Use of three years of data (2013, 2014, and 2015). Enter ratio outcomes here and expand your comments in the final document - see the "Project Outline" document. 3 Student B Activity Ratios Accounts Receivable Turnover Student B Activity Ratios Inventory Turnover 5 Student B Activity Ratios Accounts Payable Turnover Student C Profitability Returns Return on Equity % Return on Assets% Student C Student C Profitability Returns Profitability Returns Net Profit Margin % 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 Operating Profit Margin Debt to Equity % 9 10 11 12 Student D Student Financing Financing Debt to Assets % Student D Financing Times Interest Earned 13 Student E Market Value 14 Student E Market Value Earnings per Share $ Price to Earnings ratio Price per share $ 10.00 $ $ 8.00 9.00 2014 2015 2013
