Documentation/Calc Functions/PV

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.

Additional details:

 * PV solves the following equation:
 * 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.

Related LibreOffice functions:
[[Special:MyLanguage/Documentation/Calc_Functions/FV FV]

[[Special:MyLanguage/Documentation/Calc_Functions/NPER NPER]

[[Special:MyLanguage/Documentation/Calc_Functions/PMT PMT]

[[Special:MyLanguage/Documentation/Calc_Functions/RATE RATE]

ODF standard:
Section 6.12.41, part 2

Equivalent Excel functions:
PV