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/27/2020	=DNES()				
tento měsíc	2	=MĚSÍC(B1)				
tento rok	2020	=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	8.00	=12-$B$2+(ROK(B10)-$B$3-1)*12+MĚSÍC(B10)			
2. dítě	Mar-23	37.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,185.36 Kč"	560.36 Kč	625.00 Kč	" 299,439.64 Kč "	
2	"1,185.36 Kč"	561.53 Kč	623.83 Kč	" 298,878.11 Kč "	
3	"1,185.36 Kč"	562.70 Kč	622.66 Kč	" 298,315.41 Kč "	
4	"1,185.36 Kč"	563.87 Kč	621.49 Kč	" 297,751.53 Kč "	
5	"1,185.36 Kč"	565.05 Kč	620.32 Kč	" 297,186.49 Kč "	
6	"1,185.36 Kč"	566.22 Kč	619.14 Kč	" 296,620.26 Kč "	
7	"1,185.36 Kč"	567.40 Kč	617.96 Kč	" 296,052.86 Kč "	
8	"1,185.36 Kč"	568.59 Kč	616.78 Kč	" 295,484.27 Kč "	
9	"1,185.36 Kč"	569.77 Kč	615.59 Kč	" 294,914.50 Kč "	
10	"1,185.36 Kč"	570.96 Kč	614.41 Kč	" 294,343.55 Kč "	
11	"1,185.36 Kč"	572.15 Kč	613.22 Kč	" 293,771.40 Kč "	
12	"1,185.36 Kč"	573.34 Kč	612.02 Kč	" 293,198.06 Kč "	
13	"1,185.36 Kč"	574.53 Kč	610.83 Kč	" 292,623.53 Kč "	
14	"1,185.36 Kč"	575.73 Kč	609.63 Kč	" 292,047.80 Kč "	
15	"1,185.36 Kč"	576.93 Kč	608.43 Kč	" 291,470.87 Kč "	
16	"1,185.36 Kč"	578.13 Kč	607.23 Kč	" 290,892.73 Kč "	
17	"1,185.36 Kč"	579.34 Kč	606.03 Kč	" 290,313.40 Kč "	
18	"1,185.36 Kč"	580.54 Kč	604.82 Kč	" 289,732.86 Kč "	
19	"1,185.36 Kč"	581.75 Kč	603.61 Kč	" 289,151.10 Kč "	
20	"1,185.36 Kč"	582.96 Kč	602.40 Kč	" 288,568.14 Kč "	
21	"1,185.36 Kč"	584.18 Kč	601.18 Kč	" 287,983.96 Kč "	
22	"1,185.36 Kč"	585.40 Kč	599.97 Kč	" 287,398.56 Kč "	
23	"1,185.36 Kč"	586.62 Kč	598.75 Kč	" 286,811.95 Kč "	
24	"1,185.36 Kč"	587.84 Kč	597.52 Kč	" 286,224.11 Kč "	
25	"1,185.36 Kč"	589.06 Kč	596.30 Kč	" 285,635.05 Kč "	
26	"1,185.36 Kč"	590.29 Kč	595.07 Kč	" 285,044.76 Kč "	
27	"1,185.36 Kč"	591.52 Kč	593.84 Kč	" 284,453.24 Kč "	
28	"1,185.36 Kč"	592.75 Kč	592.61 Kč	" 283,860.49 Kč "	
29	"1,185.36 Kč"	593.99 Kč	591.38 Kč	" 283,266.50 Kč "	
30	"1,185.36 Kč"	595.22 Kč	590.14 Kč	" 282,671.28 Kč "	
31	"1,185.36 Kč"	596.46 Kč	588.90 Kč	" 282,074.81 Kč "	
32	"1,185.36 Kč"	597.71 Kč	587.66 Kč	" 281,477.10 Kč "	
33	"1,185.36 Kč"	598.95 Kč	586.41 Kč	" 280,878.15 Kč "	
34	"1,185.36 Kč"	600.20 Kč	585.16 Kč	" 280,277.95 Kč "	
35	"1,185.36 Kč"	601.45 Kč	583.91 Kč	" 279,676.50 Kč "	
36	"1,185.36 Kč"	602.70 Kč	582.66 Kč	" 279,073.80 Kč "	
37	"1,185.36 Kč"	603.96 Kč	581.40 Kč	" 278,469.84 Kč "	
38	"1,185.36 Kč"	605.22 Kč	580.15 Kč	" 277,864.62 Kč "	
39	"1,185.36 Kč"	606.48 Kč	578.88 Kč	" 277,258.14 Kč "	
40	"1,185.36 Kč"	607.74 Kč	577.62 Kč	" 276,650.40 Kč "	
41	"1,185.36 Kč"	609.01 Kč	576.36 Kč	" 276,041.40 Kč "	
42	"1,185.36 Kč"	610.28 Kč	575.09 Kč	" 275,431.12 Kč "	
43	"1,185.36 Kč"	611.55 Kč	573.81 Kč	" 274,819.57 Kč "	
44	"1,185.36 Kč"	612.82 Kč	572.54 Kč	" 274,206.75 Kč "	
45	"1,185.36 Kč"	614.10 Kč	571.26 Kč	" 273,592.65 Kč "	
46	"1,185.36 Kč"	615.38 Kč	569.98 Kč	" 272,977.27 Kč "	
47	"1,185.36 Kč"	616.66 Kč	568.70 Kč	" 272,360.61 Kč "	
48	"1,185.36 Kč"	617.94 Kč	567.42 Kč	" 271,742.67 Kč "	
49	"1,185.36 Kč"	619.23 Kč	566.13 Kč	" 271,123.44 Kč "	
50	"1,185.36 Kč"	620.52 Kč	564.84 Kč	" 270,502.91 Kč "	
51	"1,185.36 Kč"	621.81 Kč	563.55 Kč	" 269,881.10 Kč "	
52	"1,185.36 Kč"	623.11 Kč	562.25 Kč	" 269,257.99 Kč "	
53	"1,185.36 Kč"	624.41 Kč	560.95 Kč	" 268,633.58 Kč "	
54	"1,185.36 Kč"	625.71 Kč	559.65 Kč	" 268,007.87 Kč "	
55	"1,185.36 Kč"	627.01 Kč	558.35 Kč	" 267,380.86 Kč "	
56	"1,185.36 Kč"	628.32 Kč	557.04 Kč	" 266,752.54 Kč "	
57	"1,185.36 Kč"	629.63 Kč	555.73 Kč	" 266,122.91 Kč "	
58	"1,185.36 Kč"	630.94 Kč	554.42 Kč	" 265,491.97 Kč "	
59	"1,185.36 Kč"	632.25 Kč	553.11 Kč	" 264,859.72 Kč "	
60	"1,185.36 Kč"	633.57 Kč	551.79 Kč	" 264,226.14 Kč "	
61	"1,185.36 Kč"	634.89 Kč	550.47 Kč	" 263,591.25 Kč "	
62	"1,185.36 Kč"	636.21 Kč	549.15 Kč	" 262,955.04 Kč "	
63	"1,185.36 Kč"	637.54 Kč	547.82 Kč	" 262,317.50 Kč "	
64	"1,185.36 Kč"	638.87 Kč	546.49 Kč	" 261,678.63 Kč "	
65	"1,185.36 Kč"	640.20 Kč	545.16 Kč	" 261,038.43 Kč "	
66	"1,185.36 Kč"	641.53 Kč	543.83 Kč	" 260,396.90 Kč "	
67	"1,185.36 Kč"	642.87 Kč	542.49 Kč	" 259,754.03 Kč "	
68	"1,185.36 Kč"	644.21 Kč	541.15 Kč	" 259,109.82 Kč "	
69	"1,185.36 Kč"	645.55 Kč	539.81 Kč	" 258,464.27 Kč "	
70	"1,185.36 Kč"	646.90 Kč	538.47 Kč	" 257,817.38 Kč "	
71	"1,185.36 Kč"	648.24 Kč	537.12 Kč	" 257,169.13 Kč "	
72	"1,185.36 Kč"	649.59 Kč	535.77 Kč	" 256,519.54 Kč "	
73	"1,185.36 Kč"	650.95 Kč	534.42 Kč	" 255,868.59 Kč "	
74	"1,185.36 Kč"	652.30 Kč	533.06 Kč	" 255,216.29 Kč "	
75	"1,185.36 Kč"	653.66 Kč	531.70 Kč	" 254,562.63 Kč "	
76	"1,185.36 Kč"	655.02 Kč	530.34 Kč	" 253,907.60 Kč "	
77	"1,185.36 Kč"	656.39 Kč	528.97 Kč	" 253,251.21 Kč "	
78	"1,185.36 Kč"	657.76 Kč	527.61 Kč	" 252,593.46 Kč "	
79	"1,185.36 Kč"	659.13 Kč	526.24 Kč	" 251,934.33 Kč "	
80	"1,185.36 Kč"	660.50 Kč	524.86 Kč	" 251,273.83 Kč "	
81	"1,185.36 Kč"	661.88 Kč	523.49 Kč	" 250,611.96 Kč "	
82	"1,185.36 Kč"	663.25 Kč	522.11 Kč	" 249,948.70 Kč "	
83	"1,185.36 Kč"	664.64 Kč	520.73 Kč	" 249,284.07 Kč "	
84	"1,185.36 Kč"	666.02 Kč	519.34 Kč	" 248,618.04 Kč "	
85	"1,185.36 Kč"	667.41 Kč	517.95 Kč	" 247,950.64 Kč "	
86	"1,185.36 Kč"	668.80 Kč	516.56 Kč	" 247,281.84 Kč "	
87	"1,185.36 Kč"	670.19 Kč	515.17 Kč	" 246,611.65 Kč "	
88	"1,185.36 Kč"	671.59 Kč	513.77 Kč	" 245,940.06 Kč "	
89	"1,185.36 Kč"	672.99 Kč	512.38 Kč	" 245,267.07 Kč "	
90	"1,185.36 Kč"	674.39 Kč	510.97 Kč	" 244,592.68 Kč "	
91	"1,185.36 Kč"	675.79 Kč	509.57 Kč	" 243,916.88 Kč "	
92	"1,185.36 Kč"	677.20 Kč	508.16 Kč	" 243,239.68 Kč "	
93	"1,185.36 Kč"	678.61 Kč	506.75 Kč	" 242,561.07 Kč "	
94	"1,185.36 Kč"	680.03 Kč	505.34 Kč	" 241,881.04 Kč "	
95	"1,185.36 Kč"	681.44 Kč	503.92 Kč	" 241,199.60 Kč "	
96	"1,185.36 Kč"	682.86 Kč	502.50 Kč	" 240,516.73 Kč "	
97	"1,185.36 Kč"	684.29 Kč	501.08 Kč	" 239,832.45 Kč "	
98	"1,185.36 Kč"	685.71 Kč	499.65 Kč	" 239,146.74 Kč "	
99	"1,185.36 Kč"	687.14 Kč	498.22 Kč	" 238,459.60 Kč "	
100	"1,185.36 Kč"	688.57 Kč	496.79 Kč	" 237,771.02 Kč "	
101	"1,185.36 Kč"	690.01 Kč	495.36 Kč	" 237,081.02 Kč "	
102	"1,185.36 Kč"	691.44 Kč	493.92 Kč	" 236,389.57 Kč "	
103	"1,185.36 Kč"	692.88 Kč	492.48 Kč	" 235,696.69 Kč "	
104	"1,185.36 Kč"	694.33 Kč	491.03 Kč	" 235,002.36 Kč "	
105	"1,185.36 Kč"	695.77 Kč	489.59 Kč	" 234,306.59 Kč "	
106	"1,185.36 Kč"	697.22 Kč	488.14 Kč	" 233,609.36 Kč "	
107	"1,185.36 Kč"	698.68 Kč	486.69 Kč	" 232,910.69 Kč "	
108	"1,185.36 Kč"	700.13 Kč	485.23 Kč	" 232,210.55 Kč "	
109	"1,185.36 Kč"	701.59 Kč	483.77 Kč	" 231,508.96 Kč "	
110	"1,185.36 Kč"	703.05 Kč	482.31 Kč	" 230,805.91 Kč "	
111	"1,185.36 Kč"	704.52 Kč	480.85 Kč	" 230,101.39 Kč "	
112	"1,185.36 Kč"	705.98 Kč	479.38 Kč	" 229,395.41 Kč "	
113	"1,185.36 Kč"	707.46 Kč	477.91 Kč	" 228,687.95 Kč "	
114	"1,185.36 Kč"	708.93 Kč	476.43 Kč	" 227,979.02 Kč "	
115	"1,185.36 Kč"	710.41 Kč	474.96 Kč	" 227,268.62 Kč "	
116	"1,185.36 Kč"	711.89 Kč	473.48 Kč	" 226,556.73 Kč "	
117	"1,185.36 Kč"	713.37 Kč	471.99 Kč	" 225,843.36 Kč "	
118	"1,185.36 Kč"	714.86 Kč	470.51 Kč	" 225,128.51 Kč "	
119	"1,185.36 Kč"	716.34 Kč	469.02 Kč	" 224,412.16 Kč "	
120	"1,185.36 Kč"	717.84 Kč	467.53 Kč	" 223,694.32 Kč "	
121	"1,185.36 Kč"	719.33 Kč	466.03 Kč	" 222,974.99 Kč "	
122	"1,185.36 Kč"	720.83 Kč	464.53 Kč	" 222,254.16 Kč "	
123	"1,185.36 Kč"	722.33 Kč	463.03 Kč	" 221,531.83 Kč "	
124	"1,185.36 Kč"	723.84 Kč	461.52 Kč	" 220,807.99 Kč "	
125	"1,185.36 Kč"	725.35 Kč	460.02 Kč	" 220,082.64 Kč "	
126	"1,185.36 Kč"	726.86 Kč	458.51 Kč	" 219,355.79 Kč "	
127	"1,185.36 Kč"	728.37 Kč	456.99 Kč	" 218,627.41 Kč "	
128	"1,185.36 Kč"	729.89 Kč	455.47 Kč	" 217,897.53 Kč "	
129	"1,185.36 Kč"	731.41 Kč	453.95 Kč	" 217,166.12 Kč "	
130	"1,185.36 Kč"	732.93 Kč	452.43 Kč	" 216,433.18 Kč "	
131	"1,185.36 Kč"	734.46 Kč	450.90 Kč	" 215,698.72 Kč "	
132	"1,185.36 Kč"	735.99 Kč	449.37 Kč	" 214,962.73 Kč "	
133	"1,185.36 Kč"	737.52 Kč	447.84 Kč	" 214,225.21 Kč "	
134	"1,185.36 Kč"	739.06 Kč	446.30 Kč	" 213,486.15 Kč "	
135	"1,185.36 Kč"	740.60 Kč	444.76 Kč	" 212,745.55 Kč "	
136	"1,185.36 Kč"	742.14 Kč	443.22 Kč	" 212,003.41 Kč "	
137	"1,185.36 Kč"	743.69 Kč	441.67 Kč	" 211,259.72 Kč "	
138	"1,185.36 Kč"	745.24 Kč	440.12 Kč	" 210,514.48 Kč "	
139	"1,185.36 Kč"	746.79 Kč	438.57 Kč	" 209,767.69 Kč "	
140	"1,185.36 Kč"	748.35 Kč	437.02 Kč	" 209,019.34 Kč "	
141	"1,185.36 Kč"	749.91 Kč	435.46 Kč	" 208,269.43 Kč "	
142	"1,185.36 Kč"	751.47 Kč	433.89 Kč	" 207,517.97 Kč "	
143	"1,185.36 Kč"	753.03 Kč	432.33 Kč	" 206,764.93 Kč "	
144	"1,185.36 Kč"	754.60 Kč	430.76 Kč	" 206,010.33 Kč "	
145	"1,185.36 Kč"	756.17 Kč	429.19 Kč	" 205,254.16 Kč "	
146	"1,185.36 Kč"	757.75 Kč	427.61 Kč	" 204,496.41 Kč "	
147	"1,185.36 Kč"	759.33 Kč	426.03 Kč	" 203,737.08 Kč "	
148	"1,185.36 Kč"	760.91 Kč	424.45 Kč	" 202,976.17 Kč "	
149	"1,185.36 Kč"	762.50 Kč	422.87 Kč	" 202,213.67 Kč "	
150	"1,185.36 Kč"	764.08 Kč	421.28 Kč	" 201,449.59 Kč "	
151	"1,185.36 Kč"	765.68 Kč	419.69 Kč	" 200,683.91 Kč "	
152	"1,185.36 Kč"	767.27 Kč	418.09 Kč	" 199,916.64 Kč "	
153	"1,185.36 Kč"	768.87 Kč	416.49 Kč	" 199,147.77 Kč "	
154	"1,185.36 Kč"	770.47 Kč	414.89 Kč	" 198,377.30 Kč "	
155	"1,185.36 Kč"	772.08 Kč	413.29 Kč	" 197,605.22 Kč "	
156	"1,185.36 Kč"	773.69 Kč	411.68 Kč	" 196,831.54 Kč "	
157	"1,185.36 Kč"	775.30 Kč	410.07 Kč	" 196,056.24 Kč "	
158	"1,185.36 Kč"	776.91 Kč	408.45 Kč	" 195,279.33 Kč "	
159	"1,185.36 Kč"	778.53 Kč	406.83 Kč	" 194,500.80 Kč "	
160	"1,185.36 Kč"	780.15 Kč	405.21 Kč	" 193,720.64 Kč "	
161	"1,185.36 Kč"	781.78 Kč	403.58 Kč	" 192,938.87 Kč "	
162	"1,185.36 Kč"	783.41 Kč	401.96 Kč	" 192,155.46 Kč "	
163	"1,185.36 Kč"	785.04 Kč	400.32 Kč	" 191,370.42 Kč "	
164	"1,185.36 Kč"	786.67 Kč	398.69 Kč	" 190,583.75 Kč "	
165	"1,185.36 Kč"	788.31 Kč	397.05 Kč	" 189,795.43 Kč "	
166	"1,185.36 Kč"	789.96 Kč	395.41 Kč	" 189,005.48 Kč "	
167	"1,185.36 Kč"	791.60 Kč	393.76 Kč	" 188,213.88 Kč "	
168	"1,185.36 Kč"	793.25 Kč	392.11 Kč	" 187,420.63 Kč "	
169	"1,185.36 Kč"	794.90 Kč	390.46 Kč	" 186,625.72 Kč "	
170	"1,185.36 Kč"	796.56 Kč	388.80 Kč	" 185,829.16 Kč "	
171	"1,185.36 Kč"	798.22 Kč	387.14 Kč	" 185,030.95 Kč "	
172	"1,185.36 Kč"	799.88 Kč	385.48 Kč	" 184,231.06 Kč "	
173	"1,185.36 Kč"	801.55 Kč	383.81 Kč	" 183,429.52 Kč "	
174	"1,185.36 Kč"	803.22 Kč	382.14 Kč	" 182,626.30 Kč "	
175	"1,185.36 Kč"	804.89 Kč	380.47 Kč	" 181,821.41 Kč "	
176	"1,185.36 Kč"	806.57 Kč	378.79 Kč	" 181,014.84 Kč "	
177	"1,185.36 Kč"	808.25 Kč	377.11 Kč	" 180,206.59 Kč "	
178	"1,185.36 Kč"	809.93 Kč	375.43 Kč	" 179,396.66 Kč "	
179	"1,185.36 Kč"	811.62 Kč	373.74 Kč	" 178,585.04 Kč "	
180	"1,185.36 Kč"	813.31 Kč	372.05 Kč	" 177,771.73 Kč "	
181	"1,185.36 Kč"	815.00 Kč	370.36 Kč	" 176,956.72 Kč "	
182	"1,185.36 Kč"	816.70 Kč	368.66 Kč	" 176,140.02 Kč "	
183	"1,185.36 Kč"	818.40 Kč	366.96 Kč	" 175,321.62 Kč "	
184	"1,185.36 Kč"	820.11 Kč	365.25 Kč	" 174,501.51 Kč "	
185	"1,185.36 Kč"	821.82 Kč	363.54 Kč	" 173,679.69 Kč "	
186	"1,185.36 Kč"	823.53 Kč	361.83 Kč	" 172,856.16 Kč "	
187	"1,185.36 Kč"	825.25 Kč	360.12 Kč	" 172,030.91 Kč "	
188	"1,185.36 Kč"	826.96 Kč	358.40 Kč	" 171,203.95 Kč "	
189	"1,185.36 Kč"	828.69 Kč	356.67 Kč	" 170,375.26 Kč "	
190	"1,185.36 Kč"	830.41 Kč	354.95 Kč	" 169,544.85 Kč "	
191	"1,185.36 Kč"	832.14 Kč	353.22 Kč	" 168,712.70 Kč "	
192	"1,185.36 Kč"	833.88 Kč	351.48 Kč	" 167,878.82 Kč "	
193	"1,185.36 Kč"	835.62 Kč	349.75 Kč	" 167,043.21 Kč "	
194	"1,185.36 Kč"	837.36 Kč	348.01 Kč	" 166,205.85 Kč "	
195	"1,185.36 Kč"	839.10 Kč	346.26 Kč	" 165,366.75 Kč "	
196	"1,185.36 Kč"	840.85 Kč	344.51 Kč	" 164,525.90 Kč "	
197	"1,185.36 Kč"	842.60 Kč	342.76 Kč	" 163,683.30 Kč "	
198	"1,185.36 Kč"	844.36 Kč	341.01 Kč	" 162,838.95 Kč "	
199	"1,185.36 Kč"	846.11 Kč	339.25 Kč	" 161,992.83 Kč "	
200	"1,185.36 Kč"	847.88 Kč	337.49 Kč	" 161,144.95 Kč "	
201	"1,185.36 Kč"	849.64 Kč	335.72 Kč	" 160,295.31 Kč "	
202	"1,185.36 Kč"	851.41 Kč	333.95 Kč	" 159,443.90 Kč "	
203	"1,185.36 Kč"	853.19 Kč	332.17 Kč	" 158,590.71 Kč "	
204	"1,185.36 Kč"	854.97 Kč	330.40 Kč	" 157,735.74 Kč "	
205	"1,185.36 Kč"	856.75 Kč	328.62 Kč	" 156,879.00 Kč "	
206	"1,185.36 Kč"	858.53 Kč	326.83 Kč	" 156,020.46 Kč "	
207	"1,185.36 Kč"	860.32 Kč	325.04 Kč	" 155,160.14 Kč "	
208	"1,185.36 Kč"	862.11 Kč	323.25 Kč	" 154,298.03 Kč "	
209	"1,185.36 Kč"	863.91 Kč	321.45 Kč	" 153,434.12 Kč "	
210	"1,185.36 Kč"	865.71 Kč	319.65 Kč	" 152,568.42 Kč "	
211	"1,185.36 Kč"	867.51 Kč	317.85 Kč	" 151,700.90 Kč "	
212	"1,185.36 Kč"	869.32 Kč	316.04 Kč	" 150,831.58 Kč "	
213	"1,185.36 Kč"	871.13 Kč	314.23 Kč	" 149,960.45 Kč "	
214	"1,185.36 Kč"	872.95 Kč	312.42 Kč	" 149,087.51 Kč "	
215	"1,185.36 Kč"	874.76 Kč	310.60 Kč	" 148,212.75 Kč "	
216	"1,185.36 Kč"	876.59 Kč	308.78 Kč	" 147,336.16 Kč "	
217	"1,185.36 Kč"	878.41 Kč	306.95 Kč	" 146,457.75 Kč "	
218	"1,185.36 Kč"	880.24 Kč	305.12 Kč	" 145,577.50 Kč "	
219	"1,185.36 Kč"	882.08 Kč	303.29 Kč	" 144,695.43 Kč "	
220	"1,185.36 Kč"	883.91 Kč	301.45 Kč	" 143,811.51 Kč "	
221	"1,185.36 Kč"	885.76 Kč	299.61 Kč	" 142,925.76 Kč "	
222	"1,185.36 Kč"	887.60 Kč	297.76 Kč	" 142,038.16 Kč "	
223	"1,185.36 Kč"	889.45 Kč	295.91 Kč	" 141,148.71 Kč "	
224	"1,185.36 Kč"	891.30 Kč	294.06 Kč	" 140,257.41 Kč "	
225	"1,185.36 Kč"	893.16 Kč	292.20 Kč	" 139,364.25 Kč "	
226	"1,185.36 Kč"	895.02 Kč	290.34 Kč	" 138,469.23 Kč "	
227	"1,185.36 Kč"	896.89 Kč	288.48 Kč	" 137,572.34 Kč "	
228	"1,185.36 Kč"	898.75 Kč	286.61 Kč	" 136,673.59 Kč "	
229	"1,185.36 Kč"	900.63 Kč	284.74 Kč	" 135,772.96 Kč "	
230	"1,185.36 Kč"	902.50 Kč	282.86 Kč	" 134,870.46 Kč "	
231	"1,185.36 Kč"	904.38 Kč	280.98 Kč	" 133,966.08 Kč "	
232	"1,185.36 Kč"	906.27 Kč	279.10 Kč	" 133,059.81 Kč "	
233	"1,185.36 Kč"	908.15 Kč	277.21 Kč	" 132,151.65 Kč "	
234	"1,185.36 Kč"	910.05 Kč	275.32 Kč	" 131,241.61 Kč "	
235	"1,185.36 Kč"	911.94 Kč	273.42 Kč	" 130,329.66 Kč "	
236	"1,185.36 Kč"	913.84 Kč	271.52 Kč	" 129,415.82 Kč "	
237	"1,185.36 Kč"	915.75 Kč	269.62 Kč	" 128,500.08 Kč "	
238	"1,185.36 Kč"	917.65 Kč	267.71 Kč	" 127,582.42 Kč "	
239	"1,185.36 Kč"	919.57 Kč	265.80 Kč	" 126,662.86 Kč "	
240	"1,185.36 Kč"	921.48 Kč	263.88 Kč	" 125,741.37 Kč "	
241	"1,185.36 Kč"	923.40 Kč	261.96 Kč	" 124,817.97 Kč "	
242	"1,185.36 Kč"	925.33 Kč	260.04 Kč	" 123,892.65 Kč "	
243	"1,185.36 Kč"	927.25 Kč	258.11 Kč	" 122,965.39 Kč "	
244	"1,185.36 Kč"	929.18 Kč	256.18 Kč	" 122,036.21 Kč "	
245	"1,185.36 Kč"	931.12 Kč	254.24 Kč	" 121,105.09 Kč "	
246	"1,185.36 Kč"	933.06 Kč	252.30 Kč	" 120,172.03 Kč "	
247	"1,185.36 Kč"	935.00 Kč	250.36 Kč	" 119,237.02 Kč "	
248	"1,185.36 Kč"	936.95 Kč	248.41 Kč	" 118,300.07 Kč "	
249	"1,185.36 Kč"	938.90 Kč	246.46 Kč	" 117,361.17 Kč "	
250	"1,185.36 Kč"	940.86 Kč	244.50 Kč	" 116,420.31 Kč "	
251	"1,185.36 Kč"	942.82 Kč	242.54 Kč	" 115,477.49 Kč "	
252	"1,185.36 Kč"	944.78 Kč	240.58 Kč	" 114,532.70 Kč "	
253	"1,185.36 Kč"	946.75 Kč	238.61 Kč	" 113,585.95 Kč "	
254	"1,185.36 Kč"	948.73 Kč	236.64 Kč	" 112,637.22 Kč "	
255	"1,185.36 Kč"	950.70 Kč	234.66 Kč	" 111,686.52 Kč "	
256	"1,185.36 Kč"	952.68 Kč	232.68 Kč	" 110,733.84 Kč "	
257	"1,185.36 Kč"	954.67 Kč	230.70 Kč	" 109,779.17 Kč "	
258	"1,185.36 Kč"	956.66 Kč	228.71 Kč	" 108,822.52 Kč "	
259	"1,185.36 Kč"	958.65 Kč	226.71 Kč	" 107,863.87 Kč "	
260	"1,185.36 Kč"	960.65 Kč	224.72 Kč	" 106,903.22 Kč "	
261	"1,185.36 Kč"	962.65 Kč	222.72 Kč	" 105,940.57 Kč "	
262	"1,185.36 Kč"	964.65 Kč	220.71 Kč	" 104,975.92 Kč "	
263	"1,185.36 Kč"	966.66 Kč	218.70 Kč	" 104,009.26 Kč "	
264	"1,185.36 Kč"	968.68 Kč	216.69 Kč	" 103,040.58 Kč "	
265	"1,185.36 Kč"	970.69 Kč	214.67 Kč	" 102,069.89 Kč "	
266	"1,185.36 Kč"	972.72 Kč	212.65 Kč	" 101,097.17 Kč "	
267	"1,185.36 Kč"	974.74 Kč	210.62 Kč	" 100,122.43 Kč "	
268	"1,185.36 Kč"	976.77 Kč	208.59 Kč	" 99,145.65 Kč "	
269	"1,185.36 Kč"	978.81 Kč	206.55 Kč	" 98,166.84 Kč "	
270	"1,185.36 Kč"	980.85 Kč	204.51 Kč	" 97,185.99 Kč "	
271	"1,185.36 Kč"	982.89 Kč	202.47 Kč	" 96,203.10 Kč "	
272	"1,185.36 Kč"	984.94 Kč	200.42 Kč	" 95,218.16 Kč "	
273	"1,185.36 Kč"	986.99 Kč	198.37 Kč	" 94,231.17 Kč "	
274	"1,185.36 Kč"	989.05 Kč	196.31 Kč	" 93,242.12 Kč "	
275	"1,185.36 Kč"	991.11 Kč	194.25 Kč	" 92,251.01 Kč "	
276	"1,185.36 Kč"	993.17 Kč	192.19 Kč	" 91,257.84 Kč "	
277	"1,185.36 Kč"	995.24 Kč	190.12 Kč	" 90,262.60 Kč "	
278	"1,185.36 Kč"	997.32 Kč	188.05 Kč	" 89,265.28 Kč "	
279	"1,185.36 Kč"	999.39 Kč	185.97 Kč	" 88,265.89 Kč "	
280	"1,185.36 Kč"	"1,001.48 Kč"	183.89 Kč	" 87,264.41 Kč "	
281	"1,185.36 Kč"	"1,003.56 Kč"	181.80 Kč	" 86,260.85 Kč "	
282	"1,185.36 Kč"	"1,005.65 Kč"	179.71 Kč	" 85,255.20 Kč "	
283	"1,185.36 Kč"	"1,007.75 Kč"	177.62 Kč	" 84,247.45 Kč "	
284	"1,185.36 Kč"	"1,009.85 Kč"	175.52 Kč	" 83,237.61 Kč "	
285	"1,185.36 Kč"	"1,011.95 Kč"	173.41 Kč	" 82,225.65 Kč "	
286	"1,185.36 Kč"	"1,014.06 Kč"	171.30 Kč	" 81,211.60 Kč "	
287	"1,185.36 Kč"	"1,016.17 Kč"	169.19 Kč	" 80,195.42 Kč "	
288	"1,185.36 Kč"	"1,018.29 Kč"	167.07 Kč	" 79,177.13 Kč "	
289	"1,185.36 Kč"	"1,020.41 Kč"	164.95 Kč	" 78,156.72 Kč "	
290	"1,185.36 Kč"	"1,022.54 Kč"	162.83 Kč	" 77,134.19 Kč "	
291	"1,185.36 Kč"	"1,024.67 Kč"	160.70 Kč	" 76,109.52 Kč "	
292	"1,185.36 Kč"	"1,026.80 Kč"	158.56 Kč	" 75,082.72 Kč "	
293	"1,185.36 Kč"	"1,028.94 Kč"	156.42 Kč	" 74,053.78 Kč "	
294	"1,185.36 Kč"	"1,031.08 Kč"	154.28 Kč	" 73,022.70 Kč "	
295	"1,185.36 Kč"	"1,033.23 Kč"	152.13 Kč	" 71,989.46 Kč "	
296	"1,185.36 Kč"	"1,035.38 Kč"	149.98 Kč	" 70,954.08 Kč "	
297	"1,185.36 Kč"	"1,037.54 Kč"	147.82 Kč	" 69,916.54 Kč "	
298	"1,185.36 Kč"	"1,039.70 Kč"	145.66 Kč	" 68,876.83 Kč "	
299	"1,185.36 Kč"	"1,041.87 Kč"	143.49 Kč	" 67,834.96 Kč "	
300	"1,185.36 Kč"	"1,044.04 Kč"	141.32 Kč	" 66,790.92 Kč "	
301	"1,185.36 Kč"	"1,046.21 Kč"	139.15 Kč	" 65,744.71 Kč "	
302	"1,185.36 Kč"	"1,048.39 Kč"	136.97 Kč	" 64,696.32 Kč "	
303	"1,185.36 Kč"	"1,050.58 Kč"	134.78 Kč	" 63,645.74 Kč "	
304	"1,185.36 Kč"	"1,052.77 Kč"	132.60 Kč	" 62,592.97 Kč "	
305	"1,185.36 Kč"	"1,054.96 Kč"	130.40 Kč	" 61,538.01 Kč "	
306	"1,185.36 Kč"	"1,057.16 Kč"	128.20 Kč	" 60,480.85 Kč "	
307	"1,185.36 Kč"	"1,059.36 Kč"	126.00 Kč	" 59,421.49 Kč "	
308	"1,185.36 Kč"	"1,061.57 Kč"	123.79 Kč	" 58,359.92 Kč "	
309	"1,185.36 Kč"	"1,063.78 Kč"	121.58 Kč	" 57,296.14 Kč "	
310	"1,185.36 Kč"	"1,066.00 Kč"	119.37 Kč	" 56,230.15 Kč "	
311	"1,185.36 Kč"	"1,068.22 Kč"	117.15 Kč	" 55,161.93 Kč "	
312	"1,185.36 Kč"	"1,070.44 Kč"	114.92 Kč	" 54,091.49 Kč "	
313	"1,185.36 Kč"	"1,072.67 Kč"	112.69 Kč	" 53,018.82 Kč "	
314	"1,185.36 Kč"	"1,074.91 Kč"	110.46 Kč	" 51,943.91 Kč "	
315	"1,185.36 Kč"	"1,077.15 Kč"	108.22 Kč	" 50,866.76 Kč "	
316	"1,185.36 Kč"	"1,079.39 Kč"	105.97 Kč	" 49,787.37 Kč "	
317	"1,185.36 Kč"	"1,081.64 Kč"	103.72 Kč	" 48,705.73 Kč "	
318	"1,185.36 Kč"	"1,083.89 Kč"	101.47 Kč	" 47,621.84 Kč "	
319	"1,185.36 Kč"	"1,086.15 Kč"	99.21 Kč	" 46,535.69 Kč "	
320	"1,185.36 Kč"	"1,088.41 Kč"	96.95 Kč	" 45,447.28 Kč "	
321	"1,185.36 Kč"	"1,090.68 Kč"	94.68 Kč	" 44,356.60 Kč "	
322	"1,185.36 Kč"	"1,092.95 Kč"	92.41 Kč	" 43,263.64 Kč "	
323	"1,185.36 Kč"	"1,095.23 Kč"	90.13 Kč	" 42,168.41 Kč "	
324	"1,185.36 Kč"	"1,097.51 Kč"	87.85 Kč	" 41,070.90 Kč "	
325	"1,185.36 Kč"	"1,099.80 Kč"	85.56 Kč	" 39,971.10 Kč "	
326	"1,185.36 Kč"	"1,102.09 Kč"	83.27 Kč	" 38,869.01 Kč "	
327	"1,185.36 Kč"	"1,104.39 Kč"	80.98 Kč	" 37,764.63 Kč "	
328	"1,185.36 Kč"	"1,106.69 Kč"	78.68 Kč	" 36,657.94 Kč "	
329	"1,185.36 Kč"	"1,108.99 Kč"	76.37 Kč	" 35,548.95 Kč "	
330	"1,185.36 Kč"	"1,111.30 Kč"	74.06 Kč	" 34,437.65 Kč "	
331	"1,185.36 Kč"	"1,113.62 Kč"	71.75 Kč	" 33,324.03 Kč "	
332	"1,185.36 Kč"	"1,115.94 Kč"	69.43 Kč	" 32,208.09 Kč "	
333	"1,185.36 Kč"	"1,118.26 Kč"	67.10 Kč	" 31,089.83 Kč "	
334	"1,185.36 Kč"	"1,120.59 Kč"	64.77 Kč	" 29,969.24 Kč "	
335	"1,185.36 Kč"	"1,122.93 Kč"	62.44 Kč	" 28,846.31 Kč "	
336	"1,185.36 Kč"	"1,125.27 Kč"	60.10 Kč	" 27,721.04 Kč "	
337	"1,185.36 Kč"	"1,127.61 Kč"	57.75 Kč	" 26,593.43 Kč "	
338	"1,185.36 Kč"	"1,129.96 Kč"	55.40 Kč	" 25,463.47 Kč "	
339	"1,185.36 Kč"	"1,132.31 Kč"	53.05 Kč	" 24,331.16 Kč "	
340	"1,185.36 Kč"	"1,134.67 Kč"	50.69 Kč	" 23,196.49 Kč "	
341	"1,185.36 Kč"	"1,137.04 Kč"	48.33 Kč	" 22,059.45 Kč "	
342	"1,185.36 Kč"	"1,139.41 Kč"	45.96 Kč	" 20,920.04 Kč "	
343	"1,185.36 Kč"	"1,141.78 Kč"	43.58 Kč	" 19,778.27 Kč "	
344	"1,185.36 Kč"	"1,144.16 Kč"	41.20 Kč	" 18,634.11 Kč "	
345	"1,185.36 Kč"	"1,146.54 Kč"	38.82 Kč	" 17,487.57 Kč "	
346	"1,185.36 Kč"	"1,148.93 Kč"	36.43 Kč	" 16,338.64 Kč "	
347	"1,185.36 Kč"	"1,151.32 Kč"	34.04 Kč	" 15,187.31 Kč "	
348	"1,185.36 Kč"	"1,153.72 Kč"	31.64 Kč	" 14,033.59 Kč "	
349	"1,185.36 Kč"	"1,156.13 Kč"	29.24 Kč	" 12,877.46 Kč "	
350	"1,185.36 Kč"	"1,158.53 Kč"	26.83 Kč	" 11,718.93 Kč "	
351	"1,185.36 Kč"	"1,160.95 Kč"	24.41 Kč	" 10,557.98 Kč "	
352	"1,185.36 Kč"	"1,163.37 Kč"	22.00 Kč	" 9,394.61 Kč "	
353	"1,185.36 Kč"	"1,165.79 Kč"	19.57 Kč	" 8,228.82 Kč "	
354	"1,185.36 Kč"	"1,168.22 Kč"	17.14 Kč	" 7,060.60 Kč "	
355	"1,185.36 Kč"	"1,170.65 Kč"	14.71 Kč	" 5,889.95 Kč "	
356	"1,185.36 Kč"	"1,173.09 Kč"	12.27 Kč	" 4,716.86 Kč "	
357	"1,185.36 Kč"	"1,175.54 Kč"	9.83 Kč	" 3,541.32 Kč "	
358	"1,185.36 Kč"	"1,177.98 Kč"	7.38 Kč	" 2,363.34 Kč "	
359	"1,185.36 Kč"	"1,180.44 Kč"	4.92 Kč	" 1,182.90 Kč "	
360	"1,185.36 Kč"	"1,182.90 Kč"	2.46 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,913,277.43 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	2.50%					
				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,185.36 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,913,277.43 Kč "									
