PCP Calculator
Discussion
No, and be careful there is one on the Internet that doesn't add in the double interest on the balloon payment.
The only other ones I have seen want you to choose a model and give them your details so they can contact you.
If you don't find what you want email me. Having just gone through working all this out I can probably give you a formula. Though that is not as easy as using an online calculator obviously.
Manks
Careful Dr Jekyll
Manks will quote the FSA at you!
OP
Just build a spreadsheet
the only tricky bit is the APR calculation
You need to build a column of cash flows (ie -20000 for the 20000 car loan, then +ve amounts for each monthly payment and the balloon at the end).
Then apply the IRR function to the cashflows. Then use the IRR to calc APR.
Manks will quote the FSA at you!
OP
Just build a spreadsheet
the only tricky bit is the APR calculation
You need to build a column of cash flows (ie -20000 for the 20000 car loan, then +ve amounts for each monthly payment and the balloon at the end).
Then apply the IRR function to the cashflows. Then use the IRR to calc APR.
Manks said:
Dr Jekyll said:
Manks said:
No, and be careful there is one on the Internet that doesn't add in the double interest on the balloon payment.
Manks
If loan A means owing an average of £500 for 12 months (EG because £1000 is paid off in instalments), and loan B means owing an average of £1000 for the same period (EG because it's a one off balloon payment), then for the same interest rate I would expect to pay twice as much interest on loan B.
Not because interest is paid twice, but because I am effectively borrowing twice as much money.
If you insist on regarding the interest rate as half the true rate then you have to double it to get the right figure, but that is simply a demonstration that your figure was wrong in the first place.
Dr Jekyll said:
Manks said:
Dr Jekyll said:
Manks said:
No, and be careful there is one on the Internet that doesn't add in the double interest on the balloon payment.
Manks
If loan A means owing an average of £500 for 12 months (EG because £1000 is paid off in instalments), and loan B means owing an average of £1000 for the same period (EG because it's a one off balloon payment), then for the same interest rate I would expect to pay twice as much interest on loan B.
Not because interest is paid twice, but because I am effectively borrowing twice as much money.
Dr Jekyll said:
If you insist on regarding the interest rate as half the true rate then you have to double it to get the right figure, but that is simply a demonstration that your figure was wrong in the first place.
It is not a question of me "regarding" the interest rate as half the true rate. I am using the figure that will inevitably be quoted by the dealer in order to obtain the right answer.Manks
Manks said:
It is not a question of me "regarding" the interest rate as half the true rate. I am using the figure that will inevitably be quoted by the dealer in order to obtain the right answer.
Manks
No, it will be quoted by the dealer to make the rate sound lower than it really is. The fact that you have to double it to get the right answer is a clue.Manks
Dr Jekyll said:
Manks said:
It is not a question of me "regarding" the interest rate as half the true rate. I am using the figure that will inevitably be quoted by the dealer in order to obtain the right answer.
Manks
No, it will be quoted by the dealer to make the rate sound lower than it really is. The fact that you have to double it to get the right answer is a clue.Manks
Manks
Edited by Manks on Sunday 7th March 14:18
Manks said:
Oh for sure. But the fact remains that you need to apply the flat rate once to the amortised part of the loan and twice to the deferred payment or bubble. Which is what I said and which you apparently disagreed with.
Manks
It's the same point as we are discussing on the other thread - if you use the 'proper' IRR calculation then you don't need to charge the (wrong) interest rate twice to get the right answer!!Manks
Sidicks
sidicks said:
Manks said:
Oh for sure. But the fact remains that you need to apply the flat rate once to the amortised part of the loan and twice to the deferred payment or bubble. Which is what I said and which you apparently disagreed with.
Manks
It's the same point as we are discussing on the other thread - if you use the 'proper' IRR calculation then you don't need to charge the (wrong) interest rate twice to get the right answer!!Manks
Sidicks
Manks
sidicks said:
Manks said:
But if you do it your way, you get the WRONG answer as you have already demonstrated.
Manks
No you don't!!Manks
Why do you think you get the wrong answer?
Sidicks
sidicks said:
Ok, as has already been posted previously (hundreds of times), flat rate is meaningless, you need to use the APR to calculate the monthly payments, as this takes into account all fees etc.
With a £10k car and £1k deposit, there is £9k to finance. Effectively there are 2 parts to this agreement:
- A £5000 loan (residual) on which interest is paid but no capital
- A £4000 loan which is re-payable over 3 years
Using an APR of 8.8% (equivalent to a monthly rate of 0.71%):
The interest on the £5k loan is £35.27 per month
The interest and capital repayment on the £4k loan is £126.20
This leads to a total premium of £161.47
Whereas "RS6 see you", who is a car finance broker, inputted the figures into his PCP calculator and obtained the figure: £170.70 which also tallies with the answer calculating it manually.With a £10k car and £1k deposit, there is £9k to finance. Effectively there are 2 parts to this agreement:
- A £5000 loan (residual) on which interest is paid but no capital
- A £4000 loan which is re-payable over 3 years
Using an APR of 8.8% (equivalent to a monthly rate of 0.71%):
The interest on the £5k loan is £35.27 per month
The interest and capital repayment on the £4k loan is £126.20
This leads to a total premium of £161.47
So, your method has been demonstrated to give the incorrect answer.
But as I have said on the other thread I think it is time for me to draw a line under this. I have a car to wash and enjoy in the sunshine - and you know what it hasn't got any finance on it.
Manks
Edited by Manks on Sunday 7th March 14:31
The 'calculation' is very very easy to create on excel.
For the example figures, if you pay £1000 deposit on day one and £170.69 per month with a £5k balloon, the APR is 8.71%.
Amount of loan 10000
admin fees 0
deposit 1000
monthly pmt 170.69
balloon 5000
eoc fees 0
interest rate 5%
no opf payments 36
total repaid 11144.84
total interest 1144.84
rough monthly pmt £170.69
IRR 0.698040092662%
APR 8.71
For the example figures, if you pay £1000 deposit on day one and £170.69 per month with a £5k balloon, the APR is 8.71%.
Amount of loan 10000
admin fees 0
deposit 1000
monthly pmt 170.69
balloon 5000
eoc fees 0
interest rate 5%
no opf payments 36
total repaid 11144.84
total interest 1144.84
rough monthly pmt £170.69
IRR 0.698040092662%
APR 8.71
Manks said:
Whereas "RS6 see you", who is a car finance broker, inputted the figures into his PCP calculator and obtained the figure: £170.70 which also tallies with the answer calculating it manually.
So, your method has been demonstrated to give the incorrect answer.
My number uses the APR, which as you have said is rounded down to the lower 0.1%. By definition the actual IRR (i.e. unrounded APR) will produce the correct answer. I was being a bit lazy when I was using referring to APR rather than IRR.So, your method has been demonstrated to give the incorrect answer.
Given the full cashflows and a simple spreadsheet it is a trivial spreadsheet to tie up with the 'correct' answer.
Sidicks
PS - My car needs a wash too!
For anyone looking for a quick and dirty pcp calculator online, I have one that I created here http://www.pcpcal.co.uk/ It will let you see what happens when you change the APR, deposit, final payment etc.
I do not make any guarantees over it's accuracy although the model has always been within a few quid of the numbers from dealers quotes that I have had recently.
I do not make any guarantees over it's accuracy although the model has always been within a few quid of the numbers from dealers quotes that I have had recently.
Manks said:
So you don't think interest is paid on the balloon twice then no?
Manks
Manks
OP - this one isn't too bad- it is only out be a few pounds on the monthlies. You'll need to take one month off the term to get it to work properly i.e if it is a 48 month term enter 47.
http://www.thecalculatorsite.com/finance/calculato...
Gassing Station | Finance | Top of Page | What's New | My Stuff