How to create a deconsolidation report recognizing the 401k?

Note 12. Retirement-Related Benefits The Company offers a 401(k) plan for associates in the U.S. under which eligible associates can begin contributing to the plan immediately upon hire. The Company also offers a 401(k) type plan for associates in Puerto Rico under which associates can begin to contribute generally after one year of employment. Under these plans, after one year of employment, the Company matches 100% of participant contributions up to 6% of annual eligible earnings. The matching contributions immediately vest at 100% for each associate. Participants can contribute up to 50% of their pretax earnings, but not more than the statutory limits. Associates in international countries who are not U.S. citizens are covered by various defined contribution post-employment benefit arrangements. These plans are administered based upon the legislative and tax requirements in the countries in which they are established. The following table summarizes the contribution expense related to the Company's defined contribution plans for fiscal 2018, 2017 and 2016: Fiscal Years Ended January 31, 2018 2017 2016 (Amounts in millions) Defined contribution plans: U.S. International Total contribution expense for defined contribution plans S S 1,124 $ 126 1.250 1,064 173 1,237 967 179 1.146 Additionally, the Company's subsidiaries in the United Kingdom and Japan have sponsored defined benefit pension plans. The plan in the United Kingdom was overfunded by $97 million at January 31, 2018 and underfunded by $129 million at January 31, 2017. The plan in Japan was underfunded by $184 million and $203 million at January 31, 2018 and 2017, respectively. Overfunded amounts are recorded as assets in the Company's Consolidated Balance Sheets in other assets and deferred charges. Underfunded amounts are recorded as liabilities in the Company's Consolidated Balance Sheets in deferred income taxes and other. Certain other international operations also have defined benefit arrangements that are not significant. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME 2017 2016 2015 Year Ended December 31, (In millions except per share data) NET OPERATING REVENUES Cost of goods sold GROSS PROFIT Selling, general and administrative expenses Other operating charges OPERATING INCOME Interest income Interest expense Equity income (loss) - net Other income (loss)-net INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Income taxes from continuing operations NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operations (net of income taxes of $47, $0 and $0, respectively) CONSOLIDATED NET INCOME Less: Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY $ 44,294 17,482 26,812 16,427 1,657 8,728 613 856 $ 35,410 13,256 22,154 12,496 2,157 7,501 677 841 1,071 (1,666) 6,742 5,560 1,182 101 1,283 35 $ 41,863 16,465 25,398 15,262 1,510 8,626 642 733 835 (1,234) 8,136 1,586 6,550 489 631 9,605 2.239 7,366 6,550 23 7,366 15 $ 1,248 $ 6,527 $ 7,351 Basic net income per share from continuing operations! $ 0.28 $ 1.51 $ 1.69 Basic net income per share from discontinued operations 0.02 BASIC NET INCOME PER SHARE $ 0.29 $ 1.51 $ 1.69 Diluted net income per share from continuing operations! $ 0.27 $ 1.49 $ 1.67 Diluted net income per share from discontinued operations 0.02 DILUTED NET INCOME PER SHARE $ 0.29 S 1.49 $ 1.67 AVERAGE SHARES OUTSTANDING - BASIC 4,272 4,317 4,352 Effect of dilutive securities 52 50 53 AVERAGE SHARES OUTSTANDING - DILUTED 4,324 4,367 4,405 Calculated based on net income from continuing operations less net income from continuing operations attributable to noncontrolling interests. 2 Calculated based on net income from discontinued operations less net income from discontinued operations attributable to noncontrolling interests. Per share amounts do not add due to rounding. Refer to Notes to Consolidated Financial Statements. 72 Note 12. Retirement-Related Benefits The Company offers a 401(k) plan for associates in the U.S. under which eligible associates can begin contributing to the plan immediately upon hire. The Company also offers a 401(k) type plan for associates in Puerto Rico under which associates can begin to contribute generally after one year of employment. Under these plans, after one year of employment, the Company matches 100% of participant contributions up to 6% of annual eligible earnings. The matching contributions immediately vest at 100% for each associate. Participants can contribute up to 50% of their pretax earnings, but not more than the statutory limits. Associates in international countries who are not U.S. citizens are covered by various defined contribution post-employment benefit arrangements. These plans are administered based upon the legislative and tax requirements in the countries in which they are established. The following table summarizes the contribution expense related to the Company's defined contribution plans for fiscal 2018, 2017 and 2016: Fiscal Years Ended January 31, 2018 2017 2016 (Amounts in millions) Defined contribution plans: U.S. International Total contribution expense for defined contribution plans S S 1,124 $ 126 1.250 1,064 173 1,237 967 179 1.146 Additionally, the Company's subsidiaries in the United Kingdom and Japan have sponsored defined benefit pension plans. The plan in the United Kingdom was overfunded by $97 million at January 31, 2018 and underfunded by $129 million at January 31, 2017. The plan in Japan was underfunded by $184 million and $203 million at January 31, 2018 and 2017, respectively. Overfunded amounts are recorded as assets in the Company's Consolidated Balance Sheets in other assets and deferred charges. Underfunded amounts are recorded as liabilities in the Company's Consolidated Balance Sheets in deferred income taxes and other. Certain other international operations also have defined benefit arrangements that are not significant. THE COCA-COLA COMPANY AND SUBSIDIARIES CONSOLIDATED STATEMENTS OF INCOME 2017 2016 2015 Year Ended December 31, (In millions except per share data) NET OPERATING REVENUES Cost of goods sold GROSS PROFIT Selling, general and administrative expenses Other operating charges OPERATING INCOME Interest income Interest expense Equity income (loss) - net Other income (loss)-net INCOME FROM CONTINUING OPERATIONS BEFORE INCOME TAXES Income taxes from continuing operations NET INCOME FROM CONTINUING OPERATIONS Income from discontinued operations (net of income taxes of $47, $0 and $0, respectively) CONSOLIDATED NET INCOME Less: Net income attributable to noncontrolling interests NET INCOME ATTRIBUTABLE TO SHAREOWNERS OF THE COCA-COLA COMPANY $ 44,294 17,482 26,812 16,427 1,657 8,728 613 856 $ 35,410 13,256 22,154 12,496 2,157 7,501 677 841 1,071 (1,666) 6,742 5,560 1,182 101 1,283 35 $ 41,863 16,465 25,398 15,262 1,510 8,626 642 733 835 (1,234) 8,136 1,586 6,550 489 631 9,605 2.239 7,366 6,550 23 7,366 15 $ 1,248 $ 6,527 $ 7,351 Basic net income per share from continuing operations! $ 0.28 $ 1.51 $ 1.69 Basic net income per share from discontinued operations 0.02 BASIC NET INCOME PER SHARE $ 0.29 $ 1.51 $ 1.69 Diluted net income per share from continuing operations! $ 0.27 $ 1.49 $ 1.67 Diluted net income per share from discontinued operations 0.02 DILUTED NET INCOME PER SHARE $ 0.29 S 1.49 $ 1.67 AVERAGE SHARES OUTSTANDING - BASIC 4,272 4,317 4,352 Effect of dilutive securities 52 50 53 AVERAGE SHARES OUTSTANDING - DILUTED 4,324 4,367 4,405 Calculated based on net income from continuing operations less net income from continuing operations attributable to noncontrolling interests. 2 Calculated based on net income from discontinued operations less net income from discontinued operations attributable to noncontrolling interests. Per share amounts do not add due to rounding. Refer to Notes to Consolidated Financial Statements. 72