...
The simple interest formula below is used to calculate the interest and is then applied based on the start and end dates selected. The interest accrued is then applied to the transaction amount for any subsequent rows so that the total amount calculated is cumulative.
i = t((r/100)/c)*d
i – Interest Amount
r – Interest rate as a %
...