Ready, steady… save!
You don’t need a chart to join in. Here are 2 ways to record your savings:
1. Cross it off
Pop a chart into your first post. Saved an amount? Cross it out! Read more »
£0.01 £0.02 £0.03
2. Write it down
Skip the chart and add updates to your first post. Read more »
“Another +£3 saved today. Go me!”
Use +£ before each new saving so it counts towards your total.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
Car finance - can someone help me work these values out?
Comments
-
or buy the car for an undisclosed amount.
Not undisclosed
Guaranteed Future Value £7808What do these 2 figures actually mean ?Cash Price £16498Deal Price £17380
Never associate with idiots on their own level, because, being an intelligent man, you'll try to deal with them on their level - and on their level they'll beat you every time.
Being hated by idiots is the price you pay for not being one of them.
Jean Cocteau 1889-1963
1 -
Looks like PCP given the mention of a Guaranteed Future Value of £7,808.Roughly, the £259.08 monthly payment is made up of:£70.19 interest on £7,808 (the GFV)£188.89 repaying capital+interest on £7,322 (the rest of the loan, i.e. £15,130 - £7,808)Period is 48 months, so 47 payments x £259.08 + pay GFV or hand back47 x £259.08 = £12,176.76 + £7,808 = £19,984.76 total amount payableAPR looks to be around 10.9%The figures you have provided do need checking as the deal doesn't make total sense.
1 -
Thanks both. Getting closer
@ ev51 - your calc suggests my brother is paying £3298.93 interest on the £7808 GFV over the term, but only £1545.83 interest on the remaining £7332 over the term. I guess this is the result of the GFV never changing (no capital payments) and ammortisation of the £7332 as this value decreases over time.
But, can you show me how the quoted 5.66% could be used to reach these figures (assuming it's the same rate for both parts of the loan)?0 -
Yes, the GFV never changes so interest remains the same every month, in simple terms 7808 x (10.9/12) = 70.92 (near enough for the purpose of checking dealers figures).The other part of the loan is reducing with every payment, higher interest at the start and reducing over time so less interest due overall compared to the GFV. Excel PMT function can be used for amortisation of that part of the loan, for example, first payment is £125 principal and £65 interest, last £189 principal and £1 interest (all figures are approx.)The APR is key and should be provided as part of the finance quotation, not just the fixed interest rate.Edit: The Excel PMT function calculates the payment, you can then caculate the monthly interest, principal and balance for the duration of the loan.1
-
That PMT function is really useful, thanks - I love excel but I've never used it for the purpose of working out interest - very good. I've managed to get the figures to balance almost perfectly using that function for an APR% of 10.8271% (very specific, I know) - but still can't fathom how the 5.66% 'fixed/flat rate' is arrived at. I've sent a question to the dealer (Arnold Clarke) in any case to ask them what it actually means. But for now, I have what I need I think. Thanks again.0
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 355.9K Banking & Borrowing
- 255K Reduce Debt & Boost Income
- 456.2K Spending & Discounts
- 248.4K Work, Benefits & Business
- 606.2K Mortgages, Homes & Bills
- 179.1K Life & Family
- 264K Travel & Transport
- 1.5M Hobbies & Leisure
- 16.2K Discuss & Feedback
- 37.7K Read-Only Boards
