5-70). How would you solve the following problem using the Microsoft Excel functions in the photo I've attached? "The following costs are associated with three tomato peeling machines being considered for use in a canning plant. If the canning company uses an interest rate of 12%, which is the best alternative? Use NPW to make your decision. (Note: Consider the least common multiple as the study period)."

interest rate is 6%, which alternative should be selected? alternatives. Which alternative should be selected? (a) If an 8% interest rate is used? (b) If a 12% interest rate is used? The following costs are associated with three tomato- peeling machines being considered for use in a canning plant. If the interest rate of 12%, which is the best alterna- tive? Use NPW to make your decision. (Note: Consider the least common multiple as the study period.) 5-70 canning company uses an 5-73 Given the following data, use present worth analysis to find the best alternative, A, B, or C Initial cost 10,000 15,000 $:20) Annual benefit 6,000 10,000 ,cou Salvage value 1,0002,000 ,00 Machine Useful life 2 years 3 years 4years First cost O&M costs Annual benefit 38,000 31,000 Salvage value 13,00019,000 Useful life (yrs)4 $52,000 $63,000 $67,000 15,000 9,000 12,000 37,000 22,000 Use an analysis period of 12 years and 10% interest. 12 5-74 An investor has carefully studied a number of com- A panies and their common stock. From his analysis, he has decided that the stocks of six firms are the NPV Returns the net present value of an investment based on a series of periodic cash flows and a discount rate (Does not include year zero) PV Returns the present value of an investment (P|A,i,n), (PIF,i.n) PMT Returns the periodic payment for an annuity (AjP,i,n), (AlF,i,n) FV Returns the future value of an investment (FA,i,n), (FIP,i,n) IRR Returns the internal rate of return for a series of cash flows (IRR) MIRR Returns the internal rate of return where positive and negative cash flows are financed at different rates (ERR?)