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

Trades & Technology

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

Trades & Technology

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

Trades & Technology

What is the difference between a zoetrope and an azeotrope?

What will be an ideal response?

Trades & Technology

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

Trades & Technology