Environmental recovery company RexChem Part­ners plans to finance a site reclamation project that will require a 4-year cleanup period. If the com­pany borrows $4.1 million now, how much will the company have to get at the end of each year in order to earn 15% per year, compounded quarterly on its investment? Additionally, what is the spread­sheet function?

What will be an ideal response?


PP = year; CP = quarter; effective per PP needed

i = (1 + 0.15/4)4 – 1 * 100
= 15.865% per year

A = 4,100,000(A/P,15.865%,4)

Find factor value by interpolation, formula, or spreadsheet.

By formula: A = 4,100,000(0.35641) = $1,461,281 per year

By spreadsheet function: = PMT(15.865%,4,4100000)

A = $1,461,291 per year

Trades & Technology

You might also like to view...

¿Qué cemento suele NO usarse en la industria del aislamiento?

a. De acabado b. Refractario c. Para altas temperaturas d. Hidráulico

Trades & Technology

Which of the following describes the maximum amount of heat that can be released if all fuel is consumed?

A. Fire load B. Fuel load C. Thermal energy D. Heat of combustion

Trades & Technology

Which of the following is the correct method for troubleshooting an electronic time delay?

a. Check the time delay with a stopwatch and adjust as necessary. b. Check for the presence of smoke near the furnace. c. Look for an unbalanced flame. d. Check the input and output voltage to and from the time delay.

Trades & Technology

The driver of an emergency vehicle that uses lights and a siren can legally:

a. exceed the speed limit b. pass red lights c. All of the above

Trades & Technology