odkaz na další listy	popis	
grafický model	slouží k vizualizaci na návrhu celého modelu	
vstupy	slouží pro zadání základních vstupních parametrů	
hypotéka	slouží pro výpočet hypotéky se zadanými parametry	
zadání & výpočty	slouží pro celký vypočet nákladů & výnosů & bilance	
		
		
Úkol:	1) Projděte si grafický model a zkuste sami sestavit jednotlivé komponenty nákladů a výnosů	
	"2) Vytvořte list vstupů (vstupy pro hypotéku), budete potřebovat údaje o dnešním dni, měsíci a roce, u rodičovské dovolené uvažujte délku 2,3 a nebo 4 let. Počet dětí předpokládejme v rozsahu 0-3. Úspěšnost pronájmu bereme ve škále 80 - 100%. Úroková míra se v tomto modelovém příkladě může pohybovat od 1,7 do 3,1 (škálujte po desetinách). Výši hypotéky předpokládejme od 4,5 mil do 7,3 mil. Škálujte po 200 tis."	
	3) Sestavte list hypotéka	
	4) Vytvořte list zadání a výpočty a proveďte jednotlivé kroky výpočtu	
	"5) Pro funkci Goal seek vyberte jednu s Variant počtu dětí, odstraňte podmínkové formátování (když) a proveďte výpočet nejvyšší možné hypotéky pro daný plat "	
	6) Sestavte tabulku dat nejprve pro různou výši hypotéky (jaká je bilance) následně pak pro výši hypotéky a různé úrokové sazby	
##### Sheet/List 3 #####
dnešní datum	2/23/2023	=DNES()				
tento měsíc	2	=MĚSÍC(B1)				
tento rok	2023	=ROK(B1)				
						
rodičovská dovolená	2	3	4			
počet dětí	0	1	2			
úspěšnost pronájmu	80%	85%	90%	95%	100%	
						
	datum narození	počet měsíců do narození				
1. dítě	Oct-20	-28.00	=12-$B$2+(ROK(B10)-$B$3-1)*12+MĚSÍC(B10)			
2. dítě	Mar-23	1.00	=12-$B$2+(ROK(B11)-$B$3-1)*12+MĚSÍC(B11)			
						
