At Westonci.ca, we make it easy for you to get the answers you need from a community of knowledgeable individuals. Explore comprehensive solutions to your questions from knowledgeable professionals across various fields on our platform. Experience the convenience of finding accurate answers to your questions from knowledgeable experts on our platform.

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

Thanks for using our service. We aim to provide the most accurate answers for all your queries. Visit us again for more insights. Thanks for stopping by. We strive to provide the best answers for all your questions. See you again soon. Westonci.ca is your go-to source for reliable answers. Return soon for more expert insights.