[]
Spread provides the following financial functions, listed alphabetically.
Function | Description |
---|---|
This function calculates the accrued interest for a security that pays periodic interest. | |
This function calculates the accrued interest at maturity for a security that pays periodic interest. | |
This function returns the depreciation for an accounting period, taking into consideration prorated depreciation, and applies a depreciation coefficient in the calculation based on the life of the assets. | |
This function calculates the depreciation for an accounting period, taking into account prorated depreciation. | |
This function calculates the number of days from the beginning of the coupon period to the settlement date. | |
This function returns the number of days in the coupon period that contains the settlement date. | |
This function calculates the number of days from the settlement date to the next coupon date. | |
This function returns a date number of the next coupon date after the settlement date. | |
This function returns the number of coupons due between the settlement date and maturity date. | |
This function returns a date number of the previous coupon date before the settlement date. | |
This function returns the cumulative interest paid on a loan between the starting and ending periods. | |
This function returns the cumulative principal paid on a loan between the start and end periods. | |
This function calculates the depreciation of an asset for a specified period using the fixed‑declining balance method. | |
This function calculates the depreciation of an asset for a specified period using the double-declining balance method or another method you specify. | |
This function calculates the discount rate for security. | |
This function converts a fraction dollar price to a decimal dollar price. | |
This function converts a decimal number dollar price to a fraction dollar price. | |
This function returns the Macaulay duration for an assumed par value of $100. | |
This function calculates the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year. | |
This function returns the future value of an investment based on a present value, periodic payments, and a specified interest rate. | |
This function returns the future value of an initial principal after applying a series of compound interest rates. Calculate future value of an investment with a variable or adjustable rate. | |
This function calculates the interest rate for a fully invested security. | |
This function calculates the payment of interest on a loan. | |
This function returns the internal rate of return for a series of cash flows represented by the numbers in an array. | |
This function calculates the interest paid during a specific period of an investment. | |
This function calculates the modified Macaulay duration of a security with an assumed par value of $100. | |
This function returns the modified internal rate of return for a series of periodic cash flows. | |
This function returns the nominal annual interest rate for a given effective rate and the number of compounding periods per year. | |
This function returns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate. | |
This function calculates the net present value of an investment by using a discount rate and a series of future payments and income. | |
This function calculates the price per $100 face value of a security with an odd first period. | |
This function calculates the yield of a security with an odd first period. | |
This function calculates the price per $100 face value of a security with an odd last coupon period. | |
This function calculates the yield of a security with an odd last period. | |
This function returns the number of periods required by an investment to reach a specified value. | |
This function returns the payment amount for a loan given the present value, specified interest rate, and the number of terms. | |
This function returns the amount of payment of principal for a loan given the present value, specified interest rate, and the number of terms. | |
This function calculates the price per $100 face value of periodic interest security. | |
This function returns the price per $100 face value of a discounted security. | |
This function returns the price at maturity per $100 face value of a security that pays interest. | |
This function returns the present value of an investment based on the interest rate, number and amount of periodic payments, and future value. The present value is the total amount that a series of future payments is worth now. | |
This function returns the interest rate per period of an annuity. | |
This function returns the amount received at maturity for a fully invested security. | |
This function returns an equivalent interest rate for the growth of an investment. | |
This function returns the straight-line depreciation of an asset for one period. | |
This function returns the sum-of-years' digits depreciation of an asset for a specified period. | |
This function returns the equivalent yield for a Treasury bill (or T-bill). | |
This function returns the price per $100 face value for a Treasury bill (or T-bill). | |
This function returns the yield for a Treasury bill (or T-bill). | |
This function returns the depreciation of an asset for any period you specify using the variable declining balance method. | |
This function calculates the internal rate of return for a schedule of cash flows that may not be periodic. | |
This function calculates the net present value for a schedule of cash flows that may not be periodic. | |
This function calculates the yield on a security that pays periodic interest. | |
This function calculates the annual yield for a discounted security. | |
This function calculates the annual yield of a security that pays interest at maturity. |