CH 11-23 Capital Budgeting Criteria Your division is considering two projects. i

Question

CH 11-23

Capital Budgeting Criteria

Your division is considering two projects. its WACC is 10% and the projects after tax cash flow ( in mllions of dollars) would be as follow:

0 1 2 3 4

Project A -30 $5 $10 $15 $20

Project B -30 $20 $10 $8 $6

A) Calculate the projects NPVs, IRRs,MIRRs, regular paybacks, and discounted paybacks.

B) If the two projects are independent, which projects should be chosen?

C) If the two projects are mutually exclusive and the WACC is 10% , which project should be chosen?

Please provide answers clear to understand and in excel format.

Thank you

Explanation / Answer

a) NPV = 7.74

IRR = 19.19%

MIRR = 16.50%

regular payback = 3 years

Discounted payback = 3.43 years

Project B:

NPV = 6.55

IRR = 22.52%

MIRR = 15.57%

Payback = 2 years

discounted payback = 2.59 years

10.00% Cash flows Year Discounted CF                    (30.00) 0 -30.00                         5.00 1 4.55                      10.00 2 8.26                      15.00 3 11.27                      20.00 4 13.66

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.