1.7%	" 8,956,825.61 Kč "									
1.8%	" 8,951,533.62 Kč "									
1.9%	" 8,946,198.03 Kč "									
2.0%	" 8,940,818.97 Kč "									
2.1%	" 8,935,396.60 Kč "									
2.2%	" 8,929,931.09 Kč "									
2.3%	" 8,924,422.61 Kč "									
2.4%	" 8,918,871.32 Kč "									
2.5%	" 8,913,277.43 Kč "									
2.6%	" 8,907,641.11 Kč "									
2.7%	" 8,901,962.57 Kč "									
2.8%	" 8,896,242.00 Kč "									
2.9%	" 8,890,479.62 Kč "									
3.0%	" 8,884,675.64 Kč "									
3.1%	" 8,878,830.29 Kč "									
										
										
		výše úrokové míry								
	" 8,913,277.43 Kč "	1.70%	1.80%	1.90%	2.00%	2.10%	2.20%			
Výše hypotéky	" 4,500,000.00 Kč "	" 3,592,272.11 Kč "	" 3,512,892.37 Kč "	" 3,432,858.44 Kč "	" 3,352,172.54 Kč "	" 3,270,837.04 Kč "	" 3,188,854.37 Kč "			
	" 4,700,000.00 Kč "	" 3,336,817.18 Kč "	" 3,253,909.45 Kč "	" 3,170,318.46 Kč "	" 3,086,046.52 Kč "	" 3,001,096.11 Kč "	" 2,915,469.76 Kč "			
	" 4,900,000.00 Kč "	" 3,081,362.25 Kč "	" 2,994,926.54 Kč "	" 2,907,778.47 Kč "	" 2,819,920.50 Kč "	" 2,731,355.17 Kč "	" 2,642,085.16 Kč "			
	" 5,100,000.00 Kč "	" 2,825,907.33 Kč "	" 2,735,943.62 Kč "	" 2,645,238.49 Kč "	" 2,553,794.48 Kč "	" 2,461,614.24 Kč "	" 2,368,700.55 Kč "			
	" 5,300,000.00 Kč "	" 2,570,452.40 Kč "	" 2,476,960.70 Kč "	" 2,382,698.51 Kč "	" 2,287,668.46 Kč "	" 2,191,873.31 Kč "	" 2,095,315.95 Kč "			
	" 5,500,000.00 Kč "	" 2,314,997.47 Kč "	" 2,217,977.79 Kč "	" 2,120,158.53 Kč "	" 2,021,542.44 Kč "	" 1,922,132.38 Kč "	" 1,821,931.34 Kč "			
	" 5,700,000.00 Kč "	" 2,059,542.54 Kč "	" 1,958,994.87 Kč "	" 1,857,618.55 Kč "	" 1,755,416.42 Kč "	" 1,652,391.45 Kč "	" 1,548,546.73 Kč "			
	" 5,900,000.00 Kč "	" 1,804,087.61 Kč "	" 1,700,011.95 Kč "	" 1,595,078.57 Kč "	" 1,489,290.40 Kč "	" 1,382,650.51 Kč "	" 1,275,162.13 Kč "			
	" 6,100,000.00 Kč "	" 1,548,632.68 Kč "	" 1,441,029.04 Kč "	" 1,332,538.59 Kč "	" 1,223,164.38 Kč "	" 1,112,909.58 Kč "	" 1,001,777.52 Kč "			
	" 6,300,000.00 Kč "	" 1,293,177.76 Kč "	" 1,182,046.12 Kč "	" 1,069,998.61 Kč "	" 957,038.36 Kč "	" 843,168.65 Kč "	" 728,392.92 Kč "			
	" 6,500,000.00 Kč "	" 1,037,722.83 Kč "	" 923,063.20 Kč "	" 807,458.63 Kč "	" 690,912.34 Kč "	" 573,427.72 Kč "	" 455,008.31 Kč "			
	" 6,700,000.00 Kč "	" 782,267.90 Kč "	" 664,080.29 Kč "	" 544,918.65 Kč "	" 424,786.32 Kč "	" 303,686.79 Kč "	" 181,623.70 Kč "			
	" 6,900,000.00 Kč "	" 526,812.97 Kč "	" 405,097.37 Kč "	" 282,378.67 Kč "	" 158,660.30 Kč "	" 33,945.86 Kč "	"-91,760.90 Kč "			
	" 7,100,000.00 Kč "	" 271,358.04 Kč "	" 146,114.45 Kč "	" 19,838.69 Kč "	"-107,465.72 Kč "	"-235,795.08 Kč "	"-365,145.51 Kč "			
	" 7,300,000.00 Kč "	" 15,903.11 Kč "	"-112,868.46 Kč "	"-242,701.29 Kč "	"-373,591.74 Kč "	"-505,536.01 Kč "	"-638,530.11 Kč "