Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

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 Equity

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

An Audit Tool For Warfarin Therapy

Authors: Fatema Nuzhat, Malik Hasmat

1st Edition

3659426458, 978-3659426452

More Books

Students also viewed these Accounting questions

Question

2. Identify the purpose of your speech

Answered: 1 week ago