IMPORTANT: SHOW YOUR DETAILED SOLUTIONS FOR EACH QUESTION.

Explain what type of problem is it, explain which formula are you using, identify the variables in the formula and explain where are you finding the respective values, and solve the calculation.

1.-Belvedere Co. has identified an investment project with the following cash flows. If the discount rate is 10 percent, what is the present value of these cash flows?

What is the pay back of this project?

What is the IRR of the project?

Year 0= -1000

Year 1=+500

Year 2= +600

Year 3= +100

Year 4=+350

please use show excel screenshots , showing your computation, explain what "buttons" on excel did you use also to explain the pattern