Compute the Net Present Value of each project. Examine the Internal Rate of Return for each project. Compute the Profitability Index for all projects. Use the PV() function to determine the TVM factors. Be sure to put a "-" sign before the function and for cash out flows, and use "1" as the PMT and FV amounts as necessary. Automation Event Amount Factor NPV Initial Cost $(650,000) 1.000000 $(650,000.00) Net Income (annual) $64,000 0.321973 $20,606.29 Depreciation Expense (annual) $(64,000) $- Working Capital $25,000 $- Salvage Value $90,000 $- NPV Hire Extra Crew Event Amount Factor NPV Initial Cost $(91,000) 1.000000 Net Income (annual) NPV Acquire a Supplier Event Amount Factor NPV Initial Cost $(1,200,000) 1.000000 Net Income (annual) NPV Purchase Latest Model of Equipment Event Amount Factor NPV Initial Cost $(435,000) 1.000000 Net Income (annual) Depreciation Expense (annual) Repair at year 4 Salvage Value NPV Which project's IRR is closest to the Hurdle Rate? Which project has an IRR lower than the Hurdle Rate? Use the SUM() function in the calculated NPV charts and the Initial Cost in the original data to compute Profitability Index.