Need done by Friday afternoon

profilecarfito
Module1WalMartProjectTemplateRevised.xlsx
Home>Business & Finance homework help>Need done by Friday afternoon

Sheet1

Your Name
Complete all fields shaded in yellow. Use the exact amounts from the financial statements found in the 2019 Annual Report on pages 50-54. (Note: do not use the comprehensive income statement.)
In a separate file (Word format) discuss the trend in WalMart's liquidity, asset management, debt management, profitability, and market value from 2018 to 2019. Include a DuPont system analysis
in your discussion of profitability.
LIQUIDITY RATIOS
Amounts from 2019 Amounts from 2018
Name of Ratio Formula Financial Statements 2019 Ratio Financial Statements 2018 Ratio
Current Ratio Current Assets Times Times
Current Liabilities
Cash Ratio Cash and Cash Equivalents Times Times
Current Liabilities
Quick Ratio Current Assets - Inventory Times Times
Current Liabilities
ASSET MANAGEMENT RATIOS
Amounts from 2018
Name of Ratio Formula 2019 Ratio Financial Statements 2019 Ratio
Inventory Turnover Cost of Sales Times Times
Inventory
Days Sales in Inventory 365 365 Days 365 Days
Inventory Turnover
Receivables Turnover Net Sales (assume all sales on credit) Times Times
Receivables, Net
Average Collection Period 365 365 Days 365 Days
Receivables Turnover
Accounts Payable Turnover Cost of Goods Sold Times Times
Accounts Payable
Average Payment Period 365 365 Days 365 Days
Accounts Payable Turnover
Fixed Asset Turnover Total Revenue Times Times
Net Fixed Assets
Sales to Working Capital Total Revenue Times Times
Working Capital
Total Asset Turnover Total Revenue Times Times
Total Assets
Capital Intensity Total Assets Times Times
Total Revenue
Note: net fixed assets include all assets except current assets.
DEBT MANAGEMENT RATIOS
Amounts from 2019 Amounts from 2018
Name of Ratio Formula Financial Statements 2019 Ratio Financial Statements 2018 Ratio
Debt Ratio Total Liabilities
Total Assets
Debt-to-Equity Ratio Total Liabilities
Total Equity
Equity Multiplier Total Assets Times Times
Total Equity
Times Interest Earned (1) Net Income + Interest Expense + Income Tax Expense Times Times
Interest Expense
Cash Coverage EBIT + Depreciation and Amortization Expense (2) Times Times
Interest Expense (assume no other fixed charges)
(1) Use the interest expense, net and the income tax amounts from the income statement.
(2) WalMart does not report depreciation and amortization expense on the face of its income statement. The amount can be found on the statement of cash flows.
PROFITABILITY RATIOS
Amounts from 2019 Amounts from 2018
Name of Ratio Formula Financial Statements 2019 Ratio Financial Statements 2018 Ratio
Gross Profit Margin Net Sales - Cost of Sales
Net Sales
Operating Profit Margin Net Income + Interest Expense + Income Tax Expense
Net Sales
Profit Margin Net Income
Total Revenue
Basic Earnings Power Net Income + Interest Expense + Income Tax Expense
Total Assets
Return on Assets Net Income
Total Assets
Return on Equity Net Income
Total Equity
Dividend Payout Dividends Declared per Share
Net Income per Share (diluted)
MARKET VALUE RATIOS
Amounts from 2019
Name of Ratio Formula Financial Statements 2019 Ratio 2018 Data Provided 2018 Ratio
Market-to-Book Value per Share Market Price per Share (at Jan. 31) $ 95.32 Times $ 103.57 3.78 Times
Total equity / Total Common shares outstanding at year-end $ 80,822 2,952

&F