Black-Scholes model												
													
S	X	r	t	s				Pákový efekt Call					
1500	1500	0.03	0.25	0.1	35.74435839	Call		23.89720542	 				
1500	1500	0.03	0.25	0.1	0.569460183	D Call							
1500	1500	0.03	0.25	0.1	0.0052384	G Call							
1500	1500	0.03	0.25	0.1	2.946600071	K Call							
1500	1500	0.03	0.25	0.1	2.046114791	r Call							
1500	1500	0.03	0.25	0.1	0.23190383	Q Call							
1500	1500	0.03	0.25	0.1	-0.545630611	C Call							
													
S	X	r	t	s				Pákový efekt Put					
1500	1500	0.03	0.25	0.1	24.53644061	Put		-26.32043235					
1500	1500	0.03	0.25	0.1	-0.430539817	D Put							
1500	1500	0.03	0.25	0.1	0.0052384	G Put							
1500	1500	0.03	0.25	0.1	2.946600071	K Put							
1500	1500	0.03	0.25	0.1	-1.675865415	r Put		Parita Call a Put					
1500	1500	0.03	0.25	0.1	0.107837823	Q  Put		P+S	C+X*e-r*t				
1500	1500	0.03	0.25	0.1	0.446897444	C Put		1524.536441	1524.536441	0.000			
													
													
													
													
													
													
													
													
													
													
													
													
##### Sheet/List 2 #####
		VOLATILITA						
								
		Výnos	Výnos^2					
Týden	Ct	LN(Ct /Ct-1)	LN(Ct /Ct-1)^2					
1	100							
2	104	0.039220713	0.001538264					
3	108	0.037740328	0.0014243					
4	106	-0.018692133	0.0003494					
5	104	-0.019048195	0.0003628					
6	105	0.009569451	0.0000916					
7	103	-0.019231362	0.0003698					
8	102	-0.009756175	0.0000952					
9	104	0.019418086	0.0003771					
10	105	0.009569451	0.0000916					
	S	0.048790164	0.004700065					
								
								
	Průměrný výnos							
Týden	0.005421129	(LN(Ct /Ct-1))/9						
Rok	0.281898726	((LN(Ct /Ct-1))/9)*52						
								
	Volatilita							
Týden	0.023546676			0.0235467	SMODCH-VÝBĚR			
Rok	0.169797494	16.97974943		0.0222000	SMODCH			
								
								
								
								
								
								
								
								
								
								
								
								
								
##### Sheet/List 3 #####
Měnová opce								
								
								
								
T0	T1	S	X	rvm	rbm	s	Výsledek	
1/1/2000	4/1/2000	40.00	40.00	4.50%	3.50%	10.00%	0.845200943	Call
							0.530057943	Nd1
							0.510027756	Nd2
1/1/2000	4/1/2000	40.00	40.00	4.50%	3.50%	10.00%	0.745107000	Put
							0.469942057	N(-d1)
							0.489972244	N(-d2)
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
								
##### Sheet/List 4 #####
Úrokové opce									
									
Schéma									
Dohoda      T0	1/1/2002								
Zač. úr. ob. T1	5/13/2002	132							
Kon. úr. ob. T2	8/13/2002	92							
	Spolu dní	224							
									
tf	92								
tz	132								
rz	4.58%								
rx	4.50%								
rc	4.48%								
s	9.62%								
N	"1,000,000"								
									
									
T0	T1	T2	rz	rc	rx	s	N	Výsledek	
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	61.22	Call
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	645.74	Put
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	0.042648999	Forward
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	0.186105886	Nd1
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	0.170911186	Nd2
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	1.027875556	Diskontování
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	0.813894114	N(-d1)
1/1/2002	5/13/2002	8/13/2002	4.58%	4.48%	4.50%	9.62%	"1,000,000"	0.829088814	N(-d2)