TransWikia.com

Calculate the deposit on a loan when the monthly payment, interest rate, and balloon are known

Personal Finance & Money Asked by Adam Chance on January 8, 2021

I am looking into PCP finance for a car and I have found estimates where I enter a term and a deposit, and am given a monthly payment for the loan.

Some sites (BMW for example) will let you enter a target monthly payment and term, and they will provide the deposit required to achieve this target. I want to know how this figure can be calculated when the monthly payments, period, balloon payment, and term, are known figures.

One Answer

The standard formula for calculating loan payments is:

MathJax formula: $$P=Lfrac{c(1+c)^n}{(1+c)^n-1}$$

where:

  • P = monthly payment
  • L = Loan amount
  • c = monthly interest rate. This is the annual interest rate divided by 12.
  • n = number of months in the loan (years * 12)

You want to choose a monthly payment, interest rate, and loan term and see how much you can borrow. If we solve for L, we get:

MathJax formula: $$L=Pfrac{(1+c)^n-1}{c(1+c)^n}$$

Here is an example: Let's say that you want to pay $400 per month for 5 years, with a 4% interest rate. Plugging in P=400, c=0.04/12=0.0033, and n=5*12=60, you get a loan amount of $21,720.

Knowing that, if you want to buy a new 2020 BMW 2 Series sedan for $38,495, and you want a loan with these terms, you'll need to come up with a $16,775 down payment.

Answered by Ben Miller - Remember Monica on January 8, 2021

Add your own answers!

Ask a Question

Get help from others!

© 2024 TransWikia.com. All rights reserved. Sites we Love: PCI Database, UKBizDB, Menu Kuliner, Sharing RPP