how to write a formula for year by year increase 5% without extra row adding

[GVN KUMAR]

sir
no of cap each Rs. 0.25
50,82,000 12,70,500
63,50,400 15,87,600
66,52,800 16,63,200
69,55,200 17,38,800
72,57,600 18,14,400
75,60,000 18,90,000
78,62,400 19,65,600
HOW TO INCREASE RATE EVERY YEAR 5% ON B2 ROW
HOW TO WRITE A FORMULA WITHOUT ADDING EXTRA ROW DIRECT FORMULA
sample file attache

 

[GraH - Guido]

Hi GVN KUMAR, you have managed to explain this rather cryptic for me.
B2 is a cell reference, not a row. I guess, you do mean for the full 2nd row?
What is an extra row direct formula? I guess, you want a single formula in the 2nd row (the one already in that row) an on top of that, in the same formula, increase the result by 5 percent?
Is that a correct understanding, or am I far off track?
If on track, try in C3 =($B3*C2)*1,05 and drag to the right.

 

[GVN KUMAR]

Sir
my requirement sir
its ok sir but every year increase on increased cost
GraH - Guido 5% increase every year sir
1270500 1270500
1666980 1666980
1746360 1833678
1825740 2012878
1905120 2205414
1984500 2412172
2063880 2634091

sample file attached sir

sir 5% increased on every year on previous year amount
1st 0.25 2nd year 0.26 3rd year 0.28

 

[Hareesh_KLD]

Hi GVN Kumar,

Check Sheet2 in attached workbook

 

[bosco_yip]

Sir
my requirement sir
its ok sir but every year increase on increased cost
GraH - Guido 5% increase every year sir
1270500 1270500
1666980 1666980
1746360 1833678
1825740 2012878
1905120 2205414
1984500 2412172
2063880 2634091

sample file attached sir

sir 5% increased on every year on previous year amount
1st 0.25 2nd year 0.26 3rd year 0.28

In C5, formula copied across right :

=C2*$B4*1.05^(COUNT($C2:C2)-1)

Regards
Bosco

 

[GVN KUMAR]

yes its correct sir
thank you sir
thank you a lot for saving of time and xls sheet space
thank you sir