In these questions I need to recognize the financial statement of several different firms. I need work in excel spreadsheet to provide balance sheet and income statement In order to calculate NOPAT and Invested Capital

Reogantze the following financial statements in order to cakulate NOPAT and Invested Capital Below Reorganized in Statements Operating Tax Rate NUN Income Statement NET SALES Cost of Sales GROSS PROFIT 2017 2011 147,219 145.600 1108.647) 114,0791 3572 31.520 Calculation of NORAT 2107 2018 Selling Gerarland Administrative Depreciation and Amortization Total Operating te (15.145) 14.490) 020,3391 (17,7511 14.759) 02.510) OPERATING INCOME 18,233 SORO Operativas INOPAT Merest and investment income interest Intertohet are free 40 1.650 12.170 1606 40 12.1021 0.42 SER 14.900 11,083 0.04 4,546 Net Income 2017 2018 Cleation of invested Capital 2017 2013 Consolidated Balance Sheets-USD) $ in Millons Assets Banhand Chuivalent Operating Cash Account Recevable Merchandise vetores Total Current Arts 2.172 1.452 14,722 12 68 31,214 2,410 871 15.450 12,549 31,288 Operating Current Assets Net Property and count Goodwill Other Assets 138,254 225 1.18 173281 145,692 2,093 1,235 120 300 Operating Current abilities invested Capital | Short Term Debt Mount Payable Accrued Swies and Red Expenses Other Nerede for Current 13.250 13.586 1,268 5,779 34283 18.550 13,147 3,287 4,99 32,923 Lone Term Debt, in current iniments Otherine Trebite Deferred income Total abilities 50.476 19.023 232 104,019 51,486 18.055 256 103,259 STOCKHOLDERS IQUITY common Stock Retained famine tretry Stock Totalcar muity 25,826 7,630 (14,084) 69,362 79,617 3,125 (10.196 2,549 Totatie de identity 173,331 100 Reogante the following financial statements in order to cakulate NOPAT and Invested Capital Below Operating Tante INN Income Statement NET SALES Cartofler GROSSPORT 2012 2018 147,219 145,600 1108,647 314,079) 35,572 31,50 Reorgia Financial Statements calculation of NOPAY 3107 2018 Sie Genominative Depreciation and Alerte Total Operating per 15.8491 14.450) 20,339 (17.753) 14.7501 022.5101 Operating IT OPERATING INCOME 18,231 5.000 Oprah NOPAT terest and teement Income were pense Interest and other tamnings Before Taxes ARO 2.60 02.1701 16.063 480 0.102) 2.432) 6,58 14.00 11,083 02.043) 4,546 Netico 2017 2011 qua v quan 2017 2010 2,172 Consolidated USD SM AM Schwasheva Oering Aconteciale Merchandise Total Current A 2.410 871 15.454 12,50 11.3 14722 12 31,214 Operating Current Net Property went Go Os Total 1184 2,25 1,178 173.11 145.692 3.093 12 11010 Opring Currentes U India 13.250 12.06 16 Notable NOWww wapen Obenem Curre 1,50 11,147 127 4. 3,21 1483 Long Term Debit, cinema Other Lorem Defordeon Yol 50,436 19.02 212 104039 51486 IRON 296 107.159 STOCIOLOLDERS IQUITY Contact canadie Two Tot Story 75824 7.620 (1404) 69,23 73.617 3.125 (10154 22.14 Total dedit 12311 180.000 Reorganize the following financial statements in order to calculate NOPAT and invested Capital Below Reorganized Financial Statements Calculation of NOPAT loperating Tax Rate 2017 18SN 2018 Income Statement Revenues COGS Compensation and Benefits Delivery Cost Advertising Depreciation EBITA 2017 8,025 15,919) (482) 281) (142) (855) 128 2018 #507 16,295) (510) 0298) (162) 19571 (850) (924) Operating EBIT interest Expense interest income Nonoperating income EBT 165 (557) 165 (675) Operatine Cash awes NOPAT Income Taxes Net income ou 167 (390) 203 (473) Calculation of invested Capital 2017 2013 Consolidated Balance Sheets USD ($) in Millions Assets 2017 Operating Cash 161 Exces Cash 163 Accounts Recievable 401 Inventory 201 Current Assets 925 2018 172 63 482 191 912 Operating Current Assets 6,381 Net PP&E Equity Investments Total Assets 5,698 100 6,723 Operating Current Liabilities 100 7,393 Invested Capital usbilities and Equity Accounts Payable Short-term Debt Accrued Expenses Current Liabilities 281 590 132 1,003 323 679 139 1.140 Long term Debt Common Stock Resined ning Total abilities and Equity 4,722 998 5,135 1,118 6.723 2.193 Reogantze the following financial statements in order to cakulate NOPAT and Invested Capital Below Reorganized in Statements Operating Tax Rate NUN Income Statement NET SALES Cost of Sales GROSS PROFIT 2017 2011 147,219 145.600 1108.647) 114,0791 3572 31.520 Calculation of NORAT 2107 2018 Selling Gerarland Administrative Depreciation and Amortization Total Operating te (15.145) 14.490) 020,3391 (17,7511 14.759) 02.510) OPERATING INCOME 18,233 SORO Operativas INOPAT Merest and investment income interest Intertohet are free 40 1.650 12.170 1606 40 12.1021 0.42 SER 14.900 11,083 0.04 4,546 Net Income 2017 2018 Cleation of invested Capital 2017 2013 Consolidated Balance Sheets-USD) $ in Millons Assets Banhand Chuivalent Operating Cash Account Recevable Merchandise vetores Total Current Arts 2.172 1.452 14,722 12 68 31,214 2,410 871 15.450 12,549 31,288 Operating Current Assets Net Property and count Goodwill Other Assets 138,254 225 1.18 173281 145,692 2,093 1,235 120 300 Operating Current abilities invested Capital | Short Term Debt Mount Payable Accrued Swies and Red Expenses Other Nerede for Current 13.250 13.586 1,268 5,779 34283 18.550 13,147 3,287 4,99 32,923 Lone Term Debt, in current iniments Otherine Trebite Deferred income Total abilities 50.476 19.023 232 104,019 51,486 18.055 256 103,259 STOCKHOLDERS IQUITY common Stock Retained famine tretry Stock Totalcar muity 25,826 7,630 (14,084) 69,362 79,617 3,125 (10.196 2,549 Totatie de identity 173,331 100 Reogante the following financial statements in order to cakulate NOPAT and Invested Capital Below Operating Tante INN Income Statement NET SALES Cartofler GROSSPORT 2012 2018 147,219 145,600 1108,647 314,079) 35,572 31,50 Reorgia Financial Statements calculation of NOPAY 3107 2018 Sie Genominative Depreciation and Alerte Total Operating per 15.8491 14.450) 20,339 (17.753) 14.7501 022.5101 Operating IT OPERATING INCOME 18,231 5.000 Oprah NOPAT terest and teement Income were pense Interest and other tamnings Before Taxes ARO 2.60 02.1701 16.063 480 0.102) 2.432) 6,58 14.00 11,083 02.043) 4,546 Netico 2017 2011 qua v quan 2017 2010 2,172 Consolidated USD SM AM Schwasheva Oering Aconteciale Merchandise Total Current A 2.410 871 15.454 12,50 11.3 14722 12 31,214 Operating Current Net Property went Go Os Total 1184 2,25 1,178 173.11 145.692 3.093 12 11010 Opring Currentes U India 13.250 12.06 16 Notable NOWww wapen Obenem Curre 1,50 11,147 127 4. 3,21 1483 Long Term Debit, cinema Other Lorem Defordeon Yol 50,436 19.02 212 104039 51486 IRON 296 107.159 STOCIOLOLDERS IQUITY Contact canadie Two Tot Story 75824 7.620 (1404) 69,23 73.617 3.125 (10154 22.14 Total dedit 12311 180.000 Reorganize the following financial statements in order to calculate NOPAT and invested Capital Below Reorganized Financial Statements Calculation of NOPAT loperating Tax Rate 2017 18SN 2018 Income Statement Revenues COGS Compensation and Benefits Delivery Cost Advertising Depreciation EBITA 2017 8,025 15,919) (482) 281) (142) (855) 128 2018 #507 16,295) (510) 0298) (162) 19571 (850) (924) Operating EBIT interest Expense interest income Nonoperating income EBT 165 (557) 165 (675) Operatine Cash awes NOPAT Income Taxes Net income ou 167 (390) 203 (473) Calculation of invested Capital 2017 2013 Consolidated Balance Sheets USD ($) in Millions Assets 2017 Operating Cash 161 Exces Cash 163 Accounts Recievable 401 Inventory 201 Current Assets 925 2018 172 63 482 191 912 Operating Current Assets 6,381 Net PP&E Equity Investments Total Assets 5,698 100 6,723 Operating Current Liabilities 100 7,393 Invested Capital usbilities and Equity Accounts Payable Short-term Debt Accrued Expenses Current Liabilities 281 590 132 1,003 323 679 139 1.140 Long term Debt Common Stock Resined ning Total abilities and Equity 4,722 998 5,135 1,118 6.723 2.193