přírůstek						
0.10%	" 200,000.00 Kč "					
=A17+$A$14	=B17+$B$14					
úrokové míry	výše hypotéky					
1.70%	" 4,500,000.00 Kč "					
1.80%	" 4,700,000.00 Kč "					
1.90%	" 4,900,000.00 Kč "					
2.00%	" 5,100,000.00 Kč "					
2.10%	" 5,300,000.00 Kč "					
2.20%	" 5,500,000.00 Kč "					
2.30%	" 5,700,000.00 Kč "					
2.40%	" 5,900,000.00 Kč "					
2.50%	" 6,100,000.00 Kč "					
2.60%	" 6,300,000.00 Kč "					
2.70%	" 6,500,000.00 Kč "					
2.80%	" 6,700,000.00 Kč "					
2.90%	" 6,900,000.00 Kč "					
3.00%	" 7,100,000.00 Kč "					
3.10%	" 7,300,000.00 Kč "					
##### Sheet/List 4 #####
=1	"=KDYŽ(A4="""";"""";PLATBA(Výpočty!$B$6/12;Výpočty!$B$8;-Výpočty!B5;0))"	"=Když(A4="""";"""";PLATBA.ZÁKLAD(Výpočty!$B$6/12;A4;Výpočty!$B$8;-Výpočty!$B$5;0;0))"	"=KDYŽ(A4="""";"""";PLATBA.ÚROK(Výpočty!$B$6/12;A4;Výpočty!$B$8;-Výpočty!$B$5;0))"	 =Výpočty!B5-C4 	 První rok 
"=KDYŽ(A4<Výpočty!$B$8;A4+1;"""")"	"=KDYŽ(A5="""";"""";PLATBA(Výpočty!$B$6/12;Výpočty!$B$8-A4;-E4;0))"			" =KDYŽ(A5="""";"""";E4-C5) "	 Druhý rok a následné 
pořadí	splátka	jistina	úrok	zůstatek	
1	"1,264.81 Kč"	514.81 Kč	750.00 Kč	" 299,485.19 Kč "	
2	"1,264.81 Kč"	516.10 Kč	748.71 Kč	" 298,969.09 Kč "	
3	"1,264.81 Kč"	517.39 Kč	747.42 Kč	" 298,451.70 Kč "	
4	"1,264.81 Kč"	518.68 Kč	746.13 Kč	" 297,933.02 Kč "	
5	"1,264.81 Kč"	519.98 Kč	744.83 Kč	" 297,413.04 Kč "	
6	"1,264.81 Kč"	521.28 Kč	743.53 Kč	" 296,891.76 Kč "	
7	"1,264.81 Kč"	522.58 Kč	742.23 Kč	" 296,369.17 Kč "	
8	"1,264.81 Kč"	523.89 Kč	740.92 Kč	" 295,845.29 Kč "	
9	"1,264.81 Kč"	525.20 Kč	739.61 Kč	" 295,320.09 Kč "	
10	"1,264.81 Kč"	526.51 Kč	738.30 Kč	" 294,793.57 Kč "	
11	"1,264.81 Kč"	527.83 Kč	736.98 Kč	" 294,265.75 Kč "	
12	"1,264.81 Kč"	529.15 Kč	735.66 Kč	" 293,736.60 Kč "	
13	"1,264.81 Kč"	530.47 Kč	734.34 Kč	" 293,206.13 Kč "	
14	"1,264.81 Kč"	531.80 Kč	733.02 Kč	" 292,674.33 Kč "	
15	"1,264.81 Kč"	533.13 Kč	731.69 Kč	" 292,141.21 Kč "	
16	"1,264.81 Kč"	534.46 Kč	730.35 Kč	" 291,606.75 Kč "	
17	"1,264.81 Kč"	535.80 Kč	729.02 Kč	" 291,070.95 Kč "	
18	"1,264.81 Kč"	537.13 Kč	727.68 Kč	" 290,533.82 Kč "	
19	"1,264.81 Kč"	538.48 Kč	726.33 Kč	" 289,995.34 Kč "	
20	"1,264.81 Kč"	539.82 Kč	724.99 Kč	" 289,455.51 Kč "	
21	"1,264.81 Kč"	541.17 Kč	723.64 Kč	" 288,914.34 Kč "	
22	"1,264.81 Kč"	542.53 Kč	722.29 Kč	" 288,371.82 Kč "	
23	"1,264.81 Kč"	543.88 Kč	720.93 Kč	" 287,827.93 Kč "	
24	"1,264.81 Kč"	545.24 Kč	719.57 Kč	" 287,282.69 Kč "	
25	"1,264.81 Kč"	546.61 Kč	718.21 Kč	" 286,736.09 Kč "	
26	"1,264.81 Kč"	547.97 Kč	716.84 Kč	" 286,188.11 Kč "	
27	"1,264.81 Kč"	549.34 Kč	715.47 Kč	" 285,638.77 Kč "	
28	"1,264.81 Kč"	550.72 Kč	714.10 Kč	" 285,088.06 Kč "	
29	"1,264.81 Kč"	552.09 Kč	712.72 Kč	" 284,535.96 Kč "	
30	"1,264.81 Kč"	553.47 Kč	711.34 Kč	" 283,982.49 Kč "	
31	"1,264.81 Kč"	554.86 Kč	709.96 Kč	" 283,427.64 Kč "	
32	"1,264.81 Kč"	556.24 Kč	708.57 Kč	" 282,871.39 Kč "	
33	"1,264.81 Kč"	557.63 Kč	707.18 Kč	" 282,313.76 Kč "	
34	"1,264.81 Kč"	559.03 Kč	705.78 Kč	" 281,754.73 Kč "	
35	"1,264.81 Kč"	560.43 Kč	704.39 Kč	" 281,194.31 Kč "	
36	"1,264.81 Kč"	561.83 Kč	702.99 Kč	" 280,632.48 Kč "	
37	"1,264.81 Kč"	563.23 Kč	701.58 Kč	" 280,069.25 Kč "	
38	"1,264.81 Kč"	564.64 Kč	700.17 Kč	" 279,504.61 Kč "	
39	"1,264.81 Kč"	566.05 Kč	698.76 Kč	" 278,938.56 Kč "	
40	"1,264.81 Kč"	567.47 Kč	697.35 Kč	" 278,371.09 Kč "	
41	"1,264.81 Kč"	568.88 Kč	695.93 Kč	" 277,802.21 Kč "	
42	"1,264.81 Kč"	570.31 Kč	694.51 Kč	" 277,231.90 Kč "	
43	"1,264.81 Kč"	571.73 Kč	693.08 Kč	" 276,660.17 Kč "	
44	"1,264.81 Kč"	573.16 Kč	691.65 Kč	" 276,087.01 Kč "	
45	"1,264.81 Kč"	574.59 Kč	690.22 Kč	" 275,512.41 Kč "	
46	"1,264.81 Kč"	576.03 Kč	688.78 Kč	" 274,936.38 Kč "	
47	"1,264.81 Kč"	577.47 Kč	687.34 Kč	" 274,358.91 Kč "	
48	"1,264.81 Kč"	578.91 Kč	685.90 Kč	" 273,780.00 Kč "	
49	"1,264.81 Kč"	580.36 Kč	684.45 Kč	" 273,199.64 Kč "	
50	"1,264.81 Kč"	581.81 Kč	683.00 Kč	" 272,617.82 Kč "	
51	"1,264.81 Kč"	583.27 Kč	681.54 Kč	" 272,034.55 Kč "	
52	"1,264.81 Kč"	584.73 Kč	680.09 Kč	" 271,449.83 Kč "	
53	"1,264.81 Kč"	586.19 Kč	678.62 Kč	" 270,863.64 Kč "	
54	"1,264.81 Kč"	587.65 Kč	677.16 Kč	" 270,275.99 Kč "	
55	"1,264.81 Kč"	589.12 Kč	675.69 Kč	" 269,686.87 Kč "	
56	"1,264.81 Kč"	590.59 Kč	674.22 Kč	" 269,096.27 Kč "	
57	"1,264.81 Kč"	592.07 Kč	672.74 Kč	" 268,504.20 Kč "	
58	"1,264.81 Kč"	593.55 Kč	671.26 Kč	" 267,910.65 Kč "	
59	"1,264.81 Kč"	595.04 Kč	669.78 Kč	" 267,315.61 Kč "	
60	"1,264.81 Kč"	596.52 Kč	668.29 Kč	" 266,719.09 Kč "	
61	"1,264.81 Kč"	598.01 Kč	666.80 Kč	" 266,121.08 Kč "	
62	"1,264.81 Kč"	599.51 Kč	665.30 Kč	" 265,521.57 Kč "	
63	"1,264.81 Kč"	601.01 Kč	663.80 Kč	" 264,920.56 Kč "	
64	"1,264.81 Kč"	602.51 Kč	662.30 Kč	" 264,318.05 Kč "	
65	"1,264.81 Kč"	604.02 Kč	660.80 Kč	" 263,714.03 Kč "	
66	"1,264.81 Kč"	605.53 Kč	659.29 Kč	" 263,108.50 Kč "	
67	"1,264.81 Kč"	607.04 Kč	657.77 Kč	" 262,501.46 Kč "	
68	"1,264.81 Kč"	608.56 Kč	656.25 Kč	" 261,892.90 Kč "	
69	"1,264.81 Kč"	610.08 Kč	654.73 Kč	" 261,282.82 Kč "	
70	"1,264.81 Kč"	611.61 Kč	653.21 Kč	" 260,671.22 Kč "	
71	"1,264.81 Kč"	613.13 Kč	651.68 Kč	" 260,058.09 Kč "	
72	"1,264.81 Kč"	614.67 Kč	650.15 Kč	" 259,443.42 Kč "	
73	"1,264.81 Kč"	616.20 Kč	648.61 Kč	" 258,827.21 Kč "	
74	"1,264.81 Kč"	617.74 Kč	647.07 Kč	" 258,209.47 Kč "	
75	"1,264.81 Kč"	619.29 Kč	645.52 Kč	" 257,590.18 Kč "	
76	"1,264.81 Kč"	620.84 Kč	643.98 Kč	" 256,969.35 Kč "	
77	"1,264.81 Kč"	622.39 Kč	642.42 Kč	" 256,346.96 Kč "	
78	"1,264.81 Kč"	623.94 Kč	640.87 Kč	" 255,723.01 Kč "	
79	"1,264.81 Kč"	625.50 Kč	639.31 Kč	" 255,097.51 Kč "	
80	"1,264.81 Kč"	627.07 Kč	637.74 Kč	" 254,470.44 Kč "	
81	"1,264.81 Kč"	628.64 Kč	636.18 Kč	" 253,841.80 Kč "	
82	"1,264.81 Kč"	630.21 Kč	634.60 Kč	" 253,211.60 Kč "	
83	"1,264.81 Kč"	631.78 Kč	633.03 Kč	" 252,579.81 Kč "	
84	"1,264.81 Kč"	633.36 Kč	631.45 Kč	" 251,946.45 Kč "	
85	"1,264.81 Kč"	634.95 Kč	629.87 Kč	" 251,311.50 Kč "	
86	"1,264.81 Kč"	636.53 Kč	628.28 Kč	" 250,674.97 Kč "	
87	"1,264.81 Kč"	638.12 Kč	626.69 Kč	" 250,036.85 Kč "	
88	"1,264.81 Kč"	639.72 Kč	625.09 Kč	" 249,397.13 Kč "	
89	"1,264.81 Kč"	641.32 Kč	623.49 Kč	" 248,755.81 Kč "	
90	"1,264.81 Kč"	642.92 Kč	621.89 Kč	" 248,112.88 Kč "	
91	"1,264.81 Kč"	644.53 Kč	620.28 Kč	" 247,468.35 Kč "	
92	"1,264.81 Kč"	646.14 Kč	618.67 Kč	" 246,822.21 Kč "	
93	"1,264.81 Kč"	647.76 Kč	617.06 Kč	" 246,174.46 Kč "	
94	"1,264.81 Kč"	649.38 Kč	615.44 Kč	" 245,525.08 Kč "	
95	"1,264.81 Kč"	651.00 Kč	613.81 Kč	" 244,874.08 Kč "	
96	"1,264.81 Kč"	652.63 Kč	612.19 Kč	" 244,221.45 Kč "	
97	"1,264.81 Kč"	654.26 Kč	610.55 Kč	" 243,567.20 Kč "	
98	"1,264.81 Kč"	655.89 Kč	608.92 Kč	" 242,911.30 Kč "	
99	"1,264.81 Kč"	657.53 Kč	607.28 Kč	" 242,253.77 Kč "	
100	"1,264.81 Kč"	659.18 Kč	605.63 Kč	" 241,594.59 Kč "	
101	"1,264.81 Kč"	660.83 Kč	603.99 Kč	" 240,933.76 Kč "	
102	"1,264.81 Kč"	662.48 Kč	602.33 Kč	" 240,271.29 Kč "	
103	"1,264.81 Kč"	664.13 Kč	600.68 Kč	" 239,607.15 Kč "	
104	"1,264.81 Kč"	665.79 Kč	599.02 Kč	" 238,941.36 Kč "	
105	"1,264.81 Kč"	667.46 Kč	597.35 Kč	" 238,273.90 Kč "	
106	"1,264.81 Kč"	669.13 Kč	595.68 Kč	" 237,604.77 Kč "	
107	"1,264.81 Kč"	670.80 Kč	594.01 Kč	" 236,933.97 Kč "	
108	"1,264.81 Kč"	672.48 Kč	592.33 Kč	" 236,261.50 Kč "	
109	"1,264.81 Kč"	674.16 Kč	590.65 Kč	" 235,587.34 Kč "	
110	"1,264.81 Kč"	675.84 Kč	588.97 Kč	" 234,911.49 Kč "	
111	"1,264.81 Kč"	677.53 Kč	587.28 Kč	" 234,233.96 Kč "	
112	"1,264.81 Kč"	679.23 Kč	585.58 Kč	" 233,554.73 Kč "	
113	"1,264.81 Kč"	680.93 Kč	583.89 Kč	" 232,873.81 Kč "	
114	"1,264.81 Kč"	682.63 Kč	582.18 Kč	" 232,191.18 Kč "	
115	"1,264.81 Kč"	684.33 Kč	580.48 Kč	" 231,506.85 Kč "	
116	"1,264.81 Kč"	686.04 Kč	578.77 Kč	" 230,820.80 Kč "	
117	"1,264.81 Kč"	687.76 Kč	577.05 Kč	" 230,133.04 Kč "	
118	"1,264.81 Kč"	689.48 Kč	575.33 Kč	" 229,443.56 Kč "	
119	"1,264.81 Kč"	691.20 Kč	573.61 Kč	" 228,752.36 Kč "	
120	"1,264.81 Kč"	692.93 Kč	571.88 Kč	" 228,059.43 Kč "	
121	"1,264.81 Kč"	694.66 Kč	570.15 Kč	" 227,364.76 Kč "	
122	"1,264.81 Kč"	696.40 Kč	568.41 Kč	" 226,668.36 Kč "	
123	"1,264.81 Kč"	698.14 Kč	566.67 Kč	" 225,970.22 Kč "	
124	"1,264.81 Kč"	699.89 Kč	564.93 Kč	" 225,270.34 Kč "	
125	"1,264.81 Kč"	701.64 Kč	563.18 Kč	" 224,568.70 Kč "	
126	"1,264.81 Kč"	703.39 Kč	561.42 Kč	" 223,865.31 Kč "	
127	"1,264.81 Kč"	705.15 Kč	559.66 Kč	" 223,160.16 Kč "	
128	"1,264.81 Kč"	706.91 Kč	557.90 Kč	" 222,453.25 Kč "	
129	"1,264.81 Kč"	708.68 Kč	556.13 Kč	" 221,744.57 Kč "	
130	"1,264.81 Kč"	710.45 Kč	554.36 Kč	" 221,034.12 Kč "	
131	"1,264.81 Kč"	712.23 Kč	552.59 Kč	" 220,321.89 Kč "	
132	"1,264.81 Kč"	714.01 Kč	550.80 Kč	" 219,607.88 Kč "	
133	"1,264.81 Kč"	715.79 Kč	549.02 Kč	" 218,892.09 Kč "	
134	"1,264.81 Kč"	717.58 Kč	547.23 Kč	" 218,174.51 Kč "	
135	"1,264.81 Kč"	719.38 Kč	545.44 Kč	" 217,455.13 Kč "	
136	"1,264.81 Kč"	721.17 Kč	543.64 Kč	" 216,733.96 Kč "	
137	"1,264.81 Kč"	722.98 Kč	541.83 Kč	" 216,010.98 Kč "	
138	"1,264.81 Kč"	724.78 Kč	540.03 Kč	" 215,286.20 Kč "	
139	"1,264.81 Kč"	726.60 Kč	538.22 Kč	" 214,559.60 Kč "	
140	"1,264.81 Kč"	728.41 Kč	536.40 Kč	" 213,831.19 Kč "	
141	"1,264.81 Kč"	730.23 Kč	534.58 Kč	" 213,100.95 Kč "	
142	"1,264.81 Kč"	732.06 Kč	532.75 Kč	" 212,368.89 Kč "	
143	"1,264.81 Kč"	733.89 Kč	530.92 Kč	" 211,635.00 Kč "	
144	"1,264.81 Kč"	735.72 Kč	529.09 Kč	" 210,899.28 Kč "	
145	"1,264.81 Kč"	737.56 Kč	527.25 Kč	" 210,161.72 Kč "	
146	"1,264.81 Kč"	739.41 Kč	525.40 Kč	" 209,422.31 Kč "	
147	"1,264.81 Kč"	741.26 Kč	523.56 Kč	" 208,681.05 Kč "	
148	"1,264.81 Kč"	743.11 Kč	521.70 Kč	" 207,937.94 Kč "	
149	"1,264.81 Kč"	744.97 Kč	519.84 Kč	" 207,192.98 Kč "	
150	"1,264.81 Kč"	746.83 Kč	517.98 Kč	" 206,446.15 Kč "	
151	"1,264.81 Kč"	748.70 Kč	516.12 Kč	" 205,697.45 Kč "	
152	"1,264.81 Kč"	750.57 Kč	514.24 Kč	" 204,946.88 Kč "	
153	"1,264.81 Kč"	752.44 Kč	512.37 Kč	" 204,194.44 Kč "	
154	"1,264.81 Kč"	754.33 Kč	510.49 Kč	" 203,440.11 Kč "	
155	"1,264.81 Kč"	756.21 Kč	508.60 Kč	" 202,683.90 Kč "	
156	"1,264.81 Kč"	758.10 Kč	506.71 Kč	" 201,925.80 Kč "	
157	"1,264.81 Kč"	760.00 Kč	504.81 Kč	" 201,165.80 Kč "	
158	"1,264.81 Kč"	761.90 Kč	502.91 Kč	" 200,403.90 Kč "	
159	"1,264.81 Kč"	763.80 Kč	501.01 Kč	" 199,640.10 Kč "	
160	"1,264.81 Kč"	765.71 Kč	499.10 Kč	" 198,874.39 Kč "	
161	"1,264.81 Kč"	767.63 Kč	497.19 Kč	" 198,106.76 Kč "	
162	"1,264.81 Kč"	769.55 Kč	495.27 Kč	" 197,337.21 Kč "	
163	"1,264.81 Kč"	771.47 Kč	493.34 Kč	" 196,565.75 Kč "	
164	"1,264.81 Kč"	773.40 Kč	491.41 Kč	" 195,792.35 Kč "	
165	"1,264.81 Kč"	775.33 Kč	489.48 Kč	" 195,017.02 Kč "	
166	"1,264.81 Kč"	777.27 Kč	487.54 Kč	" 194,239.75 Kč "	
167	"1,264.81 Kč"	779.21 Kč	485.60 Kč	" 193,460.53 Kč "	
168	"1,264.81 Kč"	781.16 Kč	483.65 Kč	" 192,679.37 Kč "	
169	"1,264.81 Kč"	783.11 Kč	481.70 Kč	" 191,896.26 Kč "	
170	"1,264.81 Kč"	785.07 Kč	479.74 Kč	" 191,111.19 Kč "	
171	"1,264.81 Kč"	787.03 Kč	477.78 Kč	" 190,324.15 Kč "	
172	"1,264.81 Kč"	789.00 Kč	475.81 Kč	" 189,535.15 Kč "	
173	"1,264.81 Kč"	790.97 Kč	473.84 Kč	" 188,744.18 Kč "	
174	"1,264.81 Kč"	792.95 Kč	471.86 Kč	" 187,951.23 Kč "	
175	"1,264.81 Kč"	794.93 Kč	469.88 Kč	" 187,156.29 Kč "	
176	"1,264.81 Kč"	796.92 Kč	467.89 Kč	" 186,359.37 Kč "	
177	"1,264.81 Kč"	798.91 Kč	465.90 Kč	" 185,560.46 Kč "	
178	"1,264.81 Kč"	800.91 Kč	463.90 Kč	" 184,759.55 Kč "	
179	"1,264.81 Kč"	802.91 Kč	461.90 Kč	" 183,956.63 Kč "	
180	"1,264.81 Kč"	804.92 Kč	459.89 Kč	" 183,151.71 Kč "	
181	"1,264.81 Kč"	806.93 Kč	457.88 Kč	" 182,344.78 Kč "	
182	"1,264.81 Kč"	808.95 Kč	455.86 Kč	" 181,535.83 Kč "	
183	"1,264.81 Kč"	810.97 Kč	453.84 Kč	" 180,724.86 Kč "	
184	"1,264.81 Kč"	813.00 Kč	451.81 Kč	" 179,911.86 Kč "	
185	"1,264.81 Kč"	815.03 Kč	449.78 Kč	" 179,096.82 Kč "	
186	"1,264.81 Kč"	817.07 Kč	447.74 Kč	" 178,279.75 Kč "	
187	"1,264.81 Kč"	819.11 Kč	445.70 Kč	" 177,460.64 Kč "	
188	"1,264.81 Kč"	821.16 Kč	443.65 Kč	" 176,639.48 Kč "	
189	"1,264.81 Kč"	823.21 Kč	441.60 Kč	" 175,816.27 Kč "	
190	"1,264.81 Kč"	825.27 Kč	439.54 Kč	" 174,991.00 Kč "	
191	"1,264.81 Kč"	827.33 Kč	437.48 Kč	" 174,163.66 Kč "	
192	"1,264.81 Kč"	829.40 Kč	435.41 Kč	" 173,334.26 Kč "	
193	"1,264.81 Kč"	831.48 Kč	433.34 Kč	" 172,502.78 Kč "	
194	"1,264.81 Kč"	833.56 Kč	431.26 Kč	" 171,669.23 Kč "	
195	"1,264.81 Kč"	835.64 Kč	429.17 Kč	" 170,833.59 Kč "	
196	"1,264.81 Kč"	837.73 Kč	427.08 Kč	" 169,995.86 Kč "	
197	"1,264.81 Kč"	839.82 Kč	424.99 Kč	" 169,156.04 Kč "	
198	"1,264.81 Kč"	841.92 Kč	422.89 Kč	" 168,314.12 Kč "	
199	"1,264.81 Kč"	844.03 Kč	420.79 Kč	" 167,470.09 Kč "	
200	"1,264.81 Kč"	846.14 Kč	418.68 Kč	" 166,623.95 Kč "	
201	"1,264.81 Kč"	848.25 Kč	416.56 Kč	" 165,775.70 Kč "	
202	"1,264.81 Kč"	850.37 Kč	414.44 Kč	" 164,925.33 Kč "	
203	"1,264.81 Kč"	852.50 Kč	412.31 Kč	" 164,072.83 Kč "	
204	"1,264.81 Kč"	854.63 Kč	410.18 Kč	" 163,218.20 Kč "	
205	"1,264.81 Kč"	856.77 Kč	408.05 Kč	" 162,361.43 Kč "	
206	"1,264.81 Kč"	858.91 Kč	405.90 Kč	" 161,502.52 Kč "	
207	"1,264.81 Kč"	861.06 Kč	403.76 Kč	" 160,641.47 Kč "	
208	"1,264.81 Kč"	863.21 Kč	401.60 Kč	" 159,778.26 Kč "	
209	"1,264.81 Kč"	865.37 Kč	399.45 Kč	" 158,912.89 Kč "	
210	"1,264.81 Kč"	867.53 Kč	397.28 Kč	" 158,045.36 Kč "	
211	"1,264.81 Kč"	869.70 Kč	395.11 Kč	" 157,175.66 Kč "	
212	"1,264.81 Kč"	871.87 Kč	392.94 Kč	" 156,303.79 Kč "	
213	"1,264.81 Kč"	874.05 Kč	390.76 Kč	" 155,429.74 Kč "	
214	"1,264.81 Kč"	876.24 Kč	388.57 Kč	" 154,553.50 Kč "	
215	"1,264.81 Kč"	878.43 Kč	386.38 Kč	" 153,675.07 Kč "	
216	"1,264.81 Kč"	880.62 Kč	384.19 Kč	" 152,794.45 Kč "	
217	"1,264.81 Kč"	882.83 Kč	381.99 Kč	" 151,911.62 Kč "	
218	"1,264.81 Kč"	885.03 Kč	379.78 Kč	" 151,026.59 Kč "	
219	"1,264.81 Kč"	887.25 Kč	377.57 Kč	" 150,139.34 Kč "	
220	"1,264.81 Kč"	889.46 Kč	375.35 Kč	" 149,249.88 Kč "	
221	"1,264.81 Kč"	891.69 Kč	373.12 Kč	" 148,358.19 Kč "	
222	"1,264.81 Kč"	893.92 Kč	370.90 Kč	" 147,464.28 Kč "	
223	"1,264.81 Kč"	896.15 Kč	368.66 Kč	" 146,568.12 Kč "	
224	"1,264.81 Kč"	898.39 Kč	366.42 Kč	" 145,669.73 Kč "	
225	"1,264.81 Kč"	900.64 Kč	364.17 Kč	" 144,769.09 Kč "	
226	"1,264.81 Kč"	902.89 Kč	361.92 Kč	" 143,866.21 Kč "	
227	"1,264.81 Kč"	905.15 Kč	359.67 Kč	" 142,961.06 Kč "	
228	"1,264.81 Kč"	907.41 Kč	357.40 Kč	" 142,053.65 Kč "	
229	"1,264.81 Kč"	909.68 Kč	355.13 Kč	" 141,143.97 Kč "	
230	"1,264.81 Kč"	911.95 Kč	352.86 Kč	" 140,232.02 Kč "	
231	"1,264.81 Kč"	914.23 Kč	350.58 Kč	" 139,317.79 Kč "	
232	"1,264.81 Kč"	916.52 Kč	348.29 Kč	" 138,401.27 Kč "	
233	"1,264.81 Kč"	918.81 Kč	346.00 Kč	" 137,482.46 Kč "	
234	"1,264.81 Kč"	921.11 Kč	343.71 Kč	" 136,561.35 Kč "	
235	"1,264.81 Kč"	923.41 Kč	341.40 Kč	" 135,637.95 Kč "	
236	"1,264.81 Kč"	925.72 Kč	339.09 Kč	" 134,712.23 Kč "	
237	"1,264.81 Kč"	928.03 Kč	336.78 Kč	" 133,784.20 Kč "	
238	"1,264.81 Kč"	930.35 Kč	334.46 Kč	" 132,853.85 Kč "	
239	"1,264.81 Kč"	932.68 Kč	332.13 Kč	" 131,921.17 Kč "	
240	"1,264.81 Kč"	935.01 Kč	329.80 Kč	" 130,986.16 Kč "	
241	"1,264.81 Kč"	937.35 Kč	327.47 Kč	" 130,048.81 Kč "	
242	"1,264.81 Kč"	939.69 Kč	325.12 Kč	" 129,109.12 Kč "	
243	"1,264.81 Kč"	942.04 Kč	322.77 Kč	" 128,167.08 Kč "	
244	"1,264.81 Kč"	944.39 Kč	320.42 Kč	" 127,222.69 Kč "	
245	"1,264.81 Kč"	946.76 Kč	318.06 Kč	" 126,275.93 Kč "	
246	"1,264.81 Kč"	949.12 Kč	315.69 Kč	" 125,326.81 Kč "	
247	"1,264.81 Kč"	951.50 Kč	313.32 Kč	" 124,375.32 Kč "	
248	"1,264.81 Kč"	953.87 Kč	310.94 Kč	" 123,421.44 Kč "	
249	"1,264.81 Kč"	956.26 Kč	308.55 Kč	" 122,465.18 Kč "	
250	"1,264.81 Kč"	958.65 Kč	306.16 Kč	" 121,506.53 Kč "	
251	"1,264.81 Kč"	961.05 Kč	303.77 Kč	" 120,545.49 Kč "	
252	"1,264.81 Kč"	963.45 Kč	301.36 Kč	" 119,582.04 Kč "	
253	"1,264.81 Kč"	965.86 Kč	298.96 Kč	" 118,616.18 Kč "	
254	"1,264.81 Kč"	968.27 Kč	296.54 Kč	" 117,647.91 Kč "	
255	"1,264.81 Kč"	970.69 Kč	294.12 Kč	" 116,677.22 Kč "	
256	"1,264.81 Kč"	973.12 Kč	291.69 Kč	" 115,704.10 Kč "	
257	"1,264.81 Kč"	975.55 Kč	289.26 Kč	" 114,728.55 Kč "	
258	"1,264.81 Kč"	977.99 Kč	286.82 Kč	" 113,750.56 Kč "	
259	"1,264.81 Kč"	980.44 Kč	284.38 Kč	" 112,770.12 Kč "	
260	"1,264.81 Kč"	982.89 Kč	281.93 Kč	" 111,787.23 Kč "	
261	"1,264.81 Kč"	985.34 Kč	279.47 Kč	" 110,801.89 Kč "	
262	"1,264.81 Kč"	987.81 Kč	277.00 Kč	" 109,814.08 Kč "	
263	"1,264.81 Kč"	990.28 Kč	274.54 Kč	" 108,823.81 Kč "	
264	"1,264.81 Kč"	992.75 Kč	272.06 Kč	" 107,831.05 Kč "	
265	"1,264.81 Kč"	995.23 Kč	269.58 Kč	" 106,835.82 Kč "	
266	"1,264.81 Kč"	997.72 Kč	267.09 Kč	" 105,838.10 Kč "	
267	"1,264.81 Kč"	"1,000.22 Kč"	264.60 Kč	" 104,837.88 Kč "	
268	"1,264.81 Kč"	"1,002.72 Kč"	262.09 Kč	" 103,835.16 Kč "	
269	"1,264.81 Kč"	"1,005.22 Kč"	259.59 Kč	" 102,829.94 Kč "	
270	"1,264.81 Kč"	"1,007.74 Kč"	257.07 Kč	" 101,822.20 Kč "	
271	"1,264.81 Kč"	"1,010.26 Kč"	254.56 Kč	" 100,811.94 Kč "	
272	"1,264.81 Kč"	"1,012.78 Kč"	252.03 Kč	" 99,799.16 Kč "	
273	"1,264.81 Kč"	"1,015.31 Kč"	249.50 Kč	" 98,783.85 Kč "	
274	"1,264.81 Kč"	"1,017.85 Kč"	246.96 Kč	" 97,766.00 Kč "	
275	"1,264.81 Kč"	"1,020.40 Kč"	244.41 Kč	" 96,745.60 Kč "	
276	"1,264.81 Kč"	"1,022.95 Kč"	241.86 Kč	" 95,722.65 Kč "	
277	"1,264.81 Kč"	"1,025.51 Kč"	239.31 Kč	" 94,697.14 Kč "	
278	"1,264.81 Kč"	"1,028.07 Kč"	236.74 Kč	" 93,669.08 Kč "	
279	"1,264.81 Kč"	"1,030.64 Kč"	234.17 Kč	" 92,638.44 Kč "	
280	"1,264.81 Kč"	"1,033.22 Kč"	231.60 Kč	" 91,605.22 Kč "	
281	"1,264.81 Kč"	"1,035.80 Kč"	229.01 Kč	" 90,569.42 Kč "	
282	"1,264.81 Kč"	"1,038.39 Kč"	226.42 Kč	" 89,531.03 Kč "	
283	"1,264.81 Kč"	"1,040.98 Kč"	223.83 Kč	" 88,490.05 Kč "	
284	"1,264.81 Kč"	"1,043.59 Kč"	221.23 Kč	" 87,446.46 Kč "	
285	"1,264.81 Kč"	"1,046.20 Kč"	218.62 Kč	" 86,400.27 Kč "	
286	"1,264.81 Kč"	"1,048.81 Kč"	216.00 Kč	" 85,351.45 Kč "	
287	"1,264.81 Kč"	"1,051.43 Kč"	213.38 Kč	" 84,300.02 Kč "	
288	"1,264.81 Kč"	"1,054.06 Kč"	210.75 Kč	" 83,245.96 Kč "	
289	"1,264.81 Kč"	"1,056.70 Kč"	208.11 Kč	" 82,189.26 Kč "	
290	"1,264.81 Kč"	"1,059.34 Kč"	205.47 Kč	" 81,129.92 Kč "	
291	"1,264.81 Kč"	"1,061.99 Kč"	202.82 Kč	" 80,067.93 Kč "	
292	"1,264.81 Kč"	"1,064.64 Kč"	200.17 Kč	" 79,003.29 Kč "	
293	"1,264.81 Kč"	"1,067.30 Kč"	197.51 Kč	" 77,935.99 Kč "	
294	"1,264.81 Kč"	"1,069.97 Kč"	194.84 Kč	" 76,866.02 Kč "	
295	"1,264.81 Kč"	"1,072.65 Kč"	192.17 Kč	" 75,793.37 Kč "	
296	"1,264.81 Kč"	"1,075.33 Kč"	189.48 Kč	" 74,718.04 Kč "	
297	"1,264.81 Kč"	"1,078.02 Kč"	186.80 Kč	" 73,640.02 Kč "	
298	"1,264.81 Kč"	"1,080.71 Kč"	184.10 Kč	" 72,559.31 Kč "	
299	"1,264.81 Kč"	"1,083.41 Kč"	181.40 Kč	" 71,475.90 Kč "	
300	"1,264.81 Kč"	"1,086.12 Kč"	178.69 Kč	" 70,389.78 Kč "	
301	"1,264.81 Kč"	"1,088.84 Kč"	175.97 Kč	" 69,300.94 Kč "	
302	"1,264.81 Kč"	"1,091.56 Kč"	173.25 Kč	" 68,209.38 Kč "	
303	"1,264.81 Kč"	"1,094.29 Kč"	170.52 Kč	" 67,115.09 Kč "	
304	"1,264.81 Kč"	"1,097.02 Kč"	167.79 Kč	" 66,018.07 Kč "	
305	"1,264.81 Kč"	"1,099.77 Kč"	165.05 Kč	" 64,918.30 Kč "	
306	"1,264.81 Kč"	"1,102.52 Kč"	162.30 Kč	" 63,815.78 Kč "	
307	"1,264.81 Kč"	"1,105.27 Kč"	159.54 Kč	" 62,710.51 Kč "	
308	"1,264.81 Kč"	"1,108.04 Kč"	156.78 Kč	" 61,602.47 Kč "	
309	"1,264.81 Kč"	"1,110.81 Kč"	154.01 Kč	" 60,491.67 Kč "	
310	"1,264.81 Kč"	"1,113.58 Kč"	151.23 Kč	" 59,378.08 Kč "	
311	"1,264.81 Kč"	"1,116.37 Kč"	148.45 Kč	" 58,261.72 Kč "	
312	"1,264.81 Kč"	"1,119.16 Kč"	145.65 Kč	" 57,142.56 Kč "	
313	"1,264.81 Kč"	"1,121.96 Kč"	142.86 Kč	" 56,020.60 Kč "	
314	"1,264.81 Kč"	"1,124.76 Kč"	140.05 Kč	" 54,895.84 Kč "	
315	"1,264.81 Kč"	"1,127.57 Kč"	137.24 Kč	" 53,768.27 Kč "	
316	"1,264.81 Kč"	"1,130.39 Kč"	134.42 Kč	" 52,637.88 Kč "	
317	"1,264.81 Kč"	"1,133.22 Kč"	131.59 Kč	" 51,504.66 Kč "	
318	"1,264.81 Kč"	"1,136.05 Kč"	128.76 Kč	" 50,368.61 Kč "	
319	"1,264.81 Kč"	"1,138.89 Kč"	125.92 Kč	" 49,229.72 Kč "	
320	"1,264.81 Kč"	"1,141.74 Kč"	123.07 Kč	" 48,087.98 Kč "	
321	"1,264.81 Kč"	"1,144.59 Kč"	120.22 Kč	" 46,943.39 Kč "	
322	"1,264.81 Kč"	"1,147.45 Kč"	117.36 Kč	" 45,795.94 Kč "	
323	"1,264.81 Kč"	"1,150.32 Kč"	114.49 Kč	" 44,645.62 Kč "	
324	"1,264.81 Kč"	"1,153.20 Kč"	111.61 Kč	" 43,492.42 Kč "	
325	"1,264.81 Kč"	"1,156.08 Kč"	108.73 Kč	" 42,336.34 Kč "	
326	"1,264.81 Kč"	"1,158.97 Kč"	105.84 Kč	" 41,177.36 Kč "	
327	"1,264.81 Kč"	"1,161.87 Kč"	102.94 Kč	" 40,015.50 Kč "	
328	"1,264.81 Kč"	"1,164.77 Kč"	100.04 Kč	" 38,850.72 Kč "	
329	"1,264.81 Kč"	"1,167.69 Kč"	97.13 Kč	" 37,683.04 Kč "	
330	"1,264.81 Kč"	"1,170.60 Kč"	94.21 Kč	" 36,512.43 Kč "	
331	"1,264.81 Kč"	"1,173.53 Kč"	91.28 Kč	" 35,338.90 Kč "	
332	"1,264.81 Kč"	"1,176.46 Kč"	88.35 Kč	" 34,162.44 Kč "	
333	"1,264.81 Kč"	"1,179.41 Kč"	85.41 Kč	" 32,983.03 Kč "	
334	"1,264.81 Kč"	"1,182.35 Kč"	82.46 Kč	" 31,800.68 Kč "	
335	"1,264.81 Kč"	"1,185.31 Kč"	79.50 Kč	" 30,615.37 Kč "	
336	"1,264.81 Kč"	"1,188.27 Kč"	76.54 Kč	" 29,427.09 Kč "	
337	"1,264.81 Kč"	"1,191.24 Kč"	73.57 Kč	" 28,235.85 Kč "	
338	"1,264.81 Kč"	"1,194.22 Kč"	70.59 Kč	" 27,041.63 Kč "	
339	"1,264.81 Kč"	"1,197.21 Kč"	67.60 Kč	" 25,844.42 Kč "	
340	"1,264.81 Kč"	"1,200.20 Kč"	64.61 Kč	" 24,644.22 Kč "	
341	"1,264.81 Kč"	"1,203.20 Kč"	61.61 Kč	" 23,441.02 Kč "	
342	"1,264.81 Kč"	"1,206.21 Kč"	58.60 Kč	" 22,234.81 Kč "	
343	"1,264.81 Kč"	"1,209.23 Kč"	55.59 Kč	" 21,025.58 Kč "	
344	"1,264.81 Kč"	"1,212.25 Kč"	52.56 Kč	" 19,813.33 Kč "	
345	"1,264.81 Kč"	"1,215.28 Kč"	49.53 Kč	" 18,598.05 Kč "	
346	"1,264.81 Kč"	"1,218.32 Kč"	46.50 Kč	" 17,379.74 Kč "	
347	"1,264.81 Kč"	"1,221.36 Kč"	43.45 Kč	" 16,158.37 Kč "	
348	"1,264.81 Kč"	"1,224.42 Kč"	40.40 Kč	" 14,933.96 Kč "	
349	"1,264.81 Kč"	"1,227.48 Kč"	37.33 Kč	" 13,706.48 Kč "	
350	"1,264.81 Kč"	"1,230.55 Kč"	34.27 Kč	" 12,475.93 Kč "	
351	"1,264.81 Kč"	"1,233.62 Kč"	31.19 Kč	" 11,242.31 Kč "	
352	"1,264.81 Kč"	"1,236.71 Kč"	28.11 Kč	" 10,005.61 Kč "	
353	"1,264.81 Kč"	"1,239.80 Kč"	25.01 Kč	" 8,765.81 Kč "	
354	"1,264.81 Kč"	"1,242.90 Kč"	21.91 Kč	" 7,522.91 Kč "	
355	"1,264.81 Kč"	"1,246.00 Kč"	18.81 Kč	" 6,276.91 Kč "	
356	"1,264.81 Kč"	"1,249.12 Kč"	15.69 Kč	" 5,027.79 Kč "	
357	"1,264.81 Kč"	"1,252.24 Kč"	12.57 Kč	" 3,775.54 Kč "	
358	"1,264.81 Kč"	"1,255.37 Kč"	9.44 Kč	" 2,520.17 Kč "	
359	"1,264.81 Kč"	"1,258.51 Kč"	6.30 Kč	" 1,261.66 Kč "	
360	"1,264.81 Kč"	"1,261.66 Kč"	3.15 Kč	-0.00 Kč 	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
				  	
					
					
					
					
					
					
					
##### Sheet/List 5 #####
Příjmy				Náklady				Bilance		
								Bez dětí	 -   Kč 	=KDYŽ(B11=0;(B4+B5+B14*B15-F8-F11)*F7;0)
Platy				Hypotéka				Jedno dítě	" 8,776,675.64 Kč "	=KDYŽ(B11=1;(B4+B14*B15-F11-F8)*F7+B5*(F7-B9)+B10*B9-F12*(F7-Vstupy!C10);0)
On příjem (měsíční)	" 35,000.00 Kč "			výše úvěru	" 300,000.00 Kč "			Dvě děti	 0 	"=KDYŽ(B11=2;(B4+B14*B15-F11-F8)*F7+B5*(F7-2*B9)+B10*B9*2-F12*(F7-Vstupy!C10)-F12*(F7-Vstupy!C11);"""")"
Ona příjem (měsíční)	" 20,000.00 Kč "			úroková míra	3.00%					
				délka úvěru (v letech)	30					
