Syntax
=PV(rate, nper, pmt, [fv], [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 |
fv | Optional | The value left after the last payment (0 when left out) |
type | Optional | 0 for payments at the end of each period, 1 at the start |
How to use PV
PV takes 3 required arguments and 2 optional arguments. Type =PV( 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.
=PV(0.08/12, 12*20, 500, , 0)Result Related financial functions
- PPMTReturns the principal part of one payment of a loan or investment.
- PRICEReturns the price per 100 face value of a security that pays periodic interest.
- PRICEDISCReturns the price per 100 face value of a discounted security.
- PRICEMATReturns the price per 100 face value of a security that pays interest at maturity.
- RATEReturns the interest rate per period of a loan or investment, found by iteration.
- RECEIVEDReturns the amount received at maturity for a fully invested security.
- RRIReturns the equal interest rate per period that grows a present value into a future value.
- SLNReturns the straight line depreciation of an asset for one period.
- SYDReturns the sum of years' digits depreciation of an asset for a period.