Explore BrainMass
Share

Explore BrainMass

    NPV, IRR and payback period

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

    Please help with the following problems.

    Year Project A Project B
    0 -$200 -$200
    1 80 100
    2 80 100
    3 80 100
    4 80

    1. IRR/NPV. If the opportunity cost of capital is 11 percent, which of these projects is worth pursuing?
    2. Mutually Exclusive Investments. Suppose that you can choose only one of these projects. Which would you choose? The discount rate is still 11%.
    3. IRR/NPV. Which project would you choose if the opportunity cost of capital were 16%?
    4. IRR. What are the internal rates of return on projects A and B?
    7. Payback. What is the payback period of each project.

    I need explanations to each of these problems so I can understand how to solve them.

    © BrainMass Inc. brainmass.com October 9, 2019, 5:18 pm ad1c9bdddf
    https://brainmass.com/business/internal-rate-of-return/npv-irr-and-payback-period-53392

    Solution Preview

    Please see the attached Excel file for a detailed response.

    NPV = Present value of cash ...

    Solution Summary

    This explains the steps to compute NPV, IRR and payback period. The solution is provided in Excel.

    $2.19