View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
joeu2004 joeu2004 is offline
external usenet poster
 
Posts: 2,059
Default Compound Interest over the years

On Oct 2, 8:11 am, Rene wrote:
What is the function I use for showing me how much a fixed 6% annually will
yield over the years. For instance, on $100,000 the first year would yield
$106,000, the second year, how much, the fifth year, tenth, etc.


=fv(6%,A1,0,-100000)

where A1 is the number of years (1, 2, 5, 10).