I need help in calculating compounding interest on monthly basis

Resolved · Urgent Priority · Version 2007

Thu 18 Sep 2008, 11:59 Delegate Mabel said...

Mabel has attended:
Excel Advanced course
Access Intermediate course

I need help in calculating compounding interest on monthly basis

The loan amount is

Thu 18 Sep 2008, 12:38 Edited on Thu 18 Sep 2008, 12:40 Trainer David said...

RE: I need help in calculating compounding interest on monthly b

Hi Mabel

Interestingly Excel does not have a built in function for compounding interest but there is a useful resource on their website that shows how you can get round this.

Please see the following link:
http://support.microsoft.com/kb/141695

Hope that helps.

Thu 18 Sep 2008, 12:58 Trainer David said...

RE: I need help in calculating compounding interest on monthly b

Another way you could do this monthly is if cell A1 is the capital amount of

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Multiple Lines of Text in a Cell

As an alternative to the Text Wrapping facility, type a word or two, press Alt+Enter to get a new line, type more text, and continue the process for as many lines as you need. Enter as normal when you have finished.

The line break is not affected by changing the column width, as text wrapping. To remove this you must edit the cell and remove the invisible character and replace with a normal space.

View all Excel hints and tips