# Documentation/Calc Functions/PV

TDF LibreOffice Document Liberation Project Community Blogs Weblate Nextcloud Redmine Ask LibreOffice Donate

## 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:

- 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.

## 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:

## ODF standard:

## Equivalent Excel functions:

PV