Financial Modeling Spring
Assignment - Options Models
Note: Make sure that your models are well organized. Have the inputs clustered and color-coded; modularize different types of analyses and calculations in different sheets; document the models with good titles, good labels and short but informative/self-explanatory comments.
Option Pricing: Symantec Corporation Stock Options
Consider the call and put options on the stock of Symantec Corporation with Exercise Price equal to $16 and expiration date on October 18, 2014.
1. Download three months of daily returns for Symantec Corporations. Use this data to estimate the sigma for the Binomial and Black-Scholes models.
2. Use the Binomial Model to value the Call, assuming that the option is European and that the year is subdivided in 250 periods.
3. Use the Binomial Model to value the Put, assuming that the option is European and that the year is subdivided in 250 periods.
4. Use the Black-Scholes Model to value the Call.
5. Use the Black-Scholes Model to value the Put.
6. Estimate the implied volatility considering both the Call and the Put prices.
7. Use the Binomial Model to value the Call, assuming that the option is American and that the year is subdivided in 250 periods.
8. Use the Binomial Model to value the Put, assuming that the option is American and that the year is subdivided in 250 periods.
9. Discuss your results in a summary report.