In: Finance
Your firm is considering the following mutually exclusive projects:
Year | Project A | Project B |
0 | -$3,300,000 |
-$3,300,000 |
1 | 1,940,000 | 866,000 |
2 | 1,350,000 | 1,250,000 |
3 |
850,000 |
2,325,000 |
The firm uses a discount rate of 12.628%. At that discount rate we find that
A-Project A is clearly preferred
B-Project B is clearly preferred
C-the projects have roughly the same NPV's
Given that finding, the firm should select ___________because it's NPV is the least sensitive to change
A-Project A
B-Project B
1.
Correct option > C-the projects have roughly the same NPV's
2.
Correct option is > A-Project A
Given that finding, the firm should select Project A because it's NPV is the least sensitive to change
.
Reason: The major cash flow for Project A falls in 1st and 2nd years hence it is least sensitive to change. The Project B has largest cash flow in year 3 hence it is sensitive to interest rate change.
---------------------------------------
NPV Working:
Project A
Discount rate = WACC = R = 12.628% |
Present Values |
||
Year |
Cash flows |
Discount factor or PV factors = Df = 1/(1+R)^Year |
PV of cash flows = Cash flows x Df |
0 |
-$3,300,000.00 |
1.000000 |
-$3,300,000.00 |
1 |
$1,940,000.00 |
0.887879 |
$1,722,484.64 |
2 |
$1,350,000.00 |
0.788329 |
$1,064,243.54 |
3 |
$850,000.00 |
0.699940 |
$594,949.10 |
Net Present Value = Total of Present Values = |
$81,677.28 |
Project B
Discount rate = WACC = R = 12.628% |
Present Values |
||
Year |
Cash flows |
Discount factor or PV factors = Df = 1/(1+R)^Year |
PV of cash flows = Cash flows x Df |
0 |
-$3,300,000.00 |
1.000000 |
-$3,300,000.00 |
1 |
$866,000.00 |
0.887879 |
$768,902.94 |
2 |
$1,250,000.00 |
0.788329 |
$985,410.69 |
3 |
$2,325,000.00 |
0.699940 |
$1,627,360.76 |
Net Present Value = Total of Present Values = |
$81,674.39 |