NPV, IRR and payback period
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 ad1c9bdddfhttps://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.