Status | Function | Description |
|---|---|---|
Not started | ACCRINT | Returns the accrued interest for a security that pays periodic interest. |
Not started | ACCRINTM | Returns the accrued interest for a security that pays interest at maturity. |
Not started | AMORDEGRC | Returns the depreciation for each accounting period. Similar to AMORLINC, except a depreciation coefficient is applied depending on the life of the assets. |
Not started | AMORLINC | Returns the depreciation for each accounting period. |
Not started | COUPDAYBS | Returns the number of days from the beginning of a coupon period until its settlement date. |
Not started | COUPDAYS | Returns the number of days in the coupon period that contains the settlement date. |
Not started | COUPDAYSNC | Returns the number of days from the settlement date to the next coupon date. |
Not started | COUPNCD | Returns the next coupon date after the settlement date. |
Not started | COUPNUM | Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon. |
Not started | COUPPCD | Returns the previous coupon date before the settlement date. |
Not started | CUMIPMT | Returns the cumulative interest paid on a loan between start_period and end_period. |
Not started | CUMPRINC | Returns the cumulative principal paid on a loan between start_period and end_period. |
Not started | DB | Returns the depreciation of an asset for a specified period using the fixed-declining balance method. |
Not started | DDB | Returns the depreciation of an asset for a specified period using the double-declining balance method or some other method you specify. |
Not started | DISC | Returns the discount rate for a security. |
Not started | DOLLARDE | Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. |
Not started | DOLLARFR | Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. |
Not started | DURATION | Returns the Macauley duration for an assumed par value of $100. |
Not started | EFFECT | Returns the effective annual interest rate, given the nominal annual interest rate and the number of compounding periods per year. |
Not started | FV | Calculates the future value of an investment based on a constant interest rate. |
Not started | INTRATE | Returns the interest rate for a fully invested security. |
Not started | IPMT | Returns the interest payment for a given period for an investment based on periodic, constant payments and a constant interest rate. |
Not started | ISPMT | Calculates the interest paid (or received) for the specified period of a loan (or investment) with even principal payments. |
Not started | MDURATION | Returns the modified Macauley duration for a security with an assumed par value of $100. |
Not started | NOMINAL | Returns the nominal annual interest rate, given the effective rate and the number of compounding periods per year. |
Not started | NPER | Returns the number of periods for an investment based on periodic, constant payments and a constant interest rate. |
Not started | ODDFPRICE | Returns the price per $100 face value of a security having an odd (short or long) first period. |
Not started | ODDFYIELD | Returns the yield of a security that has an odd (short or long) first period. |
Not started | ODDLPRICE | Returns the price per $100 face value of a security having an odd (short or long) last coupon period. |
Not started | ODDLYIELD | Returns the yield of a security that has an odd (short or long) last period. |
Not started | PDURATION | Returns the number of periods required by an investment to reach a specified value. |
Not started | PMT | Calculates the payment for a loan based on constant payments and a constant interest rate. |
Not started | PPMT | Returns the payment on the principal for a given period for an investment based on periodic, constant payments and a constant interest rate. |
Not started | PRICE | Returns the price per $100 face value of a security that pays periodic interest. |
Not started | PRICEDISC | Returns the price per $100 face value of a discounted security. |
Not started | PRICEMAT | Returns the price per $100 face value of a security that pays interest at maturity. |
Not started | PV | Calculates the present value of a loan or an investment, based on a constant interest rate. |
Not started | RATE | Returns the interest rate per period of an annuity. |
Not started | RECEIVED | Returns the amount received at maturity for a fully invested security. |
Not started | RRI | Returns an equivalent interest rate for the growth of an investment. |
Not started | SLN | Returns the straight-line depreciation of an asset for one period. |
Not started | SYD | Returns the sum-of-years' digits depreciation of an asset for a specified period. |
Not started | TBILLEQ | Returns the bond-equivalent yield for a Treasury bill. |
Not started | TBILLPRICE | Returns the price per $100 face value for a Treasury bill. |
Not started | TBILLYIELD | Returns the yield for a Treasury bill. |
Not started | VDB | Returns the depreciation of an asset for any period you specify, including partial periods, using the double-declining balance method or some other method you specify. |
Not started | XIRR | Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic. |
Not started | XNPV | Returns the present value for a schedule of cash flows that is not necessarily periodic. |
Not started | YIELD | Returns the yield on a security that pays periodic interest. |
Not started | YIELDDISC | Returns the annual yield for a discounted security. |
Not started | YIELDMAT | Returns the annual yield of a security that pays interest at maturity. |