Question

In: Finance

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 flows -45,000 17,000 16,000 15,000 25,000
project Bee cash flows -50,000 11,000 30,000 15,000 25,000

Solutions

Expert Solution

Cash flows are as below

periods 0 1 2 3 4
project Hay cash flows -45000 17000 16000 15000 25000
Cumulative CF -45000 -28000 -12000 3000 28000
DCF -45000 15468.61 13247.22 11300.51 17137.57
Cumulative CF -45000 -29531.4 -16284.2 -4983.66 12153.91
Project Bee cash flows -50000 11000 30000 15000 25000
Cumulative CF -50000 -39000 -9000 6000 31000
DCF -50000 10009.1 24838.53 11300.51 17137.57
Cumulative CF -50000 -39990.9 -15152.4 -3851.86 13285.71

The indicators are as follows

Payback Discounted Payback NPV IRR MIRR
Project Hay 2.8 3.29 12153.91 21.12% 16.67%
Project Bee 2.7 3.22 13285.71 20.72% 16.57%

WORKINGS

jeff jeffy answered 1 year ago
Next > < Previous

Related Solutions

Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted...
Explain how to calculate the capital budgeting criterion (in excel) : NPV, IRR, MIRR, Payback, Discounted Payback, Crossover Rate, and decide between mutually exclusive and/or independent projects
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial...
. Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s payback period? f. What is...
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.
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial...
Problem #4 Calculate NPV, Payback, Discounted Payback, IRR and Modified IRR for the following project Initial Investment: -100,000 Annual project cash flow 22,000 for 6 years Cost of capital is 6%
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?
You evaluate ALL of its projects by applying the Payback, Discounted Payback, NPV, and IRR rules....
You evaluate ALL of its projects by applying the Payback, Discounted Payback, NPV, and IRR rules. Assume the cost of capital is 10%. Assume cash flows of: TIME               CASH FLOWS -------------------------------------------------------------- 0               -$100 1               +$75 2               +$50 3               +$25 What is the payback?                                What is the Discounted Payback?                                What...
SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback...
SHOW YOUR WORK AND EXPLAIN PLEASE! Complete problems: NPV, IRR, MIRR, Profitability Index, Payback, Discounted Payback A project has an initial cost of $60,000, expected net cash inflows of $10,000 per year for 8 years, and a cost of capital of 12%. Show your work. a. What is the project’s NPV? (Hint: Begin by constructing a timeline). b. What is the project’s IRR? c. What is the project’s MIRR? d. What is the project’s PI? e. What is the project’s...
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...
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...
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...
ADVERTISEMENT
Subjects
ADVERTISEMENT
Latest Questions
ADVERTISEMENT