Please complete the yellow parts USING THE FORMULAS IN THE SECOND PICTURE. Note the tax rate in the bottom. Please show the work, preferably the excel inputs.

Comparison of Firm Performance Performance Metrics Walmart Macy's Amazon.com Nordstrom Inc. Walmart 469,162 352,488 116,674 88,873 27,801 2,251 187 25,737 7,981 17,756 Return on Assets Return on Equity ROFL Macy's 27,686 16,538 11,148 8,482 2,661 425 (134) 2,102 Amazon.com 74,452 54,181 20,271 19,526 745 141 (98) 506 Nordstrom Inc. 12,148 7,432 4,716 3,371 1,345 Profit Margin 160 Asset Turnover - APT ART 767 1,185 450 735 161 1,198 274 INVT PPET C2C (Weeks) Net operating revenues Cost of goods sold Gross profit Selling, general, and administrative expense Operating income Interest expense Other income (loss) - net Income before income taxes Income taxes Net income Assets Cash and cash equivalents Net receivables Inventories Total current assets Property, plant and equipment Goodwill Other assets Total assets Liabilities and Stockholder Equity Accounts payable Short-term debt Total current liability Long-term debt Total liabilities Stockholder equity 7,781 6,768 43,803 59,940 116,681 20,497 5,987 203,105 1,836 371 5,308 7,876 8,196 3,743 615 20,991 8,658 4,767 7,411 24,625 10,949 2,655 1,930 40,159 1,285 2,129 1,360 5,081 2,579 175 254 8,089 21,821 1,011 7 59,099 12,719 71,818 41,417 126,243 76,343 4,951 124 5,075 6,806 14,940 6,051 3,191 30,413 9,746 3,124 6,176 1,913 Return on Equity ROE Net Income (annual) ROE = Shareholders' Equity Return on Assets ROA Earnings before Interest ROA= Average Total Assets Net Income + [Interest Expense x (1 Tax Rate) Average Total Assets Profit Margin Net Income + [interest expense x (1-Tax Rate)] / Average Total Assets Asset Turnover Revenue Asset Turnover Ratio Assets Accounts Payable Turnover APT COGS/Accounts Payable Accounts Receivable Turnover ART Sales Revenue/ Accounts Receivable Inventory Turnover INVT COGS/ Inventory Plant, Property and Equipment Turnove PPE Sales Revenue/ PPE Cash to Cash Cycle Time c2c -1/APT + 1/ART+1/INVT Selling General and Admin Expense Rat SGA Selling General and Admin Expense/ Revenue use default tax rate of 35%