Given are the indicators of the cash flow of the investment project for 6 years.

Year 0 = -590

Year 1 = 178

Year 2 = 235

Year 3 = 120

Year 4 = 116

Year 5 = 176.5

Year 6 = -145.5

R = 7.5%

Calculate:

1.net present value

2. payback period

3.modified internal rate of return(all the three methods has to be done)

Three Methods:

a.Discounting Approach

b. Reinvestment Approach

c. Combination Approach

4.profitability index of proposed projects.

After each calculated figure indicate whether the project should be accepted or rejected based on the received data. Give a general conclusion on the project and justify your decision. Do this question using MsExcel. Show the step by step working and formulas for each question.