Railmond Statisties Conadian Notional Railway 2016 Data in million c $) 201지 Net income 5,484 73,640 Total sales Revenues 1293又 13,041 Total assets >33,629 37,05又 stockholdery equity >14,841 16,656 Accounts receivable. &ヌ5 >984 Avg daily cnedit sales 733.436 36.225 Inverntary 424 7363 Fixed assets 734,950 >35,439 Curnert assets 2,190 2.10ス Curnent liabilities 3,ヌ23 73,00- Total debt >10,828 10,93ス Ineome before interest →5,558 5,312 and taxes 481 480 Interest Income before fixed → 492ス 5,089 Chonges and taxes Fixed Cheiges 964 ラヌヌら
a)Please calculate all the ratios of companies -
Profitability ratios(Profit margin,
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.
Step by step
Solved in 3 steps with 2 images