Environmental recovery company RexChem Partners plans to finance a site reclamation project that will require a 4-year cleanup period. If the company 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 spreadsheet 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
You might also like to view...
The MOST-Likely hose to have a metal wire molded within is the:
A. universal hose B. fuel hose C. by-pass hose D. formable hose
Why is lead pipe no longer used today?
A. It expands too much. B. It is too heavy. C. It breaks too easily. D. It is toxic.
Technician A says that proper starter operation depends on the battery being at a 95% charge and battery cables being of the correct size (gauge) and having no more than 0.8-volt drop. Technician B says that voltage-drop testing includes cranking the engine, measuring the drop in voltage from the battery to the starter, and measuring the drop in voltage from the negative terminal of the battery
to the engine block. Who is right? A) Technician A only B) Technician B only C) Both technicians D) Neither technician
Legends and symbols can be standard or one created by the drafter.
Answer the following statement true (T) or false (F)