Jump to content

WendyN

Registered Users

Change your profile picture
  • Content Count

    102
  • Joined

  • Last visited

Community Reputation

1 Neutral

About WendyN

  • Rank
    Basic Account Holder
  1. That's brilliant. That's what I had done, but I just wanted to check! Again, thank you SO much for all your help with this. I will keep you posted on how I get on, and of course make a donation to this fantastic forum. Best wishes, W
  2. Hiya, would really appreciate your help with just finishing off the calculations - am I right in thinking that I add a final figure to the spreadsheet, which is in effect the total excess PPI charged for all loans, minus any payments made to this, as above? Thanks very much... W
  3. OK - I think all of my calculations should be sound now. Thank you very much for all your help! I now have a very long spreadsheet (!) with: Loan 1: x9 PPI payments for loan 1 Loan 2: x0 PPI payments for loan 1, x0 PPI payments for loan 2 Loan 3: x11 PPI payments for loan 3, x11 PPI payments for loan 1&2 Loan 4: x21 PPI payments for loan 4, x21 PPI payments for loan 1-3 Loan 4: x2 PPI payments for loan 5, x2 PPI payments for loan 1-4 Just one quick question to finish off - how do I finish off? £ 2,208.40 (early repayment refund expected ) - £ 1,978.23 (early
  4. Loan 5: Early repayment refund expected £ 2,208.40 Early repayment refund received £ 1,978.23 PPI claimed £148.35 Interest claimed £105.47 Excess PPI from loan £230.17 Plus excess PPI from last loan £1,264.07
  5. Loan 4: Early repayment refund expected £1,672.07 Early repayment refund received £964.39 PPI claimed £1,343.05 Interest claimed £1,066.31 Excess PPI from loan £707.68 Plus excess PPI from last loan £1,079.14
  6. And I also think... My fifth loan was for £10000 plus the PPI of £2268.27 making a total loan of £12268.27. The PPI part of loan 5 is 18.49% of the total (given by the formula 2268.27 / 12268.27 x 100). The PPI left over from loans 1-4 = (loans 1-3 £663.78 – £292.32 (21 payments of £13.92)) + £707.68 (remainder of loan 4) = £1079.14 The PPI part of loans 1-4 is 8.79% of the total (given by the formula 1079.14 / 12268.27 x 100). 18.49% of every repayment I made was for the PPI part of loan 5. 18.49% of a repayment of £257.35 = £47.58 8.79% of every repayment I made was for
  7. Loan 5: 01-May-2005 - 01-Jun-2005 Amount of loan £10,000.00 Amount of PPI £ 2,268.27 Interest on loan (charge for credit) £ 2,594.50 Interest on PPI (charge for credit) £ 586.36 APR 9.9% Months 60 Monthly payment x1@ £47.40, x59@ £47.44 Payments made 2 of 60 Dates 01-May-2005 - 01-Jun-2005 Unknown - Early repayment refund expected £ 2,711.51 Early repayment refund received
  8. Right, so I think: My fourth loan was for £10500 plus the PPI of £2381.68 making a total loan of £12881.68. The PPI part of loan 4 is 18.49% of the total (given by the formula 2381.68 / 12881.68 x 100). The PPI left over from loans 1-3 = (loans 1&2 £295.55 – £68.20 (11 payments of £6.20)) + £436.43 (remainder of loan 3) = £663.78 The PPI part of loans 1-3 is 5.15% of the total (given by the formula 663.78 / 12881.68 x 100). 18.49% of every repayment I made was for the PPI part of loan 4. 18.49% of a repayment of £270.37 = £49.99 5.15% of every repayment I made was for
  9. Loan 4: ELPPLN03827861 Amount of loan £10,500.00 Amount of PPI £ 2,381.68 Interest on loan (charge for credit) £ 2,724.23 Interest on PPI (charge for credit) £ 617.49 APR 9.9% Months 60 Monthly payment x1@ £49.85, x59@ £49.96 Payments made 21 of 60 Dates 01-Jul-2003 - 01-Mar-2005 Unknown - Early repayment refund expected £49.96 Early repayment refund received £49.96
  10. But have by then made x11 payments of £6.20. So £436.43 + (£295.55 - (£6.20 x 11)) = £663.78?
  11. Loan 3: Early repayment refund expected £1,792.09 Early repayment refund received £1,355.66 - so a difference of £436.43
  12. The £44.08 was only the payment against the PPI part of the loan wasn't it? Yes What was the total monthly repayment on loan 3? £253.99
  13. My third loan was for £10000 plus the PPI of £2109.58 making a total loan of £12109.58. The PPI part of loan 3 is 17.42% of the total (given by the formula 2109.58 / 12109.58 x 100). The PPI part of loans 1&2 is 2.44% of the total (given by the formula 295.55 / 12109.58 x 100). 17.42% of every repayment I made was for the PPI part of loan 3. 17.42% of a repayment of £44.08 = £7.68 2.44% of every repayment I made was for the PPI part of loans 1&2. 2.44% of a repayment of £44.08 = £1.07 I think I'm with you so far. But how do I represent this on the spreadsheet
  14. Loan 3: Jun 02 - May 03 Amount of loan £10,000.00 Amount of PPI £ 2,109.58 Interest on loan (charge for credit) £ 2,594.50 Interest on PPI (charge for credit) £ 544.85 APR 9.9% Months 60 Monthly payment x1@ £44.13, x59@ £44.08 Payments made 11 of 60 Dates 30-Jun-2002 - 08-May-2003 Unknown - Early repayment refund expected £1,792.09 Early repayment refund received -£1,355.66 PPI claimed £921.36 Interest claimed £818.76
  15. OK, I've applied that formula to all five loans now, and I'm pretty sure that it's all correct now. There's just the next stage of the process to get to grips with, with the multiple PPI policies thing...! I'd be grateful for any pointers you can give :o) Thanks again for your help.
×
×
  • Create New...