Financial
29 functions in this section.
| CUMIPMT | Returns the cumulative interest paid on a loan between two specified payment periods. |
| CUMPRINC | Returns the cumulative principal repaid on a loan between two specified payment periods. |
| DB | Returns the depreciation of an asset for a given year using the fixed-rate declining-balance method. |
| DDB | Returns the depreciation of an asset for a given year using the double declining-balance method (or any other factor). |
| DOLLARDE | Converts a fractional number representation of a number into a decimal number. |
| DOLLARFR | Converts a decimal number into a fractional representation of that number. |
| EFFECT | Returns the effective annual interest rate, given a nominal rate and the number of compounding periods per year. |
| FV | Returns the future value of an investment consisting of periodic payments and/or an initial lump sum, at a constant interest rate. |
| FVSCHEDULE | Returns the future value of a lump sum after applying a series of variable interest rates, one per period. |
| IPMT | Returns the interest portion of a specific periodic payment for a fixed-rate loan or annuity. |
| IRR | Calculates the internal rate of return (IRR) of a series of equally spaced cash flows. |
| ISPMT | Returns the interest paid in a given period for a loan with equal principal repayments. |
| MIRR | Returns the modified internal rate of return (MIRR) of a series of equally spaced cash flows. |
| NOMINAL | Returns the nominal interest rate, given the effective annual rate and the number of compounding periods per year. |
| NPER | Returns the number of payment periods needed to reach a target value, given a constant interest rate and regular payments. |
| NPV | Returns the net present value (NPV) of a series of future cash flows, discounted at a constant rate. |
| PDURATION | Returns the number of compounding periods required for an investment to grow from a present value to a future value at a constant interest rate. |
| PMT | Returns the fixed periodic payment for a loan or annuity at a constant interest rate. |
| PPMT | Returns the principal portion of a specific periodic payment for a fixed-rate loan or annuity. |
| PV | Returns the present value of a stream of future payments, optionally combined with a final lump sum. |
| RATE | Returns the interest rate per period of an annuity. |
| RRI | Returns the equivalent compound interest rate needed for an investment to grow from a present value to a future value over a given number of periods. |
| SLN | Returns the depreciation of an asset in a single period using the straight-line method. |
| SYD | Returns the depreciation of an asset for a given year using the sum-of-years'-digits method. |
| TBILLEQ | Returns the bond-equivalent yield (BEY) for a US Treasury bill. |
| TBILLPRICE | Returns the price per $100 face value of a US Treasury bill, given its discount rate. |
| TBILLYIELD | Returns the yield for a US Treasury bill, given its price. |
| XIRR | Calculates the internal rate of return of a series of cash flows that occur on specific dates. |
| XNPV | Returns the net present value of a series of cash flows that occur on specific dates. |