Using the given information, please perform an EVA analysis along with calculating the enterprise value. Show work by using Microsoft excel by providing formulas please

The CEO of TPI Inc. considers the possibility to restructure one of the business segments of TPI. The analysts at TPI have prepared projections for the operations of the segment. These forecasts are provided in Table A. In addition to that, they have estimated that the cost of capital for this segment would be 14%, while its long-term growth rate would be 7%. Moreover, you know that the tax rate is 38% and the initial invested capital is $70 million. Your task is to perform EVA analysis of the segment (assume the current year is 2007). Calculate the enterprise value. You need to measure the PV of the EVA and PV of the Continuation EVA. Table A 2008 2009 2010 2011 2012 EBIT 24.8 28.0 32.0 34.0 37.0 Depreciation 5.8 7.6 9.2 10.2 11.0 Increase in Deferred tax 0.8 0.6 0.7 0.7 1.0 Capex 18.2 12.2 14.3 14.3 12.0 ANWC -0.8 -0.8 1.0 1.8 0.0 The current year is 2007 and the value of invested capital is given: $70 million. We can calculate NOPAT as EBIT*(1-t) + Increase in Deferred Tax. The capital charge in each period is calculated as the value of the invested capital (as of the end of the previous period) multiplied by the cost of capital