AMORTIZATION SCHEDULE
NOTE AMT: $160,000.00 CALC. PMNT: $1,198.04
STATED PMNT: $1,198.04
INT. RATE: 7.6500% (ie.  12%=.12)
LOAN DATE: 6/1/2006
TERM: 25 IN YEARS
Date Pmt # Total Payment Principle Interest Balance CPLTD
6/1/2006         $160,000.00  
7/1/2006 1 1,198.04 178.04 1,020.00 159,821.96 2,227.13
8/1/2006 2 1,198.04 179.18 1,018.86 159,642.78 2,241.32
9/1/2006 3 1,198.04 180.32 1,017.72 159,462.46 2,255.61
10/1/2006 4 1,198.04 181.47 1,016.57 159,280.99 2,269.99
11/1/2006 5 1,198.04 182.62 1,015.42 159,098.37 2,284.46
12/1/2006 6 1,198.04 183.79 1,014.25 158,914.58 2,299.02
1/1/2007 7 1,198.04 184.96 1,013.08 158,729.62 2,313.68
2/1/2007 8 1,198.04 186.14 1,011.90 158,543.48 2,328.43
3/1/2007 9 1,198.04 187.33 1,010.71 158,356.15 2,343.27
4/1/2007 10 1,198.04 188.52 1,009.52 158,167.63 2,358.21
5/1/2007 11 1,198.04 189.72 1,008.32 157,977.91 2,373.24
6/1/2007 12 1,198.04 190.93 1,007.11 157,786.98 2,388.37
7/1/2007 13 1,198.04 192.15 1,005.89 157,594.83 2,403.59
8/1/2007 14 1,198.04 193.37 1,004.67 157,401.46 2,418.92
9/1/2007 15 1,198.04 194.61 1,003.43 157,206.85 2,434.34
10/1/2007 16 1,198.04 195.85 1,002.19 157,011.00 2,449.86
11/1/2007 17 1,198.04 197.09 1,000.95 156,813.91 2,465.48
12/1/2007 18 1,198.04 198.35 999.69 156,615.56 2,481.20
1/1/2008 19 1,198.04 199.62 998.42 156,415.94 2,497.01
2/1/2008 20 1,198.04 200.89 997.15 156,215.05 2,512.93
3/1/2008 21 1,198.04 202.17 995.87 156,012.88 2,528.95
4/1/2008 22 1,198.04 203.46 994.58 155,809.42 2,545.07
5/1/2008 23 1,198.04 204.75 993.29 155,604.67 2,561.30
6/1/2008 24 1,198.04 206.06 991.98 155,398.61 2,577.63
7/1/2008 25 1,198.04 207.37 990.67 155,191.24 2,594.07
8/1/2008 26 1,198.04 208.70 989.34 154,982.54 2,610.60
9/1/2008 27 1,198.04 210.03 988.01 154,772.51 2,627.24
10/1/2008 28 1,198.04 211.37 986.67 154,561.14 2,643.98
11/1/2008 29 1,198.04 212.71 985.33 154,348.43 2,660.84
12/1/2008 30 1,198.04 214.07 983.97 154,134.36 2,677.80
1/1/2009 31 1,198.04 215.43 982.61 153,918.93 2,694.87
2/1/2009 32 1,198.04 216.81 981.23 153,702.12 2,712.05
3/1/2009 33 1,198.04 218.19 979.85 153,483.93 2,729.34
4/1/2009 34 1,198.04 219.58 978.46 153,264.35 2,746.74
5/1/2009 35 1,198.04 220.98 977.06 153,043.37 2,764.25
6/1/2009 36 1,198.04 222.39 975.65 152,820.98 2,781.87
7/1/2009 37 1,198.04 223.81 974.23 152,597.17 2,799.60
8/1/2009 38 1,198.04 225.23 972.81 152,371.94 2,817.45
9/1/2009 39 1,198.04 226.67 971.37 152,145.27 2,835.41
10/1/2009 40 1,198.04 228.11 969.93 151,917.16 2,853.49
11/1/2009 41 1,198.04 229.57 968.47 151,687.59 2,871.68
12/1/2009 42 1,198.04 231.03 967.01 151,456.56 2,889.99
1/1/2010 43 1,198.04 232.50 965.54 151,224.06 2,908.42
2/1/2010 44 1,198.04 233.99 964.05 150,990.07 2,926.96
3/1/2010 45 1,198.04 235.48 962.56 150,754.59 2,945.62
4/1/2010 46 1,198.04 236.98 961.06 150,517.61 2,964.40
5/1/2010 47 1,198.04 238.49 959.55 150,279.12 2,983.30
6/1/2010 48 1,198.04 240.01 958.03 150,039.11 3,002.32
7/1/2010 49 1,198.04 241.54 956.50 149,797.57 2,760.78
8/1/2010 50 1,198.04 243.08 954.96 149,554.49 2,517.70
9/1/2010 51 1,198.04 244.63 953.41 149,309.86 2,273.07
10/1/2010 52 1,198.04 246.19 951.85 149,063.67 2,026.88
11/1/2010 53 1,198.04 247.76 950.28 148,815.91 1,779.12
12/1/2010 54 1,198.04 249.34 948.70 148,566.57 1,529.78
1/1/2011 55 1,198.04 250.93 947.11 148,315.64 1,278.85
2/1/2011 56 1,198.04 252.53 945.51 148,063.11 1,026.32
3/1/2011 57 1,198.04 254.14 943.90 147,808.97 772.18
4/1/2011 58 1,198.04 255.76 942.28 147,553.21 516.42
5/1/2011 59 1,198.04 257.39 940.65 147,295.82 259.03
6/1/2011 60 1,198.04 259.03 939.01 147,036.79 0.00

Click filename below to access file

Amortization Calculator.xls




Business Forms Privacy Policy Also See Terms of Service.