J
John
Can the functions below be used or an equivalent formula be used in a
Calculation in an MS Access Query?
Present Valaue and Future Value?
PV
See Also
Returns the present value of an investment. The present value is the total
amount that a series of future payments is worth now. For example, when you
borrow money, the loan amount is the present value to the lender.
Syntax
PV(rate,nper,pmt,fv,type)
Rate is the interest rate per period. For example, if you obtain an
automobile loan at a 10 percent annual interest rate and make monthly
payments, your interest rate per month is 10%/12, or 0.83%. You would enter
10%/12, or 0.83%, or 0.0083, into the formula as the rate.
FV
See Also
Returns the future value of an investment based on periodic, constant
payments and a constant interest rate.
Syntax
FV(rate,nper,pmt,pv,type)
For a more complete description of the arguments in FV and for more
information on annuity functions, see PV.
Rate is the interest rate per period.
Nper is the total number of payment periods in an annuity.
Pmt is the payment made each period; it cannot change over the life of
the annuity. Typically, pmt contains principal and interest but no other fees
or taxes. If pmt is omitted, you must include the pv argument.
Pv is the present value, or the lump-sum amount that a series of future
payments is worth right now. If pv is omitted, it is assumed to be 0 (zero),
and you must include the pmt argument.
Type is the number 0 or 1 and indicates when payments are due. If type is
omitted, it is assumed to be 0.
Calculation in an MS Access Query?
Present Valaue and Future Value?
PV
See Also
Returns the present value of an investment. The present value is the total
amount that a series of future payments is worth now. For example, when you
borrow money, the loan amount is the present value to the lender.
Syntax
PV(rate,nper,pmt,fv,type)
Rate is the interest rate per period. For example, if you obtain an
automobile loan at a 10 percent annual interest rate and make monthly
payments, your interest rate per month is 10%/12, or 0.83%. You would enter
10%/12, or 0.83%, or 0.0083, into the formula as the rate.
FV
See Also
Returns the future value of an investment based on periodic, constant
payments and a constant interest rate.
Syntax
FV(rate,nper,pmt,pv,type)
For a more complete description of the arguments in FV and for more
information on annuity functions, see PV.
Rate is the interest rate per period.
Nper is the total number of payment periods in an annuity.
Pmt is the payment made each period; it cannot change over the life of
the annuity. Typically, pmt contains principal and interest but no other fees
or taxes. If pmt is omitted, you must include the pv argument.
Pv is the present value, or the lump-sum amount that a series of future
payments is worth right now. If pv is omitted, it is assumed to be 0 (zero),
and you must include the pmt argument.
Type is the number 0 or 1 and indicates when payments are due. If type is
omitted, it is assumed to be 0.