a)Please calculate all the ratios of companies -

Profitability ratios(Profit margin, Return on assets , Return on equity) ,

Asset utilization ratios (Receivables turnover, Average collection period, Inventory turnover, Fixed asset turnover, Total asset turnover)

Liquidity ratios (Current ratio, Quick ratio) &

Debt utilization ratios (Debt total assets, Times interest earned, Fixed charge coverage)

b) Calculate all your ratios in and Excel File. You need to show all your calculations in excel file but use the calculated value in your main report.

c) Discuss each of the ratios for two years and explain their implications for the company. Analyze the ratios that you have calculated

d) Use graphs, charts in your analysis.

Railroad Statistics [Canadian National Railway Data in million ($ 2017 2016 Net income > 5,484 3,640 > 13,041 12032 > 37,629 37,05% > 16,656 > 14,841 Total sales / Revenues. Total assets stockholdery equity Accounts receivable. Aug. daily credit sales Inventory Fixed assets > 984 > 875 36.225 33.436 424 35,439 -34,950 Current assets > 2,190 > 2, 1oz Current liabilities 3,783 > 3,008 Total debt 10,828 10,937 Income before interest and taxes 5,558 5,312 Interest 481 480 Income before fixed changes and taxes 5,089 4922 Fixed changes 964 276