Ads
related to: excel maturity formula sample
Search results
Results From The WOW.Com Content Network
In the United States, 30-day yield is a standardized yield calculation for bond funds.The formula for calculating 30-day yield is specified by the U.S. Securities and Exchange Commission (SEC). [1]
In mathematical finance, Margrabe's formula [1] is an option pricing formula applicable to an option to exchange one risky asset for another risky asset at maturity. It was derived by William Margrabe (PhD Chicago) in 1978. Margrabe's paper has been cited by over 2000 subsequent articles.
yield to call uses the same methodology as the yield to maturity, but assumes that the issuer calls the bond at the first opportunity instead of allowing it to be held until maturity; yield to put assumes that the bondholder sells the bond back to the issuer at the first opportunity; and
In Excel, the PV and FV functions take on optional fifth argument which selects from annuity-immediate or annuity-due. An annuity-due with n payments is the sum of one annuity payment now and an ordinary annuity with one payment less, and also equal, with a time shift, to an ordinary annuity.
The Black formula is similar to the Black–Scholes formula for valuing stock options except that the spot price of the underlying is replaced by a discounted futures price F. Suppose there is constant risk-free interest rate r and the futures price F(t) of a particular underlying is log-normal with constant volatility σ.
Caps consist of caplets with volatilities dependent on the corresponding forward LIBOR rate. But caps can also be represented by a "flat volatility", a single number which if plugged in the formula for valuing each caplet recovers the price of the cap i.e. the net of the caplets still comes out to be the same.