Question

1 Approved Answer

Posted on Sep 28, 2024

B C D f F G H 2020-09 2019-09 2018-09 2017-09 2016-09 2015-09 2014-09 705 1,018 619 291 1,190 582 1,411 1,125 1,136 559 1,526

B C D f F G H 2020-09 2019-09 2018-09 2017-09 2016-09 2015-09 2014-09 705 1,018 619 291 1,190 582 1,411 1,125 1,136 559 1,526 903 1,079 527 1,249 1,179 576 1.427 722 1.041 536 151 584 1,191 628 1,216 588 164 147 3,934 121 148 2.686 213 2,986 149 2.831 191 4,422 150 4.185 4,048 A 1 ROCKWELL AUTOMATION INC (ROK) BALANCE SHEET 2 Fiscal year ends in September. USD in millions. 3 4 Assets 5. Current assets 6 Cash and cash equivalents 7 Short term investments & Receivables 9 Inventories 10 Deferred income taxes 11 Other current assets 12 Total current assets 13 Non-current assets 14 Property, plant and equipment 15 Accumulated Depreciation 16 Equity and other investments 17 Goodwill 18 state assets 19 Deferred income taxes 20 Other long term avets 21 Total non-current assets 22 Total assets 28 24 Liabilities 25. Current abilities 26 short-term det 27 Accounts payable 28 Taxes Doyle 29 Accrued alities Instructionandal samt 2,249 01.675 1,292 3,650 2,095 (1512) 1,982 11.4041 1.904 1,2991 1.888 (1.256) 2,138 11.566) 794 1,071 104 2.138 11.561 2,287 1070 215 180 06 3,431 1014 255 1077 238 144 108 1,039 2.10 144 416 161 4,579 7,265 364 112 3,127 5,113 1053 26 200 100 2.296 0.230 2,740 12 2.936 7,101 6.405 25 303 551 930 115 12 600 81 75 17 720 225 70 128 107 694 35 139 21 D 6.262 E 7,162 F 7,101 G 6,405 H 6,230 7,265 6,113 325 705 25 688 139 21 301 694 107 25 551 920 115 12 250 388 2,236 600 812 75 17 241 401 2.146 449 720 72 17 214 505 1.977 694 86 17 201 78 16 196 372 264 257 330 674 1,811 553 1,937 1,692 1,975 A Total assets 3 Liabilities 5 Current liabilities 6 Short-term debt 7 Accounts payable 28 Taxes payable 39 Accrued liabilities 30 Deferred revenues 31 Other current liabilities 32 Total current liabilities 33 Non-current liabilities 34 Long term debit 15 Pensions and other benefits 36 Other long term ibilis 37 Total non-current liabilities 38 Total abilities 39 40 Stockholders' equity 41 Comeson stock 42 Additional paid in capital 43 Retained earnings 44 Treasury stock 45 Accumulated other comprehensive income 46 Total stockholders' equity 47 48 Total liabilities and stockholders equity 49 50 Financial Stimta 1.284 84 4.107 5.018 3,956 1,232 584 5,772 5,709 1,225 605 577 2.407 4,643 1,243 892 210 2.351 4,497 1,516 1.430 189 3,135 5,112 1,500 3,112 303 2,821 4,149 906 768 200 1,300 3,572 111 1,831 7459 16,510) (1614) 1,347 181 1,700 400 (6.41 11,488) 404 181 1,681 60300 303 19421 1.619 181 161 6104 14.00) 11.17 2.665 1111 1.5 5,658 02.909) IN 1.552 50117 (3,450) 181 1,512 4,540 12,927 1940 2.658 1.989 2,256 7.265 6.113 6,262 7,162 7,102 6.405 6,250 G 2020-09 2019-09 2013-09 2017-09 2016-09 2015-09 6,311 3,687 2,624 1,592 52 53 ROCKWELL AUTOMATION INC (ROK) INCOME STATEMENT 54 Fiscal year ends in September. USD in millions except per share data. 55 56 Revenue (Sales) 57 Cost of revenue (Cost of goods sold) 58 Gross profit 59 Sales, general and administrative 60 Operating income 61 Interest Expense 62 Other income (expense) 63 Income before taxes 64 Provision for income taxes 65 Net Income GG 67 Price per share 68 Earnings per share 69 70 EBITDA 70 72 73 6,330 3,735 2,595 1,326 1,269 103 (30) 1,136 113 1,023 6,695 3,795 2,900 1.907 993 98 6 901 205 696 6,666 3,794 2,872 1,599 1,273 73 131 1,331 795 536 6,308 3,605 2,703 1.506 1.197 5,880 3,404 2,476 1,467 1.009 71 6 944 213 1,032 76 82 1,037 212 825 (6) 1,127 300 827 220.08 8.77 164.80 583 18752 178.21 6.15 12214 5.56 101.42 6.09 1.442 1,145 1.56 1,282 1,18 1,354 D 15. Answers should be denoted below this row 15 Men Yew that data related to the year end of 2020 is in the column, 2019 in the Comet 2020-09 2011-09 2018-09 2017-09 2016-09 2015-09 2014-09 Name: Anwer way 19 Rockwell Automation (ROK) 00 3 Net Working Capital fornateren decimal format per decimales for recent decimus Structure detit Da Capital Status 115 ning forma decimal forma decimal places Porumber, 2 derim Tuesd 11 12 wtory To 91 Owlswory 10 Recew Talsu 101 10 ROM De M format, 2 decimal places tomaterdecimates 91 22 nentory lane maumer, decal places formatur, decimal plaats Darlina 5 clut lune 47 formicente delle forma decimal places 100 TTT 101 10. not 10V 104 cm 10 106 forma decinace format der er 10 Subtotal use the information to fill in the blanks B C D f F G H 2020-09 2019-09 2018-09 2017-09 2016-09 2015-09 2014-09 705 1,018 619 291 1,190 582 1,411 1,125 1,136 559 1,526 903 1,079 527 1,249 1,179 576 1.427 722 1.041 536 151 584 1,191 628 1,216 588 164 147 3,934 121 148 2.686 213 2,986 149 2.831 191 4,422 150 4.185 4,048 A 1 ROCKWELL AUTOMATION INC (ROK) BALANCE SHEET 2 Fiscal year ends in September. USD in millions. 3 4 Assets 5. Current assets 6 Cash and cash equivalents 7 Short term investments & Receivables 9 Inventories 10 Deferred income taxes 11 Other current assets 12 Total current assets 13 Non-current assets 14 Property, plant and equipment 15 Accumulated Depreciation 16 Equity and other investments 17 Goodwill 18 state assets 19 Deferred income taxes 20 Other long term avets 21 Total non-current assets 22 Total assets 28 24 Liabilities 25. Current abilities 26 short-term det 27 Accounts payable 28 Taxes Doyle 29 Accrued alities Instructionandal samt 2,249 01.675 1,292 3,650 2,095 (1512) 1,982 11.4041 1.904 1,2991 1.888 (1.256) 2,138 11.566) 794 1,071 104 2.138 11.561 2,287 1070 215 180 06 3,431 1014 255 1077 238 144 108 1,039 2.10 144 416 161 4,579 7,265 364 112 3,127 5,113 1053 26 200 100 2.296 0.230 2,740 12 2.936 7,101 6.405 25 303 551 930 115 12 600 81 75 17 720 225 70 128 107 694 35 139 21 D 6.262 E 7,162 F 7,101 G 6,405 H 6,230 7,265 6,113 325 705 25 688 139 21 301 694 107 25 551 920 115 12 250 388 2,236 600 812 75 17 241 401 2.146 449 720 72 17 214 505 1.977 694 86 17 201 78 16 196 372 264 257 330 674 1,811 553 1,937 1,692 1,975 A Total assets 3 Liabilities 5 Current liabilities 6 Short-term debt 7 Accounts payable 28 Taxes payable 39 Accrued liabilities 30 Deferred revenues 31 Other current liabilities 32 Total current liabilities 33 Non-current liabilities 34 Long term debit 15 Pensions and other benefits 36 Other long term ibilis 37 Total non-current liabilities 38 Total abilities 39 40 Stockholders' equity 41 Comeson stock 42 Additional paid in capital 43 Retained earnings 44 Treasury stock 45 Accumulated other comprehensive income 46 Total stockholders' equity 47 48 Total liabilities and stockholders equity 49 50 Financial Stimta 1.284 84 4.107 5.018 3,956 1,232 584 5,772 5,709 1,225 605 577 2.407 4,643 1,243 892 210 2.351 4,497 1,516 1.430 189 3,135 5,112 1,500 3,112 303 2,821 4,149 906 768 200 1,300 3,572 111 1,831 7459 16,510) (1614) 1,347 181 1,700 400 (6.41 11,488) 404 181 1,681 60300 303 19421 1.619 181 161 6104 14.00) 11.17 2.665 1111 1.5 5,658 02.909) IN 1.552 50117 (3,450) 181 1,512 4,540 12,927 1940 2.658 1.989 2,256 7.265 6.113 6,262 7,162 7,102 6.405 6,250 G 2020-09 2019-09 2013-09 2017-09 2016-09 2015-09 6,311 3,687 2,624 1,592 52 53 ROCKWELL AUTOMATION INC (ROK) INCOME STATEMENT 54 Fiscal year ends in September. USD in millions except per share data. 55 56 Revenue (Sales) 57 Cost of revenue (Cost of goods sold) 58 Gross profit 59 Sales, general and administrative 60 Operating income 61 Interest Expense 62 Other income (expense) 63 Income before taxes 64 Provision for income taxes 65 Net Income GG 67 Price per share 68 Earnings per share 69 70 EBITDA 70 72 73 6,330 3,735 2,595 1,326 1,269 103 (30) 1,136 113 1,023 6,695 3,795 2,900 1.907 993 98 6 901 205 696 6,666 3,794 2,872 1,599 1,273 73 131 1,331 795 536 6,308 3,605 2,703 1.506 1.197 5,880 3,404 2,476 1,467 1.009 71 6 944 213 1,032 76 82 1,037 212 825 (6) 1,127 300 827 220.08 8.77 164.80 583 18752 178.21 6.15 12214 5.56 101.42 6.09 1.442 1,145 1.56 1,282 1,18 1,354 D 15. Answers should be denoted below this row 15 Men Yew that data related to the year end of 2020 is in the column, 2019 in the Comet 2020-09 2011-09 2018-09 2017-09 2016-09 2015-09 2014-09 Name: Anwer way 19 Rockwell Automation (ROK) 00 3 Net Working Capital fornateren decimal format per decimales for recent decimus Structure detit Da Capital Status 115 ning forma decimal forma decimal places Porumber, 2 derim Tuesd 11 12 wtory To 91 Owlswory 10 Recew Talsu 101 10 ROM De M format, 2 decimal places tomaterdecimates 91 22 nentory lane maumer, decal places formatur, decimal plaats Darlina 5 clut lune 47 formicente delle forma decimal places 100 TTT 101 10. not 10V 104 cm 10 106 forma decinace format der er 10 Subtotal use the information to fill in the blanks