does anyone know how to calculate the interest so it matches this?
thanks
ACTUAL PLC at 6.5% interest
Date******Description*********Debit***Credit **Balance
7/3/2008 GC*****************3000*********3000
7/18/2008 PAYMENT - THANK YOU *******467***2533
7/23/2008 CHQ# **************1791********4324
7/23/2008 CHQ#***************1925********6249
7/31/2008 INTEREST ***********20.28 ********6269.28
8/1/2008 PAYMENT - THANK YOU*********467***5802.28
8/12/2008 CHQ# **************288.75********6091.03
8/21/2008 CHQ#***************372.75********6463.78
8/21/2008 CHQ# ***************2731.7 *******9195.46
8/29/2008 INTEREST**************39.14*******9234.6
i tried ACCRINTM(issue,maturity,rate,par,basis) etc etc!!!
but no success so far.
thanks
PS I tried to edit this post so it would be clearer - columns etc. but when posted the columns vanished!
will try ***
Bookmarks