Financial Functions

COMPOUND

returns compound interest parameters

CONVX

returns the convexity for an enumerated cash flow

CONVXP

returns the convexity for a periodic cash flow stream

DACCDB

returns the accumulated declining balance depreciation

DACCDBSL

returns the accumulated declining balance with conversion to a straight-line depreciation

DACCSL

returns the accumulated straight-line depreciation

DACCSYD

returns the accumulated sum-of-years-digits depreciation

DACCTAB

returns the accumulated depreciation from specified tables

DEPDB

returns the declining balance depreciation

DEPDBSL

returns the declining balance with conversion to a straight-line
depreciation

DEPSL

returns the straight-line depreciation

DEPSYD

returns the sum-of-years-digits depreciation

DEPTAB

returns the depreciation from specified tables

DUR

returns the modified duration for an enumerated cash flow

INTRR

returns the internal rate of return as a decimal

IRR

returns the internal rate of return as a percentage

MORT

returns amortization parameters

NETPV

returns the net present value as a decimal

NPV

returns the net present value as a percentage

PVP

returns the present value for a periodic cash flow stream

SAVING

returns the future value of a periodic saving

YIELDP

returns the yield-to-maturity for a periodic cash flow stream