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%.

© BrainMass Inc. brainmass.com June 19, 2018, 1:03 am ad1c9bdddf

Solution Summary

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