User Manual

8-40
• Amortization
Amt_BAL: Returns the remaining principal balance following payment PM2.
Syntax: Amt_BAL(PM1, PM2,
I %, PV, PMT, P/Y, C/Y)
Amt_INT: Returns the interest paid for payment PM1.
Syntax: Amt_INT(PM1, PM2,
I %, PV, PMT, P/Y, C/Y)
Amt_PRN: Returns the principal and interest paid for payment PM1.
Syntax: Amt_PRN(PM1, PM2,
I %, PV, PMT, P/Y, C/Y)
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)