Documentation/Calc Functions/FV

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.


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

Additional details:
None

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

[[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.20, part 2

Equivalent Excel functions:
FV