Compound interest calculator for flexible access savings accounts
The below application can be used to calculate the Interest from a Flexible rate bond considering that you can add or extract money anytime and that the rate can change over time. If you only add the Initial deposit with a rate you can also calculate the Interest for a Fixed rate bond but that is the easy part that you can do with a normal calculator.
The magic is in the rest of the logic that is quite complex if you need a result that involves all the variables used bellow. As it might not replicate 100% the logic of your investment institution, is getting though very close, so it can be use to estimate Interest per month and the Total after many changes.
A few rules applied bellow:
- For any transaction that is not the Initial Deposit, any date changed can't be smaller than the Initial deposit date. If so, the Initial deposit date will be used instead.
- A date change on any transaction that is not the Initial Deposit, will trigger a sort by date of the entire list. So transactions can be reordered by changing the dates
- A click on the minus button on the Bond duration will set the Bond duration date equal with the Initial Deposit date
- If the Bond duration date is bigger then Initial Deposit date, clicking on the Plus button will increase Bond duration date with 1 year each time, without changing the initial Bond duration date.
- If you plan in changing the Initial Deposit Rate (as you probably inserted it wrong by mistake) you can do it in 2 ways. By removing and adding back the transactions after the Initial Deposit or by adding a Rate with a date the same with the Initial Deposit Date