Amt_ΣINT: Returns the total principal and interest paid from payment PM1 to PM2.

Syntax: Amt_ΣINT(PM1, PM2, I%, PV, PMT, P/Y, C/Y)

Amt_ΣPRN: Returns the total principal paid from payment PM1 to PM2.

Syntax: Amt_ΣPRN(PM1, PM2, I%, PV, PMT, P/Y, C/Y)

Interest Rate Conversion
Cnvt_EFF:

Returns the interest rate converted from the nominal interest rate to the effective

 

interest rate.

Syntax:

Cnvt_EFF(n, I%)

Cnvt APR:

Returns the interest rate converted from the effective interest rate to the nominal

 

interest rate.

Syntax:

Cnvt APR(n, I%)

Cost, Selling Price, Margin Calculations

Cost: Returns the cost based on a specified selling price and margin.

Syntax: Cost(Sell, Margin)

Sell:Returns the selling price based on a specified cost and margin.

Syntax: Sell(Cost, Margin)

Margin: Returns the margin based on a specified cost and selling price.

Syntax: Margin(Cost, Sell)

Day/Date Calculations

Days Prd: Returns the number of days from a specified d1 to specified d2.

Syntax: Days Prd(MM1, DD1, YYYY1, MM2, DD2, YYYY2)

Bond Calculations
Bond PRC:

Returns in list form bond prices based on specified conditions.

Syntax:

Bond PRC(MM1, DD1, YYYY1, MM2, DD2, YYYY2, RDV, CPN, YLD) = {PRC,

 

INT, CST}

Bond YLD:

Returns the yield based on specified conditions.

Syntax:

Bond YLD(MM1, DD1, YYYY1, MM2, DD2, YYYY2, RDV, CPN, PRC)

8-50