Answer:
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.