COUPDAYSNC Function in Excel: Days From Settlement to Next Coupon
COUPDAYSNC counts days from settlement to the next coupon date. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →Excel
Excel formulas, unusual formula combinations, VBA, Power Query and dashboards — from basics to clever tricks.
COUPPCD Function in Excel: Previous Coupon Date
COUPPCD Function in Excel: Previous Coupon Date
COUPPCD returns the last coupon date before settlement. Used for bond pricing and accrued interest on half-yearly coupons.
Read article →COUPNCD Function in Excel: Next Coupon Date
COUPNCD Function in Excel: Next Coupon Date
COUPNCD returns the next coupon date after settlement — useful for cash-flow calendars of a bond portfolio.
Read article →COUPNUM Function in Excel: Coupons Left Until Maturity
COUPNUM Function in Excel: Coupons Left Until Maturity
FinancialLevel: ExpertAvailable in: Excel 2007+COUPNUM counts coupon payments remaining.Syntax=COUPNUM(settlement, maturity, frequency.
Read article →ODDFPRICE Function in Excel: Price of a Bond With an Odd First Period
ODDFPRICE Function in Excel: Price of a Bond With an Odd First Period
ODDFPRICE prices a bond whose first coupon period is shorter or longer than normal.
Read article →TBILLEQ Function in Excel: Bond-Equivalent Yield of a T-Bill
TBILLEQ Function in Excel: Bond-Equivalent Yield of a T-Bill
TBILLEQ converts a T-bill discount rate into a bond-equivalent yield, so you can compare it with coupon bonds and FDs.
Read article →PRICEDISC Function in Excel: Price of a Discounted Security
PRICEDISC Function in Excel: Price of a Discounted Security
PRICEDISC returns the price per 100 of a discounted security such as a T-bill or commercial paper.
Read article →YIELDMAT Function in Excel: Yield of a Security Paying Interest at Maturity
YIELDMAT Function in Excel: Yield of a Security Paying Interest at Maturity
FinanceLevel: ExpertAvailable in: Excel 2007+YIELDMAT returns the yield of a security that pays interest at maturity.Syntax=YIELDMAT(settlement, maturity.
Read article →ODDLPRICE Function in Excel: Price of a Bond With an Odd Last Period
ODDLPRICE Function in Excel: Price of a Bond With an Odd Last Period
FinanceLevel: ExpertAvailable in: Excel 2007+ODDLPRICE prices a bond whose last coupon period is irregular.Syntax=ODDLPRICE(settlement, maturity.
Read article →MDURATION Function in Excel: Modified Duration
MDURATION Function in Excel: Modified Duration
MDURATION estimates the percentage price change for a 1% change in yield — the number fund managers quote.
Read article →ODDLYIELD Function in Excel: Yield of a Bond With an Odd Last Period
ODDLYIELD Function in Excel: Yield of a Bond With an Odd Last Period
FinanceLevel: ExpertAvailable in: Excel 2007+ODDLYIELD returns the yield of a bond with an irregular last period.Syntax=ODDLYIELD(settlement, maturity.
Read article →ODDFYIELD Function in Excel: Yield of a Bond With an Odd First Period
ODDFYIELD Function in Excel: Yield of a Bond With an Odd First Period
FinanceLevel: ExpertAvailable in: Excel 2007+ODDFYIELD returns the yield of a bond with an irregular first period.Syntax=ODDFYIELD(settlement, maturity.
Read article →