PCP finance Calculator Spreadsheet - Comments opinions RDG

#1
Guys,



Having recently been looking for a new car for Mrs RDG I found it frustrating that I couldn't quickly calculate the cost of PCP finance, ie the interest paid over a year etc. So Ive built a spreadsheet on Google Docs which I think works but Id like some opinions or people to run it against real quotes.



Heres the link

https://docs.google.com/spreadsheets/d/13IFKCBQ7v5-Tw1AfDOW_g5mmpLWMvNw1nnypf8Xw-Z8/edit?usp=sharing



The intention is to then add comparisons to bank loans and other financing options, although setting the GMV to 0 should give you a HP option straight off.



Thanks in advance.

#2
I used this

http://www.pcpcal.co.uk/



when i put in my actual figures from the car I have it came out with the same figures as your chart, and both within a few £ of what i actually pay per month



Would it be good to have a total amount payed over the life of the agreement (or is it there and I just didn't see it )

#3
Thanks Paully glad its working for more than just the one example I have.



Thats a good point Il add that to the top.



Yeah i found that calculator as well but I wanted to see what the remaining sum was at different points. That way you can see when you might be out of negative equity.



My intention is that I can use it on my phone when at a dealers to see what effect changing the deposit amount will be, and seeing what target monthly payments to suggest when negotiating.

#5
Put my details in and it came out perfectly as far as I can tell (give or take a few pence).



Great work, really interesting to see how much gets paid to what each month.

#6
Right, its taken more work than I would have liked but the total interest for the term now works. Its my fault for trying to make it so you can do anything between 1 and 60 months.



britishbloke yeah it is really interesting to see how these things actually work. Obviously paying interest on the full loan amount including the final payment for the term makes the sums more difficult than a simple loan.



If theres any other information people think will be useful then let me know and Il try and incorporate it.

#7



My intention is that I can use it on my phone when at a dealers to see what effect changing the deposit amount will be, and seeing what target monthly payments to suggest when negotiating.
Originally posted by RDG


Excellent work, I bet the sales men/women love you!

#8



Right, its taken more work than I would have liked but the total interest for the term now works. Its my fault for trying to make it so you can do anything between 1 and 60 months.



britishbloke yeah it is really interesting to see how these things actually work. Obviously paying interest on the full loan amount including the final payment for the term makes the sums more difficult than a simple loan.



If theres any other information people think will be useful then let me know and Il try and incorporate it.
Originally posted by RDG


The best thing to do when buying a new car is to go in on the last day of a quarter and be prepared to sign for a car there and then. Trust me, they will sell the car to you at an insane discount just to meet their quota. Quarters end at the end of March, June, September and December.



The next point is to go in and talk like you're going to be buying the car in cash. Negotiate down the cash price, then when you decide you're at a figure you're happy with, ask about their finance options. They'll sell the car to you at the same price.




Excellent work, I bet the sales men/women love you!
Originally posted by kuohu


I don't think they're a fan of any MSE'er, haha.

#9
RDG thanks for the spreadsheet. It proves I'm not going bonkers!



Been researching a new Peugeot 308 for 2 weeks now and have a pretty sound idea of the deals out there (my domestic director is due to change her 208 after 36 months in a PCP deal). After a few telephone conversations with one dealer I visited today for a test drive.



Upshot is the monthly figures didn't stack up against the car we spec'd even after accounting for our deposit, dealer discount, Peugeot loyalty bonus and 0% finance. Your spreadsheet confirms this and I've even sense checked it against the Peugeot dealers own calculator. If need be I'll use this as a stick to bring them round to my way of thinking

#10
Just a quick update for those that use this and it appears to be a lot of people judging by the number of access requests Ive had since I took it down.



Ive taken the sheet down temporarily as through over a years use it had been modified by others quite a bit and had lost some of its functionality. I also noticed that there have been occasions when multiple users have tried using it at the same time which doesnt work. So Im looking at using google forms to create an input and out put system which should let multiple people use it at the same time.



Again if anyone has any ideas about how to improve it once it is up and running again please let me know.

Who is online

Users browsing this forum: No registered users and 1 guest

cron