View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Hillary: needing some help[_2_] Hillary: needing some help[_2_] is offline
external usenet poster
 
Posts: 7
Default future calue using target value and rate of return

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