Prepayment Analysis     This calculates your amortization schedule with a monthly prepayment or desired term of loan.           Full Amortization Schedule     For the values given below:        Principal Loan Balance: $ 100,000.00      Annual Interest Rate: % 8.5      Amortization Length:   30           Your Results Required Monthly Payment to achieve 15 year loan: $987.47 ($218.56 extra a month) Month Principal Interest Balance Tot Int 1   $279.14   708.33   $99,720.86   $708.33 2   $281.11   706.36   $99,439.75   $1,414.69 3   $283.11   704.36   $99,156.64   $2,119.50 4   $285.11   702.36   $98,871.53   $2,821.86 5   $287.13   700.34   $98,584.40   $3,522.20 6   $289.16   698.31   $98,295.24   $4,220.51 7   $291.21   696.26   $98,004.30   $4,916.77 8   $293.27   694.20   $97,711.30   $5,610.97 9   $295.35   692.12   $97,415.95   $6,303.90 10   $297.44   690.30   $97,118.51   $6,993.93 11   $299.55   687.92   $96,818.96   $7,681.85 12   $301.67   685.80   $96,517.29   $8,367.65 13   $303.81   683.66   $96,213.48   $9,051.31 14   $305.96   681.51   $95,907.52   $9,732.82 15   $308.13   679.34   $95,599.39   $10,412.16 16   $310.31   677.16   $95,289.80   $11,089.32 17   $312.50   674.97   $94,977.30   $11,764.29 18   $314.71   672.76   $94,662.59   $12,437.50 19   $316.94   670.53   $94,345.65   $13,108.30 20   $319.19   668.28   $94,026.46   $13,776.58 21   $321.45   666.20   $93,705.10   $14,442.60 22   $323.73   663.74   $93,381.37   $15,106.34 23   $326.20   661.45   $93,055.35   $15,767.79 24   $328.33   659.14   $92,727.20   $16,426.93 25   $330.65   656.82   $92,396.55   $17,083.75 26   $332.99   654.48   $92,063.56   $17,738.23 27   $335.35   652.12   $91,728.21   $18,390.35 28   $337.73   649.74   $91,390.48   $19,040.90 29   $340.12   647.35   $91,050.36   $19,688.25 30   $342.53   644.94   $90,707.83   $20,333.19 31   $344.96   642.51   $90,362.87   $20,975.70 32   $347.40   640.70   $90,015.47   $21,615.77 33   $349.86   637.61   $89,665.61   $22,253.38 34   $352.34   635.13   $89,313.27   $22,888.51 35   $354.83   632.64   $88,958.44   $23,521.15 36   $357.35   630.12   $88,601.90   $24,151.27 37   $359.87   627.60   $88,242.30   $24,778.87 38   $362.42   625.50   $87,879.88   $25,403.92 39   $364.99   622.48   $87,514.89   $26,026.40 40   $367.57   619.90   $87,147.32   $26,646.30 41   $370.18   617.29   $86,777.14   $27,263.59 42   $372.80   614.67   $86,404.34   $27,878.26 43   $375.44   612.30   $86,028.90   $28,490.29 44   $378.10   609.37   $85,650.80   $29,099.66 45   $380.78   606.69   $85,270.20   $29,706.35 46   $383.47   603.10   $84,886.73   $30,310.35 47   $386.19   601.28   $84,500.54   $30,911.63 48   $388.92   598.55   $84,111.62   $31,510.18 49   $391.68   595.79   $83,719.94   $32,105.97 50   $394.45   593.20   $83,325.49   $32,698.99 51   $397.25   590.22   $82,928.24   $33,289.21 52   $400.60   587.41   $82,528.18   $33,876.62 53   $402.90   584.57   $82,125.28   $34,461.19 54   $405.75   581.72   $81,719.53   $35,042.91 55   $408.62   578.85   $81,310.91   $35,621.76 56   $411.52   575.95   $80,899.39   $36,197.71 57   $414.43   573.40   $80,484.96   $36,770.75 58   $417.37   570.10   $80,067.59   $37,340.85 59   $420.32   567.15   $79,647.27   $37,907.10 60   $423.30   564.17   $79,223.97   $38,471.27 61   $426.30   561.17   $78,797.67   $39,032.44 62   $429.32   558.15   $78,368.35   $39,590.59 63   $432.36   555.11   $77,935.99   $40,145.70 64   $435.42   552.50   $77,500.57   $40,697.75 65   $438.51   548.96   $77,062.60   $41,246.71 66   $441.61   545.86   $76,620.99   $41,792.57 67   $444.74   542.73   $76,176.25   $42,335.30 68   $447.89   539.58   $75,728.36   $42,874.88 69   $451.60   536.41   $75,277.30   $43,411.29 70   $454.26   533.21   $74,823.40   $43,944.50 71   $457.47   529.10   $74,365.93   $44,474.50 72   $460.71   526.76   $73,905.22   $45,001.26 73   $463.97   523.50   $73,441.25   $45,524.76 74   $467.26   520.21   $72,973.99   $46,044.97 75   $470.57   516.90   $72,503.42   $46,561.87 76   $473.90   513.57   $72,029.52   $47,075.44 77   $477.26   510.21   $71,552.26   $47,585.65 78   $480.64   506.83   $71,071.62   $48,092.48 79   $484.50   503.42   $70,587.57   $48,595.90 80   $487.47   499.10   $70,100.10   $49,095.90 81   $490.93   496.54   $69,609.17   $49,592.44 82   $494.41   493.60   $69,114.76   $50,085.50 83   $497.91   489.56   $68,616.85   $50,575.60 84   $501.43   486.40   $68,115.42   $51,061.64 85   $504.99   482.48   $67,610.43   $51,544.12 86   $508.56   478.91   $67,101.87   $52,023.30 87   $512.17   475.30   $66,589.70   $52,498.60 88   $515.79   471.68   $66,073.91   $52,970.28 89   $519.45   468.20   $65,554.46   $53,438.30 90   $523.13   464.34   $65,031.33   $53,902.64 91   $526.83   460.64   $64,504.50   $54,363.28 92   $530.56   456.91   $63,973.94   $54,820.19 93   $534.32   453.15   $63,439.62   $55,273.34 94   $538.11   449.36   $62,901.51   $55,722.70 95   $541.92   445.55   $62,359.59   $56,168.25 96   $545.76   441.71   $61,813.83   $56,609.96 97   $549.62   437.85   $61,264.21   $57,047.81 98   $553.52   433.95   $60,710.69   $57,481.76 99   $557.44   430.30   $60,153.25   $57,911.79 100   $561.38   426.90   $59,591.87   $58,337.88 101   $565.36   422.11   $59,026.51   $58,759.99 102   $569.37   418.10   $58,457.14   $59,178.90 103   $573.40   414.70   $57,883.74   $59,592.97 104   $577.46   410.10   $57,306.28   $60,002.98 105   $581.55   405.92   $56,724.73   $60,408.90 106   $585.67   401.80   $56,139.60   $60,810.70 107   $589.81   397.66   $55,549.79   $61,208.36 108   $593.99   393.48   $54,955.80   $61,601.84 109   $598.20   389.27   $54,357.60   $61,991.11 110   $602.44   385.30   $53,755.16   $62,376.14 111   $606.70   380.77   $53,148.46   $62,756.91 112   $611.0   376.47   $52,537.46   $63,133.38 113   $615.33   372.14   $51,922.13   $63,505.52 114   $619.69   367.78   $51,302.44   $63,873.30 115   $624.80   363.39   $50,678.36   $64,236.69 116   $628.50   358.97   $50,049.86   $64,595.66 117   $632.95   354.52   $49,416.91   $64,950.18 118   $637.43   350.40   $48,779.48   $65,300.22 119   $641.95   345.52   $48,137.53   $65,645.74 120   $646.50   340.97   $47,491.30   $65,986.71 121   $651.70   336.40   $46,840.23   $66,323.11 122   $655.69   331.78   $46,184.54   $66,654.89 123   $660.33   327.14   $45,524.21   $66,982.30 124   $665.10   322.46   $44,859.20   $67,304.76 125   $669.72   317.75   $44,189.48   $67,622.51 126   $674.46   313.10   $43,515.20   $67,935.52 127   $679.24   308.23   $42,835.96   $68,243.75 128   $684.50   303.42   $42,151.91   $68,547.17 129   $688.89   298.58   $41,463.20   $68,845.75 130   $693.77   293.70   $40,769.43   $69,139.45 131   $698.69   288.78   $40,070.74   $69,428.23 132   $703.64   283.83   $39,367.10   $69,712.60 133   $708.62   278.85   $38,658.48   $69,991.45 134   $713.64   273.83   $37,944.84   $70,265.28 135   $718.69   268.78   $37,226.15   $70,534.60 136   $723.78   263.69   $36,502.37   $70,798.29 137   $728.91   258.56   $35,773.46   $71,056.85 138   $734.70   253.40   $35,039.39   $71,310.25 139   $739.27   248.20   $34,300.12   $71,558.45 140   $744.51   242.96   $33,555.61   $71,801.41 141   $749.78   237.69   $32,805.83   $72,039.10 142   $755.10   232.37   $32,050.73   $72,271.47 143   $760.44   227.30   $31,290.29   $72,498.50 144   $765.83   221.64   $30,524.46   $72,720.14 145   $771.26   216.21   $29,753.20   $72,936.35 146   $776.72   210.75   $28,976.48   $73,147.10 147   $782.22   205.25   $28,194.26   $73,352.35 148   $787.76   199.71   $27,406.50   $73,552.60 149   $793.34   194.13   $26,613.16   $73,746.73 150   $798.96   188.51   $25,814.20   $73,935.24 151   $804.62   182.85   $25,009.58   $74,118.90 152   $810.32   177.15   $24,199.26   $74,296.50 153   $816.60   171.41   $23,383.20   $74,467.91 154   $821.84   165.63   $22,561.36   $74,633.54 155   $827.66   159.81   $21,733.70   $74,793.35 156   $833.52   153.95   $20,900.18   $74,947.30 157   $839.43   148.40   $20,060.75   $75,095.34 158   $845.37   142.10   $19,215.38   $75,237.44 159   $851.36   136.11   $18,364.20   $75,373.55 160   $857.39   130.80   $17,506.81   $75,503.63 161   $863.46   124.10   $16,643.35   $75,627.64 162   $869.58   117.89   $15,773.77   $75,745.53 163   $875.74   111.73   $14,898.30   $75,857.26 164   $881.94   105.53   $14,016.36   $75,962.79 165   $888.19   99.28   $13,128.17   $76,062.70 166   $894.48   92.99   $12,233.69   $76,155.69 167   $900.81   86.66   $11,332.88   $76,242.35 168   $907.20   80.27   $10,425.68   $76,322.62 169   $913.62   73.85   $9,512.60   $76,396.47 170   $920.90   67.38   $8,592.51   $76,463.85 171   $926.61   60.86   $7,665.90   $76,524.71 172   $933.17   54.30   $6,732.73   $76,579.10 173   $939.78   47.69   $5,792.95   $76,626.79 174   $946.44   41.30   $4,846.51   $76,667.82 175   $953.14   34.33   $3,893.37   $76,702.15 176   $959.89   27.58   $2,933.48   $76,729.73 177   $966.69   20.78   $1,966.79   $76,750.51 178   $973.54   13.93   $993.25   $76,764.44 179   $980.43   7.40   $12.82   $76,771.48 180   $987.38   0.90   $-974.56   $76,771.57           Explanation This has calculated the monthly payment of $987.47 which is needed to cut your loan from 30 years to 15 years. The accuracy and use of this calculator is not guaranteed.

ERIC S HARLINGTON
Certified Mortgage Planner, Br Manager

phone. 253-848-2136 
fax. 866-849-7484