In order to provide drinking water as part of its 50-year plan, a west coast city is considering constructing a pipeline for importing water from a nearby community that has a plentiful supply of brackish ground water. A full-sized pipeline can be constructed at a cost of $122 million now. Alternatively, a smaller pipeline can be constructed now for $80 million and enlarged 20 years from now for another $100 million. The pumping cost will be $25,000 per year higher for the smaller pipeline during the first 20 years, but will be approximately the same thereafter. Both pipelines are expected to have the same useful life with no salvage value. (a) At an interest rate of 6% per year, which alternative is more economical? (b) Write the spreadsheet function to display the PW for the smaller pipeline alternative.
In order to provide drinking water as part of its
50-year plan, a west coast city is considering
constructing a pipeline for importing water from a
nearby community that has a plentiful supply of brackish ground water. A full-sized pipeline can be
constructed at a cost of $122 million now. Alternatively,
a smaller pipeline can be constructed now
for $80 million and enlarged 20 years from now for
another $100 million. The pumping cost will be
$25,000 per year higher for the smaller pipeline
during the first 20 years, but will be approximately
the same thereafter. Both pipelines are expected to
have the same useful life with no salvage value.
(a) At an interest rate of 6% per year, which alternative
is more economical? (b) Write the spreadsheet
function to display the PW for the smaller
pipeline alternative.
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 3 images
