Assuming you mean "monthly compounding".

=(1+0.05/12)^12*10000-10000

= $511.62





Don Pistulka

"Usedtobesmart" wrote in message
...
I need to know if I deposit a fix amount (i.e. $10,000) at a fixed interest
rate (i.e.5%)
what is the compound interest at the end of the year. Need one formula in
one cell not a schedule by month