Question

You are planning to save for retirement over the next 35 years. To do this, you will invest $710 per month in a stock account and $310 per month in a bond account. The return of the stock account is expected to be 9.1 percent, and the bond account will earn 5.1 percent. When you retire, you will combine your money into an account with an annual return of 6.1 percent. Assume the returns are expressed as APRs.

How much can you withdraw each month from your account assuming a 30-year withdrawal period?

Answer 1

Calculating Future Value from Stock Account,

Using TVM Calculation,

FV = [PV = 0, PMT = 710, N = 420, I = 0.091/12]

FV = $2,142,043.90

Calculating Future Value from Bond Account,

Using TVM Calculation,

FV = [PV = 0, PMT = 310, N = 420, I = 0.051/12]

FV = $360,116.49

Total Value = 2,142,043.90 + 360,116.49

Total Value = $2,502,160.39

Calculating Monthly Withdrawal,

Using TVM Calculation,

PMT = [PV = 2,502,160.39, FV = 0, N = 360, I = 0.061/12]

PMT = $15,162.96

Monthly Withdrawal = $15,162.96