For excel you should write "=$N3*1.01^R" but you will need to change the R for each (increase by one each time) and I even made it so you can put it into one and drag it across with ease too
EDIT: I should explain it to.... $N3 is you initial value, 1.01 is the interest rate and keeping the principle amount and you times that by the time interval as this is the same as just putting another *1.01 on the end to get the next interval. If you do them individually and then substitute each equation in to the next then you would see exactly what I'm talking about.