Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This is the vertical analysis of rogers communication company in cash flow. now write a written analysis of this calculative analysis of cash flow? B

This is the vertical analysis of rogers communication company in cash flow. now write a written analysis of this calculative analysis of cash flow?

image text in transcribedimage text in transcribed

B D E E F G H 1 J K L M N 0 P Q R S Vertical 2017 2015 2016 2017 2018 2019 2015 2016 2018 2019 1342 835 1845 2059 2043 26.82% 16.72% 34.73% 33.56% 34.96% 2142 2277 87 774 477 55 -16 0 0 0 -74 2276 71 761 324 61 -3 11 140 484 2488 77 840 712 0 -75 0 0 0 0 45.50% 1.74% 15.47% 9.53% 1.10% -0.32% 45.57% 40.32% 1.42% 1.20% 15.249 14.04% 6.49% 12.90% 1.22% 0.00% -0.06% 0.08% 38.96% 1.16% 13.57% 12.46% 0.00% 0.07% 42.58% 1.32% 14.389 12.19% 0.00% -1.28% 0 0 -1.48% 0.00% 0.00% 0.00% 0.00% 0 Consolidated Statements of Cash Flows (In millions of Canadian dollars) As at December 31 Operating activities: Net income for the year Adjustments to reconcile net income to cash provided by operating activities: Depreciation and amortization Program rights amortization Finance costs Income tax expense Stock-based compensation Post-employment benefits contributions, net of expense Net loss on divestitures pertaining to investments Loss on wind down of shomi Impairment of assets and related onerous contract charges Gain on acquisition of Mobilicity Gain on disposition of property, plant and equipment Recovery on wind-down of shomi Net change in contract asset balances Net change in financing receivable balances Other Cash provided by operating activities before changes in non-cash working capital items, income taxes paid, and interest paid Change in non-cash operating working capital items Cash provided by operating activities before income taxes paid and interest paid Income taxes paid Interest paid Cash provided by operating activities Investing activities: Additions to property, plant and equipment Capital expenditures Additions to program rights Changes in non-cash working capital related to property, plant and equipment and intangible assets Acquisitions and other strategic transactions, net of cash acquired Other Cash used in investing activities Financing activities: Net proceeds received on short-term borrowings Net repayment of long-term debt Net proceeds (payments) on settlement of debt derivatives and forward contracts Income Balance Cash 0 0 0 0 82 5004 -302 4702 -184 -771 3747 64 746 685 0 4 o 0 0 0 -49 -20 -156 0 51 5312 -164 5148 -475 -735 3938 2211 58 793 758 0 -44 0 0 0 0 -16 0 -354 0 33 5498 -114 5384 -370 -726 4288 0 0 O 0 34 4994 14 5008 -295 -756 3957 0 0 -204 -84 46 5843 -138 5705 -400 -779 4526 1.64% 0.68% 0.96% 0.93% 0.79% 100.00% 100.00% 100.00% 96.62% 100.00% -6.04% 0.28% -3.09% -2.98% -2.36% 93.96% 100.28% 96.91% 93.63% 97.64% -3.68% -5.91% -8.94% -8.64% -6.85% -15.41% -15.14% -13.84% -13.37% -13.33% 74.88% 79.24% 74.13% 71.63% 77.46% -2352 0 0 -48.76% -47.10% 0.00% 0.00% 0.00% -2436 -59 -2440 0 -64 -116 -1077 -70 -3767 0 -46 -103 0 45 o -2790 -54 -125 0 25 -2944 -2807 -60 -35 109 -184 -60 -2630 -1731 21 -4612 -1.28% -0.92% -1.11% -1.07% -1.03% % -2.32% -2.06% 2.05% 1.98% -0.60% -21.52% 0.00% -3.46% -3.35% -29.63% -1.40% 0.90% -1.13% -1.09% 0.36% -75.28% -49.18% -49.51% -47.84% -78.93% -2456 Plot Area 508 0 0 0 0 0 0 858 -1034 -79 30 2184 -823 388 -121 N1 fx Vertical A B D G H 1 J K L M S -184 -771 3747 -295 -756 3957 -475 -735 3938 E -370 -726 4288 F -400 -779 4526 N O P Q R -3.68% -5.91% -8.94% -8.64% -6.85% -15.41% -15.14% -13.84% -13.37% -13.33% 74.88% 79.24% 74.13% 71.63% 77.46% -48.76% -47.10% 0.00% 0.00% 0.00% -2440 0 Plot Area -64 -2352 0 -46 -103 0 -2436 -59 109 0 -2790 -54 -125 0 -2807 -60 -35 -1731 21 0 -116 -1077 -70 -3767 0 45 -2456 -184 -60 -2630 -1.28% -0.92% -1.11% -1.07% -1.03% -2.32% -2.06% 2.05% 1.98% -0.60% -21.52% 0.00% -3.46% -3.35% -29.63% -1.40% 0.90% -1.13% -1.09% 0.36% -75.28% -49.18% -49.51% -47.84% -78.93% 25 -2944 -4612 0 858 508 -1034 -79 o 30 2184 -121 0 24] Income taxes paid 25 Interest paid 26 Cash provided by operating activities 27 Investing activities: 28 Additions to property, plant and equipment 29 Capital expenditures 30 Additions to program rights 31 Changes in non-cash working capital related to property, plant and equipment and intangible assets 32 Acquisitions and other strategic transactions, net of cash acquired 33 Other 34 Cash used in investing activities 35 Financing activities: 36 Net proceeds received on short-term borrowings 37 Net repayment of long-term debt 38 Net proceeds (payments) on settlement of debt derivatives and forward contracts 39 Net repayments on short-term borrowings 40 Net (repayment) issuance of long-term debt 41 Net (payment) proceeds on settlement of debt derivatives and forward contracts 42 Transaction costs incurred 43 Principal payments of lease liabilities Repurchase of Class B Non-Voting Shares 45 Dividends paid 46 Other 47 Cash used in financing activities 48 Change in cash and cash equivalents 49 Cash and cash equivalents, beginning of year 50 (Bank advances) cash and cash equivalents, end of year 51 52 53 54 Statements of Cash Flows 55 56 0 0 -42 754 129 -9 0 0 -0.84% 0.00% 15.07% -10.77% 2.58% -0.90% -0.18% -0.34% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -1.04% 0 0 0 0 0 0 0 -538 -45 -17 0 0 0 -988 5 -1583 -82 11 -71 0 0 44 -823 388 o 0 0 -18 0 0 -988 o -933 411 -6 -61 - 167 -655 -1016 -19 0 0 -977 0 -145 -165 176 11 -19.52% -19.78% -18.60% -17.97% -17.39% 0 -988 0 -1243 65 -71 -6 175 3.00% 89 -2.90% -31.70% -23.40% -22.61% -3.30% -1.64% 1.22% 1.18% 3.52% 0.22% -1.34% -1.29% 0.22% -1.42% -0.11% -0.11% 405 494 1.52% 6.93% 8.45% 405 8000 57 B D E E F G H 1 J K L M N 0 P Q R S Vertical 2017 2015 2016 2017 2018 2019 2015 2016 2018 2019 1342 835 1845 2059 2043 26.82% 16.72% 34.73% 33.56% 34.96% 2142 2277 87 774 477 55 -16 0 0 0 -74 2276 71 761 324 61 -3 11 140 484 2488 77 840 712 0 -75 0 0 0 0 45.50% 1.74% 15.47% 9.53% 1.10% -0.32% 45.57% 40.32% 1.42% 1.20% 15.249 14.04% 6.49% 12.90% 1.22% 0.00% -0.06% 0.08% 38.96% 1.16% 13.57% 12.46% 0.00% 0.07% 42.58% 1.32% 14.389 12.19% 0.00% -1.28% 0 0 -1.48% 0.00% 0.00% 0.00% 0.00% 0 Consolidated Statements of Cash Flows (In millions of Canadian dollars) As at December 31 Operating activities: Net income for the year Adjustments to reconcile net income to cash provided by operating activities: Depreciation and amortization Program rights amortization Finance costs Income tax expense Stock-based compensation Post-employment benefits contributions, net of expense Net loss on divestitures pertaining to investments Loss on wind down of shomi Impairment of assets and related onerous contract charges Gain on acquisition of Mobilicity Gain on disposition of property, plant and equipment Recovery on wind-down of shomi Net change in contract asset balances Net change in financing receivable balances Other Cash provided by operating activities before changes in non-cash working capital items, income taxes paid, and interest paid Change in non-cash operating working capital items Cash provided by operating activities before income taxes paid and interest paid Income taxes paid Interest paid Cash provided by operating activities Investing activities: Additions to property, plant and equipment Capital expenditures Additions to program rights Changes in non-cash working capital related to property, plant and equipment and intangible assets Acquisitions and other strategic transactions, net of cash acquired Other Cash used in investing activities Financing activities: Net proceeds received on short-term borrowings Net repayment of long-term debt Net proceeds (payments) on settlement of debt derivatives and forward contracts Income Balance Cash 0 0 0 0 82 5004 -302 4702 -184 -771 3747 64 746 685 0 4 o 0 0 0 -49 -20 -156 0 51 5312 -164 5148 -475 -735 3938 2211 58 793 758 0 -44 0 0 0 0 -16 0 -354 0 33 5498 -114 5384 -370 -726 4288 0 0 O 0 34 4994 14 5008 -295 -756 3957 0 0 -204 -84 46 5843 -138 5705 -400 -779 4526 1.64% 0.68% 0.96% 0.93% 0.79% 100.00% 100.00% 100.00% 96.62% 100.00% -6.04% 0.28% -3.09% -2.98% -2.36% 93.96% 100.28% 96.91% 93.63% 97.64% -3.68% -5.91% -8.94% -8.64% -6.85% -15.41% -15.14% -13.84% -13.37% -13.33% 74.88% 79.24% 74.13% 71.63% 77.46% -2352 0 0 -48.76% -47.10% 0.00% 0.00% 0.00% -2436 -59 -2440 0 -64 -116 -1077 -70 -3767 0 -46 -103 0 45 o -2790 -54 -125 0 25 -2944 -2807 -60 -35 109 -184 -60 -2630 -1731 21 -4612 -1.28% -0.92% -1.11% -1.07% -1.03% % -2.32% -2.06% 2.05% 1.98% -0.60% -21.52% 0.00% -3.46% -3.35% -29.63% -1.40% 0.90% -1.13% -1.09% 0.36% -75.28% -49.18% -49.51% -47.84% -78.93% -2456 Plot Area 508 0 0 0 0 0 0 858 -1034 -79 30 2184 -823 388 -121 N1 fx Vertical A B D G H 1 J K L M S -184 -771 3747 -295 -756 3957 -475 -735 3938 E -370 -726 4288 F -400 -779 4526 N O P Q R -3.68% -5.91% -8.94% -8.64% -6.85% -15.41% -15.14% -13.84% -13.37% -13.33% 74.88% 79.24% 74.13% 71.63% 77.46% -48.76% -47.10% 0.00% 0.00% 0.00% -2440 0 Plot Area -64 -2352 0 -46 -103 0 -2436 -59 109 0 -2790 -54 -125 0 -2807 -60 -35 -1731 21 0 -116 -1077 -70 -3767 0 45 -2456 -184 -60 -2630 -1.28% -0.92% -1.11% -1.07% -1.03% -2.32% -2.06% 2.05% 1.98% -0.60% -21.52% 0.00% -3.46% -3.35% -29.63% -1.40% 0.90% -1.13% -1.09% 0.36% -75.28% -49.18% -49.51% -47.84% -78.93% 25 -2944 -4612 0 858 508 -1034 -79 o 30 2184 -121 0 24] Income taxes paid 25 Interest paid 26 Cash provided by operating activities 27 Investing activities: 28 Additions to property, plant and equipment 29 Capital expenditures 30 Additions to program rights 31 Changes in non-cash working capital related to property, plant and equipment and intangible assets 32 Acquisitions and other strategic transactions, net of cash acquired 33 Other 34 Cash used in investing activities 35 Financing activities: 36 Net proceeds received on short-term borrowings 37 Net repayment of long-term debt 38 Net proceeds (payments) on settlement of debt derivatives and forward contracts 39 Net repayments on short-term borrowings 40 Net (repayment) issuance of long-term debt 41 Net (payment) proceeds on settlement of debt derivatives and forward contracts 42 Transaction costs incurred 43 Principal payments of lease liabilities Repurchase of Class B Non-Voting Shares 45 Dividends paid 46 Other 47 Cash used in financing activities 48 Change in cash and cash equivalents 49 Cash and cash equivalents, beginning of year 50 (Bank advances) cash and cash equivalents, end of year 51 52 53 54 Statements of Cash Flows 55 56 0 0 -42 754 129 -9 0 0 -0.84% 0.00% 15.07% -10.77% 2.58% -0.90% -0.18% -0.34% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% -1.04% 0 0 0 0 0 0 0 -538 -45 -17 0 0 0 -988 5 -1583 -82 11 -71 0 0 44 -823 388 o 0 0 -18 0 0 -988 o -933 411 -6 -61 - 167 -655 -1016 -19 0 0 -977 0 -145 -165 176 11 -19.52% -19.78% -18.60% -17.97% -17.39% 0 -988 0 -1243 65 -71 -6 175 3.00% 89 -2.90% -31.70% -23.40% -22.61% -3.30% -1.64% 1.22% 1.18% 3.52% 0.22% -1.34% -1.29% 0.22% -1.42% -0.11% -0.11% 405 494 1.52% 6.93% 8.45% 405 8000 57

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Markets And Institutions

Authors: Anthony Saunders, Marcia Cornett

7th Edition

1259919714, 978-1259919718

More Books

Students also viewed these Finance questions

Question

Define Scientific Management

Answered: 1 week ago

Question

Explain budgetary Control

Answered: 1 week ago

Question

Solve the integral:

Answered: 1 week ago

Question

What is meant by Non-programmed decision?

Answered: 1 week ago