Ok, I have the following formula whe

i = interest rate
A = payment at beginning of period
n = number of payment periods
g = growth rate

(((1+i)^n-(1+g)^n)/(i-g))*A

Now this gives me the answer when I have only one payment per year(A) over a
number of years(n). It does not work if I want 12 payments per year, and the
growth ia anuually. If I change the number of payments to the number of
months, this formula will grow the premium each month by 5% which is not what
I want.

Any help with this please!

"Simba" wrote:

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.