r 8%p.a. q 0.980263733 2960.440041 5897.564635 108 36 108 number annuity interest amortization debt number annuity interest amortization debt number annuity interest amortization debt 0 150000 0 150000 1.02013363 0 150000 1 1952.807233 1000 952.8072331 149047.1928 sum_excel 1 5897.564635 3020.044444 2877.520191 147122.4798 1.02013363 1 2388.888889 1000 1388.888889 148611.1111 -9.259259259 -9.259259259 2 1952.807233 993.6479518 959.1592813 148088.0335 1.006666667 1.006666667 89219.75191 2 5897.564635 2962.109519 2935.455117 144187.0247 1.02013363 2 2379.62963 990.7407407 1388.888889 147222.2222 -9.259259259 -9.259259259 3 1952.807233 987.2535566 965.5536765 147122.4798 3 5897.564635 2903.008153 2994.556483 141192.4682 1.02013363 3 2370.37037 981.4814815 1388.888889 145833.3333 -9.259259259 -9.259259259 4 1952.807233 980.8165321 971.990701 146150.4891 GS 89219.75191 4 5897.564635 2842.716861 3054.847774 138137.6204 1.02013363 4 2361.111111 972.2222222 1388.888889 144444.4444 -9.259259259 -9.259259259 5 1952.807233 974.3365941 978.470639 145172.0185 73 5 5897.564635 2781.211688 3116.352948 135021.2675 1.02013363 5 2351.851852 962.962963 1388.888889 143055.5556 -9.259259259 -9.259259259 6 1952.807233 967.8134565 984.9937766 144187.0247 6 5897.564635 2718.468192 3179.096444 131842.171 6 2342.592593 953.7037037 1388.888889 141666.6667 -9.259259259 -9.259259259 7 1952.807233 961.2468313 991.5604018 143195.4643 M73 D73 60780.24809 7 5897.564635 2654.461441 3243.103194 128599.0679 7 2333.333333 944.4444444 1388.888889 140277.7778 -9.259259259 -9.259259259 8 1952.807233 954.6364286 998.1708045 142197.2935 60780.24809 8 5897.564635 2589.166003 3308.398633 125290.6692 30 M30 5129.479002 8 2324.074074 935.1851852 1388.888889 138888.8889 -9.259259259 -9.259259259 9 1952.807233 947.9819566 1004.825277 141192.4682 9 5897.564635 2522.55593 3375.008705 121915.6605 5129.479002 9 2314.814815 925.9259259 1388.888889 137500 -9.259259259 -9.259259259 10 1952.807233 941.2831214 1011.524112 140180.9441 sum_I 53335.1761 10 5897.564635 2454.604755 3442.959881 118472.7006 I30 768.0856335 10 2305.555556 916.6666667 1388.888889 136111.1111 -9.259259259 -9.259259259 11 1952.807233 934.5396273 1018.267606 139162.6765 11 5897.564635 2385.285476 3512.27916 114960.4215 768.0856335 11 2296.296296 907.4074074 1388.888889 134722.2222 -9.259259259 -9.259259259 12 1952.807233 927.7511766 1025.056056 138137.6204 excel 53335.1761 12 5897.564635 2314.570548 3582.994087 111377.4274 12 2287.037037 898.1481481 1388.888889 133333.3333 13 1952.807233 920.9174696 1031.889764 137105.7307 13 5897.564635 2242.431872 3655.132763 107722.2946 D30 T6-sumM30 33019.90825 13 2277.777778 888.8888889 1388.888889 131944.4444 14 1952.807233 914.0382045 1038.769029 136066.9616 14 5897.564635 2168.840783 3728.723853 103993.5708 116980.0918 14 2268.518519 879.6296296 1388.888889 130555.5556 15 1952.807233 907.1130776 1045.694155 135021.2675 15 5897.564635 2093.768038 3803.796598 100189.7742 116980.0918 33019.90825 15 2259.259259 870.3703704 1388.888889 129166.6667 16 1952.807233 900.1417833 1052.66545 133968.602 16 5897.564635 2017.183806 3880.38083 96309.39334 16 2250 861.1111111 1388.888889 127777.7778 17 1952.807233 893.1240136 1059.683219 132908.9188 17 5897.564635 1939.057655 3958.50698 92350.88636 17 2240.740741 851.8518519 1388.888889 126388.8889 18 1952.807233 886.0594588 1066.747774 131842.171 18 5897.564635 1859.358542 4038.206093 88312.68027 18 2231.481481 842.5925926 1388.888889 125000 19 1952.807233 878.947807 1073.859426 130768.3116 19 5897.564635 1778.054796 4119.509839 84193.17043 19 2222.222222 833.3333333 1388.888889 123611.1111 20 1952.807233 871.7887441 1081.018489 129687.2931 20 5897.564635 1695.114111 4202.450525 79990.71991 20 2212.962963 824.0740741 1388.888889 122222.2222 21 1952.807233 864.5819542 1088.225279 128599.0679 21 5897.564635 1610.503528 4287.061107 75703.6588 21 2203.703704 814.8148148 1388.888889 120833.3333 22 1952.807233 857.327119 1095.480114 127503.5877 22 5897.564635 1524.189428 4373.375208 71330.28359 22 2194.444444 805.5555556 1388.888889 119444.4444 23 1952.807233 850.0239182 1102.783315 126400.8044 23 5897.564635 1436.137511 4461.427124 66868.85647 23 2185.185185 796.2962963 1388.888889 118055.5556 a I m d 24 1952.807233 842.6720295 1110.135204 125290.6692 24 5897.564635 1346.31279 4551.251845 62317.60462 24 2175.925926 787.037037 1388.888889 116666.6667 24th row 2175.925926 787.037037 116666.6667 25 1952.807233 835.2711281 1117.536105 124173.1331 25 5897.564635 1254.679571 4642.885065 57674.71956 25 2166.666667 777.7777778 1388.888889 115277.7778 26 1952.807233 827.8208874 1124.986346 123048.1468 26 5897.564635 1161.201443 4736.363193 52938.35636 26 2157.407407 768.5185185 1388.888889 113888.8889 27 1952.807233 820.3209784 1132.486255 121915.6605 27 5897.564635 1065.84126 4831.723375 48106.63299 27 2148.148148 759.2592593 1388.888889 112500 28 1952.807233 812.7710701 1140.036163 120775.6243 28 5897.564635 968.5611313 4929.003504 43177.62948 28 2138.888889 750 1388.888889 111111.1111 29 1952.807233 805.170829 1147.636404 119627.9879 29 5897.564635 869.3224003 5028.242235 38149.38725 29 2129.62963 740.7407407 1388.888889 109722.2222 30 1952.807233 797.5199196 1155.287313 118472.7006 30 5897.564635 768.0856335 5129.479002 33019.90825 30 2120.37037 731.4814815 1388.888889 108333.3333 31 1952.807233 789.8180042 1162.989229 117309.7114 31 5897.564635 664.8106031 5232.754032 27787.15422 31 2111.111111 722.2222222 1388.888889 106944.4444 32 1952.807233 782.0647427 1170.74249 116138.9689 32 5897.564635 559.4562714 5338.108364 22449.04585 32 2101.851852 712.962963 1388.888889 105555.5556 33 1952.807233 774.2597928 1178.54744 114960.4215 33 5897.564635 451.9807747 5445.583861 17003.46199 33 2092.592593 703.7037037 1388.888889 104166.6667 34 1952.807233 766.4028098 1186.404423 113774.017 34 5897.564635 342.3414061 5555.223229 11448.23876 34 2083.333333 694.4444444 1388.888889 102777.7778 35 1952.807233 758.493447 1194.313786 112579.7033 35 5897.564635 230.4945991 5667.070036 5781.168725 35 2074.074074 685.1851852 1388.888889 101388.8889 36 1952.807233 750.5313551 1202.275878 111377.4274 36 5897.564635 116.3959099 5781.168725 0.00 36 2064.814815 675.9259259 1388.888889 100000 37 1952.807233 742.5161826 1210.291051 110167.1363 37 2055.555556 666.6666667 1388.888889 98611.11111 38 1952.807233 734.4475756 1218.359658 108948.7767 62312.32687 38 2046.296296 657.4074074 1388.888889 97222.22222 39 1952.807233 726.3251778 1226.482055 107722.2946 39 2037.037037 648.1481481 1388.888889 95833.33333 40 1952.807233 718.1486308 1234.658602 106487.636 62312.32687 40 2027.777778 638.8888889 1388.888889 94444.44444 41 1952.807233 709.9175735 1242.88966 105244.7464 41 2018.518519 629.6296296 1388.888889 93055.55556 42 1952.807233 701.6316424 1251.175591 103993.5708 42 2009.259259 620.3703704 1388.888889 91666.66667 43 1952.807233 693.2904718 1259.516761 102734.054 43 2000 611.1111111 1388.888889 90277.77778 44 1952.807233 684.8936934 1267.91354 101466.1405 44 1990.740741 601.8518519 1388.888889 88888.88889 45 1952.807233 676.4409365 1276.366297 100189.7742 45 1981.481481 592.5925926 1388.888889 87500 46 1952.807233 667.9318278 1284.875405 98904.89877 46 1972.222222 583.3333333 1388.888889 86111.11111 47 1952.807233 659.3659918 1293.441241 97611.45753 47 1962.962963 574.0740741 1388.888889 84722.22222 48 1952.807233 650.7430502 1302.064183 96309.39334 48 1953.703704 564.8148148 1388.888889 83333.33333 49 1952.807233 642.0626223 1310.744611 94998.64873 49 1944.444444 555.5555556 1388.888889 81944.44444 50 1952.807233 633.3243249 1319.482908 93679.16582 50 1935.185185 546.2962963 1388.888889 80555.55556 51 1952.807233 624.5277722 1328.279461 92350.88636 51 1925.925926 537.037037 1388.888889 79166.66667 52 1952.807233 615.6725757 1337.134657 91013.7517 52 1916.666667 527.7777778 1388.888889 77777.77778 53 1952.807233 606.7583447 1346.048888 89667.70282 53 1907.407407 518.5185185 1388.888889 76388.88889 54 1952.807233 597.7846854 1355.022548 88312.68027 54 1898.148148 509.2592593 1388.888889 75000 55 1952.807233 588.7512018 1364.056031 86948.62424 55 1888.888889 500 1388.888889 73611.11111 56 1952.807233 579.6574949 1373.149738 85575.4745 56 1879.62963 490.7407407 1388.888889 72222.22222 57 1952.807233 570.5031633 1382.30407 84193.17043 57 1870.37037 481.4814815 1388.888889 70833.33333 58 1952.807233 561.2878029 1391.51943 82801.651 58 1861.111111 472.2222222 1388.888889 69444.44444 59 1952.807233 552.0110067 1400.796226 81400.85477 59 1851.851852 462.962963 1388.888889 68055.55556 60 1952.807233 542.6723652 1410.134868 79990.71991 60 1842.592593 453.7037037 1388.888889 66666.66667 61 1952.807233 533.271466 1419.535767 78571.18414 61 1833.333333 444.4444444 1388.888889 65277.77778 62 1952.807233 523.8078943 1428.999339 77142.1848 62 1824.074074 435.1851852 1388.888889 63888.88889 63 1952.807233 514.281232 1438.526001 75703.6588 63 1814.814815 425.9259259 1388.888889 62500 64 1952.807233 504.6910587 1448.116174 74255.54262 64 1805.555556 416.6666667 1388.888889 61111.11111 65 1952.807233 495.0369508 1457.770282 72797.77234 65 1796.296296 407.4074074 1388.888889 59722.22222 66 1952.807233 485.3184823 1467.488751 71330.28359 66 1787.037037 398.1481481 1388.888889 58333.33333 67 1952.807233 475.5352239 1477.272009 69853.01158 67 1777.777778 388.8888889 1388.888889 56944.44444 68 1952.807233 465.6867439 1487.120489 68365.89109 68 1768.518519 379.6296296 1388.888889 55555.55556 69 1952.807233 455.7726073 1497.034626 66868.85647 69 1759.259259 370.3703704 1388.888889 54166.66667 70 1952.807233 445.7923764 1507.014857 65361.84161 70 1750 361.1111111 1388.888889 52777.77778 71 1952.807233 435.7456107 1517.061622 63844.77999 D72 D0-sum 71 1740.740741 351.8518519 1388.888889 51388.88889 72 1952.807233 425.6318666 1527.175367 62317.60462 I73 72 1731.481481 342.5925926 1388.888889 50000 73 1952.807233 415.4506975 1537.356536 60780.24809 415.4506975 1537.356536 1537.356536 73 1722.222222 333.3333333 1388.888889 48611.11111 74 1952.807233 405.2016539 1547.605579 59232.64251 74 1712.962963 324.0740741 1388.888889 47222.22222 75 1952.807233 394.8842834 1557.92295 57674.71956 75 1703.703704 314.8148148 1388.888889 45833.33333 76 1952.807233 384.4981304 1568.309103 56106.41045 76 1694.444444 305.5555556 1388.888889 44444.44444 77 1952.807233 374.0427364 1578.764497 54527.64596 77 1685.185185 296.2962963 1388.888889 43055.55556 78 1952.807233 363.5176397 1589.289593 52938.35636 78 1675.925926 287.037037 1388.888889 41666.66667 79 1952.807233 352.9223758 1599.884857 51338.47151 79 1666.666667 277.7777778 1388.888889 40277.77778 80 1952.807233 342.2564767 1610.550756 49727.92075 80 1657.407407 268.5185185 1388.888889 38888.88889 81 1952.807233 331.5194717 1621.287761 48106.63299 81 1648.148148 259.2592593 1388.888889 37500 82 1952.807233 320.7108866 1632.096346 46474.53664 82 1638.888889 250 1388.888889 36111.11111 83 1952.807233 309.8302443 1642.976989 44831.55965 83 1629.62963 240.7407407 1388.888889 34722.22222 84 1952.807233 298.8770644 1653.930169 43177.62948 84 1620.37037 231.4814815 1388.888889 33333.33333 85 1952.807233 287.8508632 1664.95637 41512.67311 85 1611.111111 222.2222222 1388.888889 31944.44444 86 1952.807233 276.7511541 1676.056079 39836.61704 86 1601.851852 212.962963 1388.888889 30555.55556 87 1952.807233 265.5774469 1687.229786 38149.38725 87 1592.592593 203.7037037 1388.888889 29166.66667 88 1952.807233 254.3292483 1698.477985 36450.90926 88 1583.333333 194.4444444 1388.888889 27777.77778 89 1952.807233 243.0060618 1709.801171 34741.10809 89 1574.074074 185.1851852 1388.888889 26388.88889 90 1952.807233 231.6073873 1721.199846 33019.90825 90 1564.814815 175.9259259 1388.888889 25000 91 1952.807233 220.1327217 1732.674511 31287.23374 91 1555.555556 166.6666667 1388.888889 23611.11111 92 1952.807233 208.5815582 1744.225675 29543.00806 92 1546.296296 157.4074074 1388.888889 22222.22222 93 1952.807233 196.9533871 1755.853846 27787.15422 93 1537.037037 148.1481481 1388.888889 20833.33333 94 1952.807233 185.2476948 1767.559538 26019.59468 94 1527.777778 138.8888889 1388.888889 19444.44444 95 1952.807233 173.4639645 1779.343269 24240.25141 95 1518.518519 129.6296296 1388.888889 18055.55556 96 1952.807233 161.6016761 1791.205557 22449.04585 96 1509.259259 120.3703704 1388.888889 16666.66667 97 1952.807233 149.6603057 1803.146927 20645.89892 97 1500 111.1111111 1388.888889 15277.77778 98 1952.807233 137.6393262 1815.167907 18830.73102 98 1490.740741 101.8518519 1388.888889 13888.88889 99 1952.807233 125.5382068 1827.269026 17003.46199 99 1481.481481 92.59259259 1388.888889 12500 100 1952.807233 113.3564133 1839.45082 15164.01117 100 1472.222222 83.33333333 1388.888889 11111.11111 101 1952.807233 101.0934078 1851.713825 13312.29735 101 1462.962963 74.07407407 1388.888889 9722.222222 102 1952.807233 88.74864897 1864.058584 11448.23876 102 1453.703704 64.81481481 1388.888889 8333.333333 103 1952.807233 76.32159174 1876.485641 9571.75312 103 1444.444444 55.55555556 1388.888889 6944.444444 104 1952.807233 63.81168747 1888.995546 7682.757575 104 1435.185185 46.2962963 1388.888889 5555.555556 105 1952.807233 51.21838383 1901.588849 5781.168725 105 1425.925926 37.03703704 1388.888889 4166.666667 106 1952.807233 38.54112484 1914.266108 3866.902617 106 1416.666667 27.77777778 1388.888889 2777.777778 107 1952.807233 25.77935078 1927.027882 1939.874735 107 1407.407407 18.51851852 1388.888889 1388.888889 108 1952.807233 12.93249823 1939.874735 0.00 108 1398.148148 9.259259259 1388.888889 0.00 60903.18117 54500 54500