Question

You plan on making a $235.15 monthly deposit into an account that pays 3.2% interest, compounded monthly, for 20 years. At the end of this period, you plan on withdrawing regular monthly payments. Determine the amount that you can withdraw each month for 10 years, if you plan on not having anything in the account at the end of the 10 year period and no future deposits are made to the account.

Answer 1

Answer:

Monthly payment = $769.27

Explanation:

First we have to determine the future value of the ordinary annuity:

Payment = $235.15

N = 20 * 12 = 240

Rate = 3.2% / 12 = 0.267%

Using a financial calculator and the FV function, the FV = $78,910.41

Again, using the financial calculator or Excel, you can determine the monthly payment:

N = 10 / 12 = 120

Rate = 0.267%

PV = $78,910.41

FV = $0

Monthly payment = $769.27