A B C D E 1 Year 2 Investment 3 4 Project A Project B Project...

Transcribed Image Text:

A B C D E 1 Year 2 Investment 3 4 Project A Project B Project C Project D (805,200) (759,330) (540,300) (833,120) 1 159,600 290,540 264,570 185,000 2 159,600 290,540 165,000 180,000 5 3 159,600 300,000 165,000 160,000 6 4 247,000 211,780 165,000 250,170 7 5 251,400 206,350 165,000 250,000 8 WACC 8.0% 9 10 NPV (41,244) 293,032 210,692 (26,461) 11 IRR 6.2% 22.7% 23.3% 6.9% 12 MIRR 6.9% 11.3% 11.3% 4.2% 13 PI 1.051 0.614 0.610 1.032 14 Payback 15 16 17 F A B C D E 1 Year 2 Investment 3 4 Project A Project B Project C Project D (805,200) (759,330) (540,300) (833,120) 1 159,600 290,540 264,570 185,000 2 159,600 290,540 165,000 180,000 5 3 159,600 300,000 165,000 160,000 6 4 247,000 211,780 165,000 250,170 7 5 251,400 206,350 165,000 250,000 8 WACC 8.0% 9 10 NPV (41,244) 293,032 210,692 (26,461) 11 IRR 6.2% 22.7% 23.3% 6.9% 12 MIRR 6.9% 11.3% 11.3% 4.2% 13 PI 1.051 0.614 0.610 1.032 14 Payback 15 16 17 F