Calculate the npv and irr using excel


Question: 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 Preview :

Prepared by a verified Expert
Finance Basics: Calculate the npv and irr using excel
Reference No:- TGS01812479

Now Priced at $20 (50% Discount)

Recommended (97%)

Rated (4.9/5)