Please use excel. Show formulas

Krueger Activity - Comparing and Prioritizing Multiple Projects Krueger Inc. has two potential capital investment projects. Both projects have made it through the screening process and now Krueger has to choose between the two projects. Due to the varying investment amounts and time horizons, selecting the best project has been difficult. or Eac ro ssume Krueger has a Tax Rate of Project 1: Updating the Machines in the Manufacturing Facility Initial cash paid for new machines is $10,000,ooo Krueger will be able to dispose of the old equipment it previously used for $1,ooo,ooo (At no Gain/Loss) The project will generate NOI of $goo,ooo per year (Excluding maintenance costs) New machines have a useful life of 8 years and a salvage value of $1,200,ooo Major maintenance is needed on the machine in Year 5, $500,ooo Project 2: Purchase an ERP Software System (Enterprise Resource Planning System) Initial Investment in software $2,0oo,ooo Initial Installation and training $2,ooo,oo0 Annual maintenance costs are $180,000 .Cost (cash) savings from the software before maintenance cost, $1,000,ooo Useful life of the software- 10 years with no salvage value Required for each project: 1. 2. 3. Using a discount rate of 10%, calculate the NPV of your project. Determine the profitability index of your project. Determine your project's payback period