Chapter 11 Financial Application 187
11-4 Financial Calculation Functions
ClassPad mathematical functions can be used to perform some Financial application calculations. ClassPad
mathematical functions can be selected on the [Financial] submenu of the [Action] menu of the Main application
or eActivity application.
The table below shows a list of mathematical functions that perform financial calculations. For descriptions of
the arguments shown in each syntax and the values returned by each function, refer to “11-5 Input and Output
Field Names”.
Financial
Calculation
Function Syntax
This function
returns:
Simple
Interest
simpInt simpInt(Days,I%,PV) SI
simpFV simpFV(Days,I%,PV) SFV
Compound
Interest
cmpdFV*
1
cmpdFV(N,I%,PV,PMT,P/Y,C/Y) FV
cmpdIR*
1
cmpdIR(N,PV,PMT,FV,P/Y,C/Y) I%
cmpdN*
1
cmpdN(I%,PV,PMT,FV,P/Y,C/Y) N
cmpdPmt*
1
cmpdPmt(N,I%,PV,FV,P/Y,C/Y) PMT
cmpdPV*
1
cmpdPV(N,I%,PMT,FV,P/Y,C/Y) PV
Cash Flow
cashIRR cashIRR(Cash) IRR
cashNFV cashNFV(I%,Cash) NFV
cashNPV cashNPV(I%,Cash) NPV
cashPBP cashPBP(I%,Cash) PBP
Amortization
amortBal amortBal(PM1,PM2,I%,PV,PMT,P/Y,C/Y) BAL
amortInt amortInt(PM1,PM2,I%,PV,PMT,P/Y,C/Y) INT
amortPrn amortPrn(PM1,PM2,I%,PV,PMT,P/Y,C/Y) PRN
amortSumInt amortSumInt(PM1,PM2,I%,PV,PMT,P/Y,C/Y)
ΣINT
amortSumPrn amortSumPrn(PM1,PM2,I%,PV,PMT,P/Y,C/Y)
ΣPRN
Interest
Conversion
convEff convEff(N,I%) EFF
convNom convNom(N,I%) APR
Cost/Sell/
Margin
priceCost priceCost(Sell,Margin) Cost
priceSell priceSell(Cost,Margin) Sell
priceMargin priceMargin(Cost,Sell) Margin
Day Count dayCount dayCount(MM1,DD1,YYYY1,MM2,DD2,YYYY2) Days
Bond
Calculation
bondPriceDate*
2
bondPriceDate(MM1,DD1,YYYY1,MM2,DD2,
YYYY2,RDV,CPN,YLD)
{PRC,INT,CST}
bondPriceTerm*
3
bondPriceTerm(N,RDV,CPN,YLD) {PRC,INT,CST}
bondYieldDate*
2
bondYieldDate(MM1,DD1,YYYY1,MM2,DD2,
YYYY2,RDV,CPN,PRC)
YLD
bondYieldTerm*
3
bondYieldTerm(N,RDV,CPN,PRC) YLD
*1 P/Y and C/Y can be omitted. When they are omitted, calculations are performed using P/Y=1 and C/Y=1.
*2 “Date” must be specified for the Financial Format “Bond Interval”.
*3 “Term” must be specified for the Financial Format “Bond Interval”.
