Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Register Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



I am looking for a formula to calculate compound interest in Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 03-02-2012
Member
 
Join Date: Jan 2012
Posts: 41
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.

Reply With Quote
  #2  
Old 03-02-2012
Member
 
Join Date: Aug 2011
Posts: 557
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
Reply With Quote
  #3  
Old 03-02-2012
Member
 
Join Date: Aug 2011
Posts: 454
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.
Reply With Quote
  #4  
Old 03-02-2012
Member
 
Join Date: Jul 2011
Posts: 429
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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


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 10-05-2012 03:10 PM
Need easy formula to calculate percentage in Microsoft Excel cupid! MS Office Support 2 23-02-2012 03:57 PM
How to calculate formula as per run rate in Excel (Cowherd) MS Office Support 2 15-02-2012 03:58 PM
Looking for Excel formula which can calculate Lease and Balloon Payments Jigisha MS Office Support 2 01-02-2012 06:46 PM
Formula to Calculate Rate of Change in Microsoft Excel Lanka Boy MS Office Support 2 14-01-2012 02:49 PM


All times are GMT +5.5. The time now is 07:42 AM.