Financial Functions
ACCRINT function
The ACCRINT function calculates the accrued interest for a security that pays periodic interest.
ACCRINTM function
The ACCRINTM function calculates the accrued interest for a security that pays interest at maturity.
AMORDEGRC function
The AMORDEGRC function calculates the depreciation of an asset for each accounting period using a degressive depreciation method.
AMORLINC function
The AMORLINC function calculates the depreciation of an asset for each accounting period using a linear depreciation method.
COUPDAYBS function
The COUPDAYBS function calculates the number of days from the beginning of the coupon period to the settlement date.
COUPDAYS function
The COUPDAYS function calculates the number of days in the coupon period that contains the settlement date.
COUPDAYSNC function
The COUPDAYSNC function calculates the number of days from the settlement date to the next coupon payment.
COUPNCD function
The COUPNCD function calculates the next coupon date after the settlement date.
COUPNUM function
The COUPNUM function calculates the number of coupons between the settlement date and the maturity date.
COUPPCD function
The COUPPCD function calculates the previous coupon date before the settlement date.
CUMIPMT function
The CUMIPMT function calculates the cumulative interest paid on an investment between two periods based on a specified interest rate and a constant payment schedule.
CUMPRINC function
The CUMPRINC function calculates the cumulative principal paid on an investment between two periods based on a specified interest rate and a constant payment schedule.
DB function
Calculates the depreciation of an asset for a specified accounting period using the fixed-declining balance method.
DDB function
Calculates the depreciation of an asset for a specified accounting period using the double-declining balance method.
DISC function
Calculates the discount rate for a security.
DOLLARDE function
Converts a dollar price represented as a fraction into a dollar price represented as a decimal number.
DOLLARFR function
Converts a dollar price represented as a decimal number into a dollar price represented as a fraction.
DURATION function
Calculates the Macaulay duration of a security with an assumed par value of $100.
EFFECT function
Calculates the effective annual interest rate for a security based on a specified nominal annual interest rate and the number of compounding periods per year.
FV function
Calculates the future value of an investment based on a specified interest rate and a constant payment schedule.
FVSCHEDULE function
Calculates the future value of an investment based on a series of changeable interest rates.
INTRATE function
Calculates the interest rate for a fully invested security that pays interest only at maturity.
IPMT function
Calculates the interest payment for an investment based on a specified interest rate and a constant payment schedule.
IRR function
Calculates the internal rate of return for a series of periodic cash flows.
ISPMT function
Calculates the interest payment for a specified period of an investment based on a constant payment schedule.
MDURATION function
Calculates the modified Macaulay duration of a security with an assumed par value of $100.
MIRR function
Calculates the modified internal rate of return for a series of periodic cash flows.
NOMINAL function
Calculates the nominal annual interest rate for a security based on a specified effective annual interest rate and the number of compounding periods per year.
NPER function
Calculates the number of periods for an investment based on a specified interest rate and a constant payment schedule.
NPV function
Calculates the net present value of an investment based on a specified discount rate.
ODDFPRICE function
Calculates the price per $100 par value for a security that pays periodic interest but has an odd first period.
ODDFYIELD function
Calculates the yield of a security that pays periodic interest but has an odd first period.
ODDLPRICE function
Calculates the price per $100 par value for a security that pays periodic interest but has an odd last period.
ODDLYIELD function
Calculates the yield of a security that pays periodic interest but has an odd last period.
PDURATION function
Calculates the number of periods required by an investment to reach a specified value.
PMT function
Calculates the payment amount for a loan based on a specified interest rate and a constant payment schedule.
PPMT function
Calculates the principal payment for an investment based on a specified interest rate and a constant payment schedule.
PRICE function
Calculates the price per $100 par value for a security that pays periodic interest.
PRICEDISC function
Calculates the price per $100 par value for a discounted security.
PRICEMAT function
Calculates the price per $100 par value for a security that pays interest at maturity.
PV function
Calculates the present value of an investment based on a specified interest rate and a constant payment schedule.
RATE function
Calculates the interest rate for an investment based on a constant payment schedule.
RECEIVED function
Calculates the amount received at maturity for a fully invested security.
RRI function
Returns an equivalent interest rate for the growth of an investment.
SLN function
Calculates the depreciation of an asset for one accounting period using the straight-line depreciation method.
SYD function
Calculates the depreciation of an asset for a specified accounting period using the sum of the years' digits method.
TBILLEQ function
Calculates the bond-equivalent yield of a Treasury bill.
TBILLPRICE function
Calculates the price per $100 par value for a Treasury bill.
TBILLYIELD function
Calculates the yield of a Treasury bill.
VDB function
Calculates the depreciation of an asset for a specified or partial accounting period using the variable declining balance method.
XIRR function
Calculates the internal rate of return for a series of irregular cash flows.
XNPV function
Calculates the net present value for an investment based on a specified interest rate and a schedule of irregular payments.
YIELD function
Calculates the yield of a security that pays periodic interest.
YIELDDISC function
Calculates the annual yield of a discounted security.
YIELDMAT function
Calculates the annual yield of a security that pays interest at maturity.