# Documentation/Calc Functions/FV

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

## Function name:

FV

## Category:

Financial Analysis

## Summary:

Calculates the future value (FV) of an investment using periodic, constant payments and a constant interest rate

## Syntax:

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

## Returns:

Returns a real number(in Currency Units) which is the future value of an investment based on periodic, constant payments and a constant interest rate (Future Value).

## Arguments:

**Rate** is a real number 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 payment period with the total number of periods. **Nper** can also be a non-integer value.(payment period)

**Pmt** is a real number or a reference to that cell containing that number which is the annuity paid regularly per period.

**PV** is a real number or a reference to the cell containing that number which is the (present) cash value of an investment. 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 | due at the end |

1 or other non-zero real number | due at the beginning |

- If
**Rate**,**NPer**or**PV**. are less than or equal to 0 then the function will return an error value.

## Additional details:

None

## Examples:

Formula | Description | Returns |
---|---|---|

=FV(4%;2;750;2500;1) | The function calculates the value at the beginning of an investment if th
---e interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 2,500 currency units. || -4,295.20(currency units) | |

=FV(4%;2;750;2500) | The function calculates the value at the end(Type is 0 by default) of an investment if the interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 2,500 currency units. |
-4234.00(currency units) |

=FV(4%;2;750) | The function calculates the value at the end(Type is 0 by default) of an investment if the interest rate is 4% and the payment period is two years, with a periodic payment of 750 currency units. The investment has a present value of 0 currency units(by default). |
-1,530.00(currency units) |

## Related LibreOffice functions:

## ODF standard:

## Equivalent Excel functions:

FV