Hi all, I hope u guys can help me on an issue I face. I'm actually developing a system to manage fixed deposits for long term tracking. I'm still quite blur on the actual formula used by banks.
As you can see, I used formula like this:
Interest = (rate/100) * (days) * (principal amount) / 365. (I read somewhere that banks use 365 method and not considering leap years).
With reference to the chart attached, the actual value for that red box in an actual statement is 5229.60. My system generated to 5229.63, additional 3 cents. I have tried to used long term precision, ie. more than 2 decimal places in computation, hoping to get it right but still resulted in deviation.
Can anyone be able to provide some info?
Additional Info: the case above is an auto-renewed FD placement starting all the way back from the first date in 2011. It is a one month placement, so the interest added up month to month. I believe the 3% interest is correct throughout the whole period, if wrong, pls correct me.
For information, there is also another old thread:
http://forum.lowyat.net/topic/689034/all which cover some lengthy discussions about that formula, which I gathered some info from.
The actual statement came from Maybank ??? I lost a few ringgit sometime back.
The formula used is correct which is 5229.63 in which most banks used. However Maybank seems to throw away beyond a few decimal points or so before doing actual calculation(x principal).