View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
PatJennings PatJennings is offline
external usenet poster
 
Posts: 19
Default Calculating compound interest

I have a column of years and a column of numbers representing annual
amounts placed in a savings account for the year. I would like to calculate
the balance of interest earned added to the balance of the account and then
calculate the interest earned on the accumulating amounts each year. The
results would be the account balance displayed in an adjoining column. So
far, I have not found a worksheet function for that. Could someone point me
in the right direction? Perhaps there should be several columns of data?
Thanks