QUOTE(vince660 @ Apr 2 2013, 04:40 PM)
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.
For 3 sen differences? It just could be the rounding error. May be you should try 10 decimal points 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.
In general , On auto-renewed FD the interest will be added on only after the maturity date. Example, HL junior FD the interest is credited quarterly in the saving account, not added onto the principal and compounded again..
Apr 2 2013, 05:03 PM

Quote
0.0439sec
0.69
7 queries
GZIP Disabled