Share
Explore BrainMass

Calculating NPV and IRR parameters in the given case

Using a spreadsheet program like Excel, calculate the NPV and IRR of the following scenario:

Cost (Year 0): 10,000.
Year 1 Return: 3,000.
Year 2 Return: 3,000.
Year 3 Return: 5,000.
Discount Rate: 10%.

Solution Summary

Solution depicts the steps to calculate NPV and IRR parameters by using built-in functions in MS Excel.

$2.19