Excel PMT Function. The PMT function figures the fees for a loan which includes continuous repayments and a consistent interest rate.