Mateřská				délka úvěru (v měsících)	360	=B7*12				
rodičovská dovolená (roky)	2			splátka (měsíční)	"1,264.81 Kč"	=Hypotéka!B4				
rodičovská dovolená (měsíce)	24	=B9*12								
rodičovská (měsíční)	" 9,167.00 Kč "	=ROUNDUP(220000/B10;0)		Další náklady						
Počet dětí	1			Provozní náklady	" 35,000.00 Kč "					
				náklady na dítě	" 3,000.00 Kč "					
Pronájem										
platby (měsíční)	" 12,000.00 Kč "									
úspěšnost pronájmu	80.0%									
										
										
hodnota hypotéky (při zůstatku 500 tis)										
" 6,307,562.10 Kč "										
										
	zůstatek									
 úrokové míry 	" 8,776,675.64 Kč "									
1.7%	" 8,848,825.61 Kč "									
1.8%	" 8,843,533.62 Kč "									
1.9%	" 8,838,198.03 Kč "									
2.0%	" 8,832,818.97 Kč "									
2.1%	" 8,827,396.60 Kč "									
2.2%	" 8,821,931.09 Kč "									
2.3%	" 8,816,422.61 Kč "									
2.4%	" 8,810,871.32 Kč "									
2.5%	" 8,805,277.43 Kč "									
2.6%	" 8,799,641.11 Kč "									
2.7%	" 8,793,962.57 Kč "									
2.8%	" 8,788,242.00 Kč "									
2.9%	" 8,782,479.62 Kč "									
3.0%	" 8,776,675.64 Kč "									
3.1%	" 8,770,830.29 Kč "									
										
										
		výše úrokové míry								
	" 8,776,675.64 Kč "	1.70%	1.80%	1.90%	2.00%	2.10%	2.20%			
