ExcelBanter - compounding of a number in excel?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - compounding of a number in excel? (https://www.excelbanter.com/excel-worksheet-functions/7208-compounding-number-excel.html)

Wolsen

compounding of a number in excel?

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

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

Excel 2002 SP3

Bernard Liengme

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

All times are GMT +1. The time now is 12:58 PM.