I need to use the FUTURE VALUE function in cell E23 to calculate Target value
of the porfolio in 20 YEARS. using cell C20=0.075 as the rate of return,
C21=2500 as the target payments to be made every year for the next 20 YEARS,
and F17=89125 as the one-time lump sum of payment.
It is suppose to calculate payments being made at the beginning of the period.

any help is greatfully recieved :)

thank you thank you thank you

This assumes one payment of $89,125 now plus one payment of $2,500 now and
nineteen more payments of $2,500 at one year interval. The result is the
value 20 years from now assuming an annual return of 7.5%.

=FV(C20,20,-C21,-F17,1)

That should get you started, but I am a unsure about the first payment of
$2,500.

Tom

that was it thanks so much, I was putting some stuff in the wrong order and I
knew when I got 13.20 something or another that that was completely wrong.
THANK YOU!!

"TomPl" wrote:

This assumes one payment of $89,125 now plus one payment of $2,500 now and
nineteen more payments of $2,500 at one year interval. The result is the
value 20 years from now assuming an annual return of 7.5%.

=FV(C20,20,-C21,-F17,1)

That should get you started, but I am a unsure about the first payment of
$2,500.

Tom