Documentation/Calc Functions/FV

From The Document Foundation Wiki
Jump to: navigation, search

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:

PV

NPER

PMT

RATE

ODF standard:

Section 6.12.20, part 2

Equivalent Excel functions:

FV