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

"Wolsen" wrote in message
...
How do I do monthly compounding of a number? $100,000 @ 5% compounding
monthly for 5 years.

Excel 2002 SP3