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

Excel 2002 SP3

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

See also the FV function

--
Bernard Liengme
www.stfx.ca/people/bliengme
remove CAPS in email address


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

Excel 2002 SP3