Explore BrainMass

Explore BrainMass

    NPV and IRR

    Not what you're looking for? Search our solutions OR ask your own Custom question.

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

    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%

    © BrainMass Inc. brainmass.com March 4, 2021, 7:40 pm ad1c9bdddf
    https://brainmass.com/business/internal-rate-of-return/npv-and-irr-115568

    Solution Summary

    The solution explains how to calculate the NPV and IRR using excel

    $2.49

    ADVERTISEMENT