Can someone answer these questions in excel ASAP. Thanks

10-5

(payback period, NPV,PI and IRR calculations) You are considering a project with an initial cash outlay of $80,000 and expected free cash flows $20,000 at the end of each year for 6 years. The required rate of return for this project is 10%.

A. What is the projects payback period?

B. What is the project NPV?

C. What is the project PI?

D. What is the project IRR?

10-9

(IRR calculations) Given the following free cash flows, determine the IRR for the three independent projects A, B and C.

Project A Project B Project C

Initial outlay -$50,000 -$100,000 $450,000

Cash inflows

Year1 $10,000 $125,000 $200,000

Year 2 $15,000 25,000 200,000

Year 3 20,000 25,000 200,000

Year 4 25,000 25,000 ----------

Year 5 30,000 25,000 ---------------

10-13

(NPV calculation) calculate the NPV given the following cash flows if the appropriate required rate of return is 10%

Year Cash Flows

0 -$60,000

1 20,000

2 20,000

3 10,000

4 10,000

5 30,000

6 30,000