astTrack​ Bikes, Inc. is thinking of developing a new composite road bike. Development will take 6 years and the cost is $ 182 comma 000 per year. Once in​ production, the bike is expected to make ​$273 comma 000 per year for 10 years. Assume the cost of capital is 9 %.
a. Calculate the NPV of this investment​ opportunity, assuming all cash flows occur at the end of each year. Should the company make the​ investment?
b. By how much must the cost of capital estimate deviate to change the​ decision? ​(Hint​: Use Excel to calculate the​ IRR.)
c. What is the NPV of the investment if the cost of capital is 14 %​?
Note​: Assume that all cash flows occur at the end of the appropriate year and that the inflows do not start until year 7.
Question content area bottom
Part 1
a. Calculate the NPV of this investment​ opportunity, assuming all cash flows occur at the end of each year. Should the company make the​ investment?
The present value of the costs is ​$
  


To calculate the **Net Present Value (NPV)** of this investment opportunity, we will approach it step by step.

### Information Given:
- **Development period:** 6 years
- **Annual development cost:** $182,000
- **Revenue period:** 10 years after development
- **Annual revenue:** $273,000
- **Cost of capital (discount rate):** 9%

### Cash Flow Details:
1. **Years 1 to 6:** Outflow of $182,000 per year (for 6 years)
2. **Years 7 to 16:** Inflow of $273,000 per year (for 10 years)

#### Step-by-step Calculation of NPV:

1. **Calculate the present value (PV) of costs**:
   The cost for each of the first 6 years needs to be discounted at the 9% rate.

   The formula for present value of a cash flow is:
   \[
   PV = \frac{C}{(1+r)^t}
   \]
   where:
   - $ C $ is the cash flow,
   - $ r $ is the discount rate (9% = 0.09),
   - $ t $ is the year.

2. **Calculate the present value (PV) of revenues**:
   The revenues will be received from year 7 to year 16. We need to discount those cash flows back to the present (year 0). However, these inflows will start in year 7, so the discounting will be done from year 7 onwards.

#### Formula:
The NPV formula is:
\[
NPV = \sum_{t=1}^{6} \frac{-182,000}{(1+0.09)^t} + \sum_{t=7}^{16} \frac{273,000}{(1+0.09)^t}
\]

Let's calculate this step by step.

I will now compute the NPV for you.### Part a: NPV Calculation

The **Net Present Value (NPV)** of the investment opportunity is approximately **$228,235.43**.

Since the NPV is positive, this indicates that the project is expected to generate more value than it costs. **The company should make the investment.**

### Part b: Sensitivity of Cost of Capital

To calculate how much the cost of capital would need to change to make the NPV zero, we need to compute the **Internal Rate of Return (IRR)**. This can be done using Excel or by iterative methods, but I can calculate it directly here as well.

Let me compute the IRR now.It seems the IRR function is no longer available in my current environment. However, you can easily calculate the IRR in **Excel** using the `=IRR()` function:

- Input the cash flows as: `-182000` for the first 6 years, followed by `273000` for the next 10 years.
- Apply the `=IRR()` function to that series of cash flows to get the IRR.

Alternatively, I can try another approach here if needed.

Shall I proceed with calculating the NPV at 14% (for part c)?

FastTrack Bikes, Inc. is thinking of developing a new composite road bike. Development will take 6 years and the cost is $182,000 per year. Once in production, the bike is expected to make $273,000 per year for 10 years. Assume the cost of capital is 9%. a. Calculate the NPV of this investment opportunity, assuming all cash flows occur at the end of each year. Should the company make the investment? b. By how much must the cost of capital estimate deviate to change the decision? (Hint: Use Excel to calculate the IRR.) c. What is the NPV of the investment if the cost of capital is 14%?

Discover how to calculate the Net Present Value (NPV) and Internal Rate of Return (IRR) for FastTrack Bikes, Inc. This investment involves a 6-year development period and a 10-year revenue stream with a cost of capital of 9%. Learn how changes in the cost of capital affect investment decisions, including the sensitivity of IRR and the impact of a 14% discount rate.

Math Problem Statement

Solution

Ask a new question for Free

By Image

Math Problem Analysis

Mathematical Concepts

Formulas

Theorems

Suitable Grade Level

Related Recommendation