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 →Financial
Excel Financial functions explained with syntax, examples and common mistakes.
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 →PRICEMAT Function in Excel: Price of a Security Paying Interest at Maturity
PRICEMAT Function in Excel: Price of a Security Paying Interest at Maturity
PRICEMAT returns the price per 100 of a security that pays interest at maturity.
Read article →YIELDDISC Function in Excel: Yield of a Discounted Security
YIELDDISC Function in Excel: Yield of a Discounted Security
FinanceLevel: ExpertAvailable in: Excel 2007+YIELDDISC returns the annual yield of a discounted security such as a T-bill.Syntax=YIELDDISC(settlement.
Read article →DISC Function in Excel: Discount Rate of a Security
DISC Function in Excel: Discount Rate of a Security
DISC works out the discount rate when you know the purchase price and redemption value — commercial paper, bill discounting.
Read article →TBILLYIELD Function in Excel: Treasury Bill Yield
TBILLYIELD Function in Excel: Treasury Bill Yield
FinancialLevel: ExpertAvailable in: Excel 2007+TBILLYIELD returns the yield of a T-bill from its price.Syntax=TBILLYIELD(settlement, maturity.
Read article →TBILLPRICE Function in Excel: Treasury Bill Price
TBILLPRICE Function in Excel: Treasury Bill Price
TBILLPRICE returns the price per 100 of a T-bill from its discount rate (US convention, 360-day year).
Read article →