Documentation/Calc Functions/PV

From The Document Foundation Wiki
Jump to: navigation, search

Function name:

PV

Category:

Financial Analysis

Summary:

Calculates the present value of an investment resulting from a series of regular payments.

Syntax:

PV(Rate; NPer; Pmt[; FV[; Type]])

Returns:

Returns a real number (in currency units) which is the present value (PV) of an investment with the given parametric constraints.

Arguments:

Rate is a real number (expressed as a percentage or fraction) or a reference to the cell containing that number which is the periodic interest rate.

NPer is a real number or a reference to the cell containing that number which is the total number of periods (payment period).

Pmt is a real number or a reference to the cell containing that number which is the constant annuity paid in each period.

FV is a real number or a reference to the cell containing that number which is the desired value (future value) at the end of the periods. If it is omitted, then the function uses 0.

Type is the due date of the payment at the beginning or end of each period. If it is omitted, then the function uses 0.

Type Maturity Date
0 or FALSE due at the end
1 or any other number (including TRUE) except 0 due at the beginning

Additional details:

  • PV solves the following equation:
Nper.png
  • Use this function to calculate the amount of money needed to be invested at a fixed rate today, to receive a specific amount, an annuity, over a specified number of periods. You can also determine how much money is to remain after the elapse of the period. Specify as well if the amount is to be paid out at the beginning or at the end of each period.
  • Enter these values either as numbers, expressions, or references. If, for example, interest is paid annually at 8%, but you want to use the month as your period, enter 8%/12 under Rate and LibreOffice Calc with automatically calculate the correct factor.
Note pin.svg

If you enter references instead of these values into the formula, you can calculate any number of "If-then" scenarios. Please note: references to constants must be defined as absolute references. Examples of this type of application are found under the depreciation functions.


Examples:

Formula Description Returns
=PV(8%/12;48;500;20000) The function calculates the present value of an investment if 500 currency units are paid out monthly and the annual interest rate is 8%? The payment period is 48 months and 20,000 currency units are to remain at the end of the payment period. Under the named conditions, you must deposit 35,019.37 currency units today, if you want to receive 500 currency units per month for 48 months and have 20,000 currency units left over at the end (Type = 0 by default). Cross-checking shows that 48 x 500 currency units + 20,000 currency units = 44,000 currency units. The difference between this amount and the 35,000 currency units deposited represents the interest paid. -35,019.37 (currency units)
=PV(8%/12;48;500;20000;1) The function calculates the present value of an investment if 500 currency units are paid out monthly and the annual interest rate is 8%? The payment period is 48 months and 20,000 currency units are to remain at the end of the payment period. (Due at the beginning) -35,155.91 (currency units)

Related LibreOffice functions:

FV

NPER

PMT

RATE

ODF standard:

Section 6.12.41, part 2

Equivalent Excel functions:

PV