A Texas chemical company had to file for bankruptcy because of a nationwide phase-out of methyl tertiary butyl ether (MTBE). The company is in the planning phase of reorganizing and expects to invest $50 million in a new ethanol production facility. Determine the revenue necessary each month to recover its investment in 3 years, plus interest at a rate of 2% per month, compounded continuously. Solve by (a) formula, and (b) spreadsheet function.

What will be an ideal response?


(a) i = e 0.02 – 1 = 2.02% per month
A = 50,000,000(A/P,2.02%,36)
= 50,000,000{[0.0202(1 + 0.0202) 36 ]/[(1 + 0.0202) 36 – 1]}
= 50,000,000(0.03936)
= $1,967,941
(b) = - PMT(EFFECT(2%,10000),36,50000000) displays $1,967,990

Trades & Technology

You might also like to view...

The test report specifies the test pressure and how long it must be maintained for hydrostatic testing. If it does not, the test pressure must be at least _____ times the maximum design pressure of the installation.

a. one and one-half b. two c. two and one-half d. three

Trades & Technology

If depth of fill is not indicated:

A) The hole is to be filled completely B) Fill to the lesser of the plate thicknesses C) It is up to the welder D) None of the above

Trades & Technology

The three-port valve has three positions.

Answer the following statement true (T) or false (F)

Trades & Technology

Express 5/16 as a decimal fraction rounded to the nearest hundredth.

What will be an ideal response?

Trades & Technology