Part I : Calculation of IRR
Year Cashflows PV@ 10% NPV PV@ 9% NPV
0 -3200 1 -3200 1 -3200
1 974 .909 885.366 .917 893.158
2 1281 .826 1058.106 .842 1078.602
3 1647 .751 1236.897 .772 1271.484
-19.631 43.244
IRR = Lower Rate(LR) + NPV at LR (Differences in rates)
NPV at LR- NPV at HR
= 9% + 43.244(1%) =9.688%
43.244-(-19.631)
Part 2: Calculation of NPV at required rate of 8.5%
Year Cashflows PV@ 8.5% NPV
0 -3200 1 -3200
1 974 .922 898.028
2 1281 .85 1088.85
3 1647 .783 1289.601
NPV of the project 76.479
Part 3 : Accept the project based on the NPV at the required rate of return
Get Answers For Free
Most questions answered within 1 hours.