Hi Guys
My 1st post ever so please allow for any protocol errors.
I use Excel 2010 but any solution must cater for Excel 2003
<tbody>
</tbody>
My 1st post ever so please allow for any protocol errors.
I use Excel 2010 but any solution must cater for Excel 2003
Here's simple extract from spreadsheet - person owes £79.72 & is charged interest at 2.843% periodically on each statement. The extract shows how I currently calculate total interest to be paid on ONE account before debt is cleared.
<colgroup><col><col><col><col><col><col></colgroup><tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
So total paid is £79.72 plus total interest payable of £10.06 - ie 1 payment @ £11.84, 6 @ £11.84, plus final 1 @ £6.90 I now need to do the calc for dozens of accounts every day; is there a formula to calc total interest to be paid Thanks in advance | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<tbody>
</tbody>