a)

b)

c)

please use excel and elaborate which formula you used and how you filled in the formula. im still figuring out excel so its a little confusing. please help a sis out. Thank you in advance!

You are evaluating a project with cash flows of $20,000 in time 0. 10,000 in time 1 and 19,087 in time 2. Given a required rate of 11.4%, what is the NPV of the project? You are evaluating a project with a cash flow in time 0 of -100,000 and a cash flow of 198,005 in time 5 (with no cash flows in between). What is the internal rate of return of the project? Note: you will need to put zeroes for the years in which there are not cash flows. (Express as a decimal:9.56% is .0956) You are evaluating two mutually exclusive projects. Project 1 has an NPV of $3000 and an IRR of 15%. Project 2 has expected cash flows of -$29,470 in year 0, $12,911 in year 1, $11,336 in year 2 and $10,222 in year 3. If there is a required rate of 10% on both projects, what is the Net Present Value of Project 2? (Think about but do not answer on line which project would you choose