El Paso Water is planning to install wind turbines to provide enhanced evaporation of reverse osmosis concentrate from its inland desalting plant. The company will spend $1.5 million in year 1 and $2 million in year 2. Annual maintenance is expected to cost $65,000 per year through year 10. Determine the equivalent annual cost of the project in years 1 through 10 at an interest rate of 6% per year. Also, develop a single-cell spreadsheet function to display the total A value.
What will be an ideal response?
First find P in year 0, then convert to equivalent A value over 10 years; add the annual maintenance.
In $1 million units,
P = 1.5(P/F,6%,1) + 2(P/F,6%,2)
= 1.5(0.9434) + 2(0.8900)
= $3.1591 million
A of investments = 3.1591(A/P,6%,10)
= 3.1591(0.13587)
= $434,118
Total A = 434,118 + 65,000 = $ 499,118
Spreadsheet function: = -PMT(6%,10, -PV(6%,1,,1500000) - PV(6%,2,,2000000)) + 65000
You might also like to view...
All amphibians are poikilotherms; that is, they are totally dependent on _____ to regulate body temperature and metabolic activity
a. a proper diet b. adequate oxygen c. other amphibians d. their environment
Shifting cultivation is characterized by:
A) an agroforestry system emphasizing intermixing of food crops and woody species. B) shifting from one food crop to another in alternate years. C) the shifting of land management of a given area from one farmer to another. D) alternating 2-3 years' food crop production with a much longer period of fallow. E) cutting and burning of woody species to reduce the C/N ratio of the crop residues.
This chapter describes the process collaborators went through in order to make this home:
A) A smoke-free environment B) Exactly like Sweetwater Sound C) Out of bamboo D) Sustainable
It is standard practice to give the first progress report when the project is 50% complete.
Answer the following statement true (T) or false (F)