Question

San Antonio is considering various options for providing water in its 50-year plan, including desalting. One...

San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million in year 7 and then declining production will decrease revenue by 10% each year. If the aquifer will be totally depleted in 20 years, what is the present worth of the desalting option at an interest rate of 6% per year?

Homework Answers

Answer #1

Year 7 revenue = 4.1
From Year 8 to Year continues decrease of 10%
Time = 20 years

A B C D E F G H I J K L M N
1 Year 7 8 9 10 11 12 13 14 15 16 17 18 19 20
2 Revenue with 10 % decrease after year 7 4.10 3.69 3.32 2.99 2.69 2.42 2.18 1.96 1.76 1.59 1.43 1.29 1.16 1.04
3 Rate 6%
Value at year 7 24.41 Uing excel formula = NPV(6%,B2:N2)+A3

PV of the above value =24.41/1.06^7 = 16.24

Best of Luck. God Bless
Please Rate Well

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The City of San Antonio is considering various options for providing water in its 50-year plan,...
The City of San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million per year for the first 4 years, after which less production will decrease revenue by 10% per year each year. If the aquifer will be totally depleted in 24 years, what is the present worth of the desalting option revenue at an interest rate of 6%...
The City of San Antonio is considering various options for providing water in its 50-year plan,...
The City of San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million per year for the first 4 years, after which less production will decrease revenue by 10% per year each year. If the aquifer will be totally depleted in 20 years, what is the present worth of the desalting option revenue at an interest rate of 6%...
The City of San Antonio is considering various options for providing water in its 50-year plan,...
The City of San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million per year for the first 5 years, after which less production will decrease revenue by 10% per year each year. If the aquifer will be totally depleted in 23 years, what is the present worth of the desalting option revenue at an interest rate of 8%...
The City of San Antonio is considering various options for providing water in its 50-year plan,...
The City of San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million per year for the first 3 years, after which less production will decrease revenue by 10% per year each year. If the aquifer will be totally depleted in 20 years, what is the present worth of the desalting option revenue at an interest rate of 6%...
The City of San Antonio is considering various options for providing water in its 50-year plan,...
The City of San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million per year for the first 5 years, after which less production will decrease revenue by 10% per year each year. If the aquifer will be totally depleted in 23 years, what is the present worth of the desalting option revenue at an interest rate of 8%...
The City of San Antonio is considering various options for providing water in its 50-year plan,...
The City of San Antonio is considering various options for providing water in its 50-year plan, including desalting. One brackish aquifer is expected to yield desalted water that will generate revenue of $4.1 million per year for the first 5 years, after which less production will decrease revenue by 10% per year each year. If the aquifer will be totally depleted in 21 years, what is the present worth of the desalting option revenue at an interest rate of 9%...
In order to provide drinking water as part of its 50-year plan, a west coast city...
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 $125 million now. Alternatively, a smaller pipeline can be constructed now for $75 million and enlarged 18 years from now for another $110 million. The pumping cost will be $25,000 per year higher...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
Using the model proposed by Lafley and Charan, analyze how Apigee was able to drive innovation....
Using the model proposed by Lafley and Charan, analyze how Apigee was able to drive innovation. case:    W17400 APIGEE: PEOPLE MANAGEMENT PRACTICES AND THE CHALLENGE OF GROWTH Ranjeet Nambudiri, S. Ramnarayan, and Catherine Xavier wrote this case solely to provide material for class discussion. The authors do not intend to illustrate either effective or ineffective handling of a managerial situation. The authors may have disguised certain names and other identifying information to protect confidentiality. This publication may not be...
What tools could AA leaders have used to increase their awareness of internal and external issues?...
What tools could AA leaders have used to increase their awareness of internal and external issues? ???ALASKA AIRLINES: NAVIGATING CHANGE In the autumn of 2007, Alaska Airlines executives adjourned at the end of a long and stressful day in the midst of a multi-day strategic planning session. Most headed outside to relax, unwind and enjoy a bonfire on the shore of Semiahmoo Spit, outside the meeting venue in Blaine, a seaport town in northwest Washington state. Meanwhile, several members of...