blender
Member of DD Central
Posts: 5,719
Likes: 4,272
|
Post by blender on Oct 11, 2014 13:04:08 GMT
Hi James,
You may find that the discrepancy is in the roundings to whole pennies, especially if you have your loans broken into a number of smaller parts. FC work to a higher resolution and when paying the interest they accumulate roundings for each part until the payment of an extra penny is triggered (see FAQs). So some of the cash which should have been paid is held by FC, and of course if you have a number of £20 parts for the same loan at fixed interest these fractions per loan part will move up in step and can be a considerable number of pennies if you have a considerable number of £20 loan parts. The fees are smaller that the interest, so of less importance, but I seem to think it works the other way round, ie they take the penny first and credit the loan part with the overpayments as roundings - though I cannot be sure of that - just that some of the first fees have been a penny more that I expected. Maybe your spreadsheet does not take account of the breakdown of your loans into parts and FC's rounding practice? If not you can have hours more fun incorporating that, if you can find out exactly how FC handles the roundings. (Then you can tell us)
|
|
|
Post by GSV3MIaC on Oct 11, 2014 13:56:51 GMT
Yep, time to panic if the error is more than one penny per loan PART, I think.
|
|
blender
Member of DD Central
Posts: 5,719
Likes: 4,272
|
Post by blender on Oct 11, 2014 16:32:54 GMT
Hi James,
Stimulated by your enquiry I decided to see how the FC roundings work, and I have been a bit unfair in that it does seem to round up or down in the normal way on both interest and fees. If you take a £20 property loan part at 8% interest only, then after one month FC pays 13p interest and takes 2p fee, whereas the amount to 2 decimal places is 13.33p interest and 1.66p fee. So on the day of first payment you are 'down' temporarily 0.67p per £20 loan part. If you have £1000 in 50 parts you are down 33.5p.
But if you have a £40 loan part you get 27p of interest and are charged 3p fee, and you are 'up' 0.67p temporarily. If you have £1000 in 25 £40 loan parts you are up 16.67p.
Given that these large property loans contain a very large number of £20 parts (some bought by FC) at fixed rate, the amount in the roundings account for each loan must swing quite remarkably month by month.
|
|