Share
Explore BrainMass

NPV and IRR

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%

Solution Summary

The solution explains how to calculate the NPV and IRR using excel

$2.19