anuita 9321.509621 počet sp. Anuita Urok Umor Dluh 0 500000 1 9321.509621 1875 7446.509621 492553.4904 1.00375 91224.35977 27.92441108 1.00375 2 9321.509621 1847.075589 7474.434032 485079.0563 1.00375 91224.35977 28.02912762 1.00375 3 9321.509621 1819.046461 7502.463159 477576.5932 1.00375 28.13423685 1.00375 4 9321.509621 1790.912224 7530.597396 470045.9958 1.00375 28.23974024 1.00375 5 9321.509621 1762.672484 7558.837137 462487.1587 1.00375 28.34563926 1.00375 6 9321.509621 1734.326845 7587.182776 454899.9759 1.00375 28.45193541 1.00375 7 9321.509621 1705.87491 7615.634711 447284.3412 1.00375 28.55863017 1.00375 8 9321.509621 1677.316279 7644.193341 439640.1478 1.00375 28.66572503 1.00375 9 9321.509621 1648.650554 7672.859066 431967.2888 1.00375 28.7732215 1.00375 10 9321.509621 1619.877333 7701.632288 424265.6565 1.00375 28.88112108 1.00375 11 9321.509621 1590.996212 7730.513409 416535.1431 28.98942528 1.00375 12 9321.509621 1562.006786 7759.502834 408775.6402 Umor30 8300.302977 29.09813563 13 9321.509621 1532.908651 7788.60097 400987.0393 14 9321.509621 1503.701397 7817.808224 393169.231 15 9321.509621 1474.384616 7847.125004 385322.106 16 9321.509621 1444.957898 7876.551723 377445.5543 17 9321.509621 1415.420829 7906.088792 369539.4655 18 9321.509621 1385.772996 7935.736625 361603.7289 19 9321.509621 1356.013983 7965.495637 353638.2333 20 9321.509621 1326.143375 7995.366246 345642.867 21 9321.509621 1296.160751 8025.348869 337617.5181 22 9321.509621 1266.065693 8055.443928 329562.0742 23 9321.509621 1235.857778 8085.651842 321476.4224 24 9321.509621 1205.536584 8115.973037 313360.4493 25 9321.509621 1175.101685 8146.407936 305214.0414 26 9321.509621 1144.552655 8176.956966 297037.0844 27 9321.509621 1113.889067 8207.620554 288829.4639 28 9321.509621 1083.11049 8238.399131 280591.0647 29 9321.509621 1052.216493 8269.293128 272321.7716 30 9321.509621 1021.206644 8300.302977 264021.4686 31 9321.509621 990.0805074 8331.429113 255690.0395 32 9321.509621 958.8376482 8362.671973 247327.3676 33 9321.509621 927.4776283 8394.031992 238933.3356 34 9321.509621 896.0000084 8425.509612 230507.8259 35 9321.509621 864.4043473 8457.105273 222050.7207 36 9321.509621 832.6902025 8488.819418 213561.9013 37 9321.509621 800.8571297 8520.652491 205041.2488 38 9321.509621 768.9046829 8552.604938 196488.6438 39 9321.509621 736.8324144 8584.677206 187903.9666 40 9321.509621 704.6398748 8616.869746 179287.0969 41 9321.509621 672.3266133 8649.183007 170637.9139 42 9321.509621 639.892177 8681.617444 161956.2964 43 9321.509621 607.3361116 8714.173509 153242.1229 44 9321.509621 574.6579609 8746.85166 144495.2713 45 9321.509621 541.8572672 8779.652354 135715.6189 46 9321.509621 508.9335709 8812.57605 126903.0429 47 9321.509621 475.8864107 8845.62321 118057.4196 48 9321.509621 442.7153237 8878.794297 109178.6253 49 9321.509621 409.419845 8912.089776 100266.5356 50 9321.509621 375.9995084 8945.510112 91321.02546 51 9321.509621 342.4538455 8979.055775 82341.96968 52 9321.509621 308.7823863 9012.727234 73329.24245 53 9321.509621 274.9846592 9046.524962 64282.71749 54 9321.509621 241.0601906 9080.44943 55202.26806 55 9321.509621 207.0085052 9114.501116 46087.76694 56 9321.509621 172.829126 9148.680495 36939.08644 57 9321.509621 138.5215742 9182.988047 27756.0984 58 9321.509621 104.085369 9217.424252 18538.67415 59 9321.509621 69.52002805 9251.989593 9286.684554 60 9321.509621 34.82506708 9286.684554 0.00 59290.57725 ##### Sheet/List 2 ##### anuita 9321.509621 -211.7867789 0.996260521 -2360.865029 0.201315537 53.63386139 0.003739479 9322.468811 počet sp. Anuita Urok Umor Dluh 0 500000 1 9322.468811 1876.757813 7445.710998 492554.289 1.003753516 91216.34755 2 9322.468811 1848.81022 7473.658591 485080.6304 1.003753516 91216.34755 3 9322.468811 1820.757726 7501.711085 477578.9193 1.003753516 4 9322.468811 1792.599936 7529.868875 470049.0505 1.003753516 5 9322.468811 1764.336455 7558.132355 462490.9181 1.003753516 6 9322.468811 1735.966887 7586.501923 454904.4162 1.003753516 7 9322.468811 1707.490834 7614.977977 447289.4382 1.003753516 8 9322.468811 1678.907895 7643.560916 439645.8773 1.003753516 9 9322.468811 1650.21767 7672.251141 431973.6261 1.003753516 10 9322.468811 1621.419755 7701.049055 424272.5771 1.003753516 11 9322.468811 1592.513747 7729.955063 416542.622 12 9322.468811 1563.49924 7758.96957 408783.6525 Umor30 8301.157084 13 9322.468811 1534.375827 7788.092984 400995.5595 14 9322.468811 1505.143098 7817.325713 393178.2338 15 9322.468811 1475.800644 7846.668167 385331.5656 16 9322.468811 1446.348052 7876.120758 377455.4448 17 9322.468811 1416.78491 7905.683901 369549.7609 18 9322.468811 1387.110802 7935.358009 361614.4029 19 9322.468811 1357.325312 7965.143499 353649.2594 20 9322.468811 1327.428021 7995.04079 345654.2186 21 9322.468811 1297.41851 8025.0503 337629.1683 22 9322.468811 1267.296359 8055.172452 329573.9959 23 9322.468811 1237.061143 8085.407668 321488.5882 24 9322.468811 1206.712439 8115.756372 313372.8318 25 9322.468811 1176.249821 8146.21899 305226.6128 26 9322.468811 1145.67286 8176.79595 297049.8169 27 9322.468811 1114.981129 8207.487682 288842.3292 28 9322.468811 1084.174196 8238.294615 280604.0346 29 9322.468811 1053.251628 8269.217182 272334.8174 30 9322.468811 1022.212992 8300.255818 264034.5616 31 9322.468811 991.0578525 8331.410958 255703.1506 32 9322.468811 959.7857713 8362.683039 247340.4676 33 9322.468811 928.3963098 8394.072501 238946.3951 34 9322.468811 896.8890276 8425.579783 230520.8153 35 9322.468811 865.2634822 8457.205328 222063.61 36 9322.468811 833.5192298 8488.949581 213574.6604 37 9322.468811 801.655825 8520.812986 205053.8474 38 9322.468811 769.6728203 8552.79599 196501.0514 39 9322.468811 737.5697669 8584.899044 187916.1524 40 9322.468811 705.3462142 8617.122596 179299.0298 41 9322.468811 673.0017099 8649.467101 170649.5627 42 9322.468811 640.5358 8681.933011 161967.6297 43 9322.468811 607.9480288 8714.520782 153253.1089 44 9322.468811 575.2379388 8747.230872 144505.878 45 9322.468811 542.4050711 8780.06374 135725.8143 46 9322.468811 509.4489647 8813.019846 126912.7944 47 9322.468811 476.369157 8846.099654 118066.6948 48 9322.468811 443.1651837 8879.303627 109187.3912 49 9322.468811 409.8365788 8912.632232 100274.7589 50 9322.468811 376.3828744 8946.085936 91328.67299 51 9322.468811 342.8036011 8979.66521 82349.00779 52 9322.468811 309.0982874 9013.370523 73335.63726 53 9322.468811 275.2664603 9047.20235 64288.43491 54 9322.468811 241.3076449 9081.161166 55207.27375 55 9322.468811 207.2213646 9115.247446 46092.0263 56 9322.468811 173.0071409 9149.46167 36942.56463 57 9322.468811 138.6644936 9183.804317 27758.76031 58 9322.468811 104.1929406 9218.27587 18540.48444 59 9322.468811 69.59199805 9252.876813 9287.60763 60 9322.468811 34.86118036 9287.60763 0.00 59348.12864 ##### Sheet/List 3 ##### počet sp. Anuita Urok Umor Dluh 8333.333333 0 500000 1 10208.33333 1875 8333.333333 491666.6667 1 #DIV/0! -31.25 2 10177.08333 1843.75 8333.333333 483333.3333 1 100000 -31.25 3 10145.83333 1812.5 8333.333333 475000 1 -31.25 4 10114.58333 1781.25 8333.333333 466666.6667 1 -31.25 5 10083.33333 1750 8333.333333 458333.3333 1 -31.25 6 10052.08333 1718.75 8333.333333 450000 1 -31.25 7 10020.83333 1687.5 8333.333333 441666.6667 1 -31.25 8 9989.583333 1656.25 8333.333333 433333.3333 1 -31.25 9 9958.333333 1625 8333.333333 425000 1 -31.25 10 9927.083333 1593.75 8333.333333 416666.6667 1 -31.25 11 9895.833333 1562.5 8333.333333 408333.3333 -31.25 12 9864.583333 1531.25 8333.333333 400000 Umor30 8783.88091 -31.25 13 9833.333333 1500 8333.333333 391666.6667 -31.25 14 9802.083333 1468.75 8333.333333 383333.3333 15 9770.833333 1437.5 8333.333333 375000 16 9739.583333 1406.25 8333.333333 366666.6667 17 9708.333333 1375 8333.333333 358333.3333 18 9677.083333 1343.75 8333.333333 350000 19 9645.833333 1312.5 8333.333333 341666.6667 20 9614.583333 1281.25 8333.333333 333333.3333 21 9583.333333 1250 8333.333333 325000 22 9552.083333 1218.75 8333.333333 316666.6667 23 9520.833333 1187.5 8333.333333 308333.3333 24 9489.583333 1156.25 8333.333333 300000 25 9458.333333 1125 8333.333333 291666.6667 26 9427.083333 1093.75 8333.333333 283333.3333 27 9395.833333 1062.5 8333.333333 275000 28 9364.583333 1031.25 8333.333333 266666.6667 29 9333.333333 1000 8333.333333 258333.3333 30 9302.083333 968.75 8333.333333 250000 31 9270.833333 937.5 8333.333333 241666.6667 32 9239.583333 906.25 8333.333333 233333.3333 33 9208.333333 875 8333.333333 225000 34 9177.083333 843.75 8333.333333 216666.6667 35 9145.833333 812.5 8333.333333 208333.3333 36 9114.583333 781.25 8333.333333 200000 37 9083.333333 750 8333.333333 191666.6667 38 9052.083333 718.75 8333.333333 183333.3333 39 9020.833333 687.5 8333.333333 175000 40 8989.583333 656.25 8333.333333 166666.6667 41 8958.333333 625 8333.333333 158333.3333 42 8927.083333 593.75 8333.333333 150000 43 8895.833333 562.5 8333.333333 141666.6667 44 8864.583333 531.25 8333.333333 133333.3333 45 8833.333333 500 8333.333333 125000 46 8802.083333 468.75 8333.333333 116666.6667 47 8770.833333 437.5 8333.333333 108333.3333 48 8739.583333 406.25 8333.333333 100000 49 8708.333333 375 8333.333333 91666.66667 50 8677.083333 343.75 8333.333333 83333.33333 51 8645.833333 312.5 8333.333333 75000 52 8614.583333 281.25 8333.333333 66666.66667 53 8583.333333 250 8333.333333 58333.33333 54 8552.083333 218.75 8333.333333 50000 55 8520.833333 187.5 8333.333333 41666.66667 56 8489.583333 156.25 8333.333333 33333.33333 57 8458.333333 125 8333.333333 25000 58 8427.083333 93.75 8333.333333 16666.66667 59 8395.833333 62.5 8333.333333 8333.333333 60 8364.583333 31.25 8333.333333 0.00 57187.5