Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I did this once and the solutions I got were wrong so I decided to turn to here to be able to see what I
I did this once and the solutions I got were wrong so I decided to turn to here to be able to see what I did wrong. Please help with both formulas and solutions so I can figure out where I went wrong. Thank You!
Wal-Mart Stores, Inc. Consolidated Statements of Income Source: 10K-Edgar Database, SEC (modified) $ $ $ S $ (Amounts in millions) Sales Revenues (can also be used as Total Credit Sales if the later is unknown) Cost of sales or Cost of Goods Sold (COGS) Gross Profit Operating, selling, general and administrative (SG&A) expenses Operating income Non-operating Income/Expenses: Net Interest expenses Other income/loss Income before income taxes Income taxes Net Income Fiscal Years Ended January 31, 2019 2018 2017 514,405.00 $ 500,343.00 $ 485,873.00 $ 385,301.00 $ 373,396.00 $ 361,256.00 $ 129,104.00 $ 126,947.00 $ 124,617.00 $ 107,147.00 $ 106,510.00 $ 101,853.00 $ 21,957.00 $ 20,437.00 $ 22,764.00 $ 2016 482,130.00 360,984.00 121, 146.00 97,041.00 24,105.00 2,467.00 $ $ $ S $ 2,129.00 $ 8,368.00 $ 11,460.00 $ 4,281.00 $ 7,179.00 $ 2,178.00 $ 3.136.00 $ 15,123.00 $ 4,600.00 $ 10,523.00 $ 2,267.00 $ $ 20,497.00 $ 6,204.00 $ 14,293.00 $ 21,638.00 6,558.00 15,080.00 Weighted average common shares outstanding (basic) Cash Dividends declared 2,929.00 6,092.32 $ 2,995.00 6,109.80 $ 3,101.00 6,202.00 $ 3,207.00 6,285.72 $ Wal-Mart Stores, Inc. Consolidated Balance Sheets Source: 10K - Edgar Database, SEC (modified) As of January 31, 2018 2017 2019 2016 ASSETS Current assets: Cash and cash equivalents Accounts Receivables, Net Inventories Prepaid expenses and other expenses Total current assets $ $ S $ $ 7,722.00 $ 6,283.00 $ 44,269.00 $ 3,623.00 $ 61,897.00 $ 6,756.00 $ 5,614.00 $ 43,783.00 $ 3,511.00 $ 59,664.00 $ 6,867.00 $ 5,835.00 $ 43,046.00 $ 1,941.00 $ 57,689.00 $ 8,705.00 5,624.00 44,469.00 1,441.00 60,239.00 Property and equipment: Property and equipment Less accumulated depreciation Property and equipment, net $ $ $ 198,570.00 $ (87,175.00) $ 111,395.00 $ 197,857.00 $ (83,039.00) $ 114,818.00 $ 191,129.00 $ (76,951.00) $ 114,178.00 $ 188,054.00 (71,538.00) 116,516.00 Intangible and other assets: Goodwill Other assets and deferred charges Total assets $ $ 31,181.00 $ 14,822.00 $ 219,295.00 $ 18,242.00 $ 11,798.00 $ 204,522.00 $ 17,037.00 $ 9,921.00 $ 198,825.00 $ 16,695.00 6,131.00 199,581.00 LIABILITIES AND EQUITY Current liabilities: Short-term borrowings Accounts payable Accrued liabilities Accrued income taxes Long-term debt due within one year Obligations under capital leases due within one year Total current liabilities $ $ $ $ $ $ 5,225.00 $ 47,060.00 $ 22,159.00 $ 428.00 $ 1,876.00 $ 729.00 $ 77,477.00 $ 5,257.00 $ 46,092.00 $ 22,122.00 $ 645.00 $ 3,738.00 $ 667.00 $ 78,521.00 $ 1,099.00 $ 41,433.00 $ 20,654.00 $ 921.00 $ 2,256.00 $ 565.00 $ 66,928.00 $ 2,708.00 38,487.00 19,607.00 521.00 2,745.00 551.00 64,619.00 Long-term debt Long-term obligations under capital leases Deferred income taxes and other Total Long-term liabilities $ $ $ $ 43,520.00 $ 6,683.00 $ 11,981.00 $ 62,184.00 $ 30,045.00 $ 6,780.00 $ 8,354.00 $ 45,179.00 $ 36,015.00 $ 6,003.00 $ 9,344.00 $ 51,362.00 $ 38,214.00 5,816.00 7,321.00 51,351.00 Equity: Common stock Paid-in Capital in excess of par value Retained earnings & Accumulated other comprehensive income (loss) Total Walmart shareholders' equity Nonredeemable noncontrolling interest Total equity $ $ $ $ $ $ 288.00 $ 2,965.00 $ 69,243.00 $ 72,496.00 $ 7,138.00 $ 79,634.00 $ 295.00 $ 2,648.00 $ 74,926.00 $ 77,869.00 $ 2,953.00 $ 80,822.00 $ 305.00 $ 2,371.00 $ 75,122.00 $ 77,798.00 $ 2,737.00 $ 80,535.00 $ 317.00 1,805.00 78,424.00 80,546.00 3,065.00 83,611.00 Total liabilities and equity $ 219,295.00 $ 204,522.00 $ 198,825.00 $ 199,581.00 Fiscal Year Ended Jan 31 Analysis Ratio Formula 2019 2018 2017 Liquidity Net Working Capital Current ratio I need the formulas for these I need the solutions for these I need the solutions for these I need the solutions for these Quick ratio Profitability Gross Profit Margin Operating Margin I need the formulas for these I need the solutions for these I need the solutions for these I need the solutions for these Net Profit Margin Debt Analysis Debt Ratio or Debt to Total Assets Ratio I need the solutions for these Interest Coverage Ratio I need the formulas for these I need the solutions for these I need the solutions for these or Times Interests Earned Asset Management Analysis Inventory Turnover Days-Sales-in-Inventory Accounts Receivable Turnover Receivable Collection Period I need the solution for these i need solution for these I need solution for these I need the formulas for these Return on Assets Total Asset Turnover Fixed Asset Turnover Stockholder's Reward Analysis Earnings Per Share Dividends Per Share I need the formulas for these i need the solution for these I need the solution for these I need the solution for these Dividends Payout Ratio Return on EquityStep by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started