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,100,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 $50,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 $25,000 investment in working capital to keep the equipment running efficiently; the $25,000 investment in working capital is fully recoverable at the end of the investment.

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 15%.

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 year of the agreement of up to 5% of the agreed salary. 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 25%.

Each shield consumes $500 worth of vibranium (imported from Wakanda). Recent contract negotiations with Wakanda and King TChalla 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 unlikelythe 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 26% tax rate (21% corporate tax rate plus 5% blended rate of state taxes).[1]

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):

[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.)

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

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

[5 points] What is the after-tax payback period of the project?

[5 points] How sensitive is the viability of the project to the choice hurdle rate assumptions you made part I? (Indicate the NPV for each of the alternative hurdle rates you use).

[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?

[15 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 $1,000,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.

[5 points] What would be the NPV of the project if Stark Industries were able to take the full benefit of Section 179?

[5 points] What would be the Internal Rate of Return based on this scenario?

[5 points] Assume that Ms. Potts also indicates that the company may be able to use Bonus Depreciation on any remaining value of the value of the equipment. Under the new law the Bonus Depreciation allows for a 100% depreciation deduction on the year the asset is placed in service. What would be the Internal Rate of Return based on this scenario?

[25 points] Sensitivity analysis.

[15 points] In addition to the scenarios calculated above, calculate the NPV under the most optimistic set of assumptions and the most pessimistic set of assumptions and summarize the NPV and IRR calculation for each scenario. (For this requirement, you must combine the best and worst possible scenarios from all the information included in the case.)

[5 points] Based on the date you have obtained throughout the exercise, would you recommend Stark Industries to accept the project? Briefly explain.

[5 points] Briefly, comment on the importance of conducting sensitivity analysis when evaluating long-term capital investments.

[1] We are assuming the 2017 Tax Reform Legislation applies to this scenario.