- I already calculate the Debt Ratio and Current Ratio In need help in the Trend part and how to make a graph, and add some comment. Discuss direction and magnitude of any trends. Add comments with respect to:Trends over the 4 year history and Industry Average.
Sobeys Inc. Consolidated Statements of Earnings (Loss) 52 and 53 Weeks Ended May 6 May 7 (in millions of Canadian dollars) 2017 2016 Sales 23,806.2 24,618.8 Other income (loss) (Note 18) 51.5 (14.2) Operating expenses Cost of sales 18,099.0 18,661.2 Selling and administrative expenses 5,491.2 5,416.1 Impairments of goodwill and long-lived assets (Notes 8 and 11) 2,975.3 Operating income (loss) 267.5 (2,448.0) Finance costs, net (Note 20) 93.7 134.6 Earnings (loss) before income taxes 173.8 (2,582.6) Income tax expense (recovery) (Note 12) 26.0 (463.4) Net earnings (loss) 147.8 (2,119.2) Earnings (loss) for the year attributable to: Non-controlling interest 14.0 $ 16.4 Owners of the Company 133.8 (2.135.6) 147.8 (2.119.2)Sobeys Inc. Consolidated Statements of Earnings 52 Weeks Ended May 4 May 5 (in millions of Canadian dollars) 2019 2018 Sales 25,142.0 S 24,214.6 Other income (Note 18) 60.3 70.5 Operating expenses Cost of sales 19,058.4 18,314.1 Selling and administrative expenses 5,578.7 5,683.1 Operating income 565.2 287.9 Finance costs, net (Note 20) 57.3 74.4 Earnings before income taxes 507.9 213.5 Income tax expense (Note 12) 136.9 43.1 Net earnings 371.0 170.4 Earnings for the year attributable to: Non-controlling interest 29.1 20.3 Owners of the Company 341.9 150.1 371.0 170.4Sobeys Inc. Consolidated Balance Sheets As At May 6 May 7 (in millions of Canadian dollars) 2017 2016 ASSETS Current Cash and cash equivalents 206.8 258.8 Receivables 413. 4894 Inventories (Note 4) 1,322.2 1,287.3 Prepaid expenses 117.3 117.2 Loans and other receivables (Note 5) 25.4 28.1 Income taxes receivable 31.6 6.4 Assets held for sale (Note 6 48.5 396.2 2,165.4 2,581.4 Loans and other receivables (Note 5) 82.1 93.0 Investments in affiliate 48.0 48.0 Other assets (Note 7) 43.3 57.9 Property and equipment (Note 8) 2,989.4 3,095.8 Investment property (Note 9) 110.6 90.4 Intangibles (Note 10 625.4 854.1 Goodwill (Note 11) 721.0 716.3 Deferred tax assets (Note 12) 686.4 637.8 7,471.6 7,975.1 LIABILITIES Current Accounts payable and accrued liabilities 2,242.8 2,180.2 Income taxes payable 13.8 16.8 Provisions (Note 13) 82.2 169.0 Long-term debt due within one year (Note 14) 134.0 350.4 2,472.8 2,716.4 Provisions (Note 13) 101.5 125.1 Long-term debt (Note 14) 1,612.7 1,928.1 Other long-term liabilities (Note 15) 141.1 107. Employee future benefits (Note 15) 363.9 326.9 Deferred tax liabilities (Note 12) 40.5 41.0 4,732.5 5,245.4 SHAREHOLDERS' EQUITY Capital stock (Note 17) 2,752.9 2,752.9 Contributed surplus 101.8 93.0 Deficit 170.2) (172.1) Accumulated other comprehensive loss (3.9) (3 2) 2,680.6 2,670.6 Non-controlling interest 58.5 59.1 2,739.1 2.729.7 7,471.6 7.975.1Debt Ratio: Total Liabilities / Total Assets Items Formula 2016 2017 2018 2019 Industry Average Total Liabilities a 5,245.4 4,732.5 4,724.5 5,389.0 (In millions of Canadian dollars) Total Assets (In b 7,975.1 7.471.6 7,555.7 8,472.0 millions of Canadian dollars) Debt Ratio c=a/b 0.66:1 0.63:1 0.63:1 0.64:1 0.67:1 Trends3. Current Ratio: Current Assets / Current Liabilities Items Formula 2016 2017 2018 2019 Industry Average Current Assets a 2,581.4 2,165.4 2,490.6 2,622.9 (In millions of Canadian dollars) Current b 2,716.4 2472.8 2,962.3 2,672.4 Liabilities ( In millions of Canadian dollars) Current Ratio c=a/b 0.95:1 0.88:1 0.84:1 0.98:1 1.27:1 Trends
