Hero - Microsoft Excel Home Page Layout Formulas Data Review View Q - EX Connections Clear 1 Show Detail ? Solver Properties Reapply Hide Detail From From From Other Existing All Edit Links 2 1 sort Filter Advanced Co Text to Remove Data Consolidate What-If Group Ungroup Subtotal Access Web Text Sources * Connections Columns Duplicates Validation Analysis Get External Data Connections Sort & Filter Data Tools Outline Analysis E5 A B H J K 1 Forward Price , FP 100 Spot Price,SO 95.44054797 Spot Price, SO 95.44 2 Teure In Year ,t 0.583333333 Exercise Price, X 98 Exercise Price, X 101 3 Risk Free Rate ,r 8% Time In Months,t Time In Months,t 4 4 Spot Price =FP*e^-rt| 95.44054797 Rate p.a.c.c,r 3.00% Rate p.a.c.c, 8.00% 5 Std Deviation, o Std Deviation, 27.79% Period 0.25 Period 0.33 8 Goal Seek X N(d1)=norm.s.dist(d1) 0.509 norm.s.dist(-d1) 0.54 d1=(A+B)/C .023 N(d1)=norm.s.dist(d1) 0.46 Set cell: $E$18 IN(SO/X) =A -0.026 d1=(A+B)/C -0.11 To value 5 {r+(.5*012)}*t=B 0.030 IN(SO/X) =A -0.06 By changing cell: $E$5 o*Vt =C 0.139 {r+ (.5*012) ]* t = B 0.04 o*Vt =C 0 . 16 OK Cancel N(d2)=norm.s.dist(d2) 0.454 12=d1-o*vt -0.116 N(-d2)=norm.s.dist(-d2) 0.61 N(d2)=norm.s.dist(d2) 0.39 17 e^-rt 0.980 d2=d1-o*vt -0.27 18 Value Of Call=SO*N(d1)-(X*e^-rt*N(d2) 5.000 19 en-rt 0.97 20 Value Of Put=(X*e^-rt*N(-d2))-SO*N(-d1) 7.75 21 22 14 4 /Sheet22 /Sheet23 /Sheet24 Sheet25 / Sheet26 / Sheet27 / Sheet28 /Sheet29 /Sheet31 /Sheet32/ Point #8 4 1009% 9 ENG 17:33 02-12-2021 Hero - Microsoft Excel X Home art Page Layout Formulas Data Review View 7 - 5 Define Name Trace Precedents Show Formulas Calculate Now f Use in Formula Trace Dependents Error Checking Insert AutoSum Recently Financial Logical Text Date & Lookup & Math & More Name Watch Calculation Calculate Sheet Function Used Time Reference . Trig Functions . Manager Create from Selection Remove Arrows Evaluate Formula | Window Options Function Library Defined Names Formula Auditing Calculation B16 fox A C D E F G H 1 Forward Price ,FP 100 Spot Price, SO =B4 Spot Price, SO =B4 2 Teure In Year ,t =7/12 Exercise Price, X 98 Exercise Price, X 101 3 Risk Free Rate ,r 0.08 Time In Months,t 3 Time In Months,t 4 4 Spot Price =FP*e^-rt =B1*EXP(-B3*B2 Rate p.a.c.c,r 0.08 Rate p.a.c.c,r 0.08 5 Std Deviation, o .277915054430732 Std Deviation, =E5 Period -E3/12 Period =H3/12 N(d1)=norm.s.dist(d1) NORMSDIST(E9) N(-d1)=norm.s.dist(-d1) =NORMSDIST(-H10) d1=(A+B)/C (E10+E11)/E12 N(d1)=norm.s.dist(d1) NORMSDIST(H10) IN(SO/X) =A LN(E1/E2) d1=(A+B)/C (H11+H12)/H13 [r+(.5*0^2)]* t=B ((E5*E5/2)+E4)*E6 =LN(H1/H2) 0*vt =C SQRT(E6)*E5 {r+(.5*012)]* t=B =((H5*H5/2)+H4)*H6 o*vt =c SQRT(H6)*H5 N(d2)=norm.s.dist(d2) =NORMSDIST(E15) d2=d1-o*vt =E9-E12 N(-d2)=norm.s.dist(-d2) =NORMSDIST(-H17) N(d2)=norm.s.dist(d2) =NORMSDIST(H17 e^-rt EXP(-E4* E6) d2=d1-o*vt H10-H13 Value Of Call=SO*N(d1)-(X*e^-rt*N(d2) =(E1*E8)-(E2*[14)*E17 en-rt (=EXP(-H4*H6) Value Of Put=(X*e^-rt*N(-d2))-SO*N(-d1) =(H2*H19*H15)-(H1*H8) 22 14 4 6 1 /Sheet22 / Sheet23 /Sheet 24 Sheet25 / Sheet26 /Sheet27 / Sheet28 /Sheet29 /Sheet31 /Sheet32/ Ready # 1 1 100% B ENG 17:33 02-12-2021