"Canadian National Railway" Annual Report 2017 and 2016a) Discuss each of the ratios for two years and explain their implications for the company by using graphs, charts in your analysis. RProfit margin=(Net income/Revenue)*10020172016(5484/13041)*100 3640/12037)*100 fixed asset turnover=net sales/average fixed asset2017201642.0530.241304112037/34950(35439+34950)/2Return on assets=Net income/Total asset0.375484/376293640/370570.340.15Total asset turnover-net sales/average total asset0.101304112037/37057Return on equity=Net income/Shareholder's equity5484/16656(37629+37057)/23640/14841100.350.320.330.2511Current Asset=Current asset/current liability12Receivable turnover-Net credit sales/average receivable2190/37932107/3008(36.225*365) (33.436*365)/875(984+875)/2130.580.701414.2213.95Quick Ratio=(current asset-inventory)current liability(2190-424)/3793 (2107-363)/300815160.470.58Avg collection period=Avg account receivable/avg credit sales per day17(984+875)/36.225875/33.436Debt total asset-DTotal debt/total asset10828/3762910937/370571827.1626.170.290.301920Inventory turnover=net sales/average inventory1304112037/363 Times interest earned=Interest before interest & taxes/Interest5558/4815312/48021(424+363)/211.5611.072233.1433.1623Fixed charge coverage=income before fixed charges & taxes/fixed charges5089/9644927/77624Note-for 2016 opening data is not given so its considered as 0 for calculating average.5.286.3525 Railroud Statisties Canadian National Railway7Data in million ($)20162012Net income5,4843,640Total sales Revenues13,0411293又Total assets33,629→ タ3,05又Stockholdery equity>14,841>16,656 -A cCounts receivable> 825984->Ang.daily credit sales>36.225>33.436Inventory7363424Fixed assets» 35,439ラ 34950Currend assets>2,1902,102Curnent liabilities→ 3,ヌ8873,008Total debt10,828→10,93スIneome before interest5,5585,312and taxes481480InterestIncome befne fixed5,089> 492又Charges and taxesFixed Chorges964ラヌヌ6

Answer: As the ratios are already calculated its interpretation is as follows: (1). Profit Margin =…

Answered: "Canadian National Railway" Annual…

Business

Accounting

"Canadian National Railway" Annual Report 2017 and 2016

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

