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,000,000, and the company will spend $100,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.Stark Industries managerial performance evaluations include an 18% charge on invested capital.The company can obtain a 6% return on short-term investments and its current weighted average cost of capital is 14%.

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 company also agreed to invest $40,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 up to 100 shields; in the worst case scenario the decrease in output would be 15%.

Each shield consumes $500 worth of vibranium (imported from Wakanda).Recent contract negotiations with Wakanda and the Black Panther have locked-in this cost for the next five years and specify an increase to $550 per shield thereafter.The current contract negotiated with the U.S. Armed Forces guarantees a price of $960 per shield for the first 5 years in the contract. Tony Stark, Stark Industries' CEO, believe it is unlikely

the government will require a reduction of more than 10% of the price per shield in the next contract negotiation.

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 1). Stark Industries is subject to a 35% tax rate.

Exhibit I: Depreciation Schedule (in percentages) for 7-year property.

1 14.29

2 24.49

3 17.49

4 12.49

5 8.93

6 8.92

7 8.93

8 4.46

Required (Please, provide supporting schedules for all your answers):

I.[20 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 references in your Excel worksheets.)

II.[15 points] Using the information on the project and the assumptions you made in part I indicate the following:

a.[5 points] What is the Internal Rate of Return of the project?

b.[5 points] How sensitive is the viability of the project to the choice hurdle rate assumptions you made part I?

c.[5 points] What will be the lowest price that Stark Industries may be able to accept upon contract renegotiation in year 5 that would continue to make the project viable?

III.[5 points] Assume that Ms. Potts suggests that the company may be able to use Section 179 of the Internal Revenue Code, which allows the company to expense up to $500,000 of the cost of an asset in the year it is placed into service. The remaining asset cost would be depreciated using the 7-year class table starting in the year it is placed in service. What would be the NPV of the project if Stark Industries were able to take the full benefit of Section 179?

IV.[25 points] Please calculate the NPV under the most optimistic set of assumptions and the most pessimistic set of assumptions based on the project's original facts and the depreciation scenario suggested in part III. (For this requirement, you must combine the best and worst possible scenarios from all the information included in the case.)

a.Would you recommend Stark Industries to accept the project? Briefly explain.

b.Briefly, comment on the importance of conducting sensitivity analysis when evaluating long-term capital investments.