Parker Hannifin of Cleveland, Ohio manufactures CNG fuel dispensers. It needs replacement equipment 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 expected use period. Also, write the FV spreadsheet functions that will display the correct future worth values.
 FIGURE 1.png)
FWD = -62,000[(F/P,15%,6) + (F/P,15%,3)] – 15,000(F/A,15%,6) + 8,000[(F/P,15%,3) + 1]
= -62,000[(2.3131) + (1.5209)] – 15,000(8.7537) + 8,000[(1.5209) + 1]
= $-348,846
FWE = -77,000(F/P,15%,6) – 21,000(F/A,15%,6) + 10,000
= -77,000(2.3131) – 21,000(8.7537) + 10,000
= $-351,936
Select option D
Spreadsheet functions:
Option D: = - FV(15%,6,-15000,-62000) - FV(15%,3,,-54000) + 8000
Option E: = - FV(15%,6,-21000,-77000) + 10000
You might also like to view...
When a motor must be started and stopped from more than one location, ____.
a. any number of start and stop buttons may be connected b. the number of start and stop buttons that may be connected varies with its size c. the number of start and stop buttons that may be connected varies with its rating d. two to four start and stop buttons may be connected
What is the diameter of the hole shown at red balloon 7?
What will be an ideal response?
The area of a triangle can be determined if the height is unknown.
Answer the following statement true (T) or false (F)
The current flowing into each junction of a parallel circuit ________ the current flow at the junction on the opposite end of that branch
A) Is more than B) Equals C) Is less than D) None of these