This is an Excel homework on options.

Very important:

You must label your x-axis and y-axis.

You must provide info on the graph, which means what the graph shows, title of the graph.

If there are more than one line on the table, you must separate them either with color or solid versus broken line, as in my lecture notes.

Appendix-2:

Some Problems to Work on Option

NOTE: For each problem on options on stocks, one option contract is equal to 100 shares of underlying stock, e.g. 1 option = 100 share.

For example, if one buys and sell 3 option contract, this amounts to 3x100=300 of shares.

This feature of options on stocks also applies to the premium of options.

For example, if one buys 5 option contract on IBM stocks @ $6.75 for each option, then it means that long position pays total of $3,375 (= $6.75 x 100 x 5)

Problem-01a: You purchase (long position) 8 European call option contracts on XYZ stock at the premium of $2.5. The exercise price of the option is $30, the maturity of the options is 2-month, and the stock currently is trading at $28 i. What is the payoff of your position if the stock is at S31 at maturity? Show the result numerically ii. Repeat i for the stock price at maturity of S25 Problem-01b: For problem-01a: i. What is the profit (P/L) of your position, if the stock prices at maturity are S31 and S25? Show the results numerically ii. What is the Break Even Point (BEP) of your investment? (It is easier to find the BEP on one option, rather than for the entire value of the investment!) For the following Excel exercise, you should use one option to one underlying in calculating and graphing, rather than using entire value of the investment.] Problem-01c (Excel Exercise): For problems -01a and-01b, assume that XYZ stock price at maturity will take values between $20 and $45 in increment of $2.5 i. Will you exercise your call option? Give only NO, INDIFFERENT, YES answer. This is a qualitative question? ii At each stated underlying price at maturity, calculate and show the Payoff and P/L numbers using formulas (in Excel!). Note that stock price of XYZ ranges from S20 to $45 in increments of S2.5 iii. Graph the numbers found in ii. iv. Integrate numbers calculated in Problem-01a i, ii, and Problem-01b i, ii. (This means put these numbers into the graph)