Explore BrainMass

Explore BrainMass

    NPV, IRR and payback period

    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!

    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 December 15, 2022, 4:56 pm ad1c9bdddf

    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.