Financial Functions
| DDB | Returns the depreciation of an asset in a single period (double or higher declining balance method) (Double). |
| FV | Returns the future value of a series of equal cash flows at regular intervals (Double). |
| IPMT | Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
| IRR | Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double). |
| MIRR | Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double). |
| NPER | Returns the number of periods for an investment (Double). |
| NPV | Returns the present value of a series of unequal cash flows at regular intervals (Double). |
| PMT | Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
| PPMT | Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double). |
| PV | Returns the present value of a series of equal cash flows at regular intervals (Double). |
| RATE | Returns the interest rate for a series of equal cash flows at regular intervals (Double). |
| SLN | Returns the straight-line depreciation of an asset over a single period of time (Double). |
| SYD | Returns the sum-of-years' digits depreciation of an asset (Double). |
| DDB Returns the depreciation of an asset in a single period (double or higher declining balance method) (Double). |
| FV Returns the future value of a series of equal cash flows at regular intervals (Double). |
| IPMT Returns the interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
| IRR Returns the interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate) (Double). |
| MIRR Returns the interest rate for a series of unequal cash flows at regular intervals (explicit reinvestment rate) (Double). |
| NPER Returns the number of periods for an investment (Double). |
| NPV Returns the present value of a series of unequal cash flows at regular intervals (Double). |
| PMT Returns the amount of principal and interest paid in a given period in a series of equal cash flows at regular intervals (Double). |
| PPMT Returns the amount of principal paid in a given period in a series of equal cash flows at regular intervals (Double). |
| PV Returns the present value of a series of equal cash flows at regular intervals (Double). |
| RATE Returns the interest rate for a series of equal cash flows at regular intervals (Double). |
| SLN Returns the straight-line depreciation of an asset over a single period of time (Double). |
| SYD Returns the sum-of-years' digits depreciation of an asset (Double). |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top