1. Use DuPont analysis to analyze, profit margin, ROA, ROE, Leverage in terms of Equity Multiplier for Walmart and Target
2. Summarize findings of their financial health and performance over the last three years

Please the attached report

DuPont Analysis - Walmart 2020 2021 2022 Net Income 14,881,000 13,510,000 13,673,000 Sales 523,964,000 559,151,000 572,754,000 Total Assets 236,495,000 252,496,000 244,860,00 Total Debt 43,714,000 41,194,000 34,864,000 Total Equity 81,552,000 87,531,000 91,891,000 Total Current Assets 61,806,000 90,067,000 81,070,000 Current Liabilities 77,790,000 92,645,000 87,379,000 Inventory 44,435,000 44,949,000 56,511,000 Cash 9,465,000 17,741,000 14,760,000 Walmart Five Step Dupont Approach 2020 2021 2022 Profit Margin (Net income/Sales) 0.03 0.02 0.02 ROA & ROE Return on assets (ROA) (Net income/Total assets) 0.06 0.05 0.06 Return on Equity (ROE) (Profit Margin * Total Asset Turnover * Equity Multiplier) 0.18 0.15 0.15 Leverage Debt to Equity (Total debt/Total equity) 0.54 0.47 0.38 Equity Multiplier (Total assets/Total equity) 2.89 2.88 2.66 Liquidity Current ratio (Current assets/current liabilities) 0.79 0.97 0.93 Quick ratio (Current assets-Inventory/Current liabilities) 0.22 0.49 0.28 Cash ratio (Cash/C 0.12 0.19 0.17 Asset Turnover (Sales/Total assets) 2.21 2.21 2.34 Target Five Step Dupont Approach 2020 2021 2022 Profit Margin (Net income/Sales) 0.04 0.05 0.07 ROA & ROE Return on assets (ROA) (Net income/Total assets) 0.13 0.08 0.7 Return on Equity (ROE) (Profit Margin * Total Asset Turnover * Equity Multiplier) 0.01 0.2 0.32 Leverage Debt to Equity (Total debt/Total equity) 1.18 1.05 1.28 Equity Multiplier (Total assets/Total equity) 3.62 3.62 4.2 Liquidity Current ratio (Current assets/current liabilities) 0.89 1.03 0.99 Quick ratio (Current assets-Inventory/Current liabilities 0.27 0.5 Cash ratio (Cash/Current liabilities) 0.35 0.18 0.4 Asset Turnover (Sales/Total assets) 0.27 0.12 1.99 2.02