Data Visualization at HydroHappy PROBLEM 3 - Data visualization can be used to help analyze investment decisions. HydroHappy's managers believe the net present value method provides the best information to make capital budgeting decisions. In addition, the NPV analysis indicates that purchasing new forklifts will result in a higher return than retaining a overhauling the old forklifts. As such, management plans to pursue the purchase of new forklifts with an estimated productive life of 8 years. The production engineers have indicated that there are several different models of forklifts, one of which may be a better option than the other models used in the analysis. The accountant has gathered the following data concerning the purchase prices and has estimated the net annual cash flow and salvage values of eight models. Instructions There are six parts to this problem. Use Excel to perform the following: a. For each possible investment, A through H, determine the net present value using the NPV function at 8%,7%,6%,5%, and 4% discount rates, and determine the profitability index at 6% for each investment. a. Table of cash flows, NPVs, and profitability indices for eight investments Data Visualization at HydroHappy PROBLEM 3 - Data visualization can be used to help analyze investment decisions. HydroHappy's managers believe the net present value method provides the best information to make capital budgeting decisions. In addition, the NPV analysis indicates that purchasing new forklifts will result in a higher return than retaining a overhauling the old forklifts. As such, management plans to pursue the purchase of new forklifts with an estimated productive life of 8 years. The production engineers have indicated that there are several different models of forklifts, one of which may be a better option than the other models used in the analysis. The accountant has gathered the following data concerning the purchase prices and has estimated the net annual cash flow and salvage values of eight models. Instructions There are six parts to this problem. Use Excel to perform the following: a. For each possible investment, A through H, determine the net present value using the NPV function at 8%,7%,6%,5%, and 4% discount rates, and determine the profitability index at 6% for each investment. a. Table of cash flows, NPVs, and profitability indices for eight investments