Question

In: Finance

El Paso Water Utilities (EPWU) purchases surface water for treatment and distribution to EPWU customers from...

El Paso Water Utilities (EPWU) purchases surface water for treatment and distribution to EPWU customers from El Paso County Water Improvement District during the irrigation season. A new contract between the two entities resulted in a reduction in future price increases in the cost of the water from 10% per year to 5% per year for the next 20 years. If the cost of water next year (which is year 1 of the new contract) will be $530 per acre-ft. using an interest rate of 10% per year,

a) Determine the difference between present worth (in $/acre-ft) of the old and the new contracts (solve using both formula and spreadsheet functions).

b) If new contract also needs a future payment of $2,000 at year 20, what is the equivalent annual worth of the new contract? (solve using both table values and spreadsheet functions)

Solutions

Expert Solution


Related Solutions

Who gains from the action for Kinder Morgan in El Paso, in what ways, and for...
Who gains from the action for Kinder Morgan in El Paso, in what ways, and for what reasons?
8. A water treatment plant with a surface water intake source is being designed for a...
8. A water treatment plant with a surface water intake source is being designed for a municipality that has a water demand of 18 million gallons per day (MGD). It has been determined that the maximum daily summertime water temperature is 20oC, and the minimum daily wintertime water temperature is 5oC. It has been determined that the design of the disinfection system must achieve 2.5-log credit for Cryptosporidium removal or inactivation. Ozone will be used as the disinfectant with a...
. Sketch the layout for a typical conventional surface water treatment plant. Label each process. Briefly...
. Sketch the layout for a typical conventional surface water treatment plant. Label each process. Briefly describe the different water treatment processes and their basic functions.
what do the different schedules mean for long term 2 enhanced surface water treatment rule?
what do the different schedules mean for long term 2 enhanced surface water treatment rule?
what do the different schedules mean for long term 2 enhanced surface water treatment rule?
what do the different schedules mean for long term 2 enhanced surface water treatment rule?
Design a system to move 100 gpm of water from a river with surface water elevation...
Design a system to move 100 gpm of water from a river with surface water elevation of 201.35 ft msl to a tank with surface water elevation = 246.55 ft msl. The tank is pressurized; the air pressure in the tank is 60 psig. The total length of pipe is 125 ft with 6 standard elbows all made of Sch 40 steel pipe. Your design should specify the nominal diameter of pipe (use only commercially available sizes) and the power...
Calculate the cash received from customers Calculate the purchases figure Calculate the cash paid for purchases
Using the following information, you will need to answer the questions below.Account20192020Inventory46,70042,100General Expenses8,200Cost of Sales116,200Advertising Expense6,500Accounts Receivable39,20042,500Wages Payable6,2007,800Insurance Expense8,000Depreciation Expenses15,900Prepaid Advertising9001,200Interest Income9,700Accounts Payable21,40018,700Doubtful Debts Expense5,200Interest Expense12,600Interest Receivable200600Tax Expense16,900Sales Income263,800Tax Payable5,2004,600Interest Payable2,8003,100Wages Expense51,300Prepaid Insurance900400Required:Answer the following questions (you must show your calculations for each answer):Calculate the cash received from customersCalculate the purchases figureCalculate the cash paid for purchasesCalculate the cash paid for expensesCalculate the cash received from interest incomeCalculate the cash paid for interest expenseCalculate the cash paid for tax expense
Water will be pumped from a reservoir free surface of which is at an elevation of...
Water will be pumped from a reservoir free surface of which is at an elevation of “z1” to reservoir the free water surface of which is at “z2”. Both of the reservoirs’ free surfaces at atmospheric pressures.Design a piping system that transmits water from the lower reservoir to the upper reservoir at a volumetric flow rate of Q (m3 /h). Q = 200 (m3/h) Za = 10(m) Zb= 60 (m) Zc = 75 (m) L1=200 (m) L2=125 (m) "Pipe material...
Water will be pumped from a reservoir free surface of which is at an elevation of...
Water will be pumped from a reservoir free surface of which is at an elevation of “z1” to reservoir the free water surface of which is at “z2”. Both of the reservoirs’ free surfaces at atmospheric pressures.Design a piping system that transmits water from the lower reservoir to the upper reservoir at a volumetric flow rate of Q (m3 /h). Q = 200 (m3/h) Za = 10(m) Zb= 60 (m) Zc = 75 (m) L1=200 (m) L2=125 (m) "Pipe material...
Out of 10 customers- Customer A purchases the most products from a company but is not...
Out of 10 customers- Customer A purchases the most products from a company but is not the most profitable for the company (Customer B is the most profitable out of the 10 customers), what concerns might you have from an audit perspective?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT