Q1. Option Price vs Strike Price Keep S0-100 and MAD-25 Create a spreadsheet to: Q1a. calculate PUT price, PUT intrinsic vs time value, while varying X from 50 to 150 with $1 increment. Q1b. calculate CALL price, CALL intrinsic vs time value, while varying X from 50 to 150 with $1 increment Q1c. Graph PUT price and intrinsic value from Q1a. x-axis is X. Q1d. Graph CALL price and intrinsic value from Q1b. x-axis is X. Q2. How option will react to underlying price movement Keep X= 100 and MAD-25. Create a spreadsheet to: Q2a. calculate PUT price, PUT intrinsic vs time value, while varying SO from 50 to 150 with $1 increment. Q2b. calculate CALL price, CALL intrinsic vs time value, while varying so from 50 to 150 with $1 increment Q2c. Graph PUT price and intrinsic value from Q2a in the same chart. x-axis is so. Q2d. Graph CALL price and intrinsic value from Q2b in the same chart. x-axis is SO. Q1. Option Price vs Strike Price Keep S0-100 and MAD-25 Create a spreadsheet to: Q1a. calculate PUT price, PUT intrinsic vs time value, while varying X from 50 to 150 with $1 increment. Q1b. calculate CALL price, CALL intrinsic vs time value, while varying X from 50 to 150 with $1 increment Q1c. Graph PUT price and intrinsic value from Q1a. x-axis is X. Q1d. Graph CALL price and intrinsic value from Q1b. x-axis is X. Q2. How option will react to underlying price movement Keep X= 100 and MAD-25. Create a spreadsheet to: Q2a. calculate PUT price, PUT intrinsic vs time value, while varying SO from 50 to 150 with $1 increment. Q2b. calculate CALL price, CALL intrinsic vs time value, while varying so from 50 to 150 with $1 increment Q2c. Graph PUT price and intrinsic value from Q2a in the same chart. x-axis is so. Q2d. Graph CALL price and intrinsic value from Q2b in the same chart. x-axis is SO