Solve Problem 13 using a function for net present value, such as @NPV (x, range) in Exce...

Solve Problem 13 using a function for net present value, such as @NPV (x, range) in Excel.

Reference:

Alamo Foods of San Antonio wants to introduce a new computer system for its perishable products warehouse. The costs and benefits are as follows:

a. Given a discount rate of 8 percent (.08), perform present value analysis on the data for Alamo Foods. (Hint: Use this formula: to find the multipliers for years 1 to 6.)

b. What is your recommendation for Alamo Foods?