Project A NPV year 0 1 2 3 4 5 wacc 0.0582 CF-neg -90000 -30000 CF-pos 10000 17000 34000 41000 38000 DCF -90000 9450.00945 15181.45536 28692.97933 8772.465247 28638.14018 NPV 735.0495728 Project B year 0 1 2 3 CF-neg -10000 -2000 -2000 -2000 scenar-1 CF-pos 2000 3000 7000 prob. 0.3 600 900 2100 scenar-2 4000 6000 9000 prob. 0.5 2000 3000 4500 scenar-3 5000 7000 10000 prob. 0.2 1000 1400 2000 Final CF -10000 1600 3300 6600 DCF -10000 1512.001512 2946.988394 5569.813634 NPV 28.8035404 IRR r1 0.0605 Project A r2 0.065 NPV1 Project A NPV2 year 0 1 2 3 4 5 CF-neg -90000 -30000 CF-pos 10000 17000 34000 41000 38000 DCF1 -90000 9429.51438 15115.67605 28506.69693 8696.609984 28328.93398 NPV1 77.43131974 DCF2 -90000 9389.671362 14988.20781 28146.86912 8550.554 27735.47179 NPV2 -1189.225922 IRR 0.060775087 Proof DCF -90000 9427.069058 15107.83727 28484.52506 8687.59245 28292.22083 NPV-proof -0.755333697 MIRR 4 3 2 1 0 Project A year 0 1 2 3 4 5 CF-neg -90000 -30000 PVofNegCF -90000 0 0 0 -23924.90522 -113924.9052 CF-pos 10000 17000 34000 41000 38000 FVofPosCF 12539.23463 20144.30058 38072.76616 43386.2 38000 152142.5014 MIRR 0.059562002 Optional IRR project B 2points MIRR 1point Payback for both 4 points 289759.7422 0.076965051 297189.4792 0.087927022