What is PV called in Spanish?

In Spanish Excel it is VA. The formula =PV(B2/12,B3*12,-B1) is written =VA(B2/12;B3*12;-B1) (or with commas in Mexico).

Why does PV use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel PV function

Calculates what a series of future payments is worth today: how much you can borrow with the payment you can afford. In Spanish Excel it is called VA.

Syntax

English Excel

=PV(rate, nper, pmt, [fv], [type])

Spanish Excel (Mexico)

=VA(tasa, nper, pago, [vf], [tipo])

Spanish Excel (Spain, Latin America)

=VA(tasa; nper; pago; [vf]; [tipo])

Argument	What it is
rate	The rate per period.
nper	The number of payments.
pmt	The payment each period (negative).
fvoptional	Balance at the end; 0 by default.
typeoptional	0: payment at the end; 1: at the start.

Example

PV(rate, periods, payment) works it out backwards: given the payment you can afford, how much you can borrow today.

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

Common mistake

Use the same time unit for rate and periods (monthly with monthly).

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 PV

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

Your progress0/94

My Excel is inExcel functions in English and Spanish

How much you can borrow with PV

PV(rate, periods, payment) works it out backwards: given the payment you can afford, how much you can borrow today.

Example=PV(B2/12,B3*12,-B1)VA = PV

Also try Loan Calculator

In B5, calculate the largest mortgage you can pay off with that monthly payment.

	A	B
1	Affordable monthly payment	9,000
2	Annual rate	11%
3	Term (years)	20
4
5	Maximum loan
6

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

Frequently asked questions

What is PV called in Spanish?: In Spanish Excel it is VA. The formula =PV(B2/12,B3*12,-B1) is written =VA(B2/12;B3*12;-B1) (or with commas in Mexico).
Why does PV use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common PV mistake?: Use the same time unit for rate and periods (monthly with monthly).