Compound Interest Calculator
- Version
- 5'314 Downloads
- 16 KB File Size
- January 4, 2022 Updated
- 7 Number of comments
- Rating
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 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.
Need a compound interest daily calculator, with a amorization, would need the fields 1 amount 2 rate 3 number of days, and would like to have a amororization schedule for each day showing the amount earned and then the total then totaled at the bottom. do you have an excel templete for this?
i need to calculate compound interest in daily basis…can anyone help me…
Hi can anybody give or tell where I can find a excel speed sheet that will give the monthly payment as well as the total interest like a payment all
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
There is no option for monthly compounding.
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.
hi,
good work, thanks but the result for quarterly compounded is same as anually compounded. plz correct it.