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 8% per year

The present worth of the desalting option revenue is 29,567,434.81 or $29.6 million.

Explanation:

Note: Calculation of the present worth of the desalting option revenue.

In the attached excel file, the revenue from year 6 to 21 is calculated using the following formula:

Revenue in the current year = Revenue in the previous year * (100% - Decreasing rate) (1)

Where;

Decreasing rate = 10%

From the attached excel file, the present worth (in bold red color) of the desalting option revenue is 29,567,434.81 or $29.6 million.

income statement is prepared in order to show the profits and loss of a business. in order to prepare the income statement she should collect all the income and expenses of the product with the cost of production.

c

explanation: