Financial
★ 8 · ◉ 44 · All versions
=DISC()
Returns the discount rate for a security.
=DISC(settlement, maturity, pr, redemption, [basis])
Financial Calculations
Securities & Bonds
Securities & Bonds
28 functions for this use case · out of 12 defined
Financial
★ 5 · ◉ 43 · All versions
=ACCRINTM()
Returns the accrued interest for a security that pays interest at maturity.
=ACCRINTM(issue, settlement, rate, par, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 43 · All versions
=ODDLYIELD()
Returns the yield of a security that has an odd (short or long) last period.
=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 41 · All versions
=DOLLARDE()
Converts a dollar price expressed as an integer part and a fraction part, such as 1.02, into a dollar price expressed as a decimal number. Fractional dollar numbers are sometimes used for security prices. The fraction part of the value is divided by an integer that you specify. For example, if you want your price to be expressed to a precision of 1/16 of a dollar, you divide the fraction part by 16. In this case, 1.02 represents $1.125 ($1 + 2/16 = $1.125).
=DOLLARDE(fractional_dollar, fraction)
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 40 · All versions
=COUPDAYBS()
The COUPDAYBS function returns the number of days from the beginning of a coupon period until its settlement date.
=COUPDAYBS(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 38 · All versions
=ODDLPRICE()
Returns the price per $100 face value of a security having an odd (short or long) last coupon period.
=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 38 · All versions
=TBILLYIELD()
Returns the yield for a Treasury bill.
=TBILLYIELD(settlement, maturity, pr)
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 37 · All versions
=ODDFYIELD()
Returns the yield of a security that has an odd (short or long) first period.
=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 35 · All versions
=COUPDAYS()
Returns the number of days in the coupon period that contains the settlement date.
=COUPDAYS(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 35 · All versions
=COUPNCD()
Returns a number that represents the next coupon date after the settlement date.
=COUPNCD(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 35 · All versions
=COUPNUM()
Returns the number of coupons payable between the settlement date and maturity date, rounded up to the nearest whole coupon.
=COUPNUM(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 34 · All versions
=TBILLEQ()
Returns the bond-equivalent yield for a Treasury bill.
=TBILLEQ(settlement, maturity, discount)
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 33 · All versions
=ACCRINT()
Returns the accrued interest for a security that pays periodic interest.
=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 33 · All versions
=COUPDAYSNC()
Returns the number of days from the settlement date to the next coupon date.
=COUPDAYSNC(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 10 · ◉ 32 · All versions
=DURATION()
Returns the Macauley duration for an assumed par value of $100. Duration is defined as the weighted average of the present value of cash flows, and is used as a measure of a bond price's response to changes in yield.
=DURATION(settlement, maturity, coupon, yld, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 32 · All versions
=YIELDDISC()
Returns the annual yield for a discounted security.
=YIELDDISC(settlement, maturity, pr, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 31 · All versions
=PRICEDISC()
Returns the price per $100 face value of a discounted security.
=PRICEDISC(settlement, maturity, discount, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 30 · All versions
=COUPPCD()
Returns a number that represents the previous coupon date before the settlement date.
=COUPPCD(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 30 · All versions
=ODDFPRICE()
Returns the price per $100 face value of a security having an odd (short or long) first period.
=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 29 · All versions
=TBILLPRICE()
Returns the price per $100 face value for a Treasury bill.
=TBILLPRICE(settlement, maturity, discount)
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 28 · All versions
=MDURATION()
Returns the modified Macauley duration for a security with an assumed par value of $100.
=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 27 · All versions
=DOLLARFR()
Use DOLLARFR to convert decimal numbers to fractional dollar numbers, such as securities prices.
=DOLLARFR(decimal_dollar, fraction)
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 27 · All versions
=INTRATE()
Returns the interest rate for a fully invested security.
=INTRATE(settlement, maturity, investment, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 15 · ◉ 27 · All versions
=PRICE()
Returns the price per $100 face value of a security that pays periodic interest.
=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 27 · All versions
=PRICEMAT()
Returns the price per $100 face value of a security that pays interest at maturity.
=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 15 · ◉ 27 · All versions
=YIELD()
Returns the yield on a security that pays periodic interest. Use YIELD to calculate bond yield.
=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 26 · All versions
=YIELDMAT()
Returns the annual yield of a security that pays interest at maturity.
=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 22 · All versions
=RECEIVED()
Returns the amount received at maturity for a fully invested security.
=RECEIVED(settlement, maturity, investment, discount, [basis])
Financial Calculations
Securities & Bonds