I need help with the ratios. I don:t know where to begin with this. i need a fixed ratio correct, to calculate the other two columns? Not sure what direction to go with this. Thanks in advance.

Excel File Edit View Insert Format Tools Data Window Help 69%O Sat 3:11 PM Q O AutoSave OFF 3. High-Module 1 Activity - Saved to my Mac Calibri (Body) 11 A ab v General Insert v E 2x Delete v 4 Paste B I UV A $ ~ % 9 Conditional Format Cell X Sort & Find & Ideas Formatting as lable Styles Format v Filter Select A2 X V fx A B C D E F G RATIO ANALYSIS 2 3 Note: change the column names to your industry and selected companies 5 RATIOS Retail WALMART Target ANALYSIS Profitability Ratios (% Gross Margin EBITDA Margin Operating Margin Pre-Tax Margin Effective Tax Rate Financial Strength Quick Ratio 15 Current Ratio T Debt to Equity otal Debt to Equity Interest Coverage Valuation Ratios Price/Earnings Ratio Price to Sales P/S Price to Book P/B Free Cash Flow per Share Management Effectiveness (%) 25 Return On Assets 26 Return On Investment 27 Return On Equity 28 Efficiency 29 Receivable Turnover 30 Inventory Turnover 31 Total Asset Turnover 32 Free Cash Flow/Net Income 33 What is Ratio Analysis? Briefly explain and cite your resources: 35 36 27 RATIO ANALYSIS + 100%