Language Reference

Financial Functions

COMPOUNDreturns compound interest parameters
CONVXreturns the convexity for an enumerated cash flow
CONVXPreturns the convexity for a periodic cash flow stream
DACCDBreturns the accumulated declining balance depreciation
DACCDBSLreturns the accumulated declining balance with conversion to a straight-line depreciation
DACCSLreturns the accumulated straight-line depreciation
DACCSYDreturns the accumulated sum-of-years-digits depreciation
DACCTABreturns the accumulated depreciation from specified tables
DEPDBreturns the declining balance depreciation
DEPDBSLreturns the declining balance with conversion to a straight-line depreciation
DEPSLreturns the straight-line depreciation
DEPSYDreturns the sum-of-years-digits depreciation
DEPTABreturns the depreciation from specified tables
DURreturns the modified duration for an enumerated cash flow
INTRRreturns the internal rate of return as a decimal
IRRreturns the internal rate of return as a percentage
MORTreturns amortization parameters
NETPVreturns the net present value as a decimal
NPVreturns the net present value as a percentage
PVPreturns the present value for a periodic cash flow stream
SAVINGreturns the future value of a periodic saving
YIELDPreturns the yield-to-maturity for a periodic cash flow stream

Previous Page | Next Page | Top of Page