Q1. Use table 1 to calculate 1. Net Profit 2. Pay Back Period 3. Return on investment 4. Net present value for the discount factor of 10 % 5. Internal rate of return Table 1. Projects' Cash Flow...

use excel sheet

Extracted text: Q1. Use table 1 to calculate 1. Net Profit 2. Pay Back Period 3. Return on investment 4. Net present value for the discount factor of 10 % 5. Internal rate of return Table 1. Projects' Cash Flow Details Project Project Project Project Project Year 1 3 4 5 0 2000000 -100000 -120000 -150000 -500000 1 500000 20000 40000 50000 150000 2 500000 25000 40000 50000 150000 3 500000 15000 30000 50000 100000 4 500000 50000 10000 50000 100000 5 500000 10000 10000 20000 100000 20000 100000 20000 100000 350000 -20000 10000 7 400000 10000 10000 8 500000 15000 10000 20000 50000 400000 30000 12000 10000 50000 10 200000 40000 5000 20000 50000