compounding of a number in excel?

[Guest]

How do I do monthly compounding of a number? $100,000 @ 5% compounding
monthly for 5 years.

Excel 2002 SP3

 

[N Harkawat]

Assuming 5% per year equals 5/12 % per month
=100000*(1+5/1200)^60

 

[Bernard Liengme]

See also the FV function