Cumulative interest on the periodic annuity payments between a start period and an end period
Read moreCumulative principal on the periodic annuity payments between a start period and an end period
Read moreCalculate future value of an annuity based on periodic, constant payments and a constant interest rate.
Read moreRate of an annuity with an odd first period given number of periods, periodic payment, present value, and future value.
Read moreCalculate an annuity-like payment schedule where the first period is a different length of the time than all subsequent periods and those subsequent periods are assumed to be of equal length.
Read moreCalculate the number of periods required by an investment to reach a specified value.
Read moreRate of an annuity given number of periods, periodic payment, present value, and future value
Read moreAccrued interest on a bond where the coupon amounts are calculated as the actual number of days in the coupon period divided by the number of days in the year.
Read moreCalculate the Accrued Interest Factor for a bond during its odd first coupon period
Read moreCalculate the Accrued Interest Factor for a bond during its odd last coupon period
Read moreCalculate the accrued interest for a security where interest is compounded periodically and paid at maturity
Read moreCalculate the accrued interest in first coupon period for a bond with an odd first coupon and a par value of 100
Read moreCalculate the price and/or yield of a bond with an odd first coupon using the ODDFPRICE equation
Read moreCalculate the price and/or yield of a bond with an odd first and an odd last coupon using the OFLPRICE equation
Read moreCalculate the price and/or yield of a bond with an odd last coupon using the ODDLPRICE equation
Read morePrice of a bond where the coupon amounts are calculated as the actual number of days in the coupon period divided by the number of days in the year.
Read moreGenerate the cash flows and discount factors for a bond where the coupon amounts are calculated as the actual number of days in the coupon period divided by the number of days in the year
Read moreFactors for the calculation of the price of a bond that pays regular periodic interest
Read moreYield on a bond where the coupon amounts are calculated as the actual number of days in the coupon period divided by the number of days in the year
Read moreCalculate the date that is the indicated number of months before or after a specified date (the start date).
Read moreCalculate the date for the last day of the month that is the indicated number of months before or after the start date.
Read moreCalculate if a date is a regular payment date for a loan given the first payment date, the issue date, and the number of payments per year.
Read moreCalculate the number of periods (fractional part included) from a cash flow date to a settlement date.
Read morethe intercept of the security characteristic line (SCL), between an asset and a specified benchmark
Read morethe slope of the security characteristic line (SCL), between an asset and a specified benchmark
Read moreCalculate Specific Risk, the standard deviation of the error term in the regression equation
Read moreCalculate the depreciation of an asset for a specified period using the fixed-declining balance method.
Read moreCalculate the depreciation of an asset for a specified period using the double-declining balance method or some other user-specified method.
Read moreCalculate the depreciation of an asset for a specified or partial period by using a declining balance method.
Read moreCalculate the internal rate of return on cash flows produced using the CDRCASHFLOWinputs.
Read moreCalculate the modified internal rate of return, where positive and negative cash flows are financed at different rates.
Read moreInternal rate of return for irregular cash flows using a 30/360 day-count convention
Read moreCalculate the modified internal rate of return, where positive and negative cash flows are financed at different rates and where the cash flows occur irregularly and are specified by date.
Read morecalculate the FIFO balances for each value from the first value to the last value in the ordered group or partition
Read moreSchedule for a loan with a fixed maturity date and annuity-style payments
Read moreSchedule with fixed maturity date where the periodic principal payment is calculated on a straight-line basis
Read moreSchedule with no fixed maturity with a fixed periodic principal payment
Read moreSchedule with no fixed maturity where a fixed percentage principal payment
Read moreCalculate the future value of an initial investment using a series of compound rates.
Read moreAmortization schedule for a loan with constant periodic payemnts and an odd first period where interest is accrued using the US rule
Read moreCalculate the number of payments from the first interest payment date to the last payment date; in other words, the total number of payments over the life of the loan.
Read moreNumber of months until first payment date, start of grace period, end of grace period, and total number payments for a loan
Read moreCalculate the daily interest accruals over a range of dates for a single cash flow or a series of cash flows, using a single rate or a series of rates.
Read moreCalculate a cash-flow schedule for a loan with a fixed periodic payment with Conditional Prepayment Rates (CPR) and Constant Default Rates (CDR) applied.
Read moreCalculate a payment schedule for a loan where the interest payment frequency and the principal payment frequency are different, or the loan starts with an interest only schedule with principal repayments commencing after the first interest payment date.
Read moreCalculate the discounted cash flow value for a loan with a fixed periodic payment with Conditional Prepayment Rates (CPR) and Constant Default Rates (CDR) applied.
Read moreCalculate the net present value of an investment based on a series of periodic cash flows and a discount rate.
Read moreCalculate the net future value of an investment based on a series of periodic cash flows and a rate.
Read moreCalculate the net present value of an investment based on a series of periodic cash flows and a discount rate.
Read moreCalculate the net present value of a series of irregular cash flows—cash flows of varying amounts occurring on various dates.
Read moreCalculate the net present value for a series of cash flows with irregular time periods—cash flows of varying amount occurring at various points in time.
Read moreCalculate a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction.
Read moreCalculate the performance of an investment portfolio based on time-weighted cash flows.
Read moreCalculate a Eurodollars futures price into a forward rate using the Ho Lee convexity adjustment formula.
Read moreCalculate the amount of time (in years) from a start date to the delivery date of a futures contract.
Read moreCalculate discount factors, zero-coupon rates, and continuously compounded zero-coupon rates from a series of cash rates, futures prices, or swaps rates.
Read moreCalculate an interpolated zero-coupon rate from a series of cash rates, futures prices, or swaps rates.
Read more