Hello! I need help with this problem, If you feel like answering please, only do

Question

Hello! I need help with this problem, If you feel like answering please, only do so in Excel. I need to see the formulas used (no screen shots). I want this done, but really want to understand how it was completed. EXCEL Only!

THANK YOU!!

After extensive research and development, Goodweek Tires, Inc., has recently developed a new tire, The research and development costs so far have totaled about $10 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 $5 million has shown that there is a significant market for a SuperTread-type tire. Except for the initial investment that will occur immediately, assume all cash flows will occur at year-end. Goodweek must initially invest $160 million in production equipment to make the SuperTread. This equipment can be sold for $65 million at the end of four years. Goodweek intends to sell the SuperTread to two distinct markets: 1. The original equipment manufacturer (OEM) market: The OEM market consists pri-marily 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 $41 per tire. The vari-able cost to produce each tire is $29. 2. The replacement market: The replacement market consists of all tires purchased after the automobile has left the factory. This market allows higher margins; Goodweek expects to sell the SuperTread for $62 per tire there. Variable costs are the same as in the OEM market. Goodweek Tires intends to raise 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 $43 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

Explanation / Answer

question to long pls increase pts

Related Questions

Navigate

• Browse (All)
• Browse H
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.