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”.

FinancialFunctionSyntaxThis function
Calculationreturns:

 

 

 

 

 

 

Simple

simpInt

simpInt(Days,I%,PV)

SI

Interest

 

 

 

simpFV

simpFV(Days,I%,PV)

SFV

 

 

 

 

 

 

cmpdFV*1

cmpdFV(N,I%,PV,PMT,P/Y,C/Y)

FV

Compound

cmpdIR*1

cmpdIR(N,PV,PMT,FV,P/Y,C/Y)

I%

cmpdN*1

cmpdN(I%,PV,PMT,FV,P/Y,C/Y)

N

Interest

cmpdPmt*1

cmpdPmt(N,I%,PV,FV,P/Y,C/Y)

PMT

 

 

cmpdPV*1

cmpdPV(N,I%,PMT,FV,P/Y,C/Y)

PV

 

cashIRR

cashIRR(Cash)

IRR

 

 

 

 

Cash Flow

cashNFV

cashNFV(I%,Cash)

NFV

 

 

 

cashNPV

cashNPV(I%,Cash)

NPV

 

 

 

 

 

 

cashPBP

cashPBP(I%,Cash)

PBP

 

 

 

 

 

amortBal

amortBal(PM1,PM2,I%,PV,PMT,P/Y,C/Y)

BAL

 

 

 

 

 

amortInt

amortInt(PM1,PM2,I%,PV,PMT,P/Y,C/Y)

INT

 

 

 

 

Amortization

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

convEff

convEff(N,I%)

EFF

Conversion

convNom

convNom(N,I%)

APR

 

 

 

 

Cost/Sell/

priceCost

priceCost(Sell,Margin)

Cost

 

 

 

priceSell

priceSell(Cost,Margin)

Sell

Margin

 

 

 

priceMargin

priceMargin(Cost,Sell)

Margin

 

 

 

 

 

Day Count

dayCount

dayCount(MM1,DD1,YYYY1,MM2,DD2,YYYY2)

Days

 

 

 

 

 

bondPriceDate*2

bondPriceDate(MM1,DD1,YYYY1,MM2,DD2,

{PRC,INT,CST}

 

YYYY2,RDV,CPN,YLD)

 

 

 

 

 

 

 

Bond

bondPriceTerm*3

bondPriceTerm(N,RDV,CPN,YLD)

{PRC,INT,CST}

Calculation

bondYieldDate*2

bondYieldDate(MM1,DD1,YYYY1,MM2,DD2,

YLD

 

YYYY2,RDV,CPN,PRC)

 

 

 

 

 

 

 

 

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”.

Chapter 11: Financial Application

187