Math Problem Statement
FastTrack Bikes, Inc. is thinking of developing a new composite road bike. Development will take 6 years and the cost is $ 208000 per year. Once in production, the bike is expected to make $332800 per year for 10 years. Assume the cost of capital is 9 %. What's the IRR of this opportunity?
Solution
To calculate the Internal Rate of Return (IRR) for the project, we need to solve for the discount rate that makes the Net Present Value (NPV) of the project's cash flows equal to zero.
Here's a breakdown of the cash flows:
- Development phase (Years 0 to 5): Costs $208,000 per year for 6 years (negative cash flows).
- Production phase (Years 6 to 15): Generates $332,800 per year for 10 years (positive cash flows).
The formula for NPV is:
Where:
- is the cash flow in year ,
- is the IRR,
- is the year of the cash flow.
At IRR, the NPV should be 0, so the equation becomes:
Now, let's solve for the IRR using a financial formula approach.It seems that I cannot use the specific function for calculating the IRR directly in this environment. However, I can guide you through how to solve this manually or using a financial calculator.
Here's the method:
Step-by-Step Calculation
-
Initial Cash Outflows: There are 6 negative cash flows of $208,000 each, starting from Year 0 to Year 5.
-
Cash Inflows: For the next 10 years (Year 6 to Year 15), the project will generate $332,800 per year.
-
Setting NPV = 0: To solve for the IRR, you need to use trial and error or a financial calculator where the NPV of the cash flows equals zero.
You can use Excel's =IRR()
function or any financial calculator to compute the IRR for the cash flow series:
- Input the sequence:
-208000 (for 6 years), 332800 (for 10 years)
into the formula.
Would you like me to show how to calculate IRR using Excel or suggest another method?
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Finance
Internal Rate of Return (IRR)
Net Present Value (NPV)
Discounting Cash Flows
Formulas
NPV = Σ (CF_t / (1 + r)^t)
IRR is the discount rate when NPV = 0
Theorems
Time Value of Money
NPV Rule
Suitable Grade Level
College-level Finance
Related Recommendation
Calculate NPV and IRR for FastTrack Bikes Investment
Calculate the Internal Rate of Return (IRR) for an 8-Year Project with $76,940 Initial Cost
Calculate IRR for Bucky Inc. Investment with Cash Flows Over 4 Years
Calculate the IRR for an 8-Year Project with $700,000 Investment
Calculate the Internal Rate of Return (IRR) for Project A with Cash Flows