Calculating EVA Brewster Company manufactures elderberry wine. Last year Brewster earned operatina income of $185,000 after income taxes The company is considered a fairly risky investment and probably commands a 12-point premium Capital employed equaled $2.9 milion. Brewster is 45 percent equity and 55 percent 10-year bonds paying 6 percent interest. Brewster's marginal tax rate is 40 percent above the 4 percent rate on long-term Treasury bonds. Donathan Brewster's aunts, Abby and Martha, have just retired, and brewater is the new cEO of Brewster Company. He wouldlike to impr the company. Compute EVA under each of the following independent scenarios that Brewster is considering. Required Use a spreadsheet to perform your calculations and round all internm and per answer as a negative amount. 1. No changes are made; calculate EVA using the original data 2 2. Sugar will be used to replace another natural ingredient (atomic number 33) in the elderberry wine. This should not affect costs but will begin to affect the market assessment of Brewster Company, bringing the premum above long-term Treasury bills to 10 percent the first year and 7 percent the second year Calculate revised EVA for both years EVA Year 1 Year 2 $ 1. No changes are made; calculate EVA using the onginal data. 2. Sugar will be used to replace another natural ingredient (atomic number 33) in the elderberry wine. This should not affect costs but will begin to affect the market assessment of Brewster Company, brinaino the premum above lono term treasury bills to 10 percent the first year and 7 percent the second year Calculate revised EVA for both years. EVA Year 1 $ Year 2$ 3. Brewster is considerng expanding but needs additional capital. The company could borrow money, but it is considering selling more common stock which would increase equity to 70 percent of total financing. Total capital emploved would be $3,600,000. The new after-tax operating income would be $395,000. Using the original data, calculate EVA. Then, recalculate EVA assuming the matenals substitution described in Requirement 2. New after-tax income will be $395,000, and in Year 1, the premium will be 10 percent above the long-term Treasury rate. In Year 2, it will be 7 percent above the long- term Treasury rate. (Hint: You will calculate three EVAs for this requirement.) EVA Year 1 Year 1 (10% premium) Year 2 (7% premium)