Syntax
=FV(rate, nper, pmt, [pv], [type])Arguments
| Argument | Required | Description |
|---|---|---|
rate | Required | The interest rate per period |
nper | Required | The number of payment periods |
pmt | Required | The payment made each period |
pv | Optional | The present value (0 when left out) |
type | Optional | 0 for payments at the end of each period, 1 at the start |
How to use FV
FV takes 3 required arguments and 2 optional arguments. Type =FV( in a cell and SheetsBat shows the arguments as you go. Optional arguments are shown in square brackets; leave them out to use their default.
Examples
Each result below was calculated by the SheetsBat formula engine.
=FV(0.06/12, 10, -200, -500, 1)Result =FV(0.12/12, 12, -1000)Result Related financial functions
- DOLLARDEConverts a price written as a whole number and a fraction (like 1.02 meaning 1 and 2/16) to a decimal number.
- DOLLARFRConverts a decimal price to a whole number and a fraction written after the decimal point.
- DURATIONReturns the Macaulay duration in years of a security that pays periodic interest, for 100 face value.
- EFFECTReturns the effective annual interest rate from a nominal rate and the compounding periods per year.
- FVSCHEDULEReturns the future value of a principal after applying a series of interest rates.
- INTRATEReturns the interest rate of a fully invested security.
- IPMTReturns the interest part of one payment of a loan or investment.
- IRRReturns the internal rate of return of cash flows at regular periods.
- ISPMTReturns the interest paid in one period of a loan with equal principal repayments.