Financial
|
Element |
Description |
|---|---|
|
DDB function |
Returns double-declining balance depreciation of an asset for a specific period |
|
FV function |
Calculates the future value of an annuity |
|
IPmt function |
Computes the interest payment for a given period of an annuity |
|
IRR function |
Calculates the internal rate of return for a series of periodic cash flows |
|
MIRR function |
Calculates the modified internal rate of return |
|
NPer function |
Determines the number of payment periods for an annuity, based on fixed periodic payments and a fixed interest rate |
|
NPV function |
Calculates the net present value of an investment |
|
Pmt function |
Calculates the payment for an annuity |
|
PPmt function |
Computes the payment of principal for a given period of an annuity |
|
PV function |
Calculates the present value of an annuity |
|
Rate function |
Returns the interest rate per period for an annuity |
|
SLN method |
Computes the straight-line depreciation of an asset |
|
SYD function |
Computes the sum-of-years’ digits depreciation of an asset for a specified period |
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access