Most banks conduct payments at the end of pay periods, which is the default option when type is blank. You can use PMT to calculate ... say $500 per month for a $15,000 loan. In such cases, you can ...