Filter
Top Products
8-36
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)