home *** CD-ROM | disk | FTP | other *** search
Text File | 1994-10-30 | 12.6 KB | 434 lines | [TEXT/MMCC] |
-
- *** Amortization Schedule ***
-
- Principal: 120000.00
- Future value: 347596.50
- Term of loan in years: 30.0
- Interest Rate: 9.000
- Total Interest Charge: 227596.50
- Payment: 965.55
-
- MONTH PRINCIPAL INTEREST BALANCE
- 1 65.55 900.00 119934.45
- 2 66.04 899.51 119868.41
- 3 66.53 899.01 119801.88
- 4 67.03 898.51 119734.85
- 5 67.53 898.01 119667.32
- 6 68.04 897.50 119599.28
- 7 68.55 896.99 119530.73
- 8 69.07 896.48 119461.66
- 9 69.58 895.96 119392.08
- 10 70.11 895.44 119321.98
- 11 70.63 894.91 119251.34
- 12 71.16 894.39 119180.18
- Interest paid for year 1 is 10766.73
-
- 13 71.69 893.85 119108.48
- 14 72.23 893.31 119036.25
- 15 72.77 892.77 118963.48
- 16 73.32 892.23 118890.16
- 17 73.87 891.68 118816.29
- 18 74.42 891.12 118741.87
- 19 74.98 890.56 118666.88
- 20 75.54 890.00 118591.34
- 21 76.11 889.44 118515.23
- 22 76.68 888.86 118438.55
- 23 77.26 888.29 118361.29
- 24 77.84 887.71 118283.45
- Interest paid for year 2 is 10689.83
-
- 25 78.42 887.13 118205.03
- 26 79.01 886.54 118126.02
- 27 79.60 885.95 118046.42
- 28 80.20 885.35 117966.23
- 29 80.80 884.75 117885.43
- 30 81.41 884.14 117804.02
- 31 82.02 883.53 117722.01
- 32 82.63 882.92 117639.38
- 33 83.25 882.30 117556.12
- 34 83.87 881.67 117472.25
- 35 84.50 881.04 117387.75
- 36 85.14 880.41 117302.61
- Interest paid for year 3 is 10605.71
-
- 37 85.78 879.77 117216.84
- 38 86.42 879.13 117130.41
- 39 87.07 878.48 117043.34
- 40 87.72 877.83 116955.62
- 41 88.38 877.17 116867.25
- 42 89.04 876.50 116778.21
- 43 89.71 875.84 116688.50
- 44 90.38 875.16 116598.12
- 45 91.06 874.49 116507.05
- 46 91.74 873.80 116415.31
- 47 92.43 873.11 116322.88
- 48 93.12 872.42 116229.76
- Interest paid for year 4 is 10513.70
-
- 49 93.82 871.72 116135.94
- 50 94.53 871.02 116041.41
- 51 95.24 870.31 115946.18
- 52 95.95 869.60 115850.23
- 53 96.67 868.88 115753.55
- 54 97.39 868.15 115656.16
- 55 98.12 867.42 115558.04
- 56 98.86 866.69 115459.18
- 57 99.60 865.94 115359.58
- 58 100.35 865.20 115259.23
- 59 101.10 864.44 115158.12
- 60 101.86 863.69 115056.27
- Interest paid for year 5 is 10413.06
-
- 61 102.62 862.92 114953.64
- 62 103.39 862.15 114850.25
- 63 104.17 861.38 114746.08
- 64 104.95 860.60 114641.12
- 65 105.74 859.81 114535.39
- 66 106.53 859.02 114428.86
- 67 107.33 858.22 114321.53
- 68 108.13 857.41 114213.40
- 69 108.95 856.60 114104.45
- 70 109.76 855.78 113994.69
- 71 110.59 854.96 113884.10
- 72 111.42 854.13 113772.69
- Interest paid for year 6 is 10302.97
-
- 73 112.25 853.30 113660.44
- 74 113.09 852.45 113547.34
- 75 113.94 851.61 113433.41
- 76 114.80 850.75 113318.61
- 77 115.66 849.89 113202.95
- 78 116.52 849.02 113086.43
- 79 117.40 848.15 112969.03
- 80 118.28 847.27 112850.75
- 81 119.17 846.38 112731.59
- 82 120.06 845.49 112611.52
- 83 120.96 844.59 112490.56
- 84 121.87 843.68 112368.70
- Interest paid for year 7 is 10182.57
-
- 85 122.78 842.77 112245.91
- 86 123.70 841.84 112122.21
- 87 124.63 840.92 111997.58
- 88 125.56 839.98 111872.02
- 89 126.51 839.04 111745.51
- 90 127.45 838.09 111618.05
- 91 128.41 837.14 111489.64
- 92 129.37 836.17 111360.27
- 93 130.34 835.20 111229.92
- 94 131.32 834.22 111098.60
- 95 132.31 833.24 110966.30
- 96 133.30 832.25 110833.00
- Interest paid for year 8 is 10050.86
-
- 97 134.30 831.25 110698.70
- 98 135.31 830.24 110563.40
- 99 136.32 829.23 110427.08
- 100 137.34 828.20 110289.73
- 101 138.37 827.17 110151.36
- 102 139.41 826.14 110011.95
- 103 140.46 825.09 109871.49
- 104 141.51 824.04 109729.98
- 105 142.57 822.97 109587.41
- 106 143.64 821.91 109443.77
- 107 144.72 820.83 109299.05
- 108 145.80 819.74 109153.25
- Interest paid for year 9 is 9906.80
-
- 109 146.90 818.65 109006.35
- 110 148.00 817.55 108858.35
- 111 149.11 816.44 108709.24
- 112 150.23 815.32 108559.02
- 113 151.35 814.19 108407.66
- 114 152.49 813.06 108255.17
- 115 153.63 811.91 108101.54
- 116 154.78 810.76 107946.76
- 117 155.95 809.60 107790.81
- 118 157.11 808.43 107633.70
- 119 158.29 807.25 107475.40
- 120 159.48 806.07 107315.92
- Interest paid for year 10 is 9749.23
-
- 121 160.68 804.87 107155.24
- 122 161.88 803.66 106993.36
- 123 163.10 802.45 106830.27
- 124 164.32 801.23 106665.95
- 125 165.55 799.99 106500.39
- 126 166.79 798.75 106333.60
- 127 168.04 797.50 106165.55
- 128 169.30 796.24 105996.25
- 129 170.57 794.97 105825.68
- 130 171.85 793.69 105653.83
- 131 173.14 792.40 105480.69
- 132 174.44 791.11 105306.25
- Interest paid for year 11 is 9576.88
-
- 133 175.75 789.80 105130.50
- 134 177.07 788.48 104953.43
- 135 178.40 787.15 104775.03
- 136 179.73 785.81 104595.30
- 137 181.08 784.46 104414.22
- 138 182.44 783.11 104231.78
- 139 183.81 781.74 104047.98
- 140 185.19 780.36 103862.79
- 141 186.57 778.97 103676.21
- 142 187.97 777.57 103488.23
- 143 189.38 776.16 103298.85
- 144 190.80 774.74 103108.05
- Interest paid for year 12 is 9388.35
-
- 145 192.24 773.31 102915.81
- 146 193.68 771.87 102722.13
- 147 195.13 770.42 102527.00
- 148 196.59 768.95 102330.41
- 149 198.07 767.48 102132.34
- 150 199.55 765.99 101932.78
- 151 201.05 764.50 101731.73
- 152 202.56 762.99 101529.18
- 153 204.08 761.47 101325.10
- 154 205.61 759.94 101119.49
- 155 207.15 758.40 100912.34
- 156 208.70 756.84 100703.64
- Interest paid for year 13 is 9182.15
-
- 157 210.27 755.28 100493.38
- 158 211.85 753.70 100281.53
- 159 213.43 752.11 100068.09
- 160 215.04 750.51 99853.06
- 161 216.65 748.90 99636.41
- 162 218.27 747.27 99418.14
- 163 219.91 745.64 99198.23
- 164 221.56 743.99 98976.67
- 165 223.22 742.33 98753.45
- 166 224.89 740.65 98528.55
- 167 226.58 738.96 98301.98
- 168 228.28 737.26 98073.70
- Interest paid for year 14 is 8956.60
-
- 169 229.99 735.55 97843.70
- 170 231.72 733.83 97611.98
- 171 233.46 732.09 97378.53
- 172 235.21 730.34 97143.33
- 173 236.97 728.58 96906.36
- 174 238.75 726.80 96667.61
- 175 240.54 725.01 96427.07
- 176 242.34 723.20 96184.73
- 177 244.16 721.39 95940.56
- 178 245.99 719.55 95694.57
- 179 247.84 717.71 95446.73
- 180 249.70 715.85 95197.04
- Interest paid for year 15 is 8709.89
-
- 181 251.57 713.98 94945.47
- 182 253.45 712.09 94692.02
- 183 255.36 710.19 94436.66
- 184 257.27 708.27 94179.38
- 185 259.20 706.35 93920.18
- 186 261.14 704.40 93659.04
- 187 263.10 702.44 93395.94
- 188 265.08 700.47 93130.86
- 189 267.06 698.48 92863.80
- 190 269.07 696.48 92594.73
- 191 271.09 694.46 92323.64
- 192 273.12 692.43 92050.52
- Interest paid for year 16 is 8440.04
-
- 193 275.17 690.38 91775.36
- 194 277.23 688.32 91498.12
- 195 279.31 686.24 91218.81
- 196 281.40 684.14 90937.41
- 197 283.52 682.03 90653.89
- 198 285.64 679.90 90368.25
- 199 287.78 677.76 90080.47
- 200 289.94 675.60 89790.52
- 201 292.12 673.43 89498.41
- 202 294.31 671.24 89204.10
- 203 296.52 669.03 88907.59
- 204 298.74 666.81 88608.84
- Interest paid for year 17 is 8144.88
-
- 205 300.98 664.57 88307.87
- 206 303.24 662.31 88004.63
- 207 305.51 660.03 87699.12
- 208 307.80 657.74 87391.32
- 209 310.11 655.43 87081.21
- 210 312.44 653.11 86768.77
- 211 314.78 650.77 86453.99
- 212 317.14 648.40 86136.85
- 213 319.52 646.03 85817.34
- 214 321.92 643.63 85495.42
- 215 324.33 641.22 85171.09
- 216 326.76 638.78 84844.33
- Interest paid for year 18 is 7822.02
-
- 217 329.21 636.33 84515.12
- 218 331.68 633.86 84183.44
- 219 334.17 631.38 83849.27
- 220 336.68 628.87 83512.59
- 221 339.20 626.34 83173.38
- 222 341.75 623.80 82831.64
- 223 344.31 621.24 82487.34
- 224 346.89 618.66 82140.45
- 225 349.49 616.05 81790.95
- 226 352.11 613.43 81438.84
- 227 354.75 610.79 81084.08
- 228 357.42 608.13 80726.66
- Interest paid for year 19 is 7468.89
-
- 229 360.10 605.45 80366.57
- 230 362.80 602.75 80003.77
- 231 365.52 600.03 79638.26
- 232 368.26 597.29 79270.00
- 233 371.02 594.53 78898.98
- 234 373.80 591.74 78525.17
- 235 376.61 588.94 78148.56
- 236 379.43 586.11 77769.13
- 237 382.28 583.27 77386.86
- 238 385.14 580.40 77001.72
- 239 388.03 577.51 76613.69
- 240 390.94 574.60 76222.74
- Interest paid for year 20 is 7082.62
-
- 241 393.88 571.67 75828.87
- 242 396.83 568.72 75432.04
- 243 399.81 565.74 75032.23
- 244 402.80 562.74 74629.43
- 245 405.83 559.72 74223.60
- 246 408.87 556.68 73814.73
- 247 411.94 553.61 73402.80
- 248 415.02 550.52 72987.77
- 249 418.14 547.41 72569.63
- 250 421.27 544.27 72148.36
- 251 424.43 541.11 71723.93
- 252 427.62 537.93 71296.31
- Interest paid for year 21 is 6660.12
-
- 253 430.82 534.72 70865.49
- 254 434.05 531.49 70431.44
- 255 437.31 528.24 69994.12
- 256 440.59 524.96 69553.53
- 257 443.89 521.65 69109.64
- 258 447.22 518.32 68662.41
- 259 450.58 514.97 68211.84
- 260 453.96 511.59 67757.88
- 261 457.36 508.18 67300.52
- 262 460.79 504.75 66839.73
- 263 464.25 501.30 66375.48
- 264 467.73 497.82 65907.75
- Interest paid for year 22 is 6197.99
-
- 265 471.24 494.31 65436.51
- 266 474.77 490.77 64961.74
- 267 478.33 487.21 64483.41
- 268 481.92 483.63 64001.48
- 269 485.53 480.01 63515.95
- 270 489.18 476.37 63026.77
- 271 492.85 472.70 62533.93
- 272 496.54 469.00 62037.39
- 273 500.27 465.28 61537.12
- 274 504.02 461.53 61033.11
- 275 507.80 457.75 60525.31
- 276 511.61 453.94 60013.70
- Interest paid for year 23 is 5692.50
-
- 277 515.44 450.10 59498.26
- 278 519.31 446.24 58978.95
- 279 523.20 442.34 58455.75
- 280 527.13 438.42 57928.62
- 281 531.08 434.46 57397.54
- 282 535.06 430.48 56862.48
- 283 539.08 426.47 56323.40
- 284 543.12 422.43 55780.28
- 285 547.19 418.35 55233.08
- 286 551.30 414.25 54681.79
- 287 555.43 410.11 54126.35
- 288 559.60 405.95 53566.75
- Interest paid for year 24 is 5139.60
-
- 289 563.80 401.75 53002.96
- 290 568.02 397.52 52434.93
- 291 572.28 393.26 51862.65
- 292 576.58 388.97 51286.07
- 293 580.90 384.65 50705.18
- 294 585.26 380.29 50119.92
- 295 589.65 375.90 49530.27
- 296 594.07 371.48 48936.20
- 297 598.52 367.02 48337.68
- 298 603.01 362.53 47734.67
- 299 607.54 358.01 47127.13
- 300 612.09 353.45 46515.04
- Interest paid for year 25 is 4534.83
-
- 301 616.68 348.86 45898.36
- 302 621.31 344.24 45277.05
- 303 625.97 339.58 44651.08
- 304 630.66 334.88 44020.41
- 305 635.39 330.15 43385.02
- 306 640.16 325.39 42744.86
- 307 644.96 320.59 42099.90
- 308 649.80 315.75 41450.10
- 309 654.67 310.88 40795.43
- 310 659.58 305.97 40135.85
- 311 664.53 301.02 39471.32
- 312 669.51 296.03 38801.81
- Interest paid for year 26 is 3873.33
-
- 313 674.53 291.01 38127.28
- 314 679.59 285.95 37447.69
- 315 684.69 280.86 36763.00
- 316 689.82 275.72 36073.18
- 317 695.00 270.55 35378.18
- 318 700.21 265.34 34677.97
- 319 705.46 260.08 33972.51
- 320 710.75 254.79 33261.76
- 321 716.08 249.46 32545.68
- 322 721.45 244.09 31824.22
- 323 726.86 238.68 31097.36
- 324 732.32 233.23 30365.04
- Interest paid for year 27 is 3149.78
-
- 325 737.81 227.74 29627.23
- 326 743.34 222.20 28883.89
- 327 748.92 216.63 28134.98
- 328 754.53 211.01 27380.44
- 329 760.19 205.35 26620.25
- 330 765.89 199.65 25854.36
- 331 771.64 193.91 25082.72
- 332 777.43 188.12 24305.29
- 333 783.26 182.29 23522.04
- 334 789.13 176.42 22732.90
- 335 795.05 170.50 21937.86
- 336 801.01 164.53 21136.84
- Interest paid for year 28 is 2358.35
-
- 337 807.02 158.53 20329.82
- 338 813.07 152.47 19516.75
- 339 819.17 146.38 18697.58
- 340 825.31 140.23 17872.27
- 341 831.50 134.04 17040.76
- 342 837.74 127.81 16203.02
- 343 844.02 121.52 15359.00
- 344 850.35 115.19 14508.65
- 345 856.73 108.81 13651.92
- 346 863.16 102.39 12788.76
- 347 869.63 95.92 11919.13
- 348 876.15 89.39 11042.98
- Interest paid for year 29 is 1492.68
-
- 349 882.72 82.82 10160.25
- 350 889.34 76.20 9270.91
- 351 896.01 69.53 8374.90
- 352 902.73 62.81 7472.16
- 353 909.50 56.04 6562.66
- 354 916.33 49.22 5646.33
- 355 923.20 42.35 4723.13
- 356 930.12 35.42 3793.01
- 357 937.10 28.45 2855.91
- 358 944.13 21.42 1911.79
- 359 951.21 14.34 960.58
- 360 958.34 7.20 2.24
- Interest paid for year 30 is 545.81
-
- Interest paid for year 31 is 0.00
-
-