Filter
Top Products
Functions and commands 373
CalcIPYR Solves for the interest rate per year of an investment or loan.
CalcIPYR(NbPmt,PV,PMTV,FV[,PPYR,CPYR,
BEG])
Example:
CalcIPYR(360, 150000, -948.10, -2.25) returns
6.50
CalcNbPmt Solves for the number of payments in an investment or loan.
CalcNbPmt(IPYR,PV,PMTV,FV[,PPYR,CPYR,BEG])
Example:
CalcNbPmt(6.5, 150000, -948.10, -2.25) returns
360.00
CalcPMT Solves for the value of a payment for an investment or loan.
CalcPMT(NbPmt,IPYR,PV,FV[,PPYR,CPYR,BEG])
Example:
CalcPMT(360, 6.5, 150000, -2.25) returns
-948.10
CalcPV Solves for the present value of an investment or loan.
CalcPV(NbPmt,IPYR,PMTV,FV[,PPYR,CPYR,BEG])
Example:
CalcPV(360, 6.5, -948.10, -2.25) returns
150000.00
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.