Comprehensive Financial Analysis

profilegattist
Unit9_Walmart_Ratio_Solutions_2017-LAPM.xlsx

Ratios

Walmart 2017 Ratios
Liquidity & Debt Ratios
Current Current Assests/Current Liabilites 0.8620
Quick (CA - Inventories)/Current Liabilites 0.2189
Total Debt to Total Asset Total Debt/Total Assests 59.49%
Asset Management
Inventory Turnover CGS/ Inventories per year 8.39
Fixed Asset Turnover Sales/ Net Fixed Assests 4.26
Total Asset Turnover Sales/Total Assets 2.44
Profitability
Profit Margin on Sales Net Income/Sales 2.81%
Return on Assests Net Income/Total Assets 6.86%
Return on Equity Net Income/Common Equity 17.54%
Market Value
Price Earnings Ratio Price of Shares/Earning Per Share 14.92
Market/Book Market Price/Book Value (Per Share) 2.58

Sheet2

Sheet3