Results 1 to 5 of 5

Thread: PCP finance Calculator Spreadsheet - Comments opinions

  1. #1

    PCP finance Calculator Spreadsheet - Comments opinions


    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

    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.

  2. #2
    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. #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.

  4. #4
    Sorry should have said, it is great chart and gives so much more info than the website above.

  5. #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.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts