Step Up SIP Value Calculator

[necaisjackie]

I have made a visual calculator where it calculates the future value of regular periodic investments. These monthly investment contributions (popularly known as SIP - Systematic Investment Plan) can also increase by a certain percentage every year. So if contributions increase by 10% every year means if first 12 installments are of 5000/month, next 12 investments will be of 5500/month and so on. Every investment will grow at certain assumed annual rate of return also. I found the future value through a detailed year-wise calculation. But I want this to be done with the help of a single formula so that back calculation can also be done. Looking forward to your kind help and suggestions. File is attached herewith.