Reference no: EM132939670

"After extensive research and development, GoodMile Tires, Inc has recently developed a new tire, the Super Tread, and must decide whether to make the investment necessary to produce and market it. The tire would be ideal for drivers doing a large amount of wet weather and off-road driving in addition to normal freeway usage.

The research and development costs so far have totaled about $10 million. The Super Tread would be put on the market beginning this year, and GoodMile expects it to stay on the market for a total of four years. Test marketing costing $5 million has shown that there is a significant market for a Super Tread-type tire.

As a financial analyst, you have been asked by the CFO, Erik Hogan, to evaluate the Super Tread project and provide recommendations on whether to go ahead with the investment. Except for the initial investment that will occur immediately, assume all cash flows will occur at year-end.

GoodMile must initially invest $120 million in production equipment to make the Super Tread. This equipment can be sold for $51 million at the end of four years. GoodMile intends to sell the Super Tread to two distinct markets:

• The original equipment manufacturer (OEM) market: The OEM market consists primarily of the large automobile companies (Like Ford) that buy tires for new cars. In the OEM market, the SuperTread is expected to sell for $36 per tire. The variable cost
  to produce each tire is $18.
• The replacement market: The replacement market consists of all tires purchased after the automobile has left the factory. This market allows higher margins; GoodMile expects to sell the SuperTread for $59 per tire there. Variable costs are the same as in the OEM market.
• GoodMile Tires intends to raise prices at 1% above the inflation rate; variable costs will also increase at 1% above the inflation rate. In addition, the SuperTread project will incur $25 million in marketing and general administration costs in the first year. This cost is expected to increase at the inflation rate in the subsequent years.
• GoodMile's corporate tax rate is 21%.
  Annual inflation is expected to remain constant at 3.25%.
  The company uses a 15.9% discount rate to evaluate new product decisions.
• The automotive industry expects automobile manufacturers to produce 2 million new cars this year and production to grow at 2.5% per year thereafter. Each new car needs four tires (the spare tires are undersized and are in different category). GoodMile's Tires expects the SuperTread to capture 11% of the OEM market. Industry analysts estimate that the replacement tire market size will be 16 million tires this year and that it will grow at 2% annually.
• GoodMile expects the SuperTread to capture an 8% market share.
• The appropriate depreciation schedule for the equipment is the seven-year MACRS depreciation schedule (MACRS table attached below).
• The immediate initial working capital requirement is $11 million. Thereafter, the net working capital requirements will be 15% of sales."

MACRS from IRS.gov

1 = 14.29% 2 = 24.49% 3 = 17.49% 4 = 12.49% 5 = 8.93% 6 = 8.92% 7 = 8.93% 8 = 4.46%

You need to answer the following questions for your client:

Question 1: What is the NPV of this project?

Question 2: What is the IRR of this project?

Question 3: What are the NPVs and IRRs under best- and worst-case scenarios? (treat all the inputs provided as base case information, you need to make your own assumption for numbers used in the best- and worst-case scenario. Your assumptions should make economic sense. Please clearly discuss those assumptions (risk factors) and label that assumption in the Excel spreadsheet.)

Question 4: Perform sensitivity analysis on prices and market shares (for both OEM and RM). Which market is more important to GoodMile Tires?

Question 5: Provide additional risk analysis if you feel necessary.

Question 6: What is your recommendation for GoodMile Tires?