ExcelBanter - Calculate Interest that compounds every 3 Years

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Calculate Interest that compounds every 3 Years (https://www.excelbanter.com/excel-worksheet-functions/451522-calculate-interest-compounds-every-3-years.html)

AdmiralAJ

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

All times are GMT +1. The time now is 10:43 PM.