For the following five spreadsheet functions, (a) write the values of the engineering economy symbols P, F, A, i, and n, using a ? for the symbol that is to be determined, and (b) state whether the displayed answer will have a positive sign, a negative sign, or it can’t be determined from the entries.
(1) = FV(8%, 10, 3000, 8000)
(2) = PMT(12%, 20, –16000)
(3) = PV(9%, 15, 1000,600)
(4) = NPER(10%, –290,, 12000)
(5) = FV(5%, 5, 500, –2000)
(a) (1) F = ?; i = 8%; n = 10; A = $3000; P = $8000
(2) A = ?; i = 12%; n = 20; P = $-16,000; F = 0
(3) P = ?; i = 9%; n = 15; A = $1000; F = $600
(4) n = ?; i = 10%; A = $-290; P = 0; F = $12,000
(5) F = ?; i = 5%; n = 5; A = $500; P = $-2000
(b) (1) negative
(2) positive
(3) negative
(4) positive (years)
(5) can’t determine if 5% per year will cover the 5 withdrawals of $500
You might also like to view...
If a technician needs to check the refrigerant pressures on a system with a small charge:
A) A short refrigeration gauge should be used. B) A standard gauge manifold set should be connected to both sides of the system. C) Only the low side of the gauge manifold set should be connected. D) Only the high side of the gauge manifold set should be connected.
Why are brake rotor designed with vents?
A) To aid cooling B) To reduce weight C) For manufacturing ease D) To increase strength
Heartworm infection is transmitted via feces ingestion
Indicate whether the statement is true or false
The longest run method for sizing fuel gas piping bases pipe capacities on which of the following lengths?
a. the appliance that is closest to the meter b. the appliance that is farthest from the meter c. the appliance that is half the distance to the meter d. none of the above