Syntax: Cmpd_PMT(n, I%, PV, FV, P/Y, C/Y)

Cmpd_FV: Returns the final input/output amount or total principal and interest.

Syntax: Cmpd_FV(n, I%, PV, PMT, P/Y, C/Y)

•Cash Flow (Investment Appraisal) Cash_NPV: Returns the net present value.

Syntax: Cash_NPV(I%, Csh)

Cash_IRR: Returns the internal rate of return.

Syntax: Cash_IRR(Csh)

Cash_PBP: Returns the payback period.

Syntax: Cash_PBP(I%, Csh)

Cash_NFV: Returns the net future value.

Syntax: Cash_NFV(I%, Csh)

•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_3INT: Returns the total principal and interest paid from payment PM1 to PM2.

Syntax: Amt_3INT(PM1, PM2, I%, PV, PMT, P/Y, C/Y)

Amt_3PRN: Returns the total principal paid from payment PM1 to PM2.

Syntax: Amt_3PRN(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)

8-36