Financial Functions

ACCRINT

This function calculates the accrued interest for a security that pays periodic interest.

ACCRINTM

This function calculates the accrued interest at maturity for a security that pays periodic interest.

AMORDEGRC

This function returns the depreciation for an accounting period, taking into consideration prorated depreciation, and applies a depreciation coefficient in the calculation based on the life of the assets.

AMORLINC

This function calculates the depreciation for an accounting period, taking into account prorated depreciation.

COUPDAYBS

This function calculates the number of days from the beginning of the coupon period to the settlement date.

COUPDAYS

This function returns the number of days in the coupon period that contains the settlement date.

COUPDAYSNC

This function calculates the number of days from the settlement date to the next coupon date.

COUPNCD

This function returns a date number of the next coupon date after the settlement date.

COUPNUM

This function returns the number of coupons due between the settlement date and maturity date.

COUPPCD

This function returns a date number of the previous coupon date before the settlement date.

CUMIPMT

This function returns the cumulative interest paid on a loan between the starting and ending periods.

CUMPRINC

This function returns the cumulative principal paid on a loan between the start and end periods.

DB

This function calculates the depreciation of an asset for a specified period using the fixed‑declining balance method.

DDB

This function calculates the depreciation of an asset for a specified period using the double-declining balance method or another method you specify.

DISC

This function calculates the discount rate for security.

DOLLARDE

This function converts a fraction dollar price to a decimal dollar price.

DOLLARFR

This function converts a decimal number dollar price to a fraction dollar price.

DURATION

This function returns the Macaulay duration for an assumed par value of $100.

EFFECT

This function calculates the effective annual interest rate for a given nominal annual interest rate and the number of compounding periods per year.

FV

This function returns the future value of an investment based on a present value, periodic payments, and a specified interest rate.

FVSCHEDULE

This function returns the future value of an initial principal after applying a series of compound interest rates. Calculate future value of an investment with a variable or adjustable rate.

INTRATE

This function calculates the interest rate for a fully invested security.

IPMT

This function calculates the payment of interest on a loan.

IRR

This function returns the internal rate of return for a series of cash flows represented by the numbers in an array.

ISPMT

This function calculates the interest paid during a specific period of an investment.

MDURATION

This function calculates the modified Macaulay duration of a security with an assumed par value of $100.

MIRR

This function returns the modified internal rate of return for a series of periodic cash flows.

NOMINAL

This function returns the nominal annual interest rate for a given effective rate and the number of compounding periods per year.

NPER

This function returns the number of periods for an investment based on a present value, future value, periodic payments, and a specified interest rate.

NPV

This function calculates the net present value of an investment by using a discount rate and a series of future payments and income.

ODDFPRICE

This function calculates the price per $100 face value of a security with an odd first period.

ODDFYIELD

This function calculates the yield of a security with an odd first period.

ODDLPRICE

This function calculates the price per $100 face value of a security with an odd last coupon period.

ODDLYIELD

This function calculates the yield of a security with an odd last period.

PDURATION

This function returns the number of periods required by an investment to reach a specified value.

PMT

This function returns the payment amount for a loan given the present value, specified interest rate, and the number of terms.

PPMT

This function returns the amount of payment of principal for a loan given the present value, specified interest rate, and the number of terms.

PRICE

This function calculates the price per $100 face value of periodic interest security.

PRICEDISC

This function returns the price per $100 face value of a discounted security.

PRICEMAT

This function returns the price at maturity per $100 face value of a security that pays interest.

PV

This function returns the present value of an investment based on the interest rate, number and amount of periodic payments, and future value. The present value is the total amount that a series of future payments is worth now.

RATE

This function returns the interest rate per period of an annuity.

RECEIVED

This function returns the amount received at maturity for a fully invested security.

RRI

This function returns an equivalent interest rate for the growth of an investment.

SLN

This function returns the straight-line depreciation of an asset for one period.

SYD

This function returns the sum-of-years' digits depreciation of an asset for a specified period.

TBILLEQ

This function returns the equivalent yield for a Treasury bill (or T-bill).

TBILLPRICE

This function returns the price per $100 face value for a Treasury bill (or T-bill).

TBILLYIELD

This function returns the yield for a Treasury bill (or T-bill).

VDB

This function returns the depreciation of an asset for any period you specify using the variable declining balance method.

XIRR

This function calculates the internal rate of return for a schedule of cash flows that may not be periodic.

XNPV

This function calculates the net present value for a schedule of cash flows that may not be periodic.

YIELD

This function calculates the yield on a security that pays periodic interest.

YIELDDISC

This function calculates the annual yield for a discounted security.

YIELDMAT

This function calculates the annual yield of a security that pays interest at maturity.