Financial Functions

ACCRINTThe accrued interest for a security that pays interest periodically.
ACCRINTMThe accrued interest for a security that pays interest at maturity.
AMORDEGRCThe depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINCThe depreciation of an asset in a single period (straight-line).
COUPDAYBSThe number of days between the previous coupon date and the settlement date.
COUPDAYSThe number of days between the coupon dates on either side of the settlement date.
COUPDAYSNCThe number of days between the settlement date and the next coupon date.
COUPNCDThe next coupon date after the settlement date.
COUPNUMThe number of coupons between the settlement date and the maturity date.
COUPPCDThe previous coupon date before the settlement date.
CUMIPMTThe cumulative interest paid on a loan between two dates.
CUMPRINCThe cumulative principal paid on a loan between two dates.
DBThe depreciation of an asset in a single period (declining balance method).
DDBThe depreciation of an asset in a single period (double or triple declining balance method).
DISCThe interest rate (or discount rate) for a security held to maturity.
DOLLARDEThe dollar fraction expressed as a decimal.
DOLLARFRThe dollar decimal expressed as a fraction.
DURATIONThe annual duration of a security that pays interest periodically.
EFFECTThe effective interest rate given a nominal interest rate and compounding frequency.
FVThe future value of a series of equal cash flows at regular intervals.
FVSCHEDULEThe future value of an initial principal after applying compound interest rates.
INTRATEThe interest rate for a security held to maturity.
IPMTThe interest paid for a given period in a series of equal cash flows at regular intervals.
IRRThe interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISPMT(IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
MDURATIONThe modified duration for a security that pays interest periodically.
MIRRThe internal rate of return for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
NOMINALThe nominal interest rate over a period given an annual interest rate.
NPERThe number of periods for an investment.
NPVThe present value of a series of unequal cash flows at regular intervals.
ODDFPRICEThe price per $100 face value of a security with an odd first period.
ODDFYIELDThe yield of a security with an odd first period.
ODDLPRICEThe price per $100 face value of a security with an odd last period.
ODDLYIELDThe yield of a security with an odd last period.
PDURATION(2013) The number of periods required by an investment to reach a specified value.
PMTThe payment for a loan with constant payments and fixed interest.
PPMTThe fixed payment made in each period of a series of equal cash flows at regular intervals.
PRICEThe price of a security that pays periodic interest.
PRICEDISCThe price of a discounted security (no interest payments).
PRICEMATThe price of a security that pays interest at maturity.
PVThe present value of a series of equal cash flows at regular intervals.
RATEThe interest rate for a series of equal cash flows at regular intervals.
RECEIVEDThe amount received at the end when a security is held to maturity.
RRI(2013) The equivalent interest rate for the growth of an investment.
SLNThe depreciation of an asset in a single period (straight-line method).
SYDThe depreciation of an asset in a single period (sum-of-years digits method).
TBILLEQThe yield (bond-equivalent) for a treasury bill.
TBILLPRICEThe price per $100 face value for a treasury bill.
TBILLYIELDThe yield for a treasury bill.
VDBThe depreciation of an asset in a single period (variable declining balance method).
XIRRThe interest rate for a series of unequal cash flows at irregular intervals.
XNPVThe present value for a series of unequal cash flows at irregular intervals.
YIELDThe interest rate (annual) for a series of equal cash flows at regular intervals.
YIELDDISCThe interest rate (annual) for a discounted security (no interest payments).
YIELDMATThe interest rate (annual) for a security that pays interest at maturity.
ACCRINT
The accrued interest for a security that pays interest periodically.
ACCRINTM
The accrued interest for a security that pays interest at maturity.
AMORDEGRC
The depreciation of an asset in a single period (straight-line, implicit coefficient).
AMORLINC
The depreciation of an asset in a single period (straight-line).
COUPDAYBS
The number of days between the previous coupon date and the settlement date.
COUPDAYS
The number of days between the coupon dates on either side of the settlement date.
COUPDAYSNC
The number of days between the settlement date and the next coupon date.
COUPNCD
The next coupon date after the settlement date.
COUPNUM
The number of coupons between the settlement date and the maturity date.
COUPPCD
The previous coupon date before the settlement date.
CUMIPMT
The cumulative interest paid on a loan between two dates.
CUMPRINC
The cumulative principal paid on a loan between two dates.
DB
The depreciation of an asset in a single period (declining balance method).
DDB
The depreciation of an asset in a single period (double or triple declining balance method).
DISC
The interest rate (or discount rate) for a security held to maturity.
DOLLARDE
The dollar fraction expressed as a decimal.
DOLLARFR
The dollar decimal expressed as a fraction.
DURATION
The annual duration of a security that pays interest periodically.
EFFECT
The effective interest rate given a nominal interest rate and compounding frequency.
FV
The future value of a series of equal cash flows at regular intervals.
FVSCHEDULE
The future value of an initial principal after applying compound interest rates.
INTRATE
The interest rate for a security held to maturity.
IPMT
The interest paid for a given period in a series of equal cash flows at regular intervals.
IRR
The interest rate for a series of unequal cash flows at regular intervals (implicit reinvestment rate).
ISPMT
(IPMT) The interest paid for a given period in a series of equal cash flows at regular intervals (incorrectly).
MDURATION
The modified duration for a security that pays interest periodically.
MIRR
The internal rate of return for a series of unequal cash flows at regular intervals (explicit reinvestment rate).
NOMINAL
The nominal interest rate over a period given an annual interest rate.
NPER
The number of periods for an investment.
NPV
The present value of a series of unequal cash flows at regular intervals.
ODDFPRICE
The price per $100 face value of a security with an odd first period.
ODDFYIELD
The yield of a security with an odd first period.
ODDLPRICE
The price per $100 face value of a security with an odd last period.
ODDLYIELD
The yield of a security with an odd last period.
PDURATION
(2013) The number of periods required by an investment to reach a specified value.
PMT
The payment for a loan with constant payments and fixed interest.
PPMT
The fixed payment made in each period of a series of equal cash flows at regular intervals.
PRICE
The price of a security that pays periodic interest.
PRICEDISC
The price of a discounted security (no interest payments).
PRICEMAT
The price of a security that pays interest at maturity.
PV
The present value of a series of equal cash flows at regular intervals.
RATE
The interest rate for a series of equal cash flows at regular intervals.
RECEIVED
The amount received at the end when a security is held to maturity.
RRI
(2013) The equivalent interest rate for the growth of an investment.
SLN
The depreciation of an asset in a single period (straight-line method).
SYD
The depreciation of an asset in a single period (sum-of-years digits method).
TBILLEQ
The yield (bond-equivalent) for a treasury bill.
TBILLPRICE
The price per $100 face value for a treasury bill.
TBILLYIELD
The yield for a treasury bill.
VDB
The depreciation of an asset in a single period (variable declining balance method).
XIRR
The interest rate for a series of unequal cash flows at irregular intervals.
XNPV
The present value for a series of unequal cash flows at irregular intervals.
YIELD
The interest rate (annual) for a series of equal cash flows at regular intervals.
YIELDDISC
The interest rate (annual) for a discounted security (no interest payments).
YIELDMAT
The interest rate (annual) for a security that pays interest at maturity.

© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited Top