View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
AdmiralAJ AdmiralAJ is offline
external usenet poster
 
Posts: 18
Default Calculate Interest that compounds every 3 Years

I'm working on a trying to set up a formula for services where the cost increases 6% every 3 years over the next 15 years. The standard FV function doesn't seem to be the right formula because its based on annual compounding.

Anyone have a good formula for what I'm trying to achieve?

Thanks...AJ