| Name | Description | |
|---|---|---|
  | DDB | Returns a value specifying the depreciation of an asset for a specific time period using the double-declining balance method or some other method you specify. |
| FV | Returns a value specifying the future value of an annuity based on periodic, fixed payments and a fixed interest rate. |
| IPmt | Returns a value specifying the interest payment for a given period of an annuity based on periodic, fixed payments and a fixed interest rate. |
| NPer | Returns a value specifying the number of periods for an annuity based on periodic fixed payments and a fixed interest rate. |
| Pmt | Returns a value specifying the payment for an annuity based on periodic, fixed payments and a fixed interest rate. |
| PPmt | Returns a value specifying the principal payment for a given period of an annuity based on periodic fixed payments and a fixed interest rate. |
| PV | Returns a value specifying the present value of an annuity based on periodic, fixed payments to be paid in the future and a fixed interest rate. |
| Rate | Returns a value specifying the interest rate per period for an annuity. |
| SLN | Returns a value specifying the straight-line depreciation of an asset for a single period. |
| SYD | Returns a value specifying the sum-of-years digits depreciation of an asset for a specified period. |