Function | Purpose Statement |
Evaluates the number of days from January 1, 1900, to the given date. | |
Evaluates the number of days from the beginning of the coupon period to the settlement date. | |
Gives the date corresponding to the number of days since January 1, 1900. | |
Evaluates the number of days from settlement date to the next coupon date. | |
Solves a first order differential-algebraic system of equations, g(t, y, y′) = 0, using the Petzold-Gear BDF method. | |
Evaluates the depreciation for each accounting period. Similar to depreciation_amorlinc. | |
Evaluates the depreciation for each accounting period. Similar to depreciation_amordegrc. | |
Evaluates the depreciation of an asset for a specified period using the fixed-declining balance method. | |
Evaluates the depreciation of an asset for a specified period using the double-declining method. | |
Evaluates the straight line depreciation of an asset for one period. | |
Evaluates the sum-of-years digits depreciation of an asset for a specified period. | |
Evaluates the depreciation of an asset for any given period, including partial periods, using the double-declining balance method. | |
Solves a first order differential-algebraic system of equations, g(t, y, y′) = 0, with optional additional constraints and user-defined linear system solver. | |
Evaluates the price per $100 face value of a discounted security. | |
Evaluates the discount rate for a security. | |
Evaluates the annual yield for a discounted security. | |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number. | |
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction. | |
Evaluates the annual duration of a security with periodic interest payment. |