# Google Sheets PMT Function: Syntax, Examples & Tips - URL: https://betteranalyst.com/google-sheets/pmt-function - Author: Better Analyst Formula Bot is now Better Analyst—same account, more powerful analysis.Formula Bot is now Better Analyst—same account and workflows, with more powerful analysis, dashboards, and automation. [Learn what changed](https://betteranalyst.com/formula-bot-is-now-better-analyst) The PMT function calculates the periodic payment for a loan based on constant payments and a constant interest rate. ``` PMT(rate, number_of_periods, present_value, [future_value], [end_or_beginning]) ``` Generate FormulaExplain Formula One free generation or explanation per browser, shared across Excel and Google Sheets. Account usage limits apply afterward. Describe the PMT you need in plain EnglishGenerate Formula ## Parameters **`rate`**:\ The interest rate for each period. **`number_of_periods`**:\ The total number of payment periods in an investment or loan. **`present_value`**:\ The current value of the loan or investment, or the total amount that a series of future payments is worth now. **`future_value`**:\ (Optional) The desired value after the last payment has been made. If omitted, it defaults to 0. **`end_or_beginning`**:\ (Optional) A value that indicates when payments are due. Use 0 if payments are due at the end of the period and 1 if they are due at the beginning. If omitted, it defaults to 0. ## What is a PMT Formula? The *PMT* function in Google Sheets is a financial tool used to calculate the periodic payment for a loan based on constant payments and a constant interest rate. This function is particularly useful for individuals or businesses looking to understand their loan obligations, whether for mortgages, car loans, or any other type of financing. In simpler terms, the PMT function helps you determine how much you need to pay each period to repay a loan over a specified term at a given interest rate. ## A Practical Example Imagine you are considering taking out a loan for a new car: - **Loan Amount**: $20,000 - **Annual Interest Rate**: 5% - **Loan Term**: 5 years You want to find out how much your monthly payment will be. ## PMT Formula To achieve this, you would use the PMT function as follows: ``` =PMT(5%/12, 5*12, -20000) ``` In this formula: - `5%/12` is the monthly interest rate (annual rate divided by 12 months). - `5*12` is the total number of payments (5 years multiplied by 12 months). - `-20000` is the loan amount (entered as a negative value because it represents an outgoing payment). ## Result of the Formula When you apply the PMT formula, the output will show the monthly payment amount: | Loan Amount | Annual Interest Rate | Loan Term | Monthly Payment | | - | - | - | - | | $20,000 | 5% | 5 years | $377.42 | This means you would need to pay approximately $377.42 each month to repay the loan over 5 years. ## Why Use PMT? The PMT function is beneficial because it provides a straightforward way to calculate loan payments without needing to manually compute interest and principal components. It helps in budgeting and financial planning by giving a clear picture of monthly obligations. ## Key Takeaways: - **PMT**: A financial function that calculates the periodic payment for a loan based on interest rate and loan term. - **Easy Calculation**: Simplifies the process of determining loan payments, making it accessible for anyone. - **Budgeting Tool**: Essential for financial planning, helping individuals and businesses manage their cash flow effectively. - **Common Use Cases**: Ideal for calculating payments for mortgages, car loans, personal loans, and any other type of installment financing. The PMT function is an essential tool for anyone dealing with loans, providing clarity and ease in managing financial commitments. Happy budgeting! ## Example use case You have a table with loan amounts in Column A and interest rates in Column B. Use the PMT formula to calculate monthly payments in Column C by entering the loan amount, interest rate, and loan term. This helps employees understand their financial commitments easily. ## Need more help with Google Sheets formulas? Sign up for Better Analyst and get unlimited AI-powered formula generation, explanations, and advanced data analysis. [Create Free Account](https://betteranalyst.com/signup)[Try Formula Generator](https://betteranalyst.com/excel-ai) ## Google Sheets how-to guides - [How To Unhide Columns In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-columns-in-google-sheets) - [How To Unhide Rows In Google Sheets](https://betteranalyst.com/google-sheets/how-to-unhide-all-rows-in-google-sheets) - [How To Unprotect Google Sheets](https://betteranalyst.com/google-sheets/how-to-unprotect-google-sheets) - [How To Wrap Text In Google Sheets](https://betteranalyst.com/google-sheets/how-to-wrap-text-in-google-sheets) - [Google Sheets Conditional Formatting](https://betteranalyst.com/google-sheets/google-sheets-conditional-formatting) - [How To Add A Column In Google Sheets](https://betteranalyst.com/google-sheets/how-to-add-a-column-in-google-sheets) - [How To Alphabetize In Google Sheets](https://betteranalyst.com/google-sheets/how-to-alphabetize-in-google-sheets) - [How To Autofit In Google Sheets](https://betteranalyst.com/google-sheets/how-to-autofit-in-google-sheets) ## Explore all Google Sheets formulas Browse our complete library of Google Sheets formula guides Compare your options ## Decide with evidence, not a sales pitch. Open a neutral research prompt in the AI tool you already use. Compare capabilities, limitations, and fit before you choose. 1. [01ChatGPTOpen a balanced comparison prompt in ChatGPT.](https://chatgpt.com/?prompt=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 2. [02ClaudeOpen the same research prompt in Claude.](https://claude.ai/new?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) 3. [03PerplexityResearch the comparison with linked web sources.](https://www.perplexity.ai/search?q=Compare%20Better%20Analyst%20with%20using%20a%20general-purpose%20AI%20assistant%20for%20data%20analysis.%20Evaluate%20spreadsheet%20and%20document%20analysis%2C%20dashboards%2C%20repeatable%20reports%2C%20code%20transparency%2C%20data%20connections%2C%20pricing%2C%20and%20limitations.%20Use%20current%20public%20sources%2C%20distinguish%20verified%20facts%20from%20assumptions%2C%20and%20explain%20which%20types%20of%20users%20each%20option%20fits%20best.) AI answers can be incomplete. Check source links, current pricing, and product documentation before deciding.