Answer all of it on Excel if you can, Thanks Goodweek...

90.2K

Verified Solution

Question

Finance

Answer all of it on Excel if you can,
Thanks image
Goodweek Tires, Inc. After extensive research and development, Goodweek Tires, Inc. has recently developed a new tire, the SuperTread, 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 additional to normal freeway usage. The research and development costs so far have totaled S7 million. The SuperTread would be put on the market beginning this year, and Goodweek expects it to stay on the market for a total of four years. Test marketing costing $2 million has shown that there is a significant market for SuperTread-type tire As a financial analyst at Goodweek Tires, you have been asked by your CFO, Adam Smith, to evaluate the SuperTread project and provide a recommendation on whether to go ahead with the investment. Except for the initial investment that will occur immediately, assume all cash flows will occur at the year-end. Goodweek must initially invest S100 million in production equipment to make the SuperTread. This equipment can be sold for $20 million at the end of four years. Goodweek intends to sell the SuperTread to two distinct markets: I. The original equipment manufacturer (OEM) market: The OEM market consists primarily of the large automobile companies (like General Motors) that buy tires for new cars. In the OEM market, the SuperTread is expected to sell for S45 per tire. The variable cost to produce each tire is $20. 2. The replacement market: The replacement market consists of a ires purchased after the automobile has left the factory. This market allows higher margins; Goodweek expects to sell the SuperTread for $70 per tire there. Variable costs are the same as in the OEM market Goodweek Tires intends to raise the prices at 1 percent above the inflation rate; variable costs will also increase at 1 percent above the inflation rate. In addition, the SuperTread project will incur S23 million in marketing and general administration costs the first year. This cost is expected to increase at the inflation rate in the subsequent years. Goodweek's corporate tax rate is 40 percent. Annual inflation is expected to remain constant at 3.5 percent. The company uses a 15.6 percent discount rate to evaluate new product decisions. Automotive industry analysts expect automobile manufacturers to produce 2 million new cars this year and production to grow at 2 percent per year thereafter. Each new car needs four tires (the spare tires are undersized and are in a different category) Goodweek Tires expects the SuperTread to capture 10 percent of the OEM market. Industry analysts estimate that the replacement tire market size will be 12 million tires this year and that it ll grow at 2 percent annually. Goodweek expects the SuperTread to capture an 8 percent market share The appropriate depreciation schedule for the equipment is straightline depreciation. The immediate ncrease working capital requirement is S10 million. Thereafter, the networking capital requirements will be 15 percent of sales and reduced to zero at the end of the project. What are the NPV, payback period, discounted payback period, and profitability index on this project

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students