Filter
Top Products
372 Functions and commands
Finance app functions
The Finance app uses a set of functions that all reference the
same set of Finance app variables. These correspond to the
fields in the Finance app Numeric view. There are 5 main
TVM variables, 4 of which are mandatory for each of these
functions, as they each solve for and return the value of the
fifth variable to two decimal places. DoFinance is the sole
exception to this syntax rule. Note that money paid to you is
entered as a positive number and money you pay to others as
part of a cash flow is entered as a negative number. There are
3 other variables that are optional and have default values.
These variables occur as arguments to the Finance app
functions in the following set order:
– NbPmt—the number of payments
– IPYR—the annual interest rate
– PV—the present value of the investment or loan
– PMTV—the payment value
– FV—the future value of the investment or loan
– PPYR—the number of payments per year (12 by
default)
– CPYR—the number of compounding periods per year
(12 by default)
– BEG—payments made at the beginning or end of the
period; the default is BEG=0, meaning that payments
are made at the end of each period
The arguments PPYR, CPYR, and BEG are optional; if not
supplied, PPYR=12, CPYR=PPYR, and BEG=0.
CalcFV Solves for the future value of an investment or loan.
CalcFV(NbPmt,IPYR,PV,PMTV[,PPYR,CPYR,BEG]
Example:
CalcFV(360, 6.5, 150000, -948.10) returns -2.25