1. Calculate the NPV of the first project using an embedded function based on the information : An initial investment cost is $ 42,000. The project generates $8,720 in the first year. The cash flows have zero growth and the project only generates cash flows for 20 years

2. Calculate the NPV of the second project based on the information: An initial investment cost is $55,700 The project generates $5,100 in the first year, and continue to grow at a constant rate of 7\% for 15 years .

Please show all the formulas and excel sheets used.