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 noninteger 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 nonzero 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