Please show work ( how you add the numbers or by cell)

Using the financial statements shown below, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for the most recent year. Innovate Technologies: December 31 Income Statement (,000) 2016 2015 Sales $960,000 $900,000 Expenses excluding depreciation and am 812,700 774,000 EBITDA $147,300 $126,000 Depreciation and amortization 33,100 31,500 EBIT $114,200 $94,500 Interest Expense 10.470 8,600 EBT $103,730 $85,900 Taxes (27%) 28.007 23.193 Net income $75,723 $62,707 Innovate Technologies: December 31 Balance Sheets (.000) Assets 2016 2015 Cash and cash equivalents $48,000 $45,000 Short-term investments 10,737 3,600 Accounts Receivable 293,298 270,000 Inventories 145.000 135.000 Total current assets $497,035 $453,600 Net fixed assets 333.750 315.000 Total assets $830,785 $768,600 Liabilities and equity Accounts payable $95,000 $90,000 Accruals 48,000 45,000 Notes payable 26.262 9.000 Total current liabilities $169,262 $144,000 Long-term debt 94.500 90,000 Total liabilities $263,762 $234,000 Common stock 444,600 444,600 Retained Earnings 122.423 90,000 Total common equity $567,023 $534,600 Total liabilities and equity $830,785 $768,600 Common dividends Addition to retained earnings $43,300 $41,230 $32,423 $21,477 Key Input Data Tax rate: 27% Investment in total net operating capital Free cash flow Net operating working capital Operatin g current 2016 NOWC = assets 2016 NOWC = 2016 NOWC = Operating current liabilities - 2016 Tc 2015 TOC Net investment in operating capital 2016 Inv. In Tc - 2016 Inv. In TOC = 2016 Inv. In TOC = 2016 2016 2016 FCF = NOPAT FCF = FCF = Operatin g current 2015 NOWC = assets 2015 NOWC = 2015 NOWC = Operating current liabilities 1 Total net operating capital Return on invested capital 2016 ROIC = NOPAT 2016 ROIC = 2016 ROIC = X Net operating profit after taxes 2016 NOPAT = EBIT 2016 NOPAT = 2016 NOPAT = (1-T) + | Fixed assets Total net operating capital 2016 TOC = NUWC | 2016 TOC = 2016 TOC = 2015 TOC = NOWC 2015 TOC = $0 2015 TOC = $315,000 Fixed assets $315,000 Using the financial statements shown below, calculate net operating working capital, total net operating capital, net operating profit after taxes, free cash flow, and return on invested capital for the most recent year. Innovate Technologies: December 31 Income Statement (,000) 2016 2015 Sales $960,000 $900,000 Expenses excluding depreciation and am 812,700 774,000 EBITDA $147,300 $126,000 Depreciation and amortization 33,100 31,500 EBIT $114,200 $94,500 Interest Expense 10.470 8,600 EBT $103,730 $85,900 Taxes (27%) 28.007 23.193 Net income $75,723 $62,707 Innovate Technologies: December 31 Balance Sheets (.000) Assets 2016 2015 Cash and cash equivalents $48,000 $45,000 Short-term investments 10,737 3,600 Accounts Receivable 293,298 270,000 Inventories 145.000 135.000 Total current assets $497,035 $453,600 Net fixed assets 333.750 315.000 Total assets $830,785 $768,600 Liabilities and equity Accounts payable $95,000 $90,000 Accruals 48,000 45,000 Notes payable 26.262 9.000 Total current liabilities $169,262 $144,000 Long-term debt 94.500 90,000 Total liabilities $263,762 $234,000 Common stock 444,600 444,600 Retained Earnings 122.423 90,000 Total common equity $567,023 $534,600 Total liabilities and equity $830,785 $768,600 Common dividends Addition to retained earnings $43,300 $41,230 $32,423 $21,477 Key Input Data Tax rate: 27% Investment in total net operating capital Free cash flow Net operating working capital Operatin g current 2016 NOWC = assets 2016 NOWC = 2016 NOWC = Operating current liabilities - 2016 Tc 2015 TOC Net investment in operating capital 2016 Inv. In Tc - 2016 Inv. In TOC = 2016 Inv. In TOC = 2016 2016 2016 FCF = NOPAT FCF = FCF = Operatin g current 2015 NOWC = assets 2015 NOWC = 2015 NOWC = Operating current liabilities 1 Total net operating capital Return on invested capital 2016 ROIC = NOPAT 2016 ROIC = 2016 ROIC = X Net operating profit after taxes 2016 NOPAT = EBIT 2016 NOPAT = 2016 NOPAT = (1-T) + | Fixed assets Total net operating capital 2016 TOC = NUWC | 2016 TOC = 2016 TOC = 2015 TOC = NOWC 2015 TOC = $0 2015 TOC = $315,000 Fixed assets $315,000