contents.gifprev1.gifnext1.gif

Financial

These are mostly financial functions.

More:

APMT() - Advance payments

ARATE() - Periodic interest rate

ARATEN() - Periodic interest rate

CPMT() - Periodic payment amount (Canadian Mortgage)

CPV() - Loan amount of Canadian mortgage

FFV() - Future value

FV() - Future value

FVAL() - Future value

GPM() - Graduated payment mortgage

IANN() - Increasing annuities

IRR() - Internal rate of return

IRRN() - Internal rate of return

MIRR() - Modified internal rate of return

NFV() - Net future value

NPV() - Net present value

OPC() - Odd period calculation

OPCV() - Odd period calculation with variable period term

PMT() - Periodic payment amount

PMTB() - Remaining balance of constant amount towards principal

PMTS() - Periodic payment amount (Amortize Schedule)

PMTT() - Loan with constant amount towards principal

PPV() - Present value with balloon payment

PV() - Present value

R78() - Rule of 78 interest rebate

R78BAL() - Rule of 78 loan balance

WRAP() - Wrap-around loans

XIRR() - Internal rate of return

XIRRN() - Internal rate of return

XNPV() - Net present value