4000000 12 a=D*i/(1-v^n) 0.1 Měsíc Anuita Úrok Úmor Stav dluhu 0 4000000 1 36348.02982 33333.33333 3014.696488 3996985.304 UMOR ZA 12 SPLÁTEK: "37,881.37" 2 36348.02982 33308.21086 3039.818959 3993945.485 3 36348.02982 33282.87904 3065.150784 3990880.334 4 36348.02982 33257.33611 3090.693707 3987789.64 5 36348.02982 33231.58033 3116.449488 3984673.191 6 36348.02982 33205.60992 3142.4199 3981530.771 7 36348.02982 33179.42309 3168.606733 3978362.164 8 36348.02982 33153.01803 3195.011789 3975167.152 9 36348.02982 33126.39293 3221.636887 3971945.515 10 36348.02982 33099.54596 3248.483861 3968697.031 11 36348.02982 33072.47526 3275.55456 3965421.477 12 36348.02982 33045.17897 3302.850848 3962118.626 13 36348.02982 33017.65522 3330.374605 3958788.251 14 36348.02982 32989.90209 3358.127727 3955430.124 15 36348.02982 32961.9177 3386.112124 3952044.012 16 36348.02982 32933.7001 3414.329725 3948629.682 17 36348.02982 32905.24735 3442.782473 3945186.899 18 36348.02982 32876.55749 3471.472327 3941715.427 19 36348.02982 32847.62856 3500.401263 3938215.026 20 36348.02982 32818.45855 3529.571274 3934685.454 21 36348.02982 32789.04545 3558.984368 3931126.47 22 36348.02982 32759.38725 3588.642571 3927537.828 23 36348.02982 32729.4819 3618.547925 3923919.28 24 36348.02982 32699.32733 3648.702491 3920270.577 25 36348.02982 32668.92148 3679.108346 3916591.469 26 36348.02982 32638.26224 3709.767582 3912881.701 27 36348.02982 32607.34751 3740.682312 3909141.019 28 36348.02982 32576.17516 3771.854664 3905369.164 29 36348.02982 32544.74304 3803.286786 3901565.877 30 36348.02982 32513.04898 3834.980843 3897730.897 31 36348.02982 32481.0908 3866.939017 3893863.958 32 36348.02982 32448.86631 3899.163508 3889964.794 33 36348.02982 32416.37328 3931.656538 3886033.138 34 36348.02982 32383.60948 3964.420342 3882068.717 35 36348.02982 32350.57264 3997.457178 3878071.26 36 36348.02982 32317.2605 4030.769322 3874040.491 37 36348.02982 32283.67076 4064.359066 3869976.132 38 36348.02982 32249.8011 4098.228725 3865877.903 39 36348.02982 32215.64919 4132.380631 3861745.522 40 36348.02982 32181.21269 4166.817136 3857578.705 41 36348.02982 32146.48921 4201.540612 3853377.165 42 36348.02982 32111.47637 4236.553451 3849140.611 43 36348.02982 32076.17176 4271.858063 3844868.753 44 36348.02982 32040.57294 4307.45688 3840561.296 45 36348.02982 32004.67747 4343.352354 3836217.944 46 36348.02982 31968.48286 4379.546957 3831838.397 47 36348.02982 31931.98664 4416.043182 3827422.354 48 36348.02982 31895.18628 4452.843541 3822969.51 49 36348.02982 31858.07925 4489.950571 3818479.56 50 36348.02982 31820.663 4527.366826 3813952.193 51 36348.02982 31782.93494 4565.094882 3809387.098 52 36348.02982 31744.89248 4603.13734 3804783.96 53 36348.02982 31706.533 4641.496818 3800142.464 54 36348.02982 31667.85386 4680.175958 3795462.288 55 36348.02982 31628.8524 4719.177424 3790743.11 56 36348.02982 31589.52592 4758.503903 3785984.606 57 36348.02982 31549.87172 4798.158102 3781186.448 58 36348.02982 31509.88707 4838.142753 3776348.306 59 36348.02982 31469.56921 4878.460609 3771469.845 60 36348.02982 31428.91537 4919.114447 3766550.73 61 36348.02982 31387.92275 4960.107068 3761590.623 62 36348.02982 31346.58853 5001.441293 3756589.182 63 36348.02982 31304.90985 5043.119971 3751546.062 64 36348.02982 31262.88385 5085.145971 3746460.916 65 36348.02982 31220.50763 5127.522187 3741333.394 66 36348.02982 31177.77828 5170.251539 3736163.142 67 36348.02982 31134.69285 5213.336968 3730949.805 68 36348.02982 31091.24838 5256.781443 3725693.024 69 36348.02982 31047.44187 5300.587955 3720392.436 70 36348.02982 31003.2703 5344.759521 3715047.677 71 36348.02982 30958.73064 5389.299184 3709658.377 72 36348.02982 30913.81981 5434.21001 3704224.167 73 36348.02982 30868.53473 5479.495094 3698744.672 74 36348.02982 30822.87227 5525.157553 3693219.515 75 36348.02982 30776.82929 5571.200532 3687648.314 76 36348.02982 30730.40262 5617.627204 3682030.687 77 36348.02982 30683.58906 5664.440764 3676366.246 78 36348.02982 30636.38539 5711.644437 3670654.602 79 36348.02982 30588.78835 5759.241474 3664895.36 80 36348.02982 30540.79467 5807.235153 3659088.125 81 36348.02982 30492.40104 5855.628779 3653232.496 82 36348.02982 30443.60414 5904.425685 3647328.071 83 36348.02982 30394.40059 5953.629233 3641374.441 84 36348.02982 30344.78701 6003.24281 3635371.199 85 36348.02982 30294.75999 6053.269833 3629317.929 86 36348.02982 30244.31607 6103.713748 3623214.215 87 36348.02982 30193.45179 6154.57803 3617059.637 88 36348.02982 30142.16364 6205.86618 3610853.771 89 36348.02982 30090.44809 6257.581731 3604596.189 90 36348.02982 30038.30158 6309.728246 3598286.461 91 36348.02982 29985.72051 6362.309314 3591924.152 92 36348.02982 29932.70126 6415.328559 3585508.823 93 36348.02982 29879.24019 6468.78963 3579040.033 94 36348.02982 29825.33361 6522.69621 3572517.337 95 36348.02982 29770.97781 6577.052012 3565940.285 96 36348.02982 29716.16904 6631.860779 3559308.424 97 36348.02982 29660.90354 6687.126285 3552621.298 98 36348.02982 29605.17748 6742.852338 3545878.446 99 36348.02982 29548.98705 6799.042774 3539079.403 100 36348.02982 29492.32836 6855.701464 3532223.702 101 36348.02982 29435.19751 6912.832309 3525310.869 102 36348.02982 29377.59058 6970.439245 3518340.43 103 36348.02982 29319.50358 7028.526239 3511311.904 104 36348.02982 29260.93253 7087.097291 3504224.806 105 36348.02982 29201.87339 7146.156435 3497078.65 106 36348.02982 29142.32208 7205.707738 3489872.942 107 36348.02982 29082.27452 7265.755303 3482607.187 108 36348.02982 29021.72656 7326.303264 3475280.884 109 36348.02982 28960.67403 7387.355791 3467893.528 110 36348.02982 28899.11273 7448.917089 3460444.611 111 36348.02982 28837.03842 7510.991398 3452933.619 112 36348.02982 28774.44683 7573.582993 3445360.036 113 36348.02982 28711.33364 7636.696185 3437723.34 114 36348.02982 28647.6945 7700.33532 3430023.005 115 36348.02982 28583.52504 7764.504781 3422258.5 116 36348.02982 28518.82083 7829.208987 3414429.291 117 36348.02982 28453.57743 7894.452395 3406534.839 118 36348.02982 28387.79032 7960.239499 3398574.599 119 36348.02982 28321.45499 8026.574828 3390548.024 120 36348.02982 28254.56687 8093.462952 3382454.561 121 36348.02982 28187.12135 8160.908476 3374293.653 122 36348.02982 28119.11377 8228.916047 3366064.737 123 36348.02982 28050.53947 8297.490347 3357767.247 124 36348.02982 27981.39372 8366.6361 3349400.61 125 36348.02982 27911.67175 8436.358068 3340964.252 126 36348.02982 27841.36877 8506.661051 3332457.591 127 36348.02982 27770.47993 8577.549894 3323880.041 128 36348.02982 27699.00035 8649.029476 3315231.012 129 36348.02982 27626.9251 8721.104722 3306509.907 130 36348.02982 27554.24923 8793.780594 3297716.127 131 36348.02982 27480.96772 8867.062099 3288849.065 132 36348.02982 27407.07554 8940.954283 3279908.11 133 36348.02982 27332.56759 9015.462236 3270892.648 134 36348.02982 27257.43873 9090.591088 3261802.057 135 36348.02982 27181.68381 9166.346013 3252635.711 136 36348.02982 27105.29759 9242.73223 3243392.979 137 36348.02982 27028.27482 9319.754999 3234073.224 138 36348.02982 26950.6102 9397.419624 3224675.804 139 36348.02982 26872.29837 9475.731454 3215200.073 140 36348.02982 26793.33394 9554.695883 3205645.377 141 36348.02982 26713.71147 9634.318348 3196011.058 142 36348.02982 26633.42549 9714.604335 3186296.454 143 36348.02982 26552.47045 9795.559371 3176500.895 144 36348.02982 26470.84079 9877.189032 3166623.706 145 36348.02982 26388.53088 9959.498941 3156664.207 146 36348.02982 26305.53506 10042.49477 3146621.712 147 36348.02982 26221.8476 10126.18222 3136495.53 148 36348.02982 26137.46275 10210.56707 3126284.963 149 36348.02982 26052.37469 10295.65513 3115989.308 150 36348.02982 25966.57756 10381.45226 3105607.855 151 36348.02982 25880.06546 10467.96436 3095139.891 152 36348.02982 25792.83242 10555.1974 3084584.694 153 36348.02982 25704.87245 10643.15738 3073941.536 154 36348.02982 25616.17947 10731.85035 3063209.686 155 36348.02982 25526.74738 10821.28244 3052388.403 156 36348.02982 25436.57003 10911.45979 3041476.944 157 36348.02982 25345.6412 11002.38863 3030474.555 158 36348.02982 25253.95462 11094.0752 3019380.48 159 36348.02982 25161.504 11186.52582 3008193.954 160 36348.02982 25068.28295 11279.74687 2996914.207 161 36348.02982 24974.28506 11373.74476 2985540.462 162 36348.02982 24879.50385 11468.52597 2974071.936 163 36348.02982 24783.9328 11564.09702 2962507.839 164 36348.02982 24687.56533 11660.46449 2950847.375 165 36348.02982 24590.39479 11757.63503 2939089.74 166 36348.02982 24492.4145 11855.61532 2927234.124 167 36348.02982 24393.6177 11954.41212 2915279.712 168 36348.02982 24293.9976 12054.03222 2903225.68 169 36348.02982 24193.54733 12154.48249 2891071.198 170 36348.02982 24092.25998 12255.76984 2878815.428 171 36348.02982 23990.12856 12357.90126 2866457.527 172 36348.02982 23887.14605 12460.88377 2853996.643 173 36348.02982 23783.30536 12564.72447 2841431.918 174 36348.02982 23678.59932 12669.4305 2828762.488 175 36348.02982 23573.02073 12775.00909 2815987.479 176 36348.02982 23466.56232 12881.4675 2803106.011 177 36348.02982 23359.21676 12988.81306 2790117.198 178 36348.02982 23250.97665 13097.05317 2777020.145 179 36348.02982 23141.83454 13206.19528 2763813.95 180 36348.02982 23031.78291 13316.24691 2750497.703 181 36348.02982 22920.81419 13427.21563 2737070.487 182 36348.02982 22808.92073 13539.1091 2723531.378 183 36348.02982 22696.09482 13651.935 2709879.443 184 36348.02982 22582.32869 13765.70113 2696113.742 185 36348.02982 22467.61452 13880.41531 2682233.327 186 36348.02982 22351.94439 13996.08543 2668237.241 187 36348.02982 22235.31034 14112.71948 2654124.522 188 36348.02982 22117.70435 14230.32547 2639894.196 189 36348.02982 21999.1183 14348.91152 2625545.285 190 36348.02982 21879.54404 14468.48578 2611076.799 191 36348.02982 21758.97332 14589.0565 2596487.742 192 36348.02982 21637.39785 14710.63197 2581777.11 193 36348.02982 21514.80925 14833.22057 2566943.89 194 36348.02982 21391.19908 14956.83074 2551987.059 195 36348.02982 21266.55883 15081.471 2536905.588 196 36348.02982 21140.8799 15207.14992 2521698.438 197 36348.02982 21014.15365 15333.87617 2506364.562 198 36348.02982 20886.37135 15461.65847 2490902.904 199 36348.02982 20757.5242 15590.50562 2475312.398 200 36348.02982 20627.60332 15720.42651 2459591.971 201 36348.02982 20496.59976 15851.43006 2443740.541 202 36348.02982 20364.50451 15983.52531 2427757.016 203 36348.02982 20231.30847 16116.72135 2411640.295 204 36348.02982 20097.00246 16251.02737 2395389.267 205 36348.02982 19961.57723 16386.45259 2379002.815 206 36348.02982 19825.02346 16523.00636 2362479.808 207 36348.02982 19687.33174 16660.69808 2345819.11 208 36348.02982 19548.49259 16799.53724 2329019.573 209 36348.02982 19408.49644 16939.53338 2312080.04 210 36348.02982 19267.33366 17080.69616 2294999.344 211 36348.02982 19124.99453 17223.03529 2277776.308 212 36348.02982 18981.46924 17366.56059 2260409.748 213 36348.02982 18836.7479 17511.28192 2242898.466 214 36348.02982 18690.82055 17657.20927 2225241.257 215 36348.02982 18543.67714 17804.35268 2207436.904 216 36348.02982 18395.30753 17952.72229 2189484.182 217 36348.02982 18245.70151 18102.32831 2171381.853 218 36348.02982 18094.84878 18253.18104 2153128.672 219 36348.02982 17942.73893 18405.29089 2134723.381 220 36348.02982 17789.36151 18558.66831 2116164.713 221 36348.02982 17634.70594 18713.32388 2097451.389 222 36348.02982 17478.76158 18869.26825 2078582.121 223 36348.02982 17321.51767 19026.51215 2059555.609 224 36348.02982 17162.96341 19185.06642 2040370.542 225 36348.02982 17003.08785 19344.94197 2021025.6 226 36348.02982 16841.88 19506.14982 2001519.451 227 36348.02982 16679.32875 19668.70107 1981850.749 228 36348.02982 16515.42291 19832.60691 1962018.143 229 36348.02982 16350.15119 19997.87863 1942020.264 230 36348.02982 16183.5022 20164.52762 1921855.736 231 36348.02982 16015.46447 20332.56535 1901523.171 232 36348.02982 15846.02642 20502.0034 1881021.168 233 36348.02982 15675.1764 20672.85343 1860348.314 234 36348.02982 15502.90262 20845.1272 1839503.187 235 36348.02982 15329.19322 21018.8366 1818484.35 236 36348.02982 15154.03625 21193.99357 1797290.357 237 36348.02982 14977.41964 21370.61018 1775919.747 238 36348.02982 14799.33122 21548.6986 1754371.048 239 36348.02982 14619.75873 21728.27109 1732642.777 240 36348.02982 14438.68981 21909.34001 1710733.437 241 36348.02982 14256.11197 22091.91785 1688641.519 242 36348.02982 14072.01266 22276.01716 1666365.502 243 36348.02982 13886.37918 22461.65064 1643903.851 244 36348.02982 13699.19876 22648.83106 1621255.02 245 36348.02982 13510.4585 22837.57132 1598417.449 246 36348.02982 13320.14541 23027.88441 1575389.564 247 36348.02982 13128.24637 23219.78345 1552169.781 248 36348.02982 12934.74817 23413.28165 1528756.499 249 36348.02982 12739.63749 23608.39233 1505148.107 250 36348.02982 12542.90089 23805.12893 1481342.978 251 36348.02982 12344.52482 24003.505 1457339.473 252 36348.02982 12144.49561 24203.53421 1433135.939 253 36348.02982 11942.79949 24405.23033 1408730.708 254 36348.02982 11739.42257 24608.60725 1384122.101 255 36348.02982 11534.35084 24813.67898 1359308.422 256 36348.02982 11327.57019 25020.45964 1334287.963 257 36348.02982 11119.06636 25228.96347 1309058.999 258 36348.02982 10908.82499 25439.20483 1283619.794 259 36348.02982 10696.83162 25651.1982 1257968.596 260 36348.02982 10483.07163 25864.95819 1232103.638 261 36348.02982 10267.53032 26080.49951 1206023.138 262 36348.02982 10050.19282 26297.837 1179725.301 263 36348.02982 9831.044179 26516.98564 1153208.316 264 36348.02982 9610.069298 26737.96052 1126470.355 265 36348.02982 9387.252961 26960.77686 1099509.578 266 36348.02982 9162.57982 27185.45 1072324.128 267 36348.02982 8936.034403 27411.99542 1044912.133 268 36348.02982 8707.601108 27640.42871 1017271.704 269 36348.02982 8477.264202 27870.76562 989400.9386 270 36348.02982 8245.007822 28103.022 961297.9167 271 36348.02982 8010.815972 28337.21385 932960.7028 272 36348.02982 7774.672523 28573.3573 904387.3455 273 36348.02982 7536.561213 28811.46861 875575.8769 274 36348.02982 7296.465641 29051.56418 846524.3127 275 36348.02982 7054.369273 29293.66055 817230.6522 276 36348.02982 6810.255435 29537.77439 787692.8778 277 36348.02982 6564.107315 29783.92251 757908.9553 278 36348.02982 6315.907961 30032.12186 727876.8334 279 36348.02982 6065.640278 30282.38954 697594.4439 280 36348.02982 5813.287032 30534.74279 667059.7011 281 36348.02982 5558.830842 30789.19898 636270.5021 282 36348.02982 5302.254184 31045.77564 605224.7265 283 36348.02982 5043.539387 31304.49043 573920.236 284 36348.02982 4782.668634 31565.36119 542354.8748 285 36348.02982 4519.623957 31828.40586 510526.469 286 36348.02982 4254.387241 32093.64258 478432.8264 287 36348.02982 3986.94022 32361.0896 446071.7368 288 36348.02982 3717.264473 32630.76535 413440.9714 289 36348.02982 3445.341429 32902.68839 380538.283 290 36348.02982 3171.152359 33176.87746 347361.4056 291 36348.02982 2894.67838 33453.35144 313908.0541 292 36348.02982 2615.900451 33732.12937 280175.9248 293 36348.02982 2334.799373 34013.23045 246162.6943 294 36348.02982 2051.355786 34296.67404 211866.0203 295 36348.02982 1765.550169 34582.47965 177283.5406 296 36348.02982 1477.362839 34870.66698 142412.8737 297 36348.02982 1186.773947 35161.25587 107251.6178 298 36348.02982 893.7634815 35454.26634 71797.35144 299 36348.02982 598.311262 35749.71856 36047.63288 300 36348.02982 300.3969407 36047.63288 0.00 ##### Sheet/List 2 ##### 560000 25 60000 12 500000 0.1 Měsíc Anuita Úrok Úmor Stav dluhu 0 500000 1 4543.503728 4166.666667 376.837061 499623.1629 UMOR ZA 6 MESICU: "2,308.65" 2 4543.503728 4163.526358 379.9773699 499243.1856 NA UROCICH ZAPLACENO: "24,952.37" 3 4543.503728 4160.35988 383.143848 498860.0417 4 4543.503728 4157.167014 386.3367134 498473.705 5 4543.503728 4153.947542 389.556186 498084.1488 6 4543.503728 4150.70124 392.8024875 497691.3463 7 4543.503728 4147.427886 396.0758416 497295.2705 8 4543.503728 4144.127254 399.3764736 496895.894 9 4543.503728 4140.799117 402.7046109 496493.1894 10 4543.503728 4137.443245 406.0604826 496087.1289 11 4543.503728 4134.059408 409.44432 495677.6846 12 4543.503728 4130.647372 412.856356 495264.8282 13 4543.503728 4127.206902 416.2968256 494848.5314 14 4543.503728 4123.737762 419.7659658 494428.7655 15 4543.503728 4120.239712 423.2640155 494005.5014 16 4543.503728 4116.712512 426.7912157 493578.7102 17 4543.503728 4113.155919 430.3478091 493148.3624 18 4543.503728 4109.569687 433.9340409 492714.4284 19 4543.503728 4105.95357 437.5501579 492276.8782 20 4543.503728 4102.307318 441.1964092 491835.6818 21 4543.503728 4098.630682 444.873046 491390.8088 22 4543.503728 4094.923406 448.5803213 490942.2284 23 4543.503728 4091.185237 452.3184907 490489.91 24 4543.503728 4087.415916 456.0878114 490033.8221 25 4543.503728 4083.615185 459.8885432 489573.9336 26 4543.503728 4079.78278 463.7209477 489110.2126 27 4543.503728 4075.918439 467.585289 488642.6274 28 4543.503728 4072.021895 471.481833 488171.1455 29 4543.503728 4068.092879 475.4108483 487695.7347 30 4543.503728 4064.131122 479.3726054 487216.3621 31 4543.503728 4060.136351 483.3673771 486732.9947 32 4543.503728 4056.108289 487.3954386 486245.5993 33 4543.503728 4052.04666 491.4570672 485754.1422 34 4543.503728 4047.951185 495.5525428 485258.5896 35 4543.503728 4043.82158 499.6821473 484758.9075 36 4543.503728 4039.657563 503.8461652 484255.0613 37 4543.503728 4035.458844 508.0448832 483747.0165 38 4543.503728 4031.225137 512.2785906 483234.7379 39 4543.503728 4026.956149 516.5475789 482718.1903 40 4543.503728 4022.651586 520.852142 482197.3381 41 4543.503728 4018.311151 525.1925765 481672.1456 42 4543.503728 4013.934546 529.5691813 481142.5764 43 4543.503728 4009.52147 533.9822578 480608.5941 44 4543.503728 4005.071618 538.43211 480070.162 45 4543.503728 4000.584683 542.9190442 479527.243 46 4543.503728 3996.060358 547.4433696 478979.7996 47 4543.503728 3991.49833 552.0053977 478427.7942 48 4543.503728 3986.898285 556.6054427 477871.1888 49 4543.503728 3982.259906 561.2438214 477309.9449 50 4543.503728 3977.582874 565.9208532 476744.0241 51 4543.503728 3972.866867 570.6368603 476173.3872 52 4543.503728 3968.11156 575.3921675 475597.9951 53 4543.503728 3963.316625 580.1871022 475017.808 54 4543.503728 3958.481733 585.0219947 474432.786 55 4543.503728 3953.60655 589.897178 473842.8888 56 4543.503728 3948.69074 594.8129878 473248.0758 57 4543.503728 3943.733965 599.7697627 472648.306 58 4543.503728 3938.735884 604.7678441 472043.5382 59 4543.503728 3933.696152 609.8075761 471433.7306 60 4543.503728 3928.614422 614.8893059 470818.8413 61 4543.503728 3923.490344 620.0133835 470198.8279 62 4543.503728 3918.323566 625.1801617 469573.6478 63 4543.503728 3913.113731 630.3899964 468943.2578 64 4543.503728 3907.860481 635.6432463 468307.6145 65 4543.503728 3902.563454 640.9402734 467666.6742 66 4543.503728 3897.222285 646.2814423 467020.3928 67 4543.503728 3891.836607 651.667121 466368.7257 68 4543.503728 3886.406047 657.0976803 465711.628 69 4543.503728 3880.930233 662.5734943 465049.0545 70 4543.503728 3875.408788 668.0949401 464380.9596 71 4543.503728 3869.84133 673.662398 463707.2972 72 4543.503728 3864.227476 679.2762513 463028.0209 73 4543.503728 3858.566841 684.9368867 462343.084 74 4543.503728 3852.859034 690.6446941 461652.4393 75 4543.503728 3847.103661 696.4000666 460956.0393 76 4543.503728 3841.300327 702.2034004 460253.8359 77 4543.503728 3835.448632 708.0550954 459545.7808 78 4543.503728 3829.548173 713.9555546 458831.8252 79 4543.503728 3823.598544 719.9051842 458111.92 80 4543.503728 3817.599334 725.9043941 457386.0156 81 4543.503728 3811.55013 731.9535973 456654.062 82 4543.503728 3805.450517 738.0532107 455916.0088 83 4543.503728 3799.300074 744.2036541 455171.8052 84 4543.503728 3793.098377 750.4053512 454421.3998 85 4543.503728 3786.844999 756.6587291 453664.7411 86 4543.503728 3780.539509 762.9642185 452901.7769 87 4543.503728 3774.181474 769.3222537 452132.4546 88 4543.503728 3767.770455 775.7332725 451356.7214 89 4543.503728 3761.306011 782.1977164 450574.5236 90 4543.503728 3754.787697 788.7160307 449785.8076 91 4543.503728 3748.215063 795.2886643 448990.5189 92 4543.503728 3741.587658 801.9160698 448188.6029 93 4543.503728 3734.905024 808.5987037 447380.0042 94 4543.503728 3728.166701 815.3370263 446564.6671 95 4543.503728 3721.372226 822.1315015 445742.5356 96 4543.503728 3714.52113 828.9825973 444913.553 97 4543.503728 3707.612942 835.8907857 444077.6623 98 4543.503728 3700.647185 842.8565422 443234.8057 99 4543.503728 3693.623381 849.8803467 442384.9254 100 4543.503728 3686.541045 856.9626829 441527.9627 101 4543.503728 3679.399689 864.1040386 440663.8586 102 4543.503728 3672.198822 871.3049056 439792.5537 103 4543.503728 3664.937948 878.5657798 438913.988 104 4543.503728 3657.616566 885.8871613 438028.1008 105 4543.503728 3650.234173 893.2695543 437134.8312 106 4543.503728 3642.79026 900.7134673 436234.1178 107 4543.503728 3635.284315 908.2194129 435325.8984 108 4543.503728 3627.71582 915.787908 434410.1105 109 4543.503728 3620.084254 923.4194739 433486.691 110 4543.503728 3612.389092 931.1146362 432555.5763 111 4543.503728 3604.629803 938.8739248 431616.7024 112 4543.503728 3596.805854 946.6978742 430670.0046 113 4543.503728 3588.916705 954.5870231 429715.4175 114 4543.503728 3580.961813 962.541915 428752.8756 115 4543.503728 3572.94063 970.5630976 427782.3125 116 4543.503728 3564.852604 978.6511234 426803.6614 117 4543.503728 3556.697178 986.8065494 425816.8548 118 4543.503728 3548.47379 995.0299373 424821.8249 119 4543.503728 3540.181874 1003.321853 423818.5031 120 4543.503728 3531.820859 1011.682869 422806.8202 121 4543.503728 3523.390168 1020.11356 421786.7066 122 4543.503728 3514.889222 1028.614506 420758.0921 123 4543.503728 3506.317434 1037.186293 419720.9058 124 4543.503728 3497.674215 1045.829513 418675.0763 125 4543.503728 3488.958969 1054.544758 417620.5316 126 4543.503728 3480.171096 1063.332631 416557.1989 127 4543.503728 3471.309991 1072.193737 415485.0052 128 4543.503728 3462.375043 1081.128684 414403.8765 129 4543.503728 3453.365638 1090.13809 413313.7384 130 4543.503728 3444.281153 1099.222574 412214.5158 131 4543.503728 3435.120965 1108.382762 411106.1331 132 4543.503728 3425.884442 1117.619285 409988.5138 133 4543.503728 3416.570948 1126.932779 408861.581 134 4543.503728 3407.179842 1136.323886 407725.2571 135 4543.503728 3397.710476 1145.793252 406579.4639 136 4543.503728 3388.162199 1155.341529 405424.1223 137 4543.503728 3378.534353 1164.969375 404259.153 138 4543.503728 3368.826275 1174.677453 403084.4755 139 4543.503728 3359.037296 1184.466432 401900.0091 140 4543.503728 3349.166742 1194.336985 400705.6721 141 4543.503728 3339.213934 1204.289794 399501.3823 142 4543.503728 3329.178186 1214.325542 398287.0568 143 4543.503728 3319.058806 1224.444921 397062.6118 144 4543.503728 3308.855099 1234.648629 395827.9632 145 4543.503728 3298.56636 1244.937368 394583.0258 146 4543.503728 3288.191882 1255.311846 393327.714 147 4543.503728 3277.73095 1265.772778 392061.9412 148 4543.503728 3267.182844 1276.320884 390785.6203 149 4543.503728 3256.546836 1286.956892 389498.6634 150 4543.503728 3245.822195 1297.681532 388200.9819 151 4543.503728 3235.008183 1308.495545 386892.4864 152 4543.503728 3224.104053 1319.399675 385573.0867 153 4543.503728 3213.109056 1330.394672 384242.692 154 4543.503728 3202.022434 1341.481294 382901.2107 155 4543.503728 3190.843423 1352.660305 381548.5504 156 4543.503728 3179.571254 1363.932474 380184.6179 157 4543.503728 3168.20515 1375.298578 378809.3194 158 4543.503728 3156.744328 1386.7594 377422.56 159 4543.503728 3145.188 1398.315728 376024.2442 160 4543.503728 3133.535369 1409.968359 374614.2759 161 4543.503728 3121.785632 1421.718095 373192.5578 162 4543.503728 3109.937982 1433.565746 371758.992 163 4543.503728 3097.9916 1445.512127 370313.4799 164 4543.503728 3085.945666 1457.558062 368855.9219 165 4543.503728 3073.799349 1469.704379 367386.2175 166 4543.503728 3061.551812 1481.951915 365904.2656 167 4543.503728 3049.202213 1494.301515 364409.964 168 4543.503728 3036.7497 1506.754027 362903.21 169 4543.503728 3024.193417 1519.310311 361383.8997 170 4543.503728 3011.532498 1531.97123 359851.9285 171 4543.503728 2998.766071 1544.737657 358307.1908 172 4543.503728 2985.893257 1557.610471 356749.5803 173 4543.503728 2972.91317 1570.590558 355178.9898 174 4543.503728 2959.824915 1583.678813 353595.311 175 4543.503728 2946.627591 1596.876136 351998.4348 176 4543.503728 2933.32029 1610.183437 350388.2514 177 4543.503728 2919.902095 1623.601633 348764.6498 178 4543.503728 2906.372081 1637.131646 347127.5181 179 4543.503728 2892.729318 1650.77441 345476.7437 180 4543.503728 2878.972864 1664.530863 343812.2128 181 4543.503728 2865.101774 1678.401954 342133.8109 182 4543.503728 2851.115091 1692.388637 340441.4223 183 4543.503728 2837.011852 1706.491876 338734.9304 184 4543.503728 2822.791087 1720.712641 337014.2177 185 4543.503728 2808.451815 1735.051913 335279.1658 186 4543.503728 2793.993049 1749.510679 333529.6551 187 4543.503728 2779.413793 1764.089935 331765.5652 188 4543.503728 2764.713043 1778.790684 329986.7745 189 4543.503728 2749.889788 1793.61394 328193.1606 190 4543.503728 2734.943005 1808.560723 326384.5999 191 4543.503728 2719.871666 1823.632062 324560.9678 192 4543.503728 2704.674732 1838.828996 322722.1388 193 4543.503728 2689.351157 1854.152571 320867.9862 194 4543.503728 2673.899885 1869.603842 318998.3824 195 4543.503728 2658.319853 1885.183874 317113.1985 196 4543.503728 2642.609988 1900.89374 315212.3048 197 4543.503728 2626.769207 1916.734521 313295.5703 198 4543.503728 2610.796419 1932.707309 311362.863 199 4543.503728 2594.690525 1948.813203 309414.0497 200 4543.503728 2578.450415 1965.053313 307448.9964 201 4543.503728 2562.07497 1981.428757 305467.5677 202 4543.503728 2545.563064 1997.940664 303469.627 203 4543.503728 2528.913558 2014.590169 301455.0368 204 4543.503728 2512.125307 2031.378421 299423.6584 205 4543.503728 2495.197154 2048.306574 297375.3519 206 4543.503728 2478.127932 2065.375796 295309.9761 207 4543.503728 2460.916467 2082.587261 293227.3888 208 4543.503728 2443.561573 2099.942154 291127.4466 209 4543.503728 2426.062055 2117.441672 289010.005 210 4543.503728 2408.416708 2135.08702 286874.9179 211 4543.503728 2390.624316 2152.879411 284722.0385 212 4543.503728 2372.683654 2170.820073 282551.2185 213 4543.503728 2354.593487 2188.910241 280362.3082 214 4543.503728 2336.352569 2207.151159 278155.1571 215 4543.503728 2317.959642 2225.544086 275929.613 216 4543.503728 2299.413441 2244.090286 273685.5227 217 4543.503728 2280.712689 2262.791039 271422.7317 218 4543.503728 2261.856097 2281.647631 269141.084 219 4543.503728 2242.842367 2300.661361 266840.4227 220 4543.503728 2223.670189 2319.833539 264520.5891 221 4543.503728 2204.338243 2339.165485 262181.4236 222 4543.503728 2184.845197 2358.658531 259822.7651 223 4543.503728 2165.189709 2378.314018 257444.4511 224 4543.503728 2145.370426 2398.133302 255046.3178 225 4543.503728 2125.385982 2418.117746 252628.2 226 4543.503728 2105.235 2438.268727 250189.9313 227 4543.503728 2084.916094 2458.587633 247731.3437 228 4543.503728 2064.427864 2479.075864 245252.2678 229 4543.503728 2043.768898 2499.734829 242752.533 230 4543.503728 2022.937775 2520.565953 240231.967 231 4543.503728 2001.933059 2541.570669 237690.3964 232 4543.503728 1980.753303 2562.750425 235127.6459 233 4543.503728 1959.39705 2584.106678 232543.5393 234 4543.503728 1937.862827 2605.640901 229937.8984 235 4543.503728 1916.149153 2627.354575 227310.5438 236 4543.503728 1894.254532 2649.249196 224661.2946 237 4543.503728 1872.177455 2671.326273 221989.9683 238 4543.503728 1849.916403 2693.587325 219296.381 239 4543.503728 1827.469842 2716.033886 216580.3471 240 4543.503728 1804.836226 2738.667502 213841.6796 241 4543.503728 1782.013997 2761.489731 211080.1899 242 4543.503728 1759.001582 2784.502145 208295.6877 243 4543.503728 1735.797398 2807.70633 205487.9814 244 4543.503728 1712.399845 2831.103883 202656.8775 245 4543.503728 1688.807313 2854.696415 199802.1811 246 4543.503728 1665.018176 2878.485552 196923.6955 247 4543.503728 1641.030796 2902.472931 194021.2226 248 4543.503728 1616.843522 2926.660206 191094.5624 249 4543.503728 1592.454687 2951.049041 188143.5134 250 4543.503728 1567.862611 2975.641116 185167.8723 251 4543.503728 1543.065602 3000.438126 182167.4341 252 4543.503728 1518.061951 3025.441777 179141.9924 253 4543.503728 1492.849936 3050.653791 176091.3386 254 4543.503728 1467.427821 3076.075906 173015.2627 255 4543.503728 1441.793855 3101.709872 169913.5528 256 4543.503728 1415.946273 3127.557455 166785.9953 257 4543.503728 1389.883294 3153.620433 163632.3749 258 4543.503728 1363.603124 3179.900604 160452.4743 259 4543.503728 1337.103952 3206.399775 157246.0745 260 4543.503728 1310.383954 3233.119773 154012.9547 261 4543.503728 1283.44129 3260.062438 150752.8923 262 4543.503728 1256.274103 3287.229625 147465.6627 263 4543.503728 1228.880522 3314.623205 144151.0395 264 4543.503728 1201.258662 3342.245065 140808.7944 265 4543.503728 1173.40662 3370.097108 137438.6973 266 4543.503728 1145.322478 3398.18125 134040.5161 267 4543.503728 1117.0043 3426.499427 130614.0166 268 4543.503728 1088.450139 3455.053589 127158.963 269 4543.503728 1059.658025 3483.845702 123675.1173 270 4543.503728 1030.625978 3512.87775 120162.2396 271 4543.503728 1001.351997 3542.151731 116620.0879 272 4543.503728 971.8340654 3571.669662 113048.4182 273 4543.503728 942.0701516 3601.433576 109446.9846 274 4543.503728 912.0582051 3631.445523 105815.5391 275 4543.503728 881.7961591 3661.707569 102153.8315 276 4543.503728 851.2819293 3692.221798 98461.60972 277 4543.503728 820.5134144 3722.990313 94738.61941 278 4543.503728 789.4884951 3754.015233 90984.60418 279 4543.503728 758.2050348 3785.298693 87199.30548 280 4543.503728 726.660879 3816.842849 83382.46263 281 4543.503728 694.8538553 3848.649872 79533.81276 282 4543.503728 662.781773 3880.721955 75653.09081 283 4543.503728 630.4424234 3913.061304 71740.0295 284 4543.503728 597.8335792 3945.670149 67794.35935 285 4543.503728 564.9529946 3978.550733 63815.80862 286 4543.503728 531.7984052 4011.705323 59804.1033 287 4543.503728 498.3675275 4045.1362 55758.9671 288 4543.503728 464.6580592 4078.845669 51680.12143 289 4543.503728 430.6676786 4112.836049 47567.28538 290 4543.503728 396.3940448 4147.109683 43420.1757 291 4543.503728 361.8347975 4181.66893 39238.50677 292 4543.503728 326.9875564 4216.516171 35021.9906 293 4543.503728 291.8499216 4251.653806 30770.33679 294 4543.503728 256.4194733 4287.084254 26483.25254 295 4543.503728 220.6937711 4322.809957 22160.44258 296 4543.503728 184.6703548 4358.833373 17801.60921 297 4543.503728 148.3467434 4395.156984 13406.45222 298 4543.503728 111.7204352 4431.783293 8974.66893 299 4543.503728 74.78890775 4468.71482 4505.95411 300 4543.503728 37.54961758 4505.95411 0.00 ##### Sheet/List 3 ##### 500000 0.15 20000 10000 Sn=(n/2)*(2*a1+(n-1)*d) n^2*d+(2*a1-d)*n-2*Sn 20.22374842 X1 -11.61187421 X2 8.611874208 Měsíc Anuita Úrok Úmor Stav dluhu 0 500000 1 95000 75000 20000 480000 2 102000 72000 30000 450000 3 107500 67500 40000 410000 4 111500 61500 50000 360000 5 114000 54000 60000 300000 6 115000 45000 70000 230000 7 114500 34500 80000 150000 8 112500 22500 90000 60000 9 69000 9000 60000 0 ##### Sheet/List 4 ##### 20000 18 12 0.12 Měsíc Anuita Úrok Úmor Stav dluhu 0 20000 1 1219.640958 200 1019.640958 18980.35904 2 1219.640958 189.8035904 1029.837367 17950.52167 3 1219.640958 179.5052167 1040.135741 16910.38593 4 1219.640958 169.1038593 1050.537099 15859.84883 5 1219.640958 158.5984883 1061.04247 14798.80637 6 1219.640958 147.9880637 1071.652894 13727.15347 7 1219.640958 137.2715347 1082.369423 12644.78405 8 1219.640958 126.4478405 1093.193117 11551.59093 9 1219.640958 115.5159093 1104.125049 10447.46588 10 1219.640958 104.4746588 1115.166299 9332.299583 11 1219.640958 93.32299583 1126.317962 8205.981621 12 1219.640958 82.05981621 1137.581142 7068.400479 13 1219.640958 70.68400479 1148.956953 5919.443526 14 1219.640958 59.19443526 1160.446523 4758.997003 15 1219.640958 47.58997003 1172.050988 3586.946015 16 1219.640958 35.86946015 1183.771498 2403.174518 17 1219.640958 24.03174518 1195.609213 1207.565305 18 1219.640958 12.07565305 1207.565305 0.00 ##### Sheet/List 5 ##### 1000000 0.15 8 96 12 Měsíc Anuita Úrok Úmor Stav dluhu 0 1000000 1 17945.40531 12500 5445.40531 994554.5947 2 17945.40531 12431.93243 5513.472876 989041.1218 ZA 1. ROK UMORENO: "70,029.88" 3 17945.40531 12363.01402 5582.391287 983458.7305 ZA 1. ROK ZAPLACENO NA ÚROCÍCH: "145,314.98" 4 17945.40531 12293.23413 5652.171178 977806.5593 5 17945.40531 12222.58199 5722.823318 972083.736 6 17945.40531 12151.0467 5794.35861 966289.3774 7 17945.40531 12078.61722 5866.788092 960422.5893 8 17945.40531 12005.28237 5940.122943 954482.4664 9 17945.40531 11931.03083 6014.37448 948468.0919 10 17945.40531 11855.85115 6089.554161 942378.5377 11 17945.40531 11779.73172 6165.673588 936212.8642 12 17945.40531 11702.6608 6242.744508 929970.1196 13 17945.40531 11624.6265 6320.778814 923649.3408 14 17945.40531 11545.61676 6399.78855 917249.5523 15 17945.40531 11465.6194 6479.785907 910769.7664 16 17945.40531 11384.62208 6560.78323 904208.9831 17 17945.40531 11302.61229 6642.793021 897566.1901 18 17945.40531 11219.57738 6725.827933 890840.3622 19 17945.40531 11135.50453 6809.900783 884030.4614 20 17945.40531 11050.38077 6895.024542 877135.4369 21 17945.40531 10964.19296 6981.212349 870154.2245 22 17945.40531 10876.92781 7068.477504 863085.747 23 17945.40531 10788.57184 7156.833472 855928.9135 24 17945.40531 10699.11142 7246.293891 848682.6196 25 17945.40531 10608.53275 7336.872564 841345.7471 26 17945.40531 10516.82184 7428.583471 833917.1636 27 17945.40531 10423.96455 7521.440765 826395.7228 28 17945.40531 10329.94654 7615.458774 818780.2641 29 17945.40531 10234.7533 7710.652009 811069.6121 30 17945.40531 10138.37015 7807.035159 803262.5769 31 17945.40531 10040.78221 7904.623099 795357.9538 32 17945.40531 9941.974423 8003.430887 787354.5229 33 17945.40531 9841.931537 8103.473774 779251.0491 34 17945.40531 9740.638114 8204.767196 771046.282 35 17945.40531 9638.078524 8307.326786 762738.9552 36 17945.40531 9534.23694 8411.16837 754327.7868 37 17945.40531 9429.097335 8516.307975 745811.4788 38 17945.40531 9322.643485 8622.761825 737188.717 39 17945.40531 9214.858962 8730.546348 728458.1706 40 17945.40531 9105.727133 8839.678177 719618.4925 41 17945.40531 8995.231156 8950.174154 710668.3183 42 17945.40531 8883.353979 9062.051331 701606.267 43 17945.40531 8770.078337 9175.326973 692430.94 44 17945.40531 8655.38675 9290.01856 683140.9215 45 17945.40531 8539.261518 9406.143792 673734.7777 46 17945.40531 8421.684721 9523.720589 664211.0571 47 17945.40531 8302.638213 9642.767097 654568.29 48 17945.40531 8182.103625 9763.301685 644804.9883 49 17945.40531 8060.062354 9885.342956 634919.6453 50 17945.40531 7936.495567 10008.90974 624910.7356 51 17945.40531 7811.384195 10134.02112 614776.7145 52 17945.40531 7684.708931 10260.69638 604516.0181 53 17945.40531 7556.450226 10388.95508 594127.063 54 17945.40531 7426.588288 10518.81702 583608.246 55 17945.40531 7295.103075 10650.30224 572957.9438 56 17945.40531 7161.974297 10783.43101 562174.5127 57 17945.40531 7027.181409 10918.2239 551256.2888 58 17945.40531 6890.70361 11054.7017 540201.5871 59 17945.40531 6752.519839 11192.88547 529008.7017 60 17945.40531 6612.608771 11332.79654 517675.9051 61 17945.40531 6470.948814 11474.4565 506201.4486 62 17945.40531 6327.518108 11617.8872 494583.5614 63 17945.40531 6182.294518 11763.11079 482820.4506 64 17945.40531 6035.255633 11910.14968 470910.301 65 17945.40531 5886.378762 12059.02655 458851.2744 66 17945.40531 5735.64093 12209.76438 446641.51 67 17945.40531 5583.018875 12362.38643 434279.1236 68 17945.40531 5428.489045 12516.91627 421762.2073 69 17945.40531 5272.027592 12673.37772 409088.8296 70 17945.40531 5113.61037 12831.79494 396257.0347 71 17945.40531 4953.212933 12992.19238 383264.8423 72 17945.40531 4790.810529 13154.59478 370110.2475 73 17945.40531 4626.378094 13319.02722 356791.2203 74 17945.40531 4459.890254 13485.51506 343305.7052 75 17945.40531 4291.321316 13654.08399 329651.6213 76 17945.40531 4120.645266 13824.76004 315826.8612 77 17945.40531 3947.835765 13997.56954 301829.2917 78 17945.40531 3772.866146 14172.53916 287656.7525 79 17945.40531 3595.709406 14349.6959 273307.0566 80 17945.40531 3416.338207 14529.0671 258777.9895 81 17945.40531 3234.724869 14710.68044 244067.3091 82 17945.40531 3050.841363 14894.56395 229172.7451 83 17945.40531 2864.659314 15080.746 214091.9991 84 17945.40531 2676.149989 15269.25532 198822.7438 85 17945.40531 2485.284297 15460.12101 183362.6228 86 17945.40531 2292.032785 15653.37253 167709.2502 87 17945.40531 2096.365628 15849.03968 151860.2106 88 17945.40531 1898.252632 16047.15268 135813.0579 89 17945.40531 1697.663224 16247.74209 119565.3158 90 17945.40531 1494.566448 16450.83886 103114.4769 91 17945.40531 1288.930962 16656.47435 86458.00259 92 17945.40531 1080.725032 16864.68028 69593.32231 93 17945.40531 869.9165289 17075.48878 52517.83353 94 17945.40531 656.4729192 17288.93239 35228.90114 95 17945.40531 440.3612643 17505.04405 17723.8571 96 17945.40531 221.5482137 17723.8571 0.00