I am one of those who is contstantly thinking of retirement and planning
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


--
jconnalyjr
------------------------------------------------------------------------
jconnalyjr's Profile: http://www.excelforum.com/member.php...o&userid=23981
View this thread: http://www.excelforum.com/showthread...hreadid=376004