Ans Project A: 33.33%
Project B: 36.94%
PROJECT A | ||||||
Year | Project Cash Flows (i) | DF@ 10% | DF@ 10% (ii) | PV of Project ( (i) * (ii) ) | DF@ 40% (iii) | PV of Project A ( (i) * (iii) ) |
0 | -105000 | 1 | 1 | (1,05,000.00) | 1 | (1,05,000.00) |
1 | 35000 | 1/((1+10%)^1) | 0.909 | 31,818.18 | 0.714 | 25,000.00 |
2 | 35000 | 1/((1+10%)^2) | 0.826 | 28,925.62 | 0.510 | 17,857.14 |
3 | 140000 | 1/((1+10%)^3) | 0.751 | 1,05,184.07 | 0.364 | 51,020.41 |
NPV | 60,927.87 | NPV | (11,122.45) | |||
IRR = | Ra + NPVa / (NPVa - NPVb) * (Rb - Ra) | |||||
10% + 60927.87 / (60927.87 + 11122.45) * 30% | ||||||
33.33% |
PROJECT B | ||||||
Year | Project Cash Flows (i) | DF@ 10% | DF@ 10% (ii) | PV of Project ( (i) * (ii) ) | DF@ 40% (iii) | PV of Project A ( (i) * (iii) ) |
0 | -90000 | 1 | 1 | (90,000.00) | 1 | (90,000.00) |
1 | 25000 | 1/((1+10%)^1) | 0.909 | 22,727.27 | 0.714 | 17,857.14 |
2 | 25000 | 1/((1+10%)^2) | 0.826 | 20,661.16 | 0.510 | 12,755.10 |
3 | 150000 | 1/((1+10%)^3) | 0.751 | 1,12,697.22 | 0.364 | 54,664.72 |
NPV | 66,085.65 | NPV | (4,723.03) | |||
IRR = | Ra + NPVa / (NPVa - NPVb) * (Rb - Ra) | |||||
10% + 66085.65/(66085.65 + 4723.03) * 30% | ||||||
36.94% |
Need IRR for both projects ASAP MOHAMMED AL ALAMI & 11/2/19 11:26 AM IDE 300 FALL19-C671020)...
Consider the two mutually exclusive investment projects given in the table below for which MARR=11%. On the basis of the IRR criterion, which project would be selected under an infinite planning horizon with project repeatability likely? The rate of return on the incremental investment is ?% Homework: HW #7 Save Score: 0 of 1 pt 10 of 10 (8 complete) HW Score: 78.33%, 7.83 of 10 pts Problem 7-56 (algorithmic) Question Help Consider the two mutually exclusive investment projects given...