Very useful, well done. I was looking for historical information on the provision fund just to see how much it fluctuates and when it hits new lows as it's an important risk flag for the platform. The monthly statements just give the coverage ratio but it's great having all the information collated onto one spreadsheet. The actual cash amounts in the fund are also good to keep an eye on rather than the overall coverage ratio since the future losses and recoveries are just estimates.
IMO this is a candidate for sticky material if it continues to auto update!
Very useful. I'm selling out (at least from rolling) at between 105% and 100%
Just wish I understood assetzcapital provision fund rules. Also wish for higher rates on Zopa+ and RS to rid itself of MR. Oh, and FS, more rolexes and less property developers please. Apart from that I'm a happy bunny.
Please would you let us know what is in column I? Personally I also track the loans with 2 & 3+ payments in arrears as an early warning for defaults. Personally I do not fully trust the estimated future defaults and so apply my own extrapolation. I also keep my eye on "credit fees received" less "Actual Losses to Date" rather than the disclosed "Contributions" in the Fund as they have never explained why this is lower. Finally, I think the description of the "Contractual Future Income" as "Potential Recovery" is a little misleading. I thought the former is an estimate of the future payments due by borrowers to the Fund. Expected recoveries appear to be netted off the expected future losses (hence 2 periods expecting negative future defaults).
copacetic - this may be similar to what you are looking for for historical data. If you put it into excel, filter to just show the coverage ratio and then plot a graph against time it will give you a useful historical view.
It covers Sep 2016 to Oct 2017 - though after that a website update has broken most of the fields. Please note it is the raw data scraped off the statistics page on the website, so there may be some errors.
Seems to have gone haywire this evening. They have significantly increased the provisions as all years are now showing further bad debts rather than negative as was the case. Conversely they are showing a further £2m in the provision fund althouth the Credit fees received have not increased significantly. There has been a significant (£800k) gap between the fees less bad debts and contributions to the fund. This is as a result of a loan sale. I can only imagine a sale of the loans that have previously defaulted.