90.2K

Verified Solution

Link Copied!

Page 2 Schedule B Walmart (FYE January 30) Balance Sheet (In Billions of USD) EYE 2020 EYE 2019 FYE 2018 3.5% 3.3% 7.72 6.28 44.27 3.62 61.90 104.32 31.18 21.90 219.30 11.4% 14.2% 8.9% Cash & Equivalents Total Receivables, Net Total Inventory Other Current Assets, Total Total Current Assets Property/Plant/Equipment, Net Goodwill Other Long Term Assets, Net Total Assets Accounts Payable Other Current liabilities, Total Total Current Liabilities Long Term Debt Other Liabilities, Total Total Liabilities Total Stockholder Equity Total Liabilities & Stockholder Equity 9.47 6.28 44.44 1.62 61.81 105.21 31.07 38.41 236.50 46.97 30.82 77.79 43.71 33.44 154.94 81.55 236.50 6.76 5.61 43.78 3.51 59.66 107.68 18.24 18.94 204.52 46.09 32.43 78.52 30.05 15.13 123.70 80.82 204.52 18.5% 19.8% 14.7% 47.06 30.42 77.48 43.52 18.66 139.66 79.63 219.30 65.5% 63.7% 60.5% Schedule C - Financial Analysis Walmart (FYE January 30) TY 2020 FYE 2019 FYI 2015 Gross Profit Total Revenue Gross Profit Margin Page 3 Three-Year Average 129.10 514.41 25.1% 126.95 500.34 25.4% 25.1% Net Income Total Revenue Net Profit Margin 14.88 523.96 2.8% 6.67 514.41 1.3% 9.86 500.34 2.0% 2.0% Net Income Total Stockholder Equity Return on Equity 14.88 81.55 18.2% 9.86 6.67 79.63 8.4% 80.82 12.2% 12.9% Net Income Total Assets Return on Assets 6.67 219.30 3.0% 9.86 204.52 4.8% 4.7% Cost of Revenues Inventory Inventory Turnover 385.30 44.27 8.70 373.40 43.78 8.53 8.70 Total Current Assets Total Current Liabilities Current Ratio 61.90 77.48 0.80 59.66 78.52 0.76 0.78 Total Liabilities Total Assets Debt to Asset Ratio 139.66 219.30 63.7% 123.70 204.52 60.5% 63.2% Schedule D - Breakeven Analysis Walmart (FYE January 30) Page 4 1. What is your contribution margin for FYE 2020? For our purposes, use the gross profit margin. 0.80 2. What is the cost of your recommendation (in US Billions)? For example, $800 million = $0.8 billion 3. Divide the recommendation cost with your contribution margin. This is your breakeven sales amount 4. What is your total revenues for FYE 2020 (in US Billions)? 5. Divide the breakeven sales amount with FYE 2020 revenues (This is required sales increase to b/e). 6. What is the average growth in sales from FYE 2017 thru FYE 2020? NO YES 7. Does the required increase in sales to b/e make sense in light of past growth in sales? NOTE: You do not have to complete this page. We will review the concept of breakeven analysis during the Zoom call and complete this math exercise during the Zoom call

Answer & Explanation Solved by verified expert

See Answer