**Create a Basic Car Loan Calculator in Excel using the PMT …**
https://www.exceltactics.com/car-loan-calculator-part-1-collecting-variables-and-calculating-payments-using-the-pmt-function/

The key question for most people when taking out a car loan is “What will my monthly payment be?” Fortunately, Excel has been around the block a few times with this kind of question, and there is a special function just for this calculation, called PMT. The basic syntax for PMTis as follows: Let’s break down the inputs: The rate input is the amount...

The key question for most people when taking out a car loan is “What will my monthly payment be?” Fortunately, Excel has been around the block a few times with this kind of question, and there is a special function just for this calculation, **called PMT.** The basic syntax for PMTis as follows: Let’s break down the inputs: The rate input is the amount...

**DA:** 24 **PA:** 78 **MOZ Rank:** 3