• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Sum of simple interest annuity with increase in rate every year


New Member
Hi all,

Analyzing an Insurance policy which pays an annuity which increases by 5% every year (simple). So if the annuity is Rs. 100 in the first year, it will be Rs. 105, 110, 115, 120 etc, in succeeding years, going up to 195 in the 20th (Final) year.

Starting annuity amount in cell A1
number of benefit years in A2
increase rate (simple, 5%) in A3

What would be the formula to calculate the Total annuity amount received over the number of benefit years?

Thanks in advance!