Financial
★ 15 · ◉ 90 · All versions
=YIELD()
Calculates the annual yield of a security that pays periodic interest
=YIELD(settlement, maturity, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 89 · All versions
=INTRATE()
Calculates the annual interest rate of securities whose full amount is received at maturity
=INTRATE(settlement, maturity, investment, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 79 · All versions
=ACCRINTM()
Calculates the accrued interest of a security that pays its interest at maturity
=ACCRINTM(issue, settlement, rate, par, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 76 · All versions
=COUPNCD()
Returns the next coupon payment date after the settlement date
=COUPNCD(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 76 · All versions
=COUPNUM()
Calculates the number of remaining coupon payments between the settlement date and maturity
=COUPNUM(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 76 · All versions
=MDURATION()
Calculates the modified duration of a security
=MDURATION(settlement, maturity, coupon, yld, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 73 · All versions
=COUPPCD()
Returns the previous coupon payment date before the settlement date
=COUPPCD(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 10 · ◉ 73 · All versions
=DURATION()
Calculates the Macaulay duration in years of a security that pays periodic interest
=DURATION(settlement, maturity, coupon, yld, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 65 · All versions
=PRICEMAT()
Calculates the price of a security that pays interest only at maturity
=PRICEMAT(settlement, maturity, issue, rate, yld, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 63 · All versions
=DOLLARFR()
Converts a decimal number to a fraction with a specified denominator
=DOLLARFR(decimal_dollar, fraction)
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 63 · All versions
=TBILLPRICE()
Calculates the price of Treasury bills per $100 face value
=TBILLPRICE(settlement, maturity, discount)
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 56 · All versions
=PRICEDISC()
Calculates the price per 100 par value of a discounted security
=PRICEDISC(settlement, maturity, discount, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 47 · All versions
=COUPDAYS()
Calculates the number of days in the coupon period that contains the settlement date
=COUPDAYS(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 43 · All versions
=COUPDAYSNC()
Calculates the number of days from the settlement date to the next interest payment
=COUPDAYSNC(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 40 · All versions
=COUPDAYBS()
Calculates the number of days from the beginning of the coupon period to the settlement date
=COUPDAYBS(settlement, maturity, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 38 · All versions
=YIELDMAT()
Calculates the annual yield of a security that pays its interest in a lump sum at maturity
=YIELDMAT(settlement, maturity, issue, rate, pr, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 33 · All versions
=ODDLPRICE()
Calculates the price of a security whose last interest period is shorter or longer than the others
=ODDLPRICE(settlement, maturity, last_interest, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 30 · All versions
=ODDLYIELD()
Calculates the yield of a security whose last interest period is shorter or longer than the others
=ODDLYIELD(settlement, maturity, last_interest, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 25 · All versions
=ODDFYIELD()
Calculates the yield of a security whose first interest period is shorter or longer than the others
=ODDFYIELD(settlement, maturity, issue, first_coupon, rate, pr, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 24 · All versions
=TBILLEQ()
Calculates the bond-equivalent yield for Treasury bills
=TBILLEQ(settlement, maturity, discount)
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 1 · All versions
=ACCRINT()
Calculates the accrued interest of a security that pays periodic interest
=ACCRINT(issue, first_interest, settlement, rate, par, frequency, [basis], [calc_method])
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 1 · All versions
=DISC()
Calculates the annual discount rate of a security
=DISC(settlement, maturity, pr, redemption, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 1 · All versions
=DOLLARDE()
Converts a price written as a fractional number to a decimal number
=DOLLARDE(fractional_dollar, fraction)
Financial Calculations
Securities & Bonds
Financial
★ 3 · ◉ 1 · All versions
=ODDFPRICE()
Calculates the price of a security whose first interest period is shorter or longer than the others
=ODDFPRICE(settlement, maturity, issue, first_coupon, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 15 · ◉ 1 · All versions
=PRICE()
Calculates the price per 100 par value of a security that pays periodic interest
=PRICE(settlement, maturity, rate, yld, redemption, frequency, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 5 · ◉ 1 · All versions
=RECEIVED()
Calculates the amount received at maturity for a fully invested security
=RECEIVED(settlement, maturity, investment, discount, [basis])
Financial Calculations
Securities & Bonds
Financial
★ 4 · ◉ 1 · All versions
=TBILLYIELD()
Calculates the yield of Treasury bills from their price
=TBILLYIELD(settlement, maturity, pr)
Financial Calculations
Securities & Bonds
Financial
★ 8 · ◉ 1 · All versions
=YIELDDISC()
Calculates the annual yield of a discounted security
=YIELDDISC(settlement, maturity, pr, redemption, [basis])
Financial Calculations
Securities & Bonds