Consider the following information about Stark Industries Shields Division. Stark Industries is considering adding a vibranium shield to the Iron Man Suits the company manufactures for the U.S. Armed Forces. The equipment to build the shields has a purchase price of $1.275,000, and the company will spend $75,000 to ship the equipment to its plant and install it on the production floor. Stark Industries engineers expect the machine to have a $25,000 salvage value at the end of its 10-year life and a practical capacity of 1.200 shields per year. The new equipment requires an average of $35.000 investment in working capital to keep the equipment running efficiently: the $35,000 investment in working capital is fully recoverable at the end of the investment. Stark Industries' current weighted average cost of capital is 17%. The estimate may vary by +/- 1.00% depending on market conditions. Stark Industries negotiations with its union regarding the staffing of the new shield-manufacturing machine resulted in the firm agreeing to hire new workers and pay them $200.000 annually. The union agreement also stipulated that the employees have the option to request a salary revision after the fifth your of the agreement of up to 6% of the agreed salary. Stark's human resources department ostimates that the renegotiation with the union will result in a 2%. 3%. 4% or 5% labor cost increase with a probability of 15%, 40%, 35% and 10%, respectively. The company also agreed to invest $50,000 to train the new employees on the equipment when hired. Training the new employees will be on the job, which will likely reduce the output for the first year of the project by 100 shields: in the worst-case scenario, the decrease in output would be 20%. The current contract negotiated with the U.S. Armed Forces guarantees a price of $1.100 per shield for the first 5 years in the contract. Tony Stark. Stark Industries' CEO. believes it is unlikely the government will require a reduction of more than 20% of the price per shield in the next contract negotiation. Exhibit 1 indicates Tony's assessment of the revised contract prices with their estimated probabilities of realization. Common practice in the tax department of Stark Industries is to depreciate the full value of any acquired assets regardless of their salvage values. Pepper Potts (Stark Industries CFO) determined the equipment is 7-years class property (see depreciation percentages for this type of property in Exhibit 2). Stark Industries is subject to a 26% tax rate (21% corporate tax rate plus 5% blended rate of state taxes). Exhibit 1: Government Contract Renegotiation Estimates: RENEGOTIATIED PRICE PROBABILITY 1,100 5% 1,020 15% 980 930 30% 880 259. 25 Exhibit 2: Depreciation Schedule (in percentages) for 7-year property. 14.29 1 2 21.19 3 17.19 4 12.19 5 8.93 6 8.92 7 8.93 8 4.46 1. 150 points; content 40 points, modeling 10 points) Determine the NPV of the project. Clearly state the assumptions for your calculations. (Hint: since your will be evaluating more than one scenario, it will be on your best interest to use formulas and cell reforences in your Excel worksheets. This is a good opportunity to practice your worksheet modeling skills.)