In: Accounting
|
||||||||||||||||||||||||||||||||||||||||||||
|
Correct Answer:
|
IRR |
|
|
Project A |
8% |
|
Project B |
10% |
Working:
IRR = R1+( NPV1/(NPV1-NPV2) * (R2-R1)
|
Project A |
|||
|
Year |
Cash Inflows |
PVA factor at 5% |
Present value |
|
1-6 |
$ 43,820 |
$ 5.0757 |
$ 2,22,417 |
|
(-) Initial Cost |
$ 2,02,575 |
||
|
Net Present Value (NPV1) @ 5% |
$ 19,842 |
||
|
Project A |
|||
|
Year |
Cash Inflows |
PVA factor at 10.% |
Present value |
|
1-6 |
$ 43,820 |
$ 4.3553 |
$ 1,90,849.25 |
|
Total |
$ 1,90,849.25 |
||
|
(-) Initial Cost |
$ 2,02,575.00 |
||
|
Net Present Value (NPV2) @ 10% |
$ (11,725.75) |
||
|
Project A |
|
|
NPV1 |
$ 19,842.17 |
|
NPV2 |
$ (11,725.75) |
|
NPV1-NPV2 |
$ 31,567.93 |
|
NPV1/(NPV1-NPV2) |
$ 0.63 |
|
R1 |
5.0% |
|
R2 |
10.0% |
|
R2-R1 |
5.0% |
|
IRR |
8% |
|
Project B |
|||
|
Year |
Cash Inflows |
PVA factor at 5% |
Present value |
|
1-9 |
$ 43,660 |
$ 7.1078 |
$ 3,10,327 |
|
Total |
$ 3,10,327 |
||
|
(-) Initial Cost |
$ 2,51,438 |
||
|
Net Present Value (NPV1) @ 5% |
$ 58,889.49 |
||
|
Project B |
|||
|
Year |
Cash Inflows |
PVA factor at 10% |
Present value |
|
1-9 |
$ 43,660 |
$ 5.7590 |
$ 2,51,437.94 |
|
Total |
$ 2,51,437.94 |
||
|
(-) Initial Cost |
$ 2,51,438.00 |
||
|
Net Present Value (NPV2) @ 10% |
$ 0.06 |
||
|
Project Beta |
|
|
NPV1 |
$ 58,888.55 |
|
NPV2 |
$ (0.06) |
|
NPV1-NPV2 |
58,888.61 |
|
NPV1/(NPV1-NPV2) |
$ 1.00000 |
|
R1 |
5% |
|
R2 |
10% |
|
R2-R1 |
5% |
|
IRR |
10% |
End of Answer.
Thanks