• Skip to main content
  • Skip to header right navigation
  • Skip to site footer

Excelypedia

The Excel Encyclopedia of The Internet

  • Tutorials
  • Functions
  • Formulas
  • Templates

PMT Function in Excel

August 25, 2021 by Andrew Childress
PMT function in Excel

Excel is a great tool to calculate financial values like loan payments. Let’s learn how to use the PMT function in Microsoft Excel.

Excel is a great tool to calculate financial values like loan payments. Fortunately for you, it includes a series of built-in functions to do exactly that. One is the PMT function, which is easy to use for a simple loan payment calculation. Let’s learn how to use the PMT function in Microsoft Excel.

How to Use the PMT Function in Excel

Before diving into the PMT function and learning to use it, it’s helpful to understand the limitations of the function. In essence, PMT makes two assumptions: that your interest rate will remain the same, and that your payment will remain the same.

Let’s look at a simple PMT example, assuming an annual payment. PMT requires four inputs to return the correct annual payment information.

  • The annual interest rate
  • The duration of the loan
  • The amount borrowed
  • The future value, which is $0, assuming the loan will be fully paid off.

To use the PMT function, input each of these four values into its own cell. Here, let’s list them in cells A1:A4 – 5% annual interest, for an 18-year duration, with $200,000 borrowed and a future value of $0.

PMT in Excel

Now, it’s time to calculate your annual payment. To do that, click into any empty cell in your Excel workbook. Type an = sign, which tells Excel that you’re inputting a formula. Then, type in the PMT function:

=PMT(

Now, click into the first of the four data cells, A1. Type a comma, click on cell A2, and repeat, until your formula reads:

=PMT(A1,A2,A3,A4)

PMT function in Excel

Finally, hit Enter on your keyboard, and Excel will calculate the annual payment for your loan. In this example, that payment will be $17,109.24.

PMT formula in Excel

As you can see, the PMT function is a quick and easy way to calculate loan payments in Excel. Use it next time you’re performing financial calculations like these.

Category: Excel FormulasTag: Excel, How To, Instructions, Tutorial

About Andrew Childress

Previous Post:Take a screenshot in ExcelTake Screenshot in Excel
Next Post:How to Hide Worksheets in ExcelHide worksheets in Excel

Sidebar

Recent Posts

  • How to Do a Contingency Table in Excel
  • Format Cell Alignment in Excel
  • Default Width in Excel
  • Translate in Excel
  • Switch Windows in Excel

Categories

  • Basics
  • Examples
  • Excel Formulas
  • Excel Functions
  • Excel Shortcuts
  • Excel Templates
  • Excel Tutorials
  • Uncategorized

Excelypedia

Master Excel to add a highly valuable asset to your employability portfolio. Learn how to analyze data in Excel.

    • Facebook
  • Twitter
  • Instagram
  • YouTube

Learn

  • Functions
  • Formulas
  • Shortcuts

Legal

  • Privacy Policy
  • Cookie Policy
  • Terms & Conditions

Help

  • FAQ
  • Contact Us

Copyright © 2023 · Excelypedia · All Rights Reserved

Back to top