Can someone please help me with the answers/ how you got there? Thank you so much I have been struggling for days!!!

Commercial Data (US Funds) Program Volume Quoted Engineerin Tooling lg Design & Year 1-100k Quoted Price Price First First Year Year 3 150 Supplier Supplier APV Year APV Year APV Year Year Lead Time APV Annual Total Cost ist Year Productivity (eZ.3% for Year 2- 150K NPV - Net Present Value 4 Tooling (#of Int (ED&D) kick-Of Date Purchase Value-1st!IAPV + Tool ing Cost. (Team expected to calculate NPV) ED&D) SupplierYear 4 200k Nafta Plant EMEA Plant 3 years) Cost Weeks) Cost American Fastener Year Technology! See above! $ 0.02900|$0.02560| 2% |$40,000| 44 |$85,000|12/1/2018 Hommel | See above | S 0.02840 | S 0.02510 | 2% | S 45,000 | 45 | S 30,000 | 12/1/2018 Clips & Fasteners | See above | $ 0.03240 | $ 0.02980 | 3% S,50020 018 ITW Fastener Group Acument Total: | See above | $ 0.02840 | $0.02540 | See above! $0.03050|$0.02654| 2% 496 31,000 12/1/2018 35,900 12/1/2018 88,000 46 | $100,000| 42 Factors to Conside US to Euro Exchange Rate 1.2 2. Supplier Kick-off (start) date December1, 2018 3. Production Start Date (Job1) January 1, 2020 4. 60% of volume (column C) will be assembled at the OEM's NAFTA plant (Sterling Heights MI) & 40% at the EMEA plant (Turin Italy) 5. NPV calculation for cost of money = 10% Commercial Data (US Funds) Program Volume Quoted Engineerin Tooling lg Design & Year 1-100k Quoted Price Price First First Year Year 3 150 Supplier Supplier APV Year APV Year APV Year Year Lead Time APV Annual Total Cost ist Year Productivity (eZ.3% for Year 2- 150K NPV - Net Present Value 4 Tooling (#of Int (ED&D) kick-Of Date Purchase Value-1st!IAPV + Tool ing Cost. (Team expected to calculate NPV) ED&D) SupplierYear 4 200k Nafta Plant EMEA Plant 3 years) Cost Weeks) Cost American Fastener Year Technology! See above! $ 0.02900|$0.02560| 2% |$40,000| 44 |$85,000|12/1/2018 Hommel | See above | S 0.02840 | S 0.02510 | 2% | S 45,000 | 45 | S 30,000 | 12/1/2018 Clips & Fasteners | See above | $ 0.03240 | $ 0.02980 | 3% S,50020 018 ITW Fastener Group Acument Total: | See above | $ 0.02840 | $0.02540 | See above! $0.03050|$0.02654| 2% 496 31,000 12/1/2018 35,900 12/1/2018 88,000 46 | $100,000| 42 Factors to Conside US to Euro Exchange Rate 1.2 2. Supplier Kick-off (start) date December1, 2018 3. Production Start Date (Job1) January 1, 2020 4. 60% of volume (column C) will be assembled at the OEM's NAFTA plant (Sterling Heights MI) & 40% at the EMEA plant (Turin Italy) 5. NPV calculation for cost of money = 10%