MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Compound interest


Posted by Paul on January 05, 2001 10:06 AM

Can excel do compound interest? If so what would the formula be If the starting amount was $10,000 at 6% interest, compounded monthly, for a term of one year. Thanks for your help in advance.


Posted by SJC on January 05, 2001 11:36 AM


10000*(1+(6%/12))^12