What is PMT called in Spanish?

In Spanish Google Sheets it is PAGO. The formula =PMT(B2/12,B3*12,-B1) is written =PAGO(B2/12;B3*12;-B1) (or with commas under a Mexico locale).

Why does PMT use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets PMT function

Calculates a loan’s fixed payment. In Spanish Sheets it is called PAGO.

Syntax

English Sheets

=PMT(rate, number_of_periods, present_value, [future_value])

Spanish Sheets (Mexico locale)

=PAGO(tipo, número_de_períodos, valor_actual, [valor_futuro])

Spanish Sheets (Spain, Latin America)

=PAGO(tipo; número_de_períodos; valor_actual; [valor_futuro])

Argument	What it is
rate	The rate per period (annual/12 for monthly payments).
number_of_periods	How many payments.
present_value	The loan amount.
future_valueoptional	What should remain at the end; 0 by default.

Example

PMT(rate, number_of_periods, present_value) calculates a loan’s fixed payment. If you pay monthly, the rate and periods must be monthly: annual rate/12 and years×12. Sheets returns the payment as negative (money going out); make the amount negative to see it positive.

=PMT(B2/12,B3*12,-B1)

Common mistake

It returns a negative number because it is money going out; make the amount negative to see it positive. Rate and periods must use the same unit.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice PMT

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/103

My spreadsheet is inGoogle Sheets functions in English and Spanish

Monthly payment with PMT

Example=PMT(B2/12,B3*12,-B1)PAGO = PMT

Also try Loan Calculator

In B5, calculate the car loan’s monthly payment, as a positive number.

	A	B
1	Loan amount	250000
2	Annual rate	12%
3	Term (years)	4
4
5	Monthly payment
6

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is PMT called in Spanish?: In Spanish Google Sheets it is PAGO. The formula =PMT(B2/12,B3*12,-B1) is written =PAGO(B2/12;B3*12;-B1) (or with commas under a Mexico locale).
Why does PMT use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common PMT mistake?: It returns a negative number because it is money going out; make the amount negative to see it positive. Rate and periods must use the same unit.