Question

A local university has a goal of raising $500,000 for an escrow account. Their fund-raising committee has committed to raising $5,000 a month until they reach their goal. These funds are deposited into an interest-bearing account that earns interest at the rate of 8 percent per year compounded monthly. The first deposit is made at the end of the current month. How many months (aka how many deposits) can the committee expect to continue their fund-raising campaign

Answer 1

Answer: 77 months

Explanation:

Use the NPER function on Excel to find the answer.

Rate is compounded monthly so:

= 8% / 12

= 0.66667%

Payment = 5,000 per month

Present value = $0

Future value = 500,000

Value should be = 76.87 months

= 77 months