How do I use EXCEl to calculate the NPV and IRR of the following scenario:
- Cost (Year o): $10,000.
- Year 1 Return: 3,000
- Year 2 Return: 3000
- Year 3 Return: 5,000
Discount Rate:10%© BrainMass Inc. brainmass.com March 4, 2021, 7:40 pm ad1c9bdddf
The solution explains how to calculate the NPV and IRR using excel