Function ImplDivYield(Maturity As Double, DiscountedDiv As Double, Ref As Double) As Double ' Calculates the implied dividend yield from a given price and a given dividend ImplDivYield = -Log(1# - DiscountedDiv / Ref) / Maturity End Function