add 5% in every year

[negi]

Dear All good evening,
i have a query in excel sheet, i have an amount in a column and we want the calculate amt in next col like as...

We want add 5 % in amt in every year.

Amt</SPAN>	Year </SPAN>	Reqd Amt</SPAN>
10000</SPAN>	5</SPAN>	55000</SPAN>
15000</SPAN>	4</SPAN>	64500</SPAN>
20000</SPAN>	3</SPAN>	63000</SPAN>
10000</SPAN>	2</SPAN>	20500</SPAN>
Example-1 1st Year</SPAN>	10000</SPAN>	B7</SPAN>
2nd Year</SPAN>	10500</SPAN>	B7+B7*5%</SPAN>
3rd Year</SPAN>	11000</SPAN>	B8+B7*5%</SPAN>
4th Year</SPAN>	11500</SPAN>	B9+B7*5%</SPAN>
5th Year</SPAN>	12000</SPAN>	B10+B7*5%</SPAN>
Total</SPAN>	55000</SPAN>	SUM(C7:C11)</SPAN>
Example-2
1st Year</SPAN>	15000</SPAN>	B14</SPAN>
2nd Year</SPAN>	15750</SPAN>	B14+B14*5%</SPAN>
3rd Year</SPAN>	16500</SPAN>	B15+B14*5%</SPAN>
4th Year</SPAN>	17250</SPAN>	B16+B14*5%</SPAN>
Total</SPAN>	64500</SPAN>	SUM(C14:C17) </SPAN>

<TBODY>
</TBODY><COLGROUP><COL span=2><COL></COLGROUP>

 

[negi]

dear mick
one of my team member who want to calculte the same but some change.
these calculation for annual only

Year	Amt
4	10000
1st year	10000	C5
2nd year	10500	C5+(C5*0.05)
3rd year	11025	C6+(C6*0.05)
4th Year	11576	C7+(C7*0.05)
total	43101	SUM(C5:C8)

<COLGROUP><COL style="WIDTH: 48pt" span=2 width=64><COL style="WIDTH: 59pt; mso-width-source: userset; mso-width-alt: 2889" width=79><TBODY>
</TBODY>

 

[MickG]

Try:-

=(10000*((1.05^4)-1))/0.05
Results = 43101.25