Calculate deposit by term with interest

**Assuming the customers have not yet withdrawn their money, the term deposit will be charged with interest rate. If at the end of the term, the Customer has not withdrawed the deposit, then they will combine the interest into the principal and calculate the interest with the old term (if continuing according to the remaining term, if not with interest of TK0).

For example: Mr.A has saved 50,000,000 with TK12 (5.6%) from from 27- 12-2017 to: 25/03/2020 the date of withdrawal Mr.A has saved 819 days. So, up to the date of withdrawal Mr.A will be maturity 2 times with the term TK12 and 3 months calculated with the interest rate of the term TK0 (0.3%).

`T1 = 50,000,000 * (1+ 0.056 / 365 * 365) = 52,800,000`  `T2 = 52,800,000 * (1+ 0.056 / 365 * 365) = 55,756,800`  `T3 = 55,756,800 * (1+ 0.003 / 365 * 89) = 55,797,586`   `M= T1+T2+T3.`  

Write a program to calculate the amount of money to be paid to each customer when they come to withdraw money from each savings book with the date of withdrawal always sysdate then store it in the database. **

https://stackoverflow.com/questions/66881357/calculate-deposit-by-term-with-interest March 31, 2021 at 11:45AM