10%										
1	"1,000,000.00"	"909,090.91"	"909,090.91"			"1,000,000.00"	"1,093,655.59"					
2	"1,000,000.00"	"826,446.28"	"1,652,892.56"									
3	"1,000,000.00"	"751,314.80"	"2,253,944.40"			"1,000,000.00"	"993,971.38"					
		"2,486,851.99"	"4,815,927.87"			"1,000,000.00"	"903,610.34"					
							"1,897,581.72"					
	Dur	1.936555891		0.936555891								
				0.063444109			"2,991,237.31"					
												
												
									Price	Dur	Accrint	
1/1/2011	7/1/2011	1/1/2012	1/1/2011	8%	10%	100	1	0	#NUM!	#NUM!	4	
1/1/2010	7/1/2010	1/1/2011	1/1/2013	8%	10%	100	1	0	95.03	2.78	4	99.03
												
												
	KS1 na 1	#NUM!										
	KS1 na 2	#NUM!				W						
	KS 1	#NUM!				0.44						
	KS3 na 2	"4,893.24"			1.78	0.56						
	KS3 na 3	"7,906.39"										
	KS 3	"12,799.63"										
												
												
												
	Po 1 r 1r	#NUM!			#NUM!							
	Vyplati	"1,000,000.00"			"102,397.01"							
		#NUM!			#NUM!							
	Po 2 r 1r	#NUM!			#NUM!		#NUM!					
	Po 1 r 3r	"102,397.01"										
	Po 2 r 3r	"112,636.72"			"102,397.01"							
	Po 2 r 3r	"102,397.01"			#NUM!							
	Po 2 r 3r	#NUM!			#NUM!		#NUM!					
		#NUM!					#NUM!	#NUM!				
	Suma	#NUM!										
	Vyplati	"1,000,000.00"					"853,889.94"	#NUM!				
		#NUM!										
		"853,889.94"										
	Vyplati	#NUM!										
												
				1.00	1.00	1.00						
				1.00	2.78	1.94						
				0.00	1.78	0.94						
					W3	0.53						
					W1	0.47						
												
					KS1	#NUM!						
					KS3	"13,790.04"						
												
												
	Po 1 r 1r	#NUM!										
	Po 1 r 3r	"110,320.28"										
		#NUM!										
		"1,000,000.00"										
		#NUM!		#NUM!								
												
		"110,320.28"		#NUM!								
												
				#NUM!								
				#NUM!								
				#NUM!								
				#NUM!								
		#NUM!										
		#NUM!