Car Finance Calculator..

spoonz · 1 Jun 2010 at 14:19

Anyone have one in Excel or online. I cant work out the functions to do it myself

I need to enter APR and deposit/balloon payments/terms etc

Ta

[TW]Fox · 1 Jun 2010 at 14:45

Just take the balloon off the price of the car giving you the amount to finance, work out the annual interest and from that you can work out monthly cost over various terms surely :confused:

spoonz · 1 Jun 2010 at 14:46

[TW]Fox;16663732 said:
Just take the balloon off the price of the car giving you the amount to finance, work out the annual interest and from that you can work out monthly cost over various terms surely

also the variations on how interest is calculated. HP, PCP etc. Maybe I'm over complicating it...

Maz · 1 Jun 2010 at 15:51

spoonz said:
also the variations on how interest is calculated. HP, PCP etc. Maybe I'm over complicating it...

PCPs can only be calculated by finance company as the GFV is determined by current mileage, annual mileage, term and extras which add value.

HP can be worked out very easily, and HP with a Balloon is bit trickier to work out because the Balloon is subject to interest.

If you know how much you want to borrow and over what term I can calculated monthly payments for you on HP or HP with a Balloon (Unguaranteed) But you need to get specific quotes for PCPs.