please can you do it manually.

Thank you!

Formulas NPV CECECF NPV = CFO + (1 + r) + (1 + r)2 + (1 + r) 3 CFT (1 + r)" PV Annuity PV Annuity = CF x PV Perpetuity CF PV Perpetuity = EAR EAR = (1+)"- 1 where r is the simple interest rate per period, t is the number of periods, m is the number of compounding periods per year, and CF, is the cashflow in period t. NPV Question 1: Adidas is thinking about designing a new pair of shoes. Adidas believes it can sell 40,000 pairs of these shoes a year, for 3 years for a price of $100 per pair. The cost per pair of shoes to the firm will be $70 per pair. The project requires a $1,500,000 investment today and will return nothing at the project's end. Adidas has a a discount rate of 16% on all projects. Should the project be undertaken, and if so what is its NPV