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)
What will be an ideal response?
(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...
A physical print produced by a printer or plotter is a:
a. print b. hard copy c. soft copy d. document
Bill uses 28 acres for his horses. He applied 45-60-50 units of fertilizer per acre using 46-0-0 urea at $505 per ton, 18-46-0 DAP at $710 per ton, and 0-0-60 muriate of potash at $571 per ton. He reseeded with 14 pounds of orchard grass per acre at $1.32 per pound and 2.2 pounds of clover per acre at $3.45 per pound.
a. How many pounds of fertilizer were applied per acre? b. What did the fertilizer cost? c. What did the seed cost?
Shade screens are often installed in greenhouses. Most of these usually perform a second role in addition to reducing light intensity during bright days. What other role could be performed?
What will be an ideal response?
In a series circuit:
A) The current stays the same throughout the circuit. B) The resistance stays the same throughout the circuit. C) The wattage stays the same throughout the circuit. D) The voltage stays the same throughout the circuit.