You want to purchase a new car for a price of $31,250. Your finance company requires a 20% down payment and will charge a 3% annual percentage rate on a 5-year loan for the remainder. Use the Present Value Excel Template to determine the amount of your monthly payment? Enter as a positive number with two decimal places (i.e., to the penny) but without the dollar sign here Clear all Check