Answered step by step
Verified Expert Solution
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?
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 57Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started