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 |
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 |