Math Problem Statement
Marissa Manufacturing is presented with the following two mutually exclusive projects. The required return for both projects is 15 percent.
Year Project M Project N 0 −$ 120,000 −$ 339,000 1 55,500 154,300 2 69,400 164,400 3 64,100 150,800 4 36,500 105,400 What is the IRR for each project? Note: Do not round intermediate calculations and enter your answers as a percent rounded to 2 decimal places, e.g., 32.16. What is the NPV for each project? Note: Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16. Which, if either, of the projects should the company accept?
Solution
Let's solve this problem by first calculating the Internal Rate of Return (IRR) and Net Present Value (NPV) for both projects. Here's a step-by-step breakdown:
1. Calculating IRR
The IRR is the discount rate that makes the NPV of a project equal to zero. To calculate it for each project, we can use the following formula:
Where:
- is the cash flow at time ,
- is the internal rate of return,
- is the number of periods.
We solve for the IRR by setting the NPV equal to zero and using the given cash flows.
Project M:
Year | Cash Flow (M) |
---|---|
0 | −120,000 |
1 | 55,500 |
2 | 69,400 |
3 | 64,100 |
4 | 36,500 |
Project N:
Year | Cash Flow (N) |
---|---|
0 | −339,000 |
1 | 154,300 |
2 | 164,400 |
3 | 150,800 |
4 | 105,400 |
To solve for IRR, we use the IRR formula with the respective cash flows. I'll calculate the IRR for both projects first.The Internal Rate of Return (IRR) for each project is as follows:
- IRR for Project M: 32.93%
- IRR for Project N: 26.74%
Next, let's calculate the Net Present Value (NPV) for each project. The NPV formula is:
Where:
- is the cash flow at time ,
- is the required return (15% or 0.15 in this case),
- is the number of periods.
I'll calculate the NPV for both projects using a discount rate of 15%.The Net Present Value (NPV) for each project is as follows:
- NPV for Project M: $43,753.02
- NPV for Project N: $78,900.17
Decision:
Since both the NPV and IRR for Project N are higher than the required return, Project N should be accepted. However, both projects have positive NPVs, so if the company could afford it, it might consider both. If forced to choose, Project N is the better option based on the NPV rule.
Would you like more details or have any questions? Here are some related questions you might find useful:
- How do NPV and IRR differ in evaluating projects?
- What are the limitations of using IRR alone for decision-making?
- What if the required return changes—how would that affect the decision?
- Could there be any qualitative factors to consider in this case?
- How do mutually exclusive projects impact investment decisions?
Tip: Always prioritize NPV when faced with conflicting signals between NPV and IRR, as NPV provides a direct measure of value added.
Ask a new question for Free
By Image
Drop file here or Click Here to upload
Math Problem Analysis
Mathematical Concepts
Internal Rate of Return (IRR)
Net Present Value (NPV)
Investment Analysis
Formulas
NPV = Σ(CF_t / (1 + r)^t) - Initial Investment
IRR: Σ(CF_t / (1 + IRR)^t) - Initial Investment = 0
Theorems
NPV Rule
IRR Calculation
Suitable Grade Level
University (Finance, MBA)
Related Recommendation
Calculate NPV, PI, and IRR for Mutually Exclusive Projects X and Y
IRR and NPV Calculation for Project Evaluation
NPV and IRR Calculation for Projects A and B
Calculate NPV and IRR for Investment Projects A and B at Different Discount Rates
Calculate NPV and IRR with Cost of Capital: $10,000 Investment Opportunity