In attempting to work out an affordable monthly payment for a PCP scheme I'm trying to design a table where I can change the variables to see how it affects the outcome.
In an excel sheet if I input;
amount to borrow
term of PCP
APR%
does anyone know the formula that the finance companies use to calculate the monthly payment + the final balloon payment?
Any help on this much appreciated, then I can just perm the figures.