J

#### jconnalyjr

for the big day. I have made a spreadsheet that will allow me to input

estimated rates, current salary, and different sources of retirement

income compared to different dates to retirement.

The problem that I'm having is that the results of my estimated

supplemental retirement using Excel and my TI BA II Plus don't have the

same results.

The formula that I'm using is:

=FV(E6,DAYS360(E3,E20)/360,E4*0.1/12,-E5,1)

E6=rate

E3="Now" date

E20=Desired Retirement Date

E4=Current monthly salary * 10%

-E5=Current Value of Supplemetal Retirement

The dividing by number of days by 360 and the percent of monthly

contributions by 12 were added to try and make things work.

Basically, I need to know what the value of my account will be in the

future with a current balance with monthly contributions, between a

date range at a specified % rate.

I hope that this makes sense.

Thank you,

John