Because of a chronic water shortage in California, new athletic fields must use artificial turf or xeriscape landscaping. If the value of the water saved each month is $6000, how much can a private developer afford to spend now on artificial turf provided he must recover his investment in 5 years. Use an interest rate of 18% per year, compounded continuously? Write the spreadsheet function to display the answer.
What will be an ideal response?
18% per year = 18/12 = 1.50% per month
i = e 0.015 – 1 = 1.51% per month
P = 6000(P/A,1.51%,60)
= 6000{[(1 + 0.0151) 60 – 1]/[0.0151(1 + 0.0151) 60 ]}
= 6000(39.2792)
= $235,675
Spreadsheet: = = - PV(EFFECT(1.5%,10000),60,6000,) displays $235,596
You might also like to view...
Al disponer una zanca por medio de una escuadra de carpintero, la hoja de la escuadra representa la ______ y la lengüeta representa la ______.
a. profundidad de la huella, altura de la contrahuella b. altura de la contrahuella, profundidad de la huella c. profundidad de la huella, largo de la zanca d. largo de la zanca, profundidad de la huella
You can view general Emacs documentation by entering ____ (press this one or two times) while you are in Emacs.
A. Alt+? B. Ctrl+? C. Alt+h D. Ctrl+h
What is the difference between a zoetrope and an azeotrope?
What will be an ideal response?
Ultra-high frequencies (UHF) operate in the ________ bandwidth.
A. 33 MHz- 45MHz B. 150 MHz-174 MHZ C. 450 MHz- 460 MHz D. 800 MHz-900 MHz