You are determining the value of Wister Mfg. Inc. at 12/31/2017. What is your determination of its equity value at 12/31/2017? Assume WACC = 13% Tax rate = 36% Revenue Forecast: 2018 and 2019 Revenue is expected to be $38million due to a two year non- recurring contract. 2020 Revenue is expected to be $33 million 2021 Revenue is expected to be $34 million Beyond 2021 Revenue is expected to grow at 3.0% per annum. I/S & B/S are provided for the past several years Provided Adjustment Grid removes non-recurring and non-operating items resulting in an estimate of normalized historical pre-tax earnings. Wister had a fire in 2009 that impacted production in 2009 & 2010. Insurance proceeds were received as shown on the adjustment grid. Revenue drop in 2012 was due to the loss of a product line. Prepare an EXCEL table calculating Equity Value.