WALMART 2020 ANALYSIS Return on Equity (ROE) (Net income) 13,510,000/ Average Shareholder Equity 80,925,000 + 80,925,000/2 = 16.7% Return on Assets (ROA) Net Income + [Interest 13,510,000 + (2,315,000 x 1 - Expense x (1 - Tax Rate) 35)/ Average Total Assets (252,496,000+252,496,000/2) = 5.94% Profit Margin Earnings before interest 34,031,000 / 559,151,000 Sales Revenue = 6.08% Asset Turnover Sales Revenue 559,151,000/ 236,495,000 Total Assets = 2.36 APT COGS 420,315,000/ 46,973,000 Acct Payable = 8.94 ART Sales Revenue 559,151,000/ 6,516,000 Acct Receivable = 85.81 INVT COGS 420,315,000/ 44,949,000 INV = 9.35 PPET Sales Revenue 559,151,000/ 109,848,000 PP&E = 5.09 C2C 52 52 52 52 52 INVT ART )-C APT 9.35 85.81 8.94 = 5.56 + 0.605 - 5.816 = 0.349 SG&A/Revenue SG&A/Rev 1 16,288,000/559,151,000 = 0.208MACYS 2020 ANAYSIS Return on Equity (ROE) (Net income) (-3,944,000)/ Average Shareholder Equity 2,553,000 + 2,553,000/2 =-1.545 Return on Assets (ROA) Net Income + [Interest (-3,944,000) + (265,000 x 1 - Expense x (1 - Tax Rate) .35)/ Average Total Assets (17,706,000 + 17,706,000/2) = -21.3% Profit Margin Earnings before interest (-3,566,000) / 18,097,000 Sales Revenue = -19.7% Asset Turnover Sales Revenue 18,097,000 / 6,184,000 Total Assets = 2.92 APT COGS 12,286,000 / 2,856,000 Acct Payable =4.3 ART Sales Revenue 18,097,000 / 276,000 Acct Receivable =65.57 INVT COGS 12,286,000 / 3,774,000 INV = 3.25 PPET Sales Revenue 18,097,000 / 8,818,000 PP&E = 2.05 C2C 52 52 52 52 52 52 INVT ART APT 3.25 65.57 43 =4.703 SG&A/Revenue SG&A/Rev 6,767,000/ 18,097,000 = 0.374