Account rundown example (AC)

Same has happened again this month. My IFISA has drawn to zero (it had ended April at '0.00') whereas the Standard account carried a non zero balance forward with a new amount added against which four interest payments for today were processed: the last of these being split, with some net interest paid whilst an unclaimed balance remains. For the IFISA meanwhile, the payment exhausted the monthly fee with the final one (like the Standard a/c) being 'split' and some interest paid net ... meaning zeroing the month's  IFISA 'claimed' fee has once again 'paused' any further claiming from the Standard account.

When the rundown and fees started I changed my spreadsheets to produce some new figures.
The results are for my wife's and my ISA accounts combined. The funds are nearly all MLA just a small amount in GBBA's
Funds in cash and not withdrawn are not taken into account i.e. the returns are slightly higher than actual.

Feb

% of interest paid taken in fees 67.589%

Return on all money in accounts 0.140%

Yearly 1.68%

Return with defaults taken out 0.148%

Yearly 1.776%

March

% of interest paid taken in fees 40.394%

Return on all money in accounts 0.283%

Yearly 3.391%

Return with defaults taken out 0.299%

Yearly 3.586%

April

% of interest paid taken in fees 47.733%

Return on all money in accounts 0.197%

Yearly 2.366%

Return with defaults taken out 0.209%

Yearly 2.509%

They have dropped a small additional fee on the MLA today [11/05] which I think looks like an adjustment b/c the amount claimed on the 1st of the month was somewhat less than previous months. 

Figures amended now look like this:

I've added a monthly update to the table in the OP.

Loan #808 made its final repayments, with a capital loss.

The figures now include my QAA account, as it's become too fiddly to remove its effects now that capital repayments have started. It makes very little difference to the numbers as it only contained £110.

XIRRs continue to fall.

You can see the AVERAGE 'claimed TO date' has leapt this month in my case also:
The difficulty with such figures of course is that the correct 'denominator' is not actual interest - nor even interest rate - but - average 'performing capital' (which is ill-defined) on which an effective interest rate of 2.9% pa is supposedly levied. There is also the question niggling in my mind whether that interest received should have the collected fee amount added  [because the fee is collected against the payment of interest by way of withholding - so we never receive it and cannot be taxed on it later] as indicated in {*} I had to add the cumulative fee from the previous month rather than the current month to give these percentages.

Some MLA loans now have an 'Irrecoverable' tag against them, e.g. #327, #330. When you go into the loan, there's a 'Write off non-Access Account holdings' option.

Progress, I suppose (although this should have been implemented ages ago).

Interesting. All of my MLA loans marked as "irrecoverable" already had my notes saying "crystallised loss".  Looks like my own assessment was precise