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.
Extracted text: Railroud Statisties Canadian National Railway7 Data in million ($) 2016 201X Net income 5,484 73,640 Total sales Revenues 1293又 13041 - Total assets 33629 → タ3,05又 stockholdery equity 14,841 > 16,656- A ccounts receivable &ヌ5 984 -> Ang. daily credit sales >36.225 33.436 Inventory 7363 424 Fixed assets ラ 34950 >35,439 Currend assets >2,190 >2,102 Current liabilities → 3,ヌ88 73,008 Total debt >10,828 > 10,93ス Ineome before interest 5,558 5,312 and taxes 481 480 Interest Income befne fixed -> >5,089 > 492又 Charges and taxes Fixed Chorges 964 ラヌヌ6