Determine Profit Margin,Asset Turnover,Earnings Per Share,Price-Earning Ratios, Pay out ratio and Debt to asset ratio for 2016 and 2017 and explain briefly whether or not the company experiences improvement in the financial positon and operating for the period from 2016 to 2017.
I. Complete the horizontal analysis below. Use the name of the company you belong to in your iLS Activity. Round off your answers to the nearest hundredths. Name: Income Statement for the years ending December 31, 201X and December 31, 201Y 2015 2016 Annual Percentage Growth 2015-2016 Sales 475,000 500,000 1. Cost of Goods Sold 265,000 269,000 2. Gross Profit 210,000 231,000 3. Wages 154,000 163,000 4. Repairs 5,800 4,150 5. Rent 13,000 12,000 6. Taxes 16,940 17,930 7. Office Expenses 1,023 587 8. Total Expenses 190,763 197,667 9. Net Income 19,237 33,333 10. II. Analyze the following ratios (Good/Not good, Undervalued/Overvalued, or just OK) based on the given industry averages. Write the answers in the spaces provided. Ratios Annual Data Industry Average Interpretation Current 5.7 4 Days Sales Outstanding 37 days 42 days Total Debt to Total Capital 47.80% 32.60% Times-Interest Earned 2.2 6 Profit Margin 6.10% 6.00% Return on Invested Capital 10.03% 10.00% Enterprise Value to EBITDA…
The comparative current liabilities balances for December 31, end of the year, for a company are provided below. 2016 2015 Current liabilities $180,000 $150,000 Based on this information, what is the percentage of increase or decrease that would be shown in a balance sheet with horizontal analysis? Group of answer choices (20.0%) 2.0% 20.0%
River Valley Production Inc. seeks to increase its market share and improve its results. The company takes as a starting point the current scenario and the results obtained in 2018 and 2019. Like other companies, River Valley uses financial ratios (ratios) as tools for analyzing the results obtained at the end of the period. Consider the data presented in the financial statements below and analyze the company's results based on the financial ratios. Balance Sheet 2018 2019 Cash $63,000 $201,000 Accounts Receivable 199,000 305,000 Marketable Securities 81,000 42,000 Inventories 441,000 455,000 Prepaids 5,000 9,000 Total Current Assets 789,000 1,012,000 Property, Plant, and Equipment, net 858,000 858,000 Total Assets $1,647,000 $1,870,000 Account Payable $150,000 $100,000 Accruals 101,000 95,000 Total Current Liabilities $251,000…
From the following, find out the amount of subscriptions to be Income and Expenditure Account for the year 2016. Subscriptions received in 2016 - OMR. 48,000, OMR. 40,000 for 2015 and OMR. 80,000 for 2017. Subscriptions outstanding in the year of 2017 were OMR. 20,000. Subscriptions outstanding in 2015 were OMR. 12,000. Select one: a. OMR 16,000 b. OMR 40,000 c. OMR 56.000 d. MR 32,000 O O O O
Please help
Forecast Income Statement and Balance Sheet Following are the income statement and balance sheet for Medtronic PLC. Note: Complete the entire question using the following Excel template: Excel Template. Then enter the answers into the provided spaces below with two decimal places. Medtronic PLC Consolidated Statement of Income $ millions, For Fiscal Year Ended April 26, 2019 Net sales $30,557 Costs and expenses Cost of products sold 9,155 Research and development expense 979 Selling, general, and administrative expense 10,418 Amortization of intangible assets 1,764 Restructuring charges, net 83 Certain litigation charges, net 166 Other operating expense, net 258 Operating profit 7,734 Other nonoperating income, net (157) Interest expense 1,444 Income before income taxes 6,447 Income tax provision 547 Net income 5,900 Net income loss attributable to noncontrolling interests (19) Net income attributable to Medtronic $5,881…
Subject;
Required information Skip to question [The following information applies to the questions displayed below.] CommercialServices.com Corporation provides business-to-business services on the Internet. Data concerning the most recent year appear below: Sales $ 2,760,000 Net operating income $ 110,400 Average operating assets $ 920,000 The following questions are to be considered independently. Brewer 8e Rechecks 2019-01-10 Required: 1. Compute the company's return on investment (ROI).
You are required to calculate:1. Liquidity ratios 2. Solvency rations 3. Profitability ratios For the selected companies and shortly write your comments and findings.
Abcde Trading has reported the following from its business operation from period 2008 through 2019: a. Sales (32,067, 35,422, 70,881, 95,519, 122,128, 165,654, 188,793, 232,834, 263,159, 273,046, 269,693, 294,619) b. Expenses (28,320, 31,490, 69, 371, 84, 747, 105,310, 144,175, 164,799, 198,966, 224,105, 236,388, 240,171, 261,738) c. Other Income (534, 849, 1,039, 2,103, 660, 662, 816, 829, 899, (932), 1,937, 4,509) d. Interest (465, 913, 2,171, 2,465, 2,385, 2,982, 3,560, 4,749, 4,861, 4,889, 4,283, 4,682) e. Prevailing tax rate is 28.23% (round off amount) Prepare the following: 1. Individual P & L using multiple worksheets. 2. Consolidated P & L for the period 2008 - 2019.
PERFORM A LIQUIDITY AND PROFITABILITY ANALYSIS ON THE FOLLOWING COMPANY UTILIZING THE RATIOS LISTED: PAYABLES TURNOVER DAYS PAYABLE statement of operations 12 Months Ended Jul. 31, 2020 Jul. 31, 2019 Revenues: Revenues $ 1,497,826,000 $ 1,684,392,000 Costs and expenses: Operating expense - personnel, vehicle, plant and other 493,055,000 468,868,000 Operating expense - equipment lease expense 33,017,000 Equipment lease expense, preadoption 33,073,000 Depreciation and amortization expense 80,481,000 78,846,000 General and administrative expense 45,752,000 59,994,000 Non-cash employee stock ownership plan compensation charge 2,871,000 5,693,000 Asset impairments 0 0 Loss on asset sales and disposals 7,924,000 10,968,000 Operating income 148,670,000 113,028,000 Interest expense (192,962,000) (177,619,000) Loss on extinguishment of debt (37,399,000) Other income (expense), net (460,000) 369,000 Loss before income taxes (82,151,000)…