Question

In: Finance

Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive...

Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above:

Table 1

Cash flows for two mutually exclusive projects

Year

Investment A

Investment B

0

-$5,000,000

-5,000,000

1

$1,500,000

$1,250,000

2

$1,500,000

$1,250,000

3

$1,500,000

$1,250,000

4

$1,500,000

$1,250,000

5

$1,500,000

$1,250,000

6

$1,500,000

$1,250,000

7

$2,000,000

$1,250,000

8

0

$1,600,000

Solutions

Expert Solution

jeff jeffy answered 2 years ago
Next > < Previous

Related Solutions

Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive...
Please calculate the payback period, IRR, MIRR, NPV, and PI for the following two mutually exclusive projects. The required rate of return is 15% and the target payback is 4 years. Explain which project is preferable under each of the four capital budgeting methods mentioned above: Table 1 Cash flows for two mutually exclusive projects Year Investment A Investment B 0 -$5,000,000 -5,000,000 1 $1,500,000 $1,250,000 2 $1,500,000 $1,250,000 3 $1,500,000 $1,250,000 4 $1,500,000 $1,250,000 5 $1,500,000 $1,250,000 6 $1,500,000...
23. Does the Payback Period, Discounted Payback Period, NPV, IRR, PI ratio and MIRR given you...
23. Does the Payback Period, Discounted Payback Period, NPV, IRR, PI ratio and MIRR given you the same accept/reject decision. Discuss the limitations of the methods that give you a decision different than that of the NPV.
If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?
Considering the following projects.ProjectYear01234ACash flows-$100$35$35$35$35BCash flows-$100$60$50$40$30Project A has WACC = 6.00% while project B has WACC = 8.50%.If these two projects are mutually exclusive, which project should the company accept based on the NPV, IRR, MIRR, payback, and discounted payback period for each project?Would your decision (Your answer from part A) change if these two projects were independent?
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For...
. For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years.          Project A= Required rate of Return= 16.30% Project B= R= 12.50% Project C= R= 15.35% Project D= R= 17.25%      Expected cash flows for the four...
Compute the IRR, NPV, PI, and payback period for the following two projects. Assume the required...
Compute the IRR, NPV, PI, and payback period for the following two projects. Assume the required return is 12%. Cashflow for each year Project A : Year 0= -2500 Year 1=900 Yaer 2=800 Year 3=1600 Year 4=100 Yaer 5=50 Year 6= 300 Project B Year 0 =-2500 Year 1=50 Year2= 600 Year 3=150 Year 4=900 Year 5= 500 Year 6=2500
Tri-Star, Inc., has the following mutually exclusive projects. a. Calculate the NPV, IRR, MIRR, TPB and...
Tri-Star, Inc., has the following mutually exclusive projects. a. Calculate the NPV, IRR, MIRR, TPB and DPB for the projects. b. Suppose the company's traditional payback period cutoff is two years. Which of these two projects should be chosen on that basis? Explain why c. Suppose the company uses the NPV rule to rank these two projects. Which project should be chosen if the appropriate discount rate is 15 percent? Explain why d. Suppose the company uses the IRR rule...
For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each...
For each project, calculate the NPV, IRR, profitability index (PI) and the payback period. For each capital budgeting decision tool, indicate if the project should be accepted or rejected, assuming that each project is independent of the others. Important Note: The venture capital folks have a firm maximum payback period of four years. Risk free rate = 1.10%, MRP = 9.5%, Required return = 14.40% Yes excel is fine Expected cash flows for the four potential projects that Avalon is...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the...
What is NPV, IRR, PI, MIRR of a project with the following cash flows if the discount rate is 14 percent? Year CF 0 -18,000    1 5000 2 7500 3 8400 4 2100 Also upload your excel files showing your work.
Apple's Project NPV ($) 10,258 IRR (%) 13 MIRR (%) 10 PI 1.5 Payback (Years) 3...
Apple's Project NPV ($) 10,258 IRR (%) 13 MIRR (%) 10 PI 1.5 Payback (Years) 3 Discounted Payback (years) 3.5 Apple's cost of capital is 9%. Its critical payback and discounted payback periods are 2 and 2.5. Should the project be accepted or not. NPV - (Accept or Do Not Accept) IRR - (Accept or Do Not Accept) MIRR - (Accept or Do Not Accept) PI - (Accept or Do Not Accept) Payback - (Accept or Do Not Accept) Discounted...
Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR)...
Calculate the five different criteria for evaluating projects (regular payback, discounted payback, NPV, IRR, and MIRR) for the two projects listed below. The firm’s WACC is 9.90%. If the projects are mutually exclusive and the firm has sufficient budget available, which project (if any) would you choose to proceed with, and why? (Hint: you may want to create the full cash flow table for each project to fully show your work.) periods 0 1 2 3 4 project Hay cash...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT