Looking for reliable answers? Westonci.ca is the ultimate Q&A platform where experts share their knowledge on various topics. Experience the ease of finding precise answers to your questions from a knowledgeable community of experts. Connect with a community of professionals ready to provide precise solutions to your questions quickly and accurately.

Detrich Products is planning to upgrade an aging manufacturing operation five years from now at a cost of $100,000. If the company plans to deposit money into an account each year for four years beginning two years from now (first deposit is in year 2) to pay for the expansion, the amount of the deposit at 10% per year interest is closest to

Sagot :

Answer:

$21,547.08

Explanation:

To get the amount of the deposit, we use the PMT function of MS Excel

Rate = 10%

Nper = 4

Pv = 0

FV = -100000

PMT = ?

The amount of the deposit = PMT(Rate, Nper, PV, -FV)

The amount of the deposit = PMT(10%, 4, 0, -100000)

The amount of the deposit = 21547.08037

The amount of the deposit = $21,547.08

So, the amount of the deposit at 10% per year interest is closest to $21,547.08