The Investment Detective - Case Solution
The Investment Detective case study allows a student to learn and compare various capital investments. It tackles the evaluation of cash flows of various projects and determines which is the most attractive based on its net present value (NPV), internal rate of return (IRR), return on investment (ROI), etc.
Case Questions Answered
- In the case of The Investment Detective, for each set of project cash flows, calculate the payback period and rank the projects.
- For each set of project cash flows, calculate the Internal Rate of Return (IRR) and rank the projects.
- For each set of project cash flows, calculate the Net Present Value (NPV) using discount rates of 8%, 10%, and 12%, respectively. For each discount rate, rank the projects. Explain why the ranking changes as the discount rate increases. Now, assume that Project #7 and Project #8 are mutually exclusive, and the cost of capital is 10%. Answer the following two questions only for projects #7 and #8.
- How would you rank these two projects based on NPV? Based on IRR? Are your rankings the same? If not, explain why.
- In addition to NPV and IRR, are there any other considerations that might affect your choice of the project?
This case solution includes an Excel file with calculations that will be available after purchase.
This case solution includes an Excel file with calculations.
The Investment Detective Case Study
The Investment Detective case study allows a student to learn and compare various capital investments. It tackles the evaluation of the cash flows of various projects.
It determines which is the most attractive based on its net present value (NPV), internal rate of return (IRR), return on investment (ROI), etc.
1. In the case of The Investment Detective, for each set of project cash
flows, calculate the payback period and rank the projects.
(Please refer to the attached Excel spreadsheet for additional computation.)
Complete Case Solution
Get immediate access to the full, detailed analysis
- Comprehensive answers to all case questions
- Detailed analysis with supporting evidence
- Instant digital delivery (PDF format)
Secure payment • Instant access
By clicking, you agree to our Terms of Use, Arbitration and Class Action Waiver Agreement and Privacy Policy