Filter
Top Products
368 Functions and commands
– CPYR—the number of compounding periods per year
(12 by default)
– END—payments made at the end of the period
The arguments PPYR, CPYR, and END are optional; if not
supplied, PPYR=12, CPYR=PPYR, and END=1.
CalcFV Solves for the future value of an investment or loan.
CalcFV(NbPmt,IPYR,PV,PMTV[,PPYR,CPYR,END]
CalcIPYR Solves for the interest rate per year of an investment or loan.
CalcIPYR(NbPmt,PV,PMTV,FV[,PPYR,CPYR,
END])
CalcNbPmt Solves for the number of payments in an investment or loan.
CalcNbPmt(IPYR,PV,PMTV,FV[,PPYR,CPYR,END])
CalcPMTV Solves for the value of a payment for an investment or loan.
CalcPMTV(NbPmt,IPYR,PV,FV[,PPYR,CPYR,END])
CalcPV Solves for the present value of an investment or loan.
CalcPV(NbPmt,IPYR,PMTV,FV[,PPYR,CPYR,END])
DoFinance Calculate TVM results. Solves a TVM problem for the variable
TVMVar. The variable must be one of the Finance app's
Numeric view variables. Performs the same calculation as
tapping
in the Numeric view of the Finance app with
TVMVar highlighted.
DoFinance(TVMVar)
Example:
DoFinance(FV) returns the future value of an investment in
the same way as tapping
in the Numeric view of the
Finance app with FV highlighted.