Analyze the financial health of two competitors in the same industry based on their ratios, using the provided Excel spreadsheet template.

Ratio Research: Use the template to analyze the selected ratios (profitability, financial strength, valuation, management effectiveness, dividends, and efficiency) for the retail industry, walmart, and target:

Please provide formulas for the percentages

RATIOS	RETAIL	WALMART	TARGET
Profitability Ratios (%)
Gross Margin
EBITD Margin
Operating Margin
Pretax Margin
Effective Tax Rate
Financial Strength
Quick Ratio
Current Ratio
LT Debt to Equity
Total Debt to Equity
Interest Coverage
Valuation Ratios
P/E Ratio
Price to Sales (P/S)
Price to Book (P/B)
Price to Tangible Book
Price to Cash Flow
Price to Free Cash Flow
Management Effectiveness (%)
Return On Assets
Return On Investment
Return On Equity
Dividends
Dividend Yield
Payout Ratio
Efficiency
Revenue/Employee
Net Income/Employee
Receivable Turnover
Inventory Turnover
Asset Turnover