Help >
Financial Functions
Version
7.11
The Financial Functions
For each of these functions that require the interest rate as one of the arguments, you must supply the per-period interest. For example, a 6% annual interest rate is 0.005 per month and 0.015 per quarter. These can
be supplied as .06/12 and .06/4 respectively.
In the financial function descriptions below the following definitions are used:
fv Future value
pv Present value
pmt Payment amount
int Per-period interest
np Number of periods
fv1(pmt;int;np) Future value of a series of equal payments based on
end-of-period payment amount, interest rate, and
number of compounding periods.
fv2(pv;int;np) Future value of present value based on interest rate
and number of compounding periods.
pv1(pmt;int;np) Present value of a series of equal payments based on
payment amount, interest rate, and number of com-
pounding periods.
pv2(fv;int;np) Present value of a future value based on interest
rate and number of compounding periods.
pmt1(int;np;pv) Payment needed to pay off the present value based
on interest rate and number of compounding periods.
pmt2(int;np;fv) Payment needed to pay off future value based on
interest rate and number of compounding periods.
rate1(fv;pv;np) Interest rate required to return the future value
based on present value and number of compounding
periods.
rate2(fv;pmt;np) Interest rate required to return the future value
based on the payment amount and the number of
compounding periods.
rate3(pv;pmt;np) Interest rate required for an annuity (represented by
pv) to return the specified amount for the specified
number of periods.
term1(pv;int;fv) Number of compounding periods for a return of
future value based on present value and interest
rate.
term2(pmt;int;fv) Number of payment periods for a return of future
value based on payments and interest rate.
term3(pmt;int;pv) Number of payment periods needed for the present
value balance to reach zero, based on the payment
amount and interest rate.
Copyright © 2019 , WhamTech, Inc. All rights reserved. This
document is provided for information purposes only and the contents hereof are
subject to change without notice. Names may be
trademarks of their respective owners.