Compound Interest with Fixed amount added each year

[anuradhagrewal]

Hi
I need to calculate compound interest with the following variable
The principal value is : 100000
Now I need to calculate in row the following
1st year PV : 100,000 at 4% interest rate
2nd Year PV (100000 fixed) + (100000 X 4% PA)
So and so forth till 15 yrs.
I need this information all in one row
For eg
Projections of Final amount at 4% interest rate at the end of 15 yrs

Plz help as I am not able to figure it out.

Rgds

Anuradha

 

[mohadin]

HI
May be

=$A$2+A2*4/100