PLEASE SHOW YOUR WORK ON EXCEL or the formula's used so it's easy to understand

1.ABC Inc. is considering a project that has the following cash flow and WACC data.

What is the project's NPV?Note that if a project's expected NPV is negative, it should be rejected.

WACC: 7 %

Year012345

Cash flows-$1,200$200$400$400$300$300

2.ABC Enterprises is considering a project that has the following cash flow and WACC data.What is the project's NPV?Note that a project's expected NPV can be negative, in which case it will be rejected.

WACC:8%

Year0123

Cash flows-$1,050$450$460$470

3.Warranty Inc. is considering a project that has the following cash flow and WACC data.

What is the project's NPV?Note that a project's expected NPV can be negative, in which case it

will be rejected.

WACC:12 %

Year0123

Cash flows-$950$500$400$300

4.Berry Company is considering a project that has the following cash flow and WACC

data.What is the project's NPV?Note that a project's expected NPV can be negative, in which

case it will be rejected.

WACC: 11 %

Year012345

Cash flows-$1,000$400$390$380$370$360

5.Data Computer Systems is considering a project that has the following cash flow data.What is the project's IRR?Note that a project's IRR can be less than the WACC (and even negative), in which case it will be rejected.

Year0123

Cash flows-$1,500$600$550$500