Explore BrainMass

Calculating NPV and IRR parameters in the given case

This content was STOLEN from BrainMass.com - View the original, and get the solution, here!

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 September 26, 2018, 2:42 am ad1c9bdddf - https://brainmass.com/business/finance/calculating-npv-and-irr-parameters-in-the-given-case-564341

Solution Summary

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