Our website uses necessary cookies to enable basic functions and optional cookies to help us to enhance your user experience. Learn more about our cookie policy by clicking "Learn More".
Accept All Only Necessary Cookies

What is PMT in Finance?

Discover what PMT in finance means, its applications, and how to use the PMT function in Excel for loan and mortgage calculations.

By Salma Christiansen


Investing.com: Stock Market APK

Get real-time stock alerts and breaking news to track volatile markets now!



The PMT function is a fundamental tool in finance, used to calculate the periodic payment for loans, mortgages, and other financial agreements. Understanding how to use this function can help individuals and businesses manage their financial obligations more effectively. This article explores the PMT function, its applications, and how to use it in Excel.


    1. Understanding the PMT Function

    The PMT function stands for "Payment" and is used to determine the payment amount for a loan or investment based on constant payments and a fixed interest rate. The formula for the PMT function in Excel is:

    • PMT(rate, nper, pv, [fv], [type])
    • Rate: The interest rate for each period.
    • Nper: The total number of payment periods.
    • Pv: The present value or the total amount of the loan.
    • Fv (optional): The future value or the cash balance desired after the last payment.
    • Type (optional): Indicates when payments are due (0 for end of period, 1 for beginning).

    2. Applications of the PMT Function

    The PMT function is widely used in various financial scenarios:

    • Loan Repayments: Calculate monthly payments for personal or business loans.
    • Mortgage Payments: Determine the monthly mortgage payments based on the loan amount, interest rate, and loan term.
    • Annuities: Calculate the periodic payments for annuities.
    • Investment Planning: Project the periodic payments required to achieve a future investment goal.

    3. How to Use the PMT Function in Excel

    Using the PMT function in Excel simplifies the process of calculating loan payments. Here’s a step-by-step guide:

    Step-by-Step Guide:

    • Open Excel: Start by opening a new or existing Excel spreadsheet.
    • Input Data: Enter the loan details such as interest rate, number of periods, and present value in separate cells.
    • Enter the PMT Formula: Click on the cell where you want the payment amount to appear and type the PMT formula. For example:
    • =PMT(B1/12,B2∗12,−B3)
    • Here, B1 is the annual interest rate, B2 is the number of years, and B3 is the loan amount.
    • Adjust for Monthly Payments: Divide the annual interest rate by 12 and multiply the number of years by 12 to convert to monthly terms.
    • Calculate: Press Enter to get the monthly payment amount.

    4. Benefits and Limitations of the PMT Function


    • Accuracy: Provides precise calculations for loan and mortgage payments.
    • Convenience: Simplifies complex financial calculations.
    • Versatility: Applicable to various financial scenarios including loans, mortgages, and investments.


    • Assumptions: Assumes constant interest rates and payments, which may not always be realistic.
    • Excludes Fees: This does not account for additional fees, taxes, or insurance that may be part of the loan agreement.
    • Complexity: May be complex for users unfamiliar with financial formulas or Excel.

    Understanding the PMT function in finance is essential for managing loans and investments effectively. By leveraging tools like Excel, individuals and businesses can make informed financial decisions and plan their finances with greater accuracy.

    Investing.com: Stock Market APK

    Get real-time stock alerts and breaking news to track volatile markets now!



    Back to top

    Featured lists

    Related Articles
    What is Business Finance?News
    What is Structured Finance?News
    What is a Basis Point in Finance?News
    Latest News
    Call of Duty: Mobile Season 6 Teaser Trailer Revealed
    Call of Duty: Black Ops 6 Unveils Launch Date, Pre-Orders Now Open
    Clash of Clans June 2024 Update: Town Hall 17, Future Plans Revealed
    Portugal vs. Czech: The Highlight of the Euro 2024 Group Stage in the Live Stream
    Top News
    Genshin Impact Redeem Codes in June 2024
    Honkai: Star Rail 2.3 Codes
    Minecraft 1.21 Tricky Trials Update Patch Notes
    Honor of Kings Redeem Codes and How to Redeem
    Car Parking Multiplayer 2 Has Opened Pre-Registration for Android
    PUBG Mobile 3.3 Beta Update Download Is Now Available
    GTA 5 Weekly Update (June 13)
    eFootball 2024 v3.6.0 Update: Release Date, Leaks and More
    Subscribe to APKPure
    Be the first to get access to the early release, news, and guides of the best Android games and apps.
    No thanks
    Sign Up
    Subscribed Successfully!
    You're now subscribed to APKPure.