Straight Perpetual Implied Volatility Calculator

As previously announced, the January edition of PrefLetter discussed the pricing of embedded options:

The January edition contains an appendix examining the calculation of Implied Volatility for PerpetualDiscount preferred shares and a discussion of the model and its applicability for portfolio management.

A calculator was developed to accompany this article and is available for download, with the permanent link under “On-Line Resources” in the right hand panel.

As always, I recognize that improvements are possible. If anybody sends me an improvement which I incorporate into the version of the spreadsheet published here, rest assured that this contribution will be fully credited.

Update, 2010-3-22: More issues now incorporated on spreadsheet.

9 Responses to “Straight Perpetual Implied Volatility Calculator”

  1. […] – I don’t think it will see much buying from those who understand the principles of the Straight Perpetual Implied Volatility Calculator introduced in the January 2010 […]

  2. […] only is the yield on the new issue way below comparables, but that there is no allowance at all for Implied Volatility of the embedded short call. There are two classes of investor who will buy this issue: those desperate to invest a large sum […]

  3. […] factor that hurt the fund’s performance in February was a decline in the implied volatility of PerpetualDiscounts. This had a large effect on performance of the different issues (though not as large as the Swoon […]

  4. […] analysis of the data using the Straight Perpetual Implied Volatility Calculator produces the following […]

  5. […] last month’s performance report, analysis of the data using the Straight Perpetual Implied Volatility Calculator produces the following […]

  6. […] of the data using the Straight Perpetual Implied Volatility Calculator produces the following […]

  7. […] of the data using the Straight Perpetual Implied Volatility Calculator produces the following […]

  8. […] of the data using the Straight Perpetual Implied Volatility Calculator produces the following […]

  9. […] not presently share my opinion! This is best illustrated by calculating Implied Volatility with the Straight Perpetual Implied Volatility Calculator. Click for […]

Leave a Reply

You must be logged in to post a comment.