Please answer the following question. Data has been provided below.

Data:

Using the previously forecasted items, calculate for each of the next four years the net operating profit after taxes (NOPAT), net operating working capital, total operating capital, free cash flow, (FCF), annual growth rate in FCF, and return on invested capital. What does the forecasted free cash flow in the first year imply about the need for external financing? Compare the forecasted RoIC compare with the WACC. What does this imply about how well the company is performing? Definitions: NOPAT = EBIT (1-T) NOWC = (Cash + accounts receivable + inventories) (Accounts payable & accruals) Total operating capital =NOWC+Net fixed assets FCF=NOPAT Change in total operating capital ROIC = NOPAT / Total operating capital The following data shows Hatfield's latest financial statements plus some ratios and other data for the Corporate valuation and nancial planning analysis. Use the following assumptions: (1) Operating ratios remain unchanged. (2) Sales will grow by 10%,8%,5%, and 5% for the next four years. (3) The target weighted average cost of capital (WACC) is 9%. This is the No Change scenario because operations remain unchanged. inputs for the forecast are shown below. You can change inputs in blue. You can show the original scenario by going to Data, WhatIf Analysis, Scenario Manager, and select the scenario named No Change. Inputs for the forecast are shown below. You can change inputs in blue. You can show the original scenario by going to Data, WhatIf Analvsis, Scenario Manager, and select the scenario named No Chanqe. or each of the next four years, forecast the following items: sales, cash, accounts receivable, inventories, net fixed assets, accounts jayable & accruals, operating costs (excluding depreciation), depreciation, and earnings before interest and taxes (EBIT). Using the previously forecasted items, calculate for each of the next four years the net operating profit after taxes (NOPAT), net operating working capital, total operating capital, free cash flow, (FCF), annual growth rate in FCF, and return on invested capital. What does the forecasted free cash flow in the first year imply about the need for external financing? Compare the forecasted RoIC compare with the WACC. What does this imply about how well the company is performing? Definitions: NOPAT = EBIT (1-T) NOWC = (Cash + accounts receivable + inventories) (Accounts payable & accruals) Total operating capital =NOWC+Net fixed assets FCF=NOPAT Change in total operating capital ROIC = NOPAT / Total operating capital The following data shows Hatfield's latest financial statements plus some ratios and other data for the Corporate valuation and nancial planning analysis. Use the following assumptions: (1) Operating ratios remain unchanged. (2) Sales will grow by 10%,8%,5%, and 5% for the next four years. (3) The target weighted average cost of capital (WACC) is 9%. This is the No Change scenario because operations remain unchanged. inputs for the forecast are shown below. You can change inputs in blue. You can show the original scenario by going to Data, WhatIf Analysis, Scenario Manager, and select the scenario named No Change. Inputs for the forecast are shown below. You can change inputs in blue. You can show the original scenario by going to Data, WhatIf Analvsis, Scenario Manager, and select the scenario named No Chanqe. or each of the next four years, forecast the following items: sales, cash, accounts receivable, inventories, net fixed assets, accounts jayable & accruals, operating costs (excluding depreciation), depreciation, and earnings before interest and taxes (EBIT)