please answer these questions on excel w clear steps show all work including equations

1) Given the following two alternative investments which would you prefer using NPV and a 10% discount rate. Consider a 5 vear investment period. 2) You have been asked to decide on a method of inspection of parts. There are two methods. One includes manual labor and the other includes an automated process. The Manual labor costs the company $30,000/ year every year. The Automated machinery costs $100,000 initially and $5000/ year in maintenance. The machinery will last for 7 years. Using pretax analysis and 8% interest rate, which is preferred? 3) What is the navback for the following cashflow? 4) What is the discounted pavback for the following cashflow? Use 8% interest