View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Simba Simba is offline
external usenet poster
 
Posts: 4
Default Compound interest with premium growing

Hi

I would like to know if there is a formula/function to calculate the
following:

Start premium per month - eg $150
Premium increase per year - eg 5%
Number of years - eg 20years
Interest rate per year - eg 8%

I would like to have the end result, or final total amount and the formula
or function to calculate it, thanx.