arrears with zero value owing
Quote:
Originally Posted by
Cool Bear
I have about 6000 loans and in for about 24+months. Arrears is currently 7.18% (total principal at risk vs total amount o/s). Mine was higher risk including E and F. RAR still above 14%. Would be better going with RMJH's risk spread.
Hi Alistar
just realised that there are quite a few loans in my list that are classified as "Arrears" but have "Amounts in Arrears" = 0. These total 24 out of the 261 loans in arrears. My previous percentage above do not take these into account. That 7.18% was based on the spreadsheet adding the principal outstanding only if the value in "Amounts in Arrears" is not equal to 0. So, if I add the "Outstanding Principals" of these zero value Arrears, my principal at risk is higher at 7.84%.
But wait, there is more...
Quote:
Originally Posted by
Cool Bear
Hi Alistar
just realised that there are quite a few loans in my list that are classified as "Arrears" but have "Amounts in Arrears" = 0. These total 24 out of the 261 loans in arrears. My previous percentage above do not take these into account. That 7.18% was based on the spreadsheet adding the principal outstanding only if the value in "Amounts in Arrears" is not equal to 0. So, if I add the "Outstanding Principals" of these zero value Arrears, my principal at risk is higher at 7.84%.
To complicate it further, I realised that out of my 3500+ current loans, 74 have days overdue on them, eventhough the "Amounts in Arrears" are also 0. If I add the outstanding principals of these, my total principal at risk goes up to 9.82%.:scared:.
But as I am already in for 24 months, it is the actuals that matters and the amount written off are just about 20% of gross interest at the moment.