Excel Formulas

Showing page 9 of 21
INTRATE
Financial

Returns the interest rate for a fully invested security

RECEIVED
Financial

Returns the amount received at maturity for a fully invested security

PRICE
Financial

Returns the price per $100 face value of a security that pays periodic interest

PRICEDISC
Financial

Returns the price per $100 face value of a discounted security

PRICEMAT
Financial

Returns the price per $100 face value of a security that pays interest at maturity

YIELD
Financial

Returns the yield on a security that pays periodic interest

YIELDDISC
Financial

Returns the annual yield for a discounted security

YIELDMAT
Financial

Returns the annual yield of a security that pays interest at maturity

TBILLEQ
Financial

Returns the bond-equivalent yield for a Treasury bill

TBILLPRICE
Financial

Returns the price per $100 face value for a Treasury bill

TBILLYIELD
Financial

Returns the yield for a Treasury bill

PRICE
Financial

Returns the price per $100 face value of a security that pays periodic interest

DOLLARDE
Financial

Converts a dollar price expressed as a fraction into a decimal number

DOLLARFR
Financial

Converts a dollar price expressed as a decimal number into a fraction

EFFECT
Financial

Returns the effective annual interest rate

NOMINAL
Financial

Returns the nominal annual interest rate

XIRR
Financial

Returns the internal rate of return for a schedule of cash flows

MIRR
Financial

Returns the modified internal rate of return for a series of periodic cash flows

ISPMT
Financial

Calculates the interest paid during a specific period of an investment

NPER
Financial

Returns the number of periods for an investment

Page 9 of 21