Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Ratio Analysis (enter the year of the company's most recent financial report) Company 2017 2016 2015 Liquidity Ratios CURRENT RATIO: Current assest 15 20 25

Ratio Analysis (enter the year of the company's most recent financial report) Company 2017 2016 2015 Liquidity Ratios CURRENT RATIO: Current assest 15 20 25 Current liabilities QUICK RATIO: Cash + ST investments + receivables Current liabilities Debt ratios DEBT TO TOTAL ASSETS: Total debt Total assets DEBT TO TOTAL EQUITY: Total debt Total equity TIMES INTEREST EARNED: Income before tax and interest Interest charges Mangement ratios ACCOUNTS RECEIVABLE TURNOVER: Net credit sales Average net accounts receivable INVENTORY TURNOVER: Cost of goods sold Average inventory Profitabilty ratios NET PROFIT ON SALES: Net income Net sales GROSS PROFIT MARGIN Gross profit Net sales RETURN ON ASSETS: Net income + interest Average assets RETURN ON EQUITY: Net income - preferred dividends Average common equity BOOK VALUE: Common equity Common shares Market ratios EARNINGS PER SHARE: Income available to common Average number of shares PRICE EARNINGS: Market price per share Earnings per share DIVIDEND RATE/YIELD: Annual cash dividend per share Market price per share DIVIDEND PAYOUT RATIO: Annual cash dividend per share Earnings per share

For Walmart Inc Company in 2015-2017 Fiscal year is February-January. All values USD Millions. 2020 2019 2018 2017 2016 5-year trend Sales/Revenue 523,964 514,405 499,909 485,144 482,130 Sales Growth 1.86% 2.90% 3.04% 0.63% - Cost of Goods Sold (COGS) incl. D&A 394,605 385,301 373,396 361,256 360,984 COGS excluding D&A 383,618 374,623 362,867 351,176 351,530 Depreciation & Amortization Expense 10,987 10,678 10,529 10,080 9,454 Depreciation 10,987 10,678 10,529 10,080 9,454 COGS Growth 2.41% 3.19% 3.36% 0.08% - Gross Income 129,359 129,104 126,513 123,888 121,146 Gross Income Growth 0.20% 2.05% 2.12% 2.26% - Gross Profit Margin 24.69% - - - - SG&A Expense 107,891 105,947 105,310 101,853 97,041 Other SG&A 107,891 105,947 105,310 101,853 97,041 SGA Growth 1.83% 0.60% 3.39% 4.96% - EBIT 21,468 23,157 21,203 22,035 24,105 Unusual Expense (1,058) 9,568 4,336 - - Non Operating Income/Expense - 49 435 772 15 Non-Operating Interest Income 189 217 152 100 81 Interest Expense 2,599 2,395 2,331 2,410 2,563 Interest Expense Growth 8.52% 2.75% -3.28% -5.97% - Gross Interest Expense 2,599 2,395 2,348 2,446 2,602 Interest Capitalized - - 17 36 39 Pretax Income 20,116 11,460 15,123 20,497 21,638 Pretax Income Growth 75.53% -24.22% -26.22% -5.27% - Pretax Margin 3.84% - - - - Income Tax 4,915 4,281 4,600 6,204 6,558 Income Tax - Current Domestic 3,381 3,256 3,403 3,949 6,184 Income Tax - Current Foreign 1,205 1,495 1,377 1,510 1,400 Income Tax - Deferred Domestic 698 (377) (34) 1,105 (810) Income Tax - Deferred Foreign (369) (93) (146) (360) (216) Consolidated Net Income 15,201 7,179 10,523 14,293 15,080 Minority Interest Expense 320 509 661 650 386 Net Income 14,881 6,670 9,862 13,643 14,694 Net Income Growth 123.10% -32.37% -27.71% -7.15% - Net Margin 2.84% - - - - Net Income After Extraordinaries 14,881 6,670 9,862 13,643 14,694 Net Income Available to Common 14,881 6,670 9,862 13,643 14,694 EPS (Basic) 5.19 2.26 3.28 4.38 4.57 EPS (Basic) Growth 129.58% -31.10% -25.11% -4.16% - Basic Shares Outstanding 2,850 2,929 2,995 3,101 3,207 EPS (Diluted) 5.19 2.26 3.28 4.38 4.57 EPS (Diluted) Growth 129.09% -30.87% -25.26% -4.02% - Diluted Shares Outstanding 2,868 2,945 3,010 3,112 3,217 EBITDA 32,455 33,835 31,732 32,115 33,559 EBITDA Growth -4.08% 6.63% -1.19% -4.30% - EBITDA Margin 6.19% - - - - EBIT 21,468 23,157 21,203 22,035 24,105

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

Step: 3

blur-text-image

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

Intermediate Financial Management

Authors: Eugene F Brigham, Phillip R Daves

14th Edition

0357516664, 978-0357516669

More Books

Students also viewed these Finance questions

Question

3. Provide unexpected, spontaneous, and genuine praise.

Answered: 1 week ago