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.
![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](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F4fca7ae5-48b0-42c7-96ed-5d4b5b82721a%2F7958ccc9-c678-419f-9a38-f73e9390509d%2Fzwckpen_processed.jpeg&w=3840&q=75)
![](/static/compass_v2/shared-icons/check-mark.png)
Step by step
Solved in 3 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
![Corporate Finance (The Mcgraw-hill/Irwin Series i…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)