Výše hypotéky	" 4,500,000.00 Kč "	" 3,484,272.11 Kč "	" 3,404,892.37 Kč "	" 3,324,858.44 Kč "	" 3,244,172.54 Kč "	" 3,162,837.04 Kč "	" 3,080,854.37 Kč "			
	" 4,700,000.00 Kč "	" 3,228,817.18 Kč "	" 3,145,909.45 Kč "	" 3,062,318.46 Kč "	" 2,978,046.52 Kč "	" 2,893,096.11 Kč "	" 2,807,469.76 Kč "			
	" 4,900,000.00 Kč "	" 2,973,362.25 Kč "	" 2,886,926.54 Kč "	" 2,799,778.47 Kč "	" 2,711,920.50 Kč "	" 2,623,355.17 Kč "	" 2,534,085.16 Kč "			
	" 5,100,000.00 Kč "	" 2,717,907.33 Kč "	" 2,627,943.62 Kč "	" 2,537,238.49 Kč "	" 2,445,794.48 Kč "	" 2,353,614.24 Kč "	" 2,260,700.55 Kč "			
	" 5,300,000.00 Kč "	" 2,462,452.40 Kč "	" 2,368,960.70 Kč "	" 2,274,698.51 Kč "	" 2,179,668.46 Kč "	" 2,083,873.31 Kč "	" 1,987,315.95 Kč "			
	" 5,500,000.00 Kč "	" 2,206,997.47 Kč "	" 2,109,977.79 Kč "	" 2,012,158.53 Kč "	" 1,913,542.44 Kč "	" 1,814,132.38 Kč "	" 1,713,931.34 Kč "			
	" 5,700,000.00 Kč "	" 1,951,542.54 Kč "	" 1,850,994.87 Kč "	" 1,749,618.55 Kč "	" 1,647,416.42 Kč "	" 1,544,391.45 Kč "	" 1,440,546.73 Kč "			
	" 5,900,000.00 Kč "	" 1,696,087.61 Kč "	" 1,592,011.95 Kč "	" 1,487,078.57 Kč "	" 1,381,290.40 Kč "	" 1,274,650.51 Kč "	" 1,167,162.13 Kč "			
	" 6,100,000.00 Kč "	" 1,440,632.68 Kč "	" 1,333,029.04 Kč "	" 1,224,538.59 Kč "	" 1,115,164.38 Kč "	" 1,004,909.58 Kč "	" 893,777.52 Kč "			
	" 6,300,000.00 Kč "	" 1,185,177.76 Kč "	" 1,074,046.12 Kč "	" 961,998.61 Kč "	" 849,038.36 Kč "	" 735,168.65 Kč "	" 620,392.92 Kč "			
	" 6,500,000.00 Kč "	" 929,722.83 Kč "	" 815,063.20 Kč "	" 699,458.63 Kč "	" 582,912.34 Kč "	" 465,427.72 Kč "	" 347,008.31 Kč "			
	" 6,700,000.00 Kč "	" 674,267.90 Kč "	" 556,080.29 Kč "	" 436,918.65 Kč "	" 316,786.32 Kč "	" 195,686.79 Kč "	" 73,623.70 Kč "			
	" 6,900,000.00 Kč "	" 418,812.97 Kč "	" 297,097.37 Kč "	" 174,378.67 Kč "	" 50,660.30 Kč "	"-74,054.14 Kč "	"-199,760.90 Kč "			
	" 7,100,000.00 Kč "	" 163,358.04 Kč "	" 38,114.45 Kč "	"-88,161.31 Kč "	"-215,465.72 Kč "	"-343,795.08 Kč "	"-473,145.51 Kč "			
	" 7,300,000.00 Kč "	"-92,096.89 Kč "	"-220,868.46 Kč "	"-350,701.29 Kč "	"-481,591.74 Kč "	"-613,536.01 Kč "	"-746,530.11 Kč "