Analyze the financial strength and trends of the Canadian tire, and comment on the relative performance.
Write a summary which should include;
Comments on the trends for company with respect to profitability, asset utilization, liquidity and leverage.
X o Canadian Tire Financial Book - Excel Ibrahim Diriye X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 11 = = ab Custom Conditional Formatting Insert B 1 U. A A % . Fomet as Table Delete A 11 .00 10 .0 Format Cell Styles Styles Clipboard font Alignment Number Cells Editing E24 VIX fx A B C D F G H 1 J 1 2020 (Projected) 2015 2016 2017 2018 2019 2020 2021 $ $ 5 14,871.00 9,794.40 5,076,60 3.599.30 5 2 Annual 3 Income Statement 5 Total Revenue 6 Cost of Revenue 7 Gross Profit 8 Selling, General and Administrative 9 Operating Expenses 10 Operating Income 11 Pre-tax Income 12 Net Income 13 Tax Rate 14 Basic EPS 15 Diluted EPS s $ $ $ 5 $ $ S $ 12,279.60 $ 8,144.30 $ 4,135.30 $ 3,096,10 $ 3,188.90 $ 946.40 $ 1,001.30 $ 735.90 $ 26.5% 3.02 $ 3.01 $ 12,681.00 $ 8,288.50 $ 4,392.50 $ 3,291.90$ 2,485.80$ 1,906.70$ 1,011.00 $ 747.50 $ 26.1% 9.25$ 9.22S 13,276.70 $ $ 8,796.50 $ 4,480.20 $ 2.758.80 $ 12,051.60 $ 1,225.10 $ 1,112.50 $ 735.00 $ 26.4% 10.70 S 10.67 S 14,058.70 $ 9,347.40 $ 4,711.30 $ 2,996.90 $ 12,789.00 $ 1,269.70 $ 1,068.20 S 692.10 $ 26.7% 10.67 $ 10.64 $ 14,534.40 9,660.60 4,873.80 2.787.80 13,084.70 1,449.70 1,182.90 778.40 24.4% 12.60 $ S 1,172.10 862.60 24.4% 12.35 12.31 $ $ 12.58 $ $ TROFEONARONS 21 22 23 24 25 28 29 30 Income Statements Balance Sheets Cash Flows # Ready 1010140 X o Canadian Tire Financial Book - Excel Ibrahim Diriye X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 11 - = ab General Conditional Formatting Insert B 1 U. A A E $ % . Fomet as Table Delete Posts A e 11 .00 00 .0 Cell Styles Format Clipboard font Alignment Number Styles Cells Editing 113 vXfx A B C D E F G H 1 1 1 2020 (Projected) 2015 2016 2017 2018 2019 2021 681.10 $ S $ $ $ $ S 900.60 $ 96.10 $ 4,875.50 $ 1,764.50 731.20 $ 3,978.20 $ 14,987.80 $ 829.70 S 690.80 5,138.40 $ S 266.40 $ 4,097.20 15,302.80 $ 5,613.20 $ 1.769.80 5 1,292.90 $ 933.30 $ $ 5,511.30 $ 1,997.50 $ 2,272.00 $ $ 17,286.80 $ 205.50 201.70 5,813.80 2,212.90 807.80 4,283.30 19,518.30 $ $ S $ S $ $ 1,327.20 643.00 5,031.80 2,312.90 631.90 2,372.80 20,377.10 $ 5 15,627.00 $ 2 Annual 3 4 Income Statement 5 Assets 6 Cash and cash equivalents 7 Short-term Investements 8 Loans receivable 9 Merchandise inventories 10 Long-term receivables and other assets 11 Property and equipment 12 Total Assets 13 Liabilities 14 Deposits 15 Trade and other payables 16 Short-term borrowings 17 Current portion of long-term debt 18 Long-term debt 19 Long-term deposits 20 Other long-term liabilities 21 Total liabilities 22 23 24 25 26 27 28 29 30 $ $ S S $ $ $ 5 880.70 $ 1,957.10 $ 88.60 S 24.30 $ 2.971.40 $ 1,372.20 $ 813.90 $ 9,198.10 $ 950.70 1,856.90 $ 199.40 $ 653.40 $ 2,667.10 $ 1,230.80 836.60 9,565.50 $ $ 2,230.80 $ 144.60 $ 282.30 $ 3,122.10 $ 964.50 $ 2,425.00 $ 378.10 $ 553.60 $ 4.000.30 $ $ S 11,871.80 $ 790.80 2,492.40 450.00 335.30 3,730.20 1,653.40 810.10 14,013.60 S S $ S $ $ 1.228.00 2,508.30 165.40 150.50 4,115.70 3,509.70 850.30 14,542.40 $ 10,060.90 5 5 Income Statements Balance Sheets Cash Flows # Ready 111119 X o Canadian Tire Financial Book - Excel Ibrahim Diriye X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 11 - = ab Custom Conditional Formatting Insert B 1 U. A A E $ % . Fomet as Table Delete Posts A e 11 .00 10 .0 Cell Styles Format Clipboard font Alignment Number Styles Cells Criting 13 vXfx A B C D E F G H H 1 1 2020 (Projected) 2015 2016 2017 2018 2019 2021 1,403.20 $ $ 430.40 -5 972.80 $ 4.30 $ 632.60 $ 1,087.60 270.40 107.40 S S $ 2,442.80 925.10 183.70 $ -$ $ $ S -$ -S S $ S -S -$ $ 1,004.10 $ 25.20 $ 978.90 $ 210.10 $ 610.60 $ 101.50 $ 299.00 $ 213.50 $ 206.00 $ 434.60 $ 12.50 1,292.50 $ 306.10 $ 986.40 $ 34.80 5 780.80 $ 32.80 782.80 $ 402.90 $ 233.90 449.40 $ $ 435.20 20.20 758.70 -5 $ -5 307.20 13.30 848.00 639.90 $ 10.80 S 1,298.90 $ 491.50 $ 807.40 $ 39.50 546.30 $ $ 1,308.60 $ 1,069.70 $ 582.40 $ 80.60 $ 62.30 S 534.60 $ 33.40 $ -$ -$ $ 2 Annual 3 4 Income Statement 5 Operating Activities (before undernoted) G Change in Loans Receivable 7 Operating Activities 8 Change in investments 9 Additions (PPE) 10 Disposition Profits (PPE) 11 Investing Activities 12 Change in Loan Debt 13 Dividends paid and distributions 14 Repurchase of share capital 15 Change in deposits 16 Proceeds on sale of ownership interests 17 Cash generated from financing 18 Cash generated in the period 19 20 21 22 23 24 25 26 27 28 29 30 96.20 462.70 1,061.00 659.30 -s 201.50 $ $ 719.70 $ 386.80 $ 84.10 604.20 30.80 142.60 604.20 275.30 $ $ 427.10 $ 252.80 $ 280.40 $ 76.80 $ S $ 462.70 1.132.10 Income Statements Balance Sheets Cash Flows + Ready 111119 X o Canadian Tire Financial Book - Excel Ibrahim Diriye X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 11 = = ab Custom Conditional Formatting Insert B 1 U. A A % . Fomet as Table Delete A 11 .00 10 .0 Format Cell Styles Styles Clipboard font Alignment Number Cells Editing E24 VIX fx A B C D F G H 1 J 1 2020 (Projected) 2015 2016 2017 2018 2019 2020 2021 $ $ 5 14,871.00 9,794.40 5,076,60 3.599.30 5 2 Annual 3 Income Statement 5 Total Revenue 6 Cost of Revenue 7 Gross Profit 8 Selling, General and Administrative 9 Operating Expenses 10 Operating Income 11 Pre-tax Income 12 Net Income 13 Tax Rate 14 Basic EPS 15 Diluted EPS s $ $ $ 5 $ $ S $ 12,279.60 $ 8,144.30 $ 4,135.30 $ 3,096,10 $ 3,188.90 $ 946.40 $ 1,001.30 $ 735.90 $ 26.5% 3.02 $ 3.01 $ 12,681.00 $ 8,288.50 $ 4,392.50 $ 3,291.90$ 2,485.80$ 1,906.70$ 1,011.00 $ 747.50 $ 26.1% 9.25$ 9.22S 13,276.70 $ $ 8,796.50 $ 4,480.20 $ 2.758.80 $ 12,051.60 $ 1,225.10 $ 1,112.50 $ 735.00 $ 26.4% 10.70 S 10.67 S 14,058.70 $ 9,347.40 $ 4,711.30 $ 2,996.90 $ 12,789.00 $ 1,269.70 $ 1,068.20 S 692.10 $ 26.7% 10.67 $ 10.64 $ 14,534.40 9,660.60 4,873.80 2.787.80 13,084.70 1,449.70 1,182.90 778.40 24.4% 12.60 $ S 1,172.10 862.60 24.4% 12.35 12.31 $ $ 12.58 $ $ TROFEONARONS 21 22 23 24 25 28 29 30 Income Statements Balance Sheets Cash Flows # Ready 1010140 X o Canadian Tire Financial Book - Excel Ibrahim Diriye X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 11 - = ab General Conditional Formatting Insert B 1 U. A A E $ % . Fomet as Table Delete Posts A e 11 .00 00 .0 Cell Styles Format Clipboard font Alignment Number Styles Cells Editing 113 vXfx A B C D E F G H 1 1 1 2020 (Projected) 2015 2016 2017 2018 2019 2021 681.10 $ S $ $ $ $ S 900.60 $ 96.10 $ 4,875.50 $ 1,764.50 731.20 $ 3,978.20 $ 14,987.80 $ 829.70 S 690.80 5,138.40 $ S 266.40 $ 4,097.20 15,302.80 $ 5,613.20 $ 1.769.80 5 1,292.90 $ 933.30 $ $ 5,511.30 $ 1,997.50 $ 2,272.00 $ $ 17,286.80 $ 205.50 201.70 5,813.80 2,212.90 807.80 4,283.30 19,518.30 $ $ S $ S $ $ 1,327.20 643.00 5,031.80 2,312.90 631.90 2,372.80 20,377.10 $ 5 15,627.00 $ 2 Annual 3 4 Income Statement 5 Assets 6 Cash and cash equivalents 7 Short-term Investements 8 Loans receivable 9 Merchandise inventories 10 Long-term receivables and other assets 11 Property and equipment 12 Total Assets 13 Liabilities 14 Deposits 15 Trade and other payables 16 Short-term borrowings 17 Current portion of long-term debt 18 Long-term debt 19 Long-term deposits 20 Other long-term liabilities 21 Total liabilities 22 23 24 25 26 27 28 29 30 $ $ S S $ $ $ 5 880.70 $ 1,957.10 $ 88.60 S 24.30 $ 2.971.40 $ 1,372.20 $ 813.90 $ 9,198.10 $ 950.70 1,856.90 $ 199.40 $ 653.40 $ 2,667.10 $ 1,230.80 836.60 9,565.50 $ $ 2,230.80 $ 144.60 $ 282.30 $ 3,122.10 $ 964.50 $ 2,425.00 $ 378.10 $ 553.60 $ 4.000.30 $ $ S 11,871.80 $ 790.80 2,492.40 450.00 335.30 3,730.20 1,653.40 810.10 14,013.60 S S $ S $ $ 1.228.00 2,508.30 165.40 150.50 4,115.70 3,509.70 850.30 14,542.40 $ 10,060.90 5 5 Income Statements Balance Sheets Cash Flows # Ready 111119 X o Canadian Tire Financial Book - Excel Ibrahim Diriye X File Home Insert Page Layout Formulas Data Review View Help Tell me what you want to do Share Calibri - 11 - = ab Custom Conditional Formatting Insert B 1 U. A A E $ % . Fomet as Table Delete Posts A e 11 .00 10 .0 Cell Styles Format Clipboard font Alignment Number Styles Cells Criting 13 vXfx A B C D E F G H H 1 1 2020 (Projected) 2015 2016 2017 2018 2019 2021 1,403.20 $ $ 430.40 -5 972.80 $ 4.30 $ 632.60 $ 1,087.60 270.40 107.40 S S $ 2,442.80 925.10 183.70 $ -$ $ $ S -$ -S S $ S -S -$ $ 1,004.10 $ 25.20 $ 978.90 $ 210.10 $ 610.60 $ 101.50 $ 299.00 $ 213.50 $ 206.00 $ 434.60 $ 12.50 1,292.50 $ 306.10 $ 986.40 $ 34.80 5 780.80 $ 32.80 782.80 $ 402.90 $ 233.90 449.40 $ $ 435.20 20.20 758.70 -5 $ -5 307.20 13.30 848.00 639.90 $ 10.80 S 1,298.90 $ 491.50 $ 807.40 $ 39.50 546.30 $ $ 1,308.60 $ 1,069.70 $ 582.40 $ 80.60 $ 62.30 S 534.60 $ 33.40 $ -$ -$ $ 2 Annual 3 4 Income Statement 5 Operating Activities (before undernoted) G Change in Loans Receivable 7 Operating Activities 8 Change in investments 9 Additions (PPE) 10 Disposition Profits (PPE) 11 Investing Activities 12 Change in Loan Debt 13 Dividends paid and distributions 14 Repurchase of share capital 15 Change in deposits 16 Proceeds on sale of ownership interests 17 Cash generated from financing 18 Cash generated in the period 19 20 21 22 23 24 25 26 27 28 29 30 96.20 462.70 1,061.00 659.30 -s 201.50 $ $ 719.70 $ 386.80 $ 84.10 604.20 30.80 142.60 604.20 275.30 $ $ 427.10 $ 252.80 $ 280.40 $ 76.80 $ S $ 462.70 1.132.10 Income Statements Balance Sheets Cash Flows + Ready 111119
