| DDB |
Returns the depreciation of an asset for a given time period using the double-declining balance method or another given depreciation method. |
| FV |
Returns the future value of an annuity given the fixed payment amount, the number of payment periods, and the interest rate. |
| IPmt |
Returns the interest portion of the payment for a given period of an annuity. |
| IRR |
Returns the internal rate of return for a series of payments. |
| MIRR |
Returns the modified internal rate of return for a series of payments. |
| NPer |
Returns the number of periods in an annuity given the present value, the fixed payment amount, and the interest rate. |
| NPV |
Returns the net present value of an investment given a series of payments and a discount rate. |
| Pmt |
Returns the fixed payment for an annuity based the present value, the number of payment periods, and the interest rate. |
| PPmt |
Returns the principal portion of the payment for a given period of an annuity. |
| PV |
Returns the present value of an annuity given the fixed payment amount, the number of payment periods, and the interest rate. |
| Rate |
Returns the interest rate for an annuity given the present value, the fixed payment amount, and the number of payment periods. |
| SLN |
Returns the straight-line depreciation of an asset for a single period. |
| SYD |
Returns the sum-of-years' digits depreciation of an asset for a given period. |
