How do you calculate ratio analysis?

Below is an example table but, I need a new calculated table of 2022 year or 2021 year.

To complete this part, you can use the websites CIS Market or Mergent INTELLECT to obtain the ratios. You can also use the SEC Edgar Company Filings resource to obtain the ratio from annual reports. Note: The ratios have to be from the same time period, the same year for both competitors.

RATIOS	Retail	Walmart	Target
Profitability Ratios (%)
Gross Margin	47.14	23.17	29.03
EBITDA Margin	4.41	6.35	9.07
Operating Margin	2.49	2.54	6.76
Pre-Tax Margin	2.47	2.37	6.57
Financial Strength
Quick Ratio	0.42	0.17	0.27
Current Ratio/Working Capital Ratio	0.23	0.95	0.99
LT Debt to Equity	0.71	0.38	1.06
Total Debt to Equity	0.04	0.41	1.07
Interest Coverage	80.02	9.62	28.43
Valuation Ratios
Price/Earnings Ratio	31.28	52.68	15.53
Price to Sales P/S	0.65	0.78	0.99
Price to Book P/B	7.57	4.57	8.19
Free Cash Flow per Share	27.55	5.52	9.77
Management Effectiveness (%)
Return On Assets	5.88	3.26	12.23
Return On Investment	5.2	4.83	24.8
Return On Equity	23.72	8.95	49.22
Efficiency
Receivable Turnover	19.44	76.65	9.38
Inventory Turnover	13.56	7.93	5.92
Total Asset Turnover	19.44	2.21	1.87
Free Cash Flow/Net Income	20.94	5.52	-35.4