Excel Templates | Excel Spreadsheets | Compound Interest Calculator


Free Excel Templates

Compound Interest Calculator

Posted on September 15, 2009
Filed Under Finance | 9 Comments



Share

If you are not a finance people or don’t know much about finance but want to know how the banks calculate your savings or loans amounts, you should understand compound interest first.

Compound Interest Calculator

Compound interest is an interest that arises when interest is added to the principal everytime the interest is due, so the total amount will be calculated together to earn next interest. The addition of interest to the principal to get another interest is called compounding. You will see that some banks put advertisement about daily interest rate, weekly interest rate which mean your savings amount will grow based on that interest period. For example,  a saving with $100 initial principal and 1% interest per month would have a balance of $101 at the end of the first month, $102.01 at the end of the second month, and so on.

This compound interest also applicable for loan. So, make sure that you read carefully your loan terms especially about how your lender apply the interest terms. This compound interest calculator is a simple calculator that will calculate the future value of your savings or loan amount based on daily, weekly, quarterly, semi-annually and annually compounded period. And you can also see how the total interest applied to your savings or loans based on that compounded period.

You can download the file here.




You can read and download my other templates below :

Tags: , , ,

Comments

9 Responses to “Compound Interest Calculator”

  1. nasir on October 3rd, 2009 7:20 am

    for business plan

  2. Dave on April 25th, 2010 2:36 pm

    Very useful tool. Thanks.

  3. Javed on October 25th, 2010 5:42 am

    For personnel use

  4. nikhil on March 13th, 2011 3:55 pm

    hi,
    good work, thanks but the result for quarterly compounded is same as anually compounded. plz correct it.

  5. Pano on April 9th, 2011 8:52 pm

    ?????????

  6. Robb Reel on August 29th, 2011 6:24 pm

    The quarterly calculations on this form are not correct… The quarterly output will not be the same as the annual output.. This form needs to be rechecked and verified.

  7. Joseph on October 24th, 2011 9:22 pm

    There is no option for monthly compounding.

  8. Dallas on February 7th, 2012 9:26 pm

    Can you create or point me to a calculator that will compound interest DAILY? I want to add: AMOUNT, # of DAYS, INTEREST RATE, COMPOUNDED = DAILY

  9. Dallas on February 8th, 2012 3:23 am

    Can you create or point me to a calculator that will compound interest DAILY? I want to add: AMOUNT, # of DAYS, INTEREST RATE, COMPOUNDED = DAILY

Leave a Reply