Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is the balance sheet and vertical analysis of Rogers company from 2015 to 2019. you have to write the written analysis of this calculative

this is the balance sheet and vertical analysis of Rogers company from 2015 to 2019. you have to write the written analysis of this calculative analysis

image text in transcribedimage text in transcribed

G H I K L M N O S Q R Vertical Analysis 2016 2017 2018 2019 2015 2019 494 2304 460 1234 0.04% 6.14% 1.09% 0.00% 6.88% 1.11% 0.00% 6.67% 1.43% 1.27% 7.08% 1.46% 1.33% 6.22% 1.24% 524 101 B D E F 1 Consolidated Statements of Financial Position (In millions of Canadian dollars) 2 As at December 31 2015 2016 2017 2018 3 Assets 4 Current assets: 5 Cash and cash equivalents 11 0 0 405 6 Accounts receivable 1792 1949 2035 2259 7 Inventories 318 315 435 466 8 Current portion of contract assets 303 0 820 1052 9 Other current assets 0 215 414 436 10 Current portion of derivative instruments 198 91 421 270 11 Total current assets 2622 2570 4125 4888 12 13 Property, plant and equipment 10997 10749 11143 11780 14 Intangible assets 7243 7130 7244 7205 15 Investments 2271 2174 2561 2134 16 Derivative instruments 1992 1708 953 1339 17 Contract assets 0 0 413 535 18 Other long-term assets 150 98 143 132 19 Deferred tax assets 9 8 3 0 20 Goodwill 3905 3905 3905 3905 21 22 Total assets 29189 28342 30490 31918 0.68% 8.98% 0.32% 9.07% 1.38% 13.53% 0.85% 15.31% 0.27% 13.82% 5117 13934 8905 2830 37.68% 24.81% 7.78% 6.82% 37.93% 25.16% 7.67% 36.55% 23.76% 8.40% 3.13% 36.91% 22.57% 6.69% 4.20% 37.64% 24.06% 7.64% 3.99% 1478 6.03% 557 275 0 0.51% 0.03% 13.38% 0.35% 0.03% 13.78% 0.47% 0.01% 12.81% 0.41% 0.00% 12.23% 0.74% 0.00% 10.60% 3923 37019 100.00% 100.00% 100.00% 100.00% 100.00% 22 6 0 0 71 800 2783 1585 2931 62 2238 3033 2.74% 9.28% 0.33% 2255 3052 177 132 233 2.82% 9.82% 0.66% 5.20% 9.61% 0.20% 7.06% 9.56% 0.55% 6.05% 8.19% 0.13% 186 0 800 2708 96 0 0 0 10 388 48 132 141 224 278 0 0 0 0 134 367 750 0 0 1756 0 900 0 0 0 0.03% 1.33% 3.43% 0.47% 1.29% 2.65% 0.00% 0.00% 5.76% 0.00% 0.00% 2.82% 0.00% 0.00% 0.00% 1000 0 0 230 0 15 5017 22 133 23 24 Liabilities and shareholders' equity 25 Current liabilities: 26 Bank advances 27 Short-term borrowings 28 Accounts payable and accrued liabilities 29 Income tax payable 30 Other current liabilities 31 Contract liabilities 32 Current portion of provisions 33 Unearned revenue 34 Current portion of long-term debt 35 Current portion of lease liabilities 36 Current portion of derivative instruments 37 Total current liabilities 38 39 Provisions 40 Long-term debt 41 Derivative instruments 42 Lease liabilities 43 Other long-term liabilities 44 Deferred tax liabilities 45 Total liabilities 46 47 Shareholders' equity 48 49 Total liabilities and shareholders' equity 50 50 87 6836 0.05% 17.19% 0.08% 18.04% 0.44% 22.57% 0.27% 21.42% 0.14% 16.11% 5113 6883 5964 50 33 35 35 36 15330 12692 147 13390 22 15967 90 0.17% 54.37% 0.33% 0.12% 54.09% 0.42% 0.11% 41.63% 0.48% 0.11% 41.95% 0.07% 0.10% 43.13% 0.24% 118 15870 95 0 455 0 1495 0 562 0 613 546 614 1917 2624 3437 2066 23553 2910 23739 1.56% 7.08% 80.69% 1.98% 6.76% 81.41% 2.01% 8.61% 75.41% 1.71% 9.12% 74.37% 1.66% 9.28% 74.56% 23073 22994 27603 5636 5269 7496 8179 9416 19.31% 18.59% 24.59% 25.63% 25.44% 29189 28342 30490 31918 37019 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% G H I K L M N O S Q R Vertical Analysis 2016 2017 2018 2019 2015 2019 494 2304 460 1234 0.04% 6.14% 1.09% 0.00% 6.88% 1.11% 0.00% 6.67% 1.43% 1.27% 7.08% 1.46% 1.33% 6.22% 1.24% 524 101 B D E F 1 Consolidated Statements of Financial Position (In millions of Canadian dollars) 2 As at December 31 2015 2016 2017 2018 3 Assets 4 Current assets: 5 Cash and cash equivalents 11 0 0 405 6 Accounts receivable 1792 1949 2035 2259 7 Inventories 318 315 435 466 8 Current portion of contract assets 303 0 820 1052 9 Other current assets 0 215 414 436 10 Current portion of derivative instruments 198 91 421 270 11 Total current assets 2622 2570 4125 4888 12 13 Property, plant and equipment 10997 10749 11143 11780 14 Intangible assets 7243 7130 7244 7205 15 Investments 2271 2174 2561 2134 16 Derivative instruments 1992 1708 953 1339 17 Contract assets 0 0 413 535 18 Other long-term assets 150 98 143 132 19 Deferred tax assets 9 8 3 0 20 Goodwill 3905 3905 3905 3905 21 22 Total assets 29189 28342 30490 31918 0.68% 8.98% 0.32% 9.07% 1.38% 13.53% 0.85% 15.31% 0.27% 13.82% 5117 13934 8905 2830 37.68% 24.81% 7.78% 6.82% 37.93% 25.16% 7.67% 36.55% 23.76% 8.40% 3.13% 36.91% 22.57% 6.69% 4.20% 37.64% 24.06% 7.64% 3.99% 1478 6.03% 557 275 0 0.51% 0.03% 13.38% 0.35% 0.03% 13.78% 0.47% 0.01% 12.81% 0.41% 0.00% 12.23% 0.74% 0.00% 10.60% 3923 37019 100.00% 100.00% 100.00% 100.00% 100.00% 22 6 0 0 71 800 2783 1585 2931 62 2238 3033 2.74% 9.28% 0.33% 2255 3052 177 132 233 2.82% 9.82% 0.66% 5.20% 9.61% 0.20% 7.06% 9.56% 0.55% 6.05% 8.19% 0.13% 186 0 800 2708 96 0 0 0 10 388 48 132 141 224 278 0 0 0 0 134 367 750 0 0 1756 0 900 0 0 0 0.03% 1.33% 3.43% 0.47% 1.29% 2.65% 0.00% 0.00% 5.76% 0.00% 0.00% 2.82% 0.00% 0.00% 0.00% 1000 0 0 230 0 15 5017 22 133 23 24 Liabilities and shareholders' equity 25 Current liabilities: 26 Bank advances 27 Short-term borrowings 28 Accounts payable and accrued liabilities 29 Income tax payable 30 Other current liabilities 31 Contract liabilities 32 Current portion of provisions 33 Unearned revenue 34 Current portion of long-term debt 35 Current portion of lease liabilities 36 Current portion of derivative instruments 37 Total current liabilities 38 39 Provisions 40 Long-term debt 41 Derivative instruments 42 Lease liabilities 43 Other long-term liabilities 44 Deferred tax liabilities 45 Total liabilities 46 47 Shareholders' equity 48 49 Total liabilities and shareholders' equity 50 50 87 6836 0.05% 17.19% 0.08% 18.04% 0.44% 22.57% 0.27% 21.42% 0.14% 16.11% 5113 6883 5964 50 33 35 35 36 15330 12692 147 13390 22 15967 90 0.17% 54.37% 0.33% 0.12% 54.09% 0.42% 0.11% 41.63% 0.48% 0.11% 41.95% 0.07% 0.10% 43.13% 0.24% 118 15870 95 0 455 0 1495 0 562 0 613 546 614 1917 2624 3437 2066 23553 2910 23739 1.56% 7.08% 80.69% 1.98% 6.76% 81.41% 2.01% 8.61% 75.41% 1.71% 9.12% 74.37% 1.66% 9.28% 74.56% 23073 22994 27603 5636 5269 7496 8179 9416 19.31% 18.59% 24.59% 25.63% 25.44% 29189 28342 30490 31918 37019 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%

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_2

Step: 3

blur-text-image_3

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

Introductory Econometrics For Finance

Authors: Chris Brooks

3rd Edition

1107661455, 9781107661455

More Books

Students also viewed these Finance questions

Question

What do you mean by dual mode operation?

Answered: 1 week ago

Question

Explain the difference between `==` and `===` in JavaScript.

Answered: 1 week ago