eh sori,aku pun silap kira...aku tak pandai tempek excel kat sini..aku summarize je la..
month,balance
jan 2008=rm0
feb08=rm0
mac08=rm100
apr08=rm100
may08=rm2100
june08=rm2100
july08=rm2100
aug08=rm2100
sep08=rm2100
oct08=rm2100
nov08=rm2100
dec08=rm4100
div=7%,bonus=1.75%..
dividend=(sum all/12)*7%=110.83
bonus=(sum all/120)*1.75%=2.77
hhhmmm,mmg lain dptnya dari yg dikira..kene tanya asnb la..tapi dpt banyak dari dikira,kira oklah kan..