

 Thread Tools  Search this Thread 
#1
 
 
I am looking for a formula to calculate compound interest in Excel
I would appreciate some help in locating a formula to calculate compound interest on an increasing principal. Can anyone please help. 
#2
 
 
Re: I am looking for a formula to calculate compound interest in Excel
If you add to the principal at a constant rate, and the interest rate doesn't change, then simple use the FV function. Otherwise, you need to use a step wise method, using a table of variable input to FV at every change in rate or principal addition. Or else follow the suggestions given in the below thread. How to Calculate Compound Interest 
#3
 
 
Re: I am looking for a formula to calculate compound interest in Excel
Hope this sample can help you out. The formula is * = End value of initial capital (1 + p) ^ n where p = interest rate (eg 0.05 for 5%) & n = term in years. There is also an Excel function: =FV (p, n, 0, initial capital). However, this throws a negative result out from there  that's why the sign is used. 
#4
 
 
Re: I am looking for a formula to calculate compound interest in Excel
For this function ZW is recommended. It returns the future value of an investment at a constant rate and constant payments if necessary. A more detailed description of the function can be seen on the Office Excel Help website. For example, the formula = FV (3% / 12; xx, 0, 1000, 1) if interest is paid monthly at 3%, or = ZW (3% yy, 0, 1000, 1) at annual compounding. Xx or yy is for the period to be entered: the number of months for xx, yy the number of years that you are interested. 1000 is the investment that you have started. 

Thread Tools  Search this Thread 

Similar Threads for: "I am looking for a formula to calculate compound interest in Excel"  
Thread  Thread Starter  Forum  Replies  Last Post 
Need Excel formula for Credit Card Interest Caculation  ELETTRA  MS Office Support  3  10052012 03:10 PM 
Need easy formula to calculate percentage in Microsoft Excel  cupid!  MS Office Support  2  23022012 03:57 PM 
How to calculate formula as per run rate in Excel  (Cowherd)  MS Office Support  2  15022012 03:58 PM 
Looking for Excel formula which can calculate Lease and Balloon Payments  Jigisha  MS Office Support  2  01022012 06:46 PM 
Formula to Calculate Rate of Change in Microsoft Excel  Lanka Boy  MS Office Support  2  14012012 02:49 PM 