In the notes, Example 5, page 23 has the following parameters: S= 50; X= 45; R_f = 6%, 2= 20%; and T= 3 months. Find the value of the call using an excel spread sheet. It should equal $7.62.

2. Using Example 5 as the base case, find the value of the call for a range of stock prices, say from $5 to $300 in increments of $5. Plot these values in excel. Comment on how the value approaches certain limits, i.e. when the option is deep in the money, what is the limit on the value of the option. What happens to the time value of the option?

3. Using Example 5 as the base case, find the value of the call for a range of volatilities. Plot these values in excel. I would suggest going from 5% to 300%.

4. Using Example 5 as the base case, find the value of the call for a range of exercise prices say from $5 to $100 in increments of $5. Plot these values in excel.

5. Using Example 5 as the base case, find the value of the call for a range of maturities say from 1 month to 12 months. Plot these values in excel.

6. Provide some narrative on these factors. Which factor seems to provide the most impact? Why?

7. Pick a firm that has traded options.^[1] Include some values as an attachment. Comment on the volume. Which option seems to be the most traded? Why?

^[1] Where do you find options? Try Finra.org. From the landing page, click investors. From there, click market data. On the side panel, click "Equities and Options." make a ticker symbol for the firm, and from there you will get tabs for data, include options prices. You can also you Yahoo finance, and other sites for the data.

Please show all formula details on how to calculate the call price for each questions above on excel.

Stock Price	50
Exercise Price	45
Risk Free Rate	0.06
Variance	0.4472
Time in Years	0.25
Standard Deviation	0.2
D1	0.65009175
D2	0.42649175
Call Price	7.62415021