All you have to ensure is that the rate that you use should be the same as
the period defined (monthly or yearly or daily) and of corse if you are
contributing at the end or at the beginning of the period.

Say you have a beginning balance of $100 and you contribute $10 every month
(beginning of the month) for 12 months.
From your question what I gather is "How miuch will be the value of your
account at end of 12 months?"
Say interest rate is 12%

Using this formula I know what I will have
=FV(12%/12,12,-10,-100,1)
= $240.78

you $100 will become =100*(1.01^12) = $112.68
and the 10 you are contrributing at the beginning of every month wil be come
==FV(12%/12,12,-10,,1) = $128.10
Adding the 2 you get $240.78





"jconnalyjr" wrote
in message ...

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