CH 11-23 Capital Budgeting Criteria Your division is considering two projects. i
ID: 2786578 • Letter: C
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