Download 3 years of Balance Sheet, and Income Statement data for...

Download 3 years of Balance Sheet, and Income Statement data for ABC Resources Inc. from Yahoo Finance (https://ca.finance.yahoo.com/quote/ABC/financials?p=ABC ) into Excel. Clean up the financial statements and calculate the following ratios for all 3 years:

1. Profitability ratios -

• Profit margin
• Return on Asset
• Return on Equity

2. Asset Utilization ratios -

• Receivables turnover
• Inventory turnover
• Account payables turnover

3. Liquidity ratios -

• Current ratio
• Quick ratio

4. Debt ratios -

• Debt to total asset
• Times interest earned
• Fixed charge coverage