ACCRINT |
Returns the accrued interest for a security that pays periodic interest |
ACCRINTM |
Returns the accrued interest for a security that pays interest at maturity |
AMORDEGRC |
Returns the depreciation for each accounting period |
AMORLINC |
Returns the depreciation for each accounting period |
COUPDAYBS |
Returns the number of days from the beginning of the coupon period to the settlement date |
COUPDAYS |
Returns the number of days in the coupon period that contains the settlement date |
COUPDAYSNC |
Returns the number of days from the settlement date to the next coupon date |
COUPNCD |
Returns the next coupon date after the settlement date |
COUPNUM |
Returns the number of coupons payable between the settlement date and maturity date |
COUPPCD |
Returns the previous coupon date before the settlement date |
CUMIPMT |
Returns the cumulative interest paid between two periods |
CUMPRINC |
Returns the cumulative principal paid on a loan between two periods |
DB |
Returns the depreciation of an asset for a specified period using the fixed-declining balance method |
DDB |
Returns the depreciation of an asset for a spcified period using the double-declining balance method or some other method you specify |
DISC |
Returns the discount rate for a security |
DOLLARDE |
Converts a dollar price, expressed as a fraction, into a dollar price, expressed as a decimal number |
DOLLARFR |
Converts a dollar price, expressed as a decimal number, into a dollar price, expressed as a fraction |
DURATION |
Returns the annual duration of a security with periodic interest payments |
EFFECT |
Returns the effective annual interest rate |
FV |
Returns the future value of an investment |
FVSCHEDULE |
Returns the future value of an initial principal after applying a series of compound interest rates |
INTRATE |
Returns the interest rate for a fully invested security |
IPMT |
Returns the interest payment for an investment for a given period |
IRR |
Returns the internal rate of return for a series of cash flows |
MDURATION |
Returns the Macauley modified duration for a security with an assumed par value of $100 |
MIRR |
Returns the internal rate of return where positive and negative cash flows are financed at different rates |
NOMINAL |
Returns the annual nominal interest rate |
NPER |
Returns the number of periods for an investment |
NPV |
Returns the net present value of an investment based on a series of periodic cash flows and a discount rate |
ODDFPRICE |
Returns the price per $100 face value of a security with an odd first period |
ODDFYIELD |
Returns the yield of a security with an odd first period |
ODDLPRICE |
Returns the price per $100 face value of a security with an odd last period |
ODDLYIELD |
Returns the yield of a security with an odd last period |
PMT |
Returns the periodic payment for an annuity |
PPMT |
Returns the payment on the principal for an investment for a given period |
PRICE |
Returns the price per $100 face value of a security that pays periodic interest |
PRICEDISC |
Returns the price per $100 face value of a discounted security |
PRICEMAT |
Returns the price per $100 face value of a security that pays interest at maturity |
PV |
Returns the present value of an investment |
RATE |
Returns the interest rate per period of an annuity |
RECEIVED |
Returns the amount received at maturity for a fully invested security |
SLN |
Returns the straight-line depreciation of an asset for one period |
SYD |
Returns the sum-of-years' digits depreciation of an asset for a specified period |
TBILLEQ |
Returns the bond-equivalent yield for a Treasury bill |
TBILLPRICE |
Returns the price per $100 face value for a Treasury bill |
TBILLYIELD |
Returns the yield for a Treasury bill |
VDB |
Returns the depreciation of an asset for a specified or partial period using a declining balance method |
XIRR |
Returns the internal rate of return for a schedule of cash flows that is not necessarily periodic |
XNPV |
Returns the net present value for a schedule of cash flows that is not necessarily periodic |
YIELD |
Returns the yield on a security that pays periodic interest |
YIELDDISC |
Returns the annual yield for a discounted security. For example, a treasury bill |
YIELDMAT |
Returns the annual yield of a security that pays interest at maturity |