Excel

Parker Hannifin of Cleveland, Ohio manufactures CNG ment to streamline one of its production lines for a new contract, but plans to sell the equipment at or before its expected life is reached at an estimated market value for used equipment. Select between the two options using the corporate MARR of 15% per year and a future worth analysis for the ex- pected use period. Also, write the FV spreadsheet functions that will display the correct future worth values 5.28 fuel dispensers. It needs replacement equip- Option First cost, $ AOC, S per year Expected market value,$ Expected use, years -62,000 15,000 8,000 77,000 -21,000 10,000 6 Parker Hannifin of Cleveland, Ohio manufactures CNG ment to streamline one of its production lines for a new contract, but plans to sell the equipment at or before its expected life is reached at an estimated market value for used equipment. Select between the two options using the corporate MARR of 15% per year and a future worth analysis for the ex- pected use period. Also, write the FV spreadsheet functions that will display the correct future worth values 5.28 fuel dispensers. It needs replacement equip- Option First cost, $ AOC, S per year Expected market value,$ Expected use, years -62,000 15,000 8,000 77,000 -21,000 10,000 6