Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Rocky Road Bikes is evaluating the possibility of offering a new top-of-the-line bike model. The companys market research team estimates that first year sales of

Rocky Road Bikes is evaluating the possibility of offering a new top-of-the-line bike model. The companys market research team estimates that first year sales of the new model will be 25,000 units at the proposed price of $750.00 per unit and estimated cost per unit of $275.00. Sales are expected to grow 4% per year in each of the following 5 years, until the new model is discontinued at the end of year 6. The market research team also estimates the introduction of the new model will erode sales of the current top model by a constant 5,000 units per year. The current top model has a price of $500.00 and associated costs of $145.00.The required tooling and machinery to manufacture the new model will cost a total of $15,000,000, and this will be depreciated on a straight-line basis over the six-year life of the project to zero. The company expects to be able to sell the machinery at the end of the project for $3,000,000. There will also be fixed costs associated with the new model of $6,000,000 per year. The new model will require an increase in working capital of $250,000 which will be returned at the end of the project. Rocky Road has a tax rate of 35%, and management believes that the discount rate for this project should be 12%.

What is the NPV of this project?

Please use excel, this is how I need to answer it and it's confusing to me

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Finance questions

Question

Define the term "Leasing"

Answered: 1 week ago

Question

What do you mean by Dividend ?

Answered: 1 week ago

Question

What is database?

Answered: 1 week ago

Question

What are Mergers ?

Answered: 1 week ago

Question

What is the average transaction amount for Montana (MT)?

Answered: 1 week ago