I'm trying to work out the best way to calculate returns on an interest bearing account over the last 5 years.
The interest will be calculated monthly on the cash holdings in the account.
I'm thinking that a decent kludge solution would be to work out the average rate at which interest was paid to high interest monthly bank accounts and just use that.
Anyone aware of a better solution or where to find historical rate data for interest accounts?
The amount in the bank is also changing quite a lot from month to month, a perfect solution isn't needed; just a reasonable one.
The interest will be calculated monthly on the cash holdings in the account.
I'm thinking that a decent kludge solution would be to work out the average rate at which interest was paid to high interest monthly bank accounts and just use that.
Anyone aware of a better solution or where to find historical rate data for interest accounts?
The amount in the bank is also changing quite a lot from month to month, a perfect solution isn't needed; just a reasonable one.