Excel University Blog

Read on for in-depth articles, tutorials, and videos. Search or browse for specific topics. Be sure to subscribe if you'd like to be notified when we write something new.

PMT

Calculate the Payment of a Loan with the PMT Function in Excel

By Jeff Lenning | February 14, 2013 |

Thanks to Excel’s PMT function, computing the monthly payment of a loan with various terms is easy. In summary, you provide the function with the basic loan information, including the loan amount, the interest rate, and the term, and the function will compute the payment. You provide this basic loan information to the function through…

Read More