Explore BrainMass

Explore BrainMass

    Calculating NPV and IRR parameters in the given case

    This content was COPIED from BrainMass.com - View the original, and get the already-completed 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 March 5, 2021, 1:07 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.

    $2.19

    ADVERTISEMENT