COUPNUM Function in Excel: Coupons Left Until Maturity
COUPNUM counts coupon payments remaining.
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 →RECEIVED Function in Excel: Amount Received at Maturity
RECEIVED Function in Excel: Amount Received at Maturity
RECEIVED calculates what you get back at maturity for a discounted security.
Read article →INTRATE Function in Excel: Interest Rate of a Fully Invested Security
INTRATE Function in Excel: Interest Rate of a Fully Invested Security
INTRATE returns the annualised return when you invest an amount and receive a larger amount at maturity, with nothing in between.
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
TBILLYIELD returns the yield of a T-bill from its price.
Read article →Link Excel Charts to PowerPoint and Refresh Them Automatically
Link Excel Charts to PowerPoint and Refresh Them Automatically
Paste Excel charts into PowerPoint as linked objects so monthly decks update with one click — plus a VBA macro that refreshes every link…
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 →DOLLARFR Function in Excel: Decimal Prices to Fractions
DOLLARFR Function in Excel: Decimal Prices to Fractions
DOLLARFR is the reverse of DOLLARDE: 1.125 with fraction 16 becomes 1.02 (1 and 2/16).
Read article →MULTINOMIAL Function in Excel: Ways to Split Into Groups
MULTINOMIAL Function in Excel: Ways to Split Into Groups
MULTINOMIAL counts ways to divide items into groups of given sizes.
Read article →FACTDOUBLE Function in Excel: Double Factorial
FACTDOUBLE Function in Excel: Double Factorial
FACTDOUBLE multiplies every other number: 7!! = 7 × 5 × 3 × 1.
Read article →COMBINA Function in Excel: Combinations With Repeats
COMBINA Function in Excel: Combinations With Repeats
COMBINA counts selections where the same item can be chosen more than once — scoops of ice cream from four flavours.
Read article →