Excel Spreadsheet

Amortization Calculator Template

You must be logged in to download this document
Reviews
Shared by: Katrina Golden
Stats
views:
119
downloads:
6
rating:
not rated
reviews:
0
posted:
4/8/2008
language:
English
pages:
0
AMORTIZATION SCHEDULE NOTE AMT: STATED PMNT: INT. RATE: LOAN DATE: TERM: Date Pmt # 6/1/2006 7/1/2006 1 8/1/2006 2 9/1/2006 3 10/1/2006 4 11/1/2006 5 12/1/2006 6 1/1/2007 7 2/1/2007 8 3/1/2007 9 4/1/2007 10 5/1/2007 11 6/1/2007 12 7/1/2007 13 8/1/2007 14 9/1/2007 15 10/1/2007 16 11/1/2007 17 12/1/2007 18 1/1/2008 19 2/1/2008 20 3/1/2008 21 4/1/2008 22 5/1/2008 23 6/1/2008 24 7/1/2008 25 8/1/2008 26 9/1/2008 27 10/1/2008 28 11/1/2008 29 12/1/2008 30 1/1/2009 31 2/1/2009 32 3/1/2009 33 4/1/2009 34 5/1/2009 35 6/1/2009 36 7/1/2009 37 8/1/2009 38 9/1/2009 39 10/1/2009 40 11/1/2009 41 12/1/2009 42 1/1/2010 43 2/1/2010 44 3/1/2010 45 4/1/2010 46 5/1/2010 47 6/1/2010 48 7/1/2010 49 8/1/2010 50 9/1/2010 51 10/1/2010 52 11/1/2010 53 12/1/2010 54 1/1/2011 55 2/1/2011 56 3/1/2011 57 4/1/2011 58 5/1/2011 59 6/1/2011 60 $160,000.00 $1,198.04 7.6500% (ie. 12%=.12) 6/1/2006 25 IN YEARS Total Payment 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 1,198.04 Principle 178.04 179.18 180.32 181.47 182.62 183.79 184.96 186.14 187.33 188.52 189.72 190.93 192.15 193.37 194.61 195.85 197.09 198.35 199.62 200.89 202.17 203.46 204.75 206.06 207.37 208.70 210.03 211.37 212.71 214.07 215.43 216.81 218.19 219.58 220.98 222.39 223.81 225.23 226.67 228.11 229.57 231.03 232.50 233.99 235.48 236.98 238.49 240.01 241.54 243.08 244.63 246.19 247.76 249.34 250.93 252.53 254.14 255.76 257.39 259.03 CALC. PMNT: $1,198.04 Interest 1,020.00 1,018.86 1,017.72 1,016.57 1,015.42 1,014.25 1,013.08 1,011.90 1,010.71 1,009.52 1,008.32 1,007.11 1,005.89 1,004.67 1,003.43 1,002.19 1,000.95 999.69 998.42 997.15 995.87 994.58 993.29 991.98 990.67 989.34 988.01 986.67 985.33 983.97 982.61 981.23 979.85 978.46 977.06 975.65 974.23 972.81 971.37 969.93 968.47 967.01 965.54 964.05 962.56 961.06 959.55 958.03 956.50 954.96 953.41 951.85 950.28 948.70 947.11 945.51 943.90 942.28 940.65 939.01 Balance $160,000.00 159,821.96 159,642.78 159,462.46 159,280.99 159,098.37 158,914.58 158,729.62 158,543.48 158,356.15 158,167.63 157,977.91 157,786.98 157,594.83 157,401.46 157,206.85 157,011.00 156,813.91 156,615.56 156,415.94 156,215.05 156,012.88 155,809.42 155,604.67 155,398.61 155,191.24 154,982.54 154,772.51 154,561.14 154,348.43 154,134.36 153,918.93 153,702.12 153,483.93 153,264.35 153,043.37 152,820.98 152,597.17 152,371.94 152,145.27 151,917.16 151,687.59 151,456.56 151,224.06 150,990.07 150,754.59 150,517.61 150,279.12 150,039.11 149,797.57 149,554.49 149,309.86 149,063.67 148,815.91 148,566.57 148,315.64 148,063.11 147,808.97 147,553.21 147,295.82 147,036.79 CPLTD 2,227.13 2,241.32 2,255.61 2,269.99 2,284.46 2,299.02 2,313.68 2,328.43 2,343.27 2,358.21 2,373.24 2,388.37 2,403.59 2,418.92 2,434.34 2,449.86 2,465.48 2,481.20 2,497.01 2,512.93 2,528.95 2,545.07 2,561.30 2,577.63 2,594.07 2,610.60 2,627.24 2,643.98 2,660.84 2,677.80 2,694.87 2,712.05 2,729.34 2,746.74 2,764.25 2,781.87 2,799.60 2,817.45 2,835.41 2,853.49 2,871.68 2,889.99 2,908.42 2,926.96 2,945.62 2,964.40 2,983.30 3,002.32 2,760.78 2,517.70 2,273.07 2,026.88 1,779.12 1,529.78 1,278.85 1,026.32 772.18 516.42 259.03 0.00 AMORTIZATION SCHEDULE NOTE AMT: STATED PMNT: INT. RATE: LOAN DATE: TERM: Date Pmt # 6/1/2006 7/1/2006 1 8/1/2006 2 9/1/2006 3 10/1/2006 4 11/1/2006 5 12/1/2006 6 1/1/2007 7 2/1/2007 8 3/1/2007 9 4/1/2007 10 5/1/2007 11 6/1/2007 12 7/1/2007 13 8/1/2007 14 9/1/2007 15 10/1/2007 16 11/1/2007 17 12/1/2007 18 1/1/2008 19 2/1/2008 20 3/1/2008 21 4/1/2008 22 5/1/2008 23 6/1/2008 24 7/1/2008 25 8/1/2008 26 9/1/2008 27 10/1/2008 28 11/1/2008 29 12/1/2008 30 1/1/2009 31 2/1/2009 32 3/1/2009 33 4/1/2009 34 5/1/2009 35 6/1/2009 36 7/1/2009 37 8/1/2009 38 9/1/2009 39 10/1/2009 40 11/1/2009 41 12/1/2009 42 1/1/2010 43 2/1/2010 44 3/1/2010 45 4/1/2010 46 5/1/2010 47 6/1/2010 48 7/1/2010 49 8/1/2010 50 9/1/2010 51 10/1/2010 52 11/1/2010 53 12/1/2010 54 1/1/2011 55 2/1/2011 56 3/1/2011 57 4/1/2011 58 5/1/2011 59 6/1/2011 60 $75,000.00 $561.58 7.6500% (ie. 12%=.12) 6/1/2006 25 IN YEARS Total Payment 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 561.58 Principle 83.45 83.99 84.52 85.06 85.60 86.15 86.70 87.25 87.81 88.37 88.93 89.50 90.07 90.64 91.22 91.80 92.39 92.98 93.57 94.16 94.77 95.37 95.98 96.59 97.21 97.82 98.45 99.08 99.71 100.34 100.98 101.63 102.27 102.93 103.58 104.24 104.91 105.58 106.25 106.93 107.61 108.29 108.98 109.68 110.38 111.08 111.79 112.50 113.22 113.94 114.67 115.40 116.14 116.88 117.62 118.37 119.13 119.88 120.65 121.42 CALC. PMNT: $561.58 Interest 478.13 477.59 477.06 476.52 475.98 475.43 474.88 474.33 473.77 473.21 472.65 472.08 471.51 470.94 470.36 469.78 469.19 468.60 468.01 467.42 466.81 466.21 465.60 464.99 464.37 463.76 463.13 462.50 461.87 461.24 460.60 459.95 459.31 458.65 458.00 457.34 456.67 456.00 455.33 454.65 453.97 453.29 452.60 451.90 451.20 450.50 449.79 449.08 448.36 447.64 446.91 446.18 445.44 444.70 443.96 443.21 442.45 441.70 440.93 440.16 Balance $75,000.00 74,916.55 74,832.56 74,748.04 74,662.98 74,577.38 74,491.23 74,404.53 74,317.28 74,229.47 74,141.10 74,052.17 73,962.67 73,872.60 73,781.96 73,690.74 73,598.94 73,506.55 73,413.57 73,320.00 73,225.84 73,131.07 73,035.70 72,939.72 72,843.13 72,745.92 72,648.10 72,549.65 72,450.57 72,350.86 72,250.52 72,149.54 72,047.91 71,945.64 71,842.71 71,739.13 71,634.89 71,529.98 71,424.40 71,318.15 71,211.22 71,103.61 70,995.32 70,886.34 70,776.66 70,666.28 70,555.20 70,443.41 70,330.91 70,217.69 70,103.75 69,989.08 69,873.68 69,757.54 69,640.66 69,523.04 69,404.67 69,285.54 69,165.66 69,045.01 68,923.59 CPLTD 1,043.95 1,050.60 1,057.30 1,064.04 1,070.83 1,077.66 1,084.53 1,091.44 1,098.40 1,105.40 1,112.45 1,119.54 1,126.68 1,133.86 1,141.09 1,148.37 1,155.69 1,163.05 1,170.46 1,177.93 1,185.43 1,192.99 1,200.59 1,208.24 1,215.94 1,223.70 1,231.50 1,239.35 1,247.25 1,255.20 1,263.20 1,271.25 1,279.36 1,287.51 1,295.72 1,303.98 1,312.29 1,320.65 1,329.07 1,337.54 1,346.07 1,354.66 1,363.30 1,371.99 1,380.74 1,389.54 1,398.40 1,407.32 1,294.10 1,180.16 1,065.49 950.09 833.95 717.07 599.45 481.08 361.95 242.07 121.42 0.00 AMORTIZATION SCHEDULE NOTE AMT: STATED PMNT: INT. RATE: LOAN DATE: TERM: Date Pmt # 6/1/2006 7/1/2006 1 8/1/2006 2 9/1/2006 3 10/1/2006 4 11/1/2006 5 12/1/2006 6 1/1/2007 7 2/1/2007 8 3/1/2007 9 4/1/2007 10 5/1/2007 11 6/1/2007 12 7/1/2007 13 8/1/2007 14 9/1/2007 15 10/1/2007 16 11/1/2007 17 12/1/2007 18 1/1/2008 19 2/1/2008 20 3/1/2008 21 4/1/2008 22 5/1/2008 23 6/1/2008 24 7/1/2008 25 8/1/2008 26 9/1/2008 27 10/1/2008 28 11/1/2008 29 12/1/2008 30 1/1/2009 31 2/1/2009 32 3/1/2009 33 4/1/2009 34 5/1/2009 35 6/1/2009 36 7/1/2009 37 8/1/2009 38 9/1/2009 39 10/1/2009 40 11/1/2009 41 12/1/2009 42 1/1/2010 43 2/1/2010 44 3/1/2010 45 4/1/2010 46 5/1/2010 47 6/1/2010 48 7/1/2010 49 8/1/2010 50 9/1/2010 51 10/1/2010 52 11/1/2010 53 12/1/2010 54 1/1/2011 55 2/1/2011 56 3/1/2011 57 4/1/2011 58 5/1/2011 59 6/1/2011 60 $167,000.00 $1,401.46 9.0000% (ie. 12%=.12) 6/1/2006 25 IN YEARS Total Payment 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 1,401.46 Principle 148.96 150.08 151.20 152.34 153.48 154.63 155.79 156.96 158.14 159.32 160.52 161.72 162.93 164.16 165.39 166.63 167.88 169.14 170.40 171.68 172.97 174.27 175.57 176.89 178.22 179.55 180.90 182.26 183.62 185.00 186.39 187.79 189.20 190.61 192.04 193.48 194.94 196.40 197.87 199.35 200.85 202.36 203.87 205.40 206.94 208.50 210.06 211.63 213.22 214.82 216.43 218.06 219.69 221.34 223.00 224.67 226.36 228.05 229.76 231.49 CALC. PMNT: $1,401.46 Interest 1,252.50 1,251.38 1,250.26 1,249.12 1,247.98 1,246.83 1,245.67 1,244.50 1,243.32 1,242.14 1,240.94 1,239.74 1,238.53 1,237.30 1,236.07 1,234.83 1,233.58 1,232.32 1,231.06 1,229.78 1,228.49 1,227.19 1,225.89 1,224.57 1,223.24 1,221.91 1,220.56 1,219.20 1,217.84 1,216.46 1,215.07 1,213.67 1,212.26 1,210.85 1,209.42 1,207.98 1,206.52 1,205.06 1,203.59 1,202.11 1,200.61 1,199.10 1,197.59 1,196.06 1,194.52 1,192.96 1,191.40 1,189.83 1,188.24 1,186.64 1,185.03 1,183.40 1,181.77 1,180.12 1,178.46 1,176.79 1,175.10 1,173.41 1,171.70 1,169.97 Balance $167,000.00 166,851.04 166,700.96 166,549.76 166,397.42 166,243.94 166,089.31 165,933.52 165,776.56 165,618.42 165,459.10 165,298.58 165,136.86 164,973.93 164,809.77 164,644.38 164,477.75 164,309.87 164,140.73 163,970.33 163,798.65 163,625.68 163,451.41 163,275.84 163,098.95 162,920.73 162,741.18 162,560.28 162,378.02 162,194.40 162,009.40 161,823.01 161,635.22 161,446.02 161,255.41 161,063.37 160,869.89 160,674.95 160,478.55 160,280.68 160,081.33 159,880.48 159,678.12 159,474.25 159,268.85 159,061.91 158,853.41 158,643.35 158,431.72 158,218.50 158,003.68 157,787.25 157,569.19 157,349.50 157,128.16 156,905.16 156,680.49 156,454.13 156,226.08 155,996.32 155,764.83 CPLTD 1,877.11 1,891.19 1,905.38 1,919.67 1,934.07 1,948.58 1,963.19 1,977.91 1,992.74 2,007.69 2,022.74 2,037.91 2,053.20 2,068.59 2,084.10 2,099.73 2,115.47 2,131.33 2,147.32 2,163.43 2,179.66 2,196.00 2,212.47 2,229.06 2,245.78 2,262.63 2,279.60 2,296.69 2,313.92 2,331.28 2,348.76 2,366.37 2,384.11 2,402.00 2,420.02 2,438.17 2,456.45 2,474.87 2,493.43 2,512.14 2,530.98 2,549.96 2,569.09 2,588.36 2,607.78 2,627.33 2,647.03 2,666.89 2,453.67 2,238.85 2,022.42 1,804.36 1,584.67 1,363.33 1,140.33 915.66 689.30 461.25 231.49 0.00 AMORTIZATION SCHEDULE NOTE AMT: STATED PMNT: INT. RATE: LOAN DATE: TERM: Date Pmt # 6/1/2006 7/1/2006 1 8/1/2006 2 9/1/2006 3 10/1/2006 4 11/1/2006 5 12/1/2006 6 1/1/2007 7 2/1/2007 8 3/1/2007 9 4/1/2007 10 5/1/2007 11 6/1/2007 12 7/1/2007 13 8/1/2007 14 9/1/2007 15 10/1/2007 16 11/1/2007 17 12/1/2007 18 1/1/2008 19 2/1/2008 20 3/1/2008 21 4/1/2008 22 5/1/2008 23 6/1/2008 24 7/1/2008 25 8/1/2008 26 9/1/2008 27 10/1/2008 28 11/1/2008 29 12/1/2008 30 1/1/2009 31 2/1/2009 32 3/1/2009 33 4/1/2009 34 5/1/2009 35 6/1/2009 36 7/1/2009 37 8/1/2009 38 9/1/2009 39 10/1/2009 40 11/1/2009 41 12/1/2009 42 1/1/2010 43 2/1/2010 44 3/1/2010 45 4/1/2010 46 5/1/2010 47 6/1/2010 48 7/1/2010 49 8/1/2010 50 9/1/2010 51 10/1/2010 52 11/1/2010 53 12/1/2010 54 1/1/2011 55 2/1/2011 56 3/1/2011 57 4/1/2011 58 5/1/2011 59 6/1/2011 60 $77,000.00 $646.18 9.0000% (ie. 12%=.12) 6/1/2006 25 IN YEARS Total Payment 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 646.18 Principle 68.68 69.20 69.71 70.24 70.76 71.29 71.83 72.37 72.91 73.46 74.01 74.56 75.12 75.69 76.25 76.83 77.40 77.98 78.57 79.16 79.75 80.35 80.95 81.56 82.17 82.79 83.41 84.03 84.66 85.30 85.94 86.58 87.23 87.89 88.54 89.21 89.88 90.55 91.23 91.92 92.60 93.30 94.00 94.70 95.41 96.13 96.85 97.58 98.31 99.05 99.79 100.54 101.29 102.05 102.82 103.59 104.36 105.15 105.94 106.73 CALC. PMNT: $646.18 Interest 577.50 576.98 576.47 575.94 575.42 574.89 574.35 573.81 573.27 572.72 572.17 571.62 571.06 570.49 569.93 569.35 568.78 568.20 567.61 567.02 566.43 565.83 565.23 564.62 564.01 563.39 562.77 562.15 561.52 560.88 560.24 559.60 558.95 558.29 557.64 556.97 556.30 555.63 554.95 554.26 553.58 552.88 552.18 551.48 550.77 550.05 549.33 548.60 547.87 547.13 546.39 545.64 544.89 544.13 543.36 542.59 541.82 541.03 540.24 539.45 Balance $77,000.00 76,931.32 76,862.12 76,792.41 76,722.17 76,651.41 76,580.12 76,508.29 76,435.92 76,363.01 76,289.55 76,215.54 76,140.98 76,065.86 75,990.17 75,913.92 75,837.09 75,759.69 75,681.71 75,603.14 75,523.98 75,444.23 75,363.88 75,282.93 75,201.37 75,119.20 75,036.41 74,953.00 74,868.97 74,784.31 74,699.01 74,613.07 74,526.49 74,439.26 74,351.37 74,262.83 74,173.62 74,083.74 73,993.19 73,901.96 73,810.04 73,717.44 73,624.14 73,530.14 73,435.44 73,340.03 73,243.90 73,147.05 73,049.47 72,951.16 72,852.11 72,752.32 72,651.78 72,550.49 72,448.44 72,345.62 72,242.03 72,137.67 72,032.52 71,926.58 71,819.85 CPLTD 865.46 871.95 878.49 885.08 891.72 898.41 905.15 911.94 918.78 925.67 932.61 939.61 946.66 953.76 960.92 968.12 975.38 982.70 990.07 997.49 1,004.97 1,012.51 1,020.10 1,027.75 1,035.46 1,043.22 1,051.04 1,058.93 1,066.87 1,074.87 1,082.93 1,091.05 1,099.23 1,107.47 1,115.78 1,124.15 1,132.58 1,141.08 1,149.64 1,158.26 1,166.95 1,175.70 1,184.52 1,193.41 1,202.36 1,211.38 1,220.47 1,229.62 1,131.31 1,032.26 932.47 831.93 730.64 628.59 525.77 422.18 317.82 212.67 106.73 0.00 AMORTIZATION SCHEDULE NOTE AMT: STATED PMNT: INT. RATE: LOAN DATE: TERM: Date Pmt # 6/1/2006 7/1/2006 1 8/1/2006 2 9/1/2006 3 10/1/2006 4 11/1/2006 5 12/1/2006 6 1/1/2007 7 2/1/2007 8 3/1/2007 9 4/1/2007 10 5/1/2007 11 6/1/2007 12 7/1/2007 13 8/1/2007 14 9/1/2007 15 10/1/2007 16 11/1/2007 17 12/1/2007 18 1/1/2008 19 2/1/2008 20 3/1/2008 21 4/1/2008 22 5/1/2008 23 6/1/2008 24 7/1/2008 25 8/1/2008 26 9/1/2008 27 10/1/2008 28 11/1/2008 29 12/1/2008 30 1/1/2009 31 2/1/2009 32 3/1/2009 33 4/1/2009 34 5/1/2009 35 6/1/2009 36 7/1/2009 37 8/1/2009 38 9/1/2009 39 10/1/2009 40 11/1/2009 41 12/1/2009 42 1/1/2010 43 2/1/2010 44 3/1/2010 45 4/1/2010 46 5/1/2010 47 6/1/2010 48 7/1/2010 49 8/1/2010 50 9/1/2010 51 10/1/2010 52 11/1/2010 53 12/1/2010 54 1/1/2011 55 2/1/2011 56 3/1/2011 57 4/1/2011 58 5/1/2011 59 6/1/2011 60 $167,000.00 $1,403.10 8.0600% (ie. 12%=.12) 6/1/2006 20 IN YEARS Total Payment 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 1,403.10 Principle 281.42 283.31 285.21 287.13 289.05 291.00 292.95 294.92 296.90 298.89 300.90 302.92 304.96 307.00 309.07 311.14 313.23 315.34 317.45 319.59 321.73 323.89 326.07 328.26 330.46 332.68 334.92 337.17 339.43 341.71 344.01 346.32 348.64 350.99 353.34 355.72 358.11 360.51 362.93 365.37 367.82 370.29 372.78 375.29 377.81 380.34 382.90 385.47 388.06 390.67 393.29 395.93 398.59 401.27 403.96 406.68 409.41 412.16 414.93 417.71 CALC. PMNT: $1,403.10 Interest 1,121.68 1,119.79 1,117.89 1,115.97 1,114.05 1,112.10 1,110.15 1,108.18 1,106.20 1,104.21 1,102.20 1,100.18 1,098.14 1,096.10 1,094.03 1,091.96 1,089.87 1,087.76 1,085.65 1,083.51 1,081.37 1,079.21 1,077.03 1,074.84 1,072.64 1,070.42 1,068.18 1,065.93 1,063.67 1,061.39 1,059.09 1,056.78 1,054.46 1,052.11 1,049.76 1,047.38 1,044.99 1,042.59 1,040.17 1,037.73 1,035.28 1,032.81 1,030.32 1,027.81 1,025.29 1,022.76 1,020.20 1,017.63 1,015.04 1,012.43 1,009.81 1,007.17 1,004.51 1,001.83 999.14 996.42 993.69 990.94 988.17 985.39 Balance $167,000.00 166,718.58 166,435.27 166,150.06 165,862.93 165,573.88 165,282.88 164,989.93 164,695.01 164,398.11 164,099.22 163,798.32 163,495.40 163,190.44 162,883.44 162,574.37 162,263.23 161,950.00 161,634.66 161,317.21 160,997.62 160,675.89 160,352.00 160,025.93 159,697.67 159,367.21 159,034.53 158,699.61 158,362.44 158,023.01 157,681.30 157,337.29 156,990.97 156,642.33 156,291.34 155,938.00 155,582.28 155,224.17 154,863.66 154,500.73 154,135.36 153,767.54 153,397.25 153,024.47 152,649.18 152,271.37 151,891.03 151,508.13 151,122.66 150,734.60 150,343.93 149,950.64 149,554.71 149,156.12 148,754.85 148,350.89 147,944.21 147,534.80 147,122.64 146,707.71 146,290.00 CPLTD 3,528.14 3,551.83 3,575.69 3,599.70 3,623.88 3,648.22 3,672.72 3,697.39 3,722.22 3,747.22 3,772.39 3,797.73 3,823.23 3,848.91 3,874.76 3,900.79 3,926.99 3,953.36 3,979.92 4,006.65 4,033.56 4,060.66 4,087.93 4,115.39 4,143.04 4,170.87 4,198.88 4,227.08 4,255.47 4,284.05 4,312.82 4,341.79 4,370.96 4,400.31 4,429.87 4,459.62 4,489.57 4,519.73 4,550.09 4,580.65 4,611.42 4,642.40 4,673.58 4,704.97 4,736.57 4,768.39 4,800.42 4,832.66 4,444.60 4,053.93 3,660.64 3,264.71 2,866.12 2,464.85 2,060.89 1,654.21 1,244.80 832.64 417.71 0.00 AMORTIZATION SCHEDULE NOTE AMT: STATED PMNT: INT. RATE: LOAN DATE: TERM: Date Pmt # 6/1/2006 7/1/2006 1 8/1/2006 2 9/1/2006 3 10/1/2006 4 11/1/2006 5 12/1/2006 6 1/1/2007 7 2/1/2007 8 3/1/2007 9 4/1/2007 10 5/1/2007 11 6/1/2007 12 7/1/2007 13 8/1/2007 14 9/1/2007 15 10/1/2007 16 11/1/2007 17 12/1/2007 18 1/1/2008 19 2/1/2008 20 3/1/2008 21 4/1/2008 22 5/1/2008 23 6/1/2008 24 7/1/2008 25 8/1/2008 26 9/1/2008 27 10/1/2008 28 11/1/2008 29 12/1/2008 30 1/1/2009 31 2/1/2009 32 3/1/2009 33 4/1/2009 34 5/1/2009 35 6/1/2009 36 7/1/2009 37 8/1/2009 38 9/1/2009 39 10/1/2009 40 11/1/2009 41 12/1/2009 42 1/1/2010 43 2/1/2010 44 3/1/2010 45 4/1/2010 46 5/1/2010 47 6/1/2010 48 7/1/2010 49 8/1/2010 50 9/1/2010 51 10/1/2010 52 11/1/2010 53 12/1/2010 54 1/1/2011 55 2/1/2011 56 3/1/2011 57 4/1/2011 58 5/1/2011 59 6/1/2011 60 $73,000.00 $613.33 8.0600% (ie. 12%=.12) 6/1/2006 20 IN YEARS Total Payment 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 613.33 Principle 123.01 123.84 124.67 125.51 126.35 127.20 128.05 128.91 129.78 130.65 131.53 132.41 133.30 134.20 135.10 136.01 136.92 137.84 138.77 139.70 140.64 141.58 142.53 143.49 144.45 145.42 146.40 147.38 148.37 149.37 150.37 151.38 152.40 153.42 154.45 155.49 156.54 157.59 158.65 159.71 160.78 161.86 162.95 164.05 165.15 166.26 167.37 168.50 169.63 170.77 171.92 173.07 174.23 175.40 176.58 177.77 178.96 180.16 181.37 182.59 CALC. PMNT: $613.33 Interest 490.32 489.49 488.66 487.82 486.98 486.13 485.28 484.42 483.55 482.68 481.80 480.92 480.03 479.13 478.23 477.32 476.41 475.49 474.56 473.63 472.69 471.75 470.80 469.84 468.88 467.91 466.93 465.95 464.96 463.96 462.96 461.95 460.93 459.91 458.88 457.84 456.79 455.74 454.68 453.62 452.55 451.47 450.38 449.28 448.18 447.07 445.96 444.83 443.70 442.56 441.41 440.26 439.10 437.93 436.75 435.56 434.37 433.17 431.96 430.74 Balance $73,000.00 72,876.99 72,753.15 72,628.48 72,502.97 72,376.62 72,249.42 72,121.37 71,992.46 71,862.68 71,732.03 71,600.50 71,468.09 71,334.79 71,200.59 71,065.49 70,929.48 70,792.56 70,654.72 70,515.95 70,376.25 70,235.61 70,094.03 69,951.50 69,808.01 69,663.56 69,518.14 69,371.74 69,224.36 69,075.99 68,926.62 68,776.25 68,624.87 68,472.47 68,319.05 68,164.60 68,009.11 67,852.57 67,694.98 67,536.33 67,376.62 67,215.84 67,053.98 66,891.03 66,726.98 66,561.83 66,395.57 66,228.20 66,059.70 65,890.07 65,719.30 65,547.38 65,374.31 65,200.08 65,024.68 64,848.10 64,670.33 64,491.37 64,311.21 64,129.84 63,947.25 CPLTD 1,542.20 1,552.56 1,562.99 1,573.49 1,584.06 1,594.70 1,605.42 1,616.21 1,627.07 1,638.00 1,649.00 1,660.08 1,671.23 1,682.45 1,693.75 1,705.12 1,716.57 1,728.10 1,739.70 1,751.38 1,763.14 1,774.98 1,786.90 1,798.90 1,810.99 1,823.16 1,835.41 1,847.74 1,860.15 1,872.64 1,885.22 1,897.89 1,910.64 1,923.48 1,936.40 1,949.41 1,962.50 1,975.68 1,988.95 2,002.31 2,015.76 2,029.30 2,042.93 2,056.65 2,070.46 2,084.36 2,098.36 2,112.45 1,942.82 1,772.05 1,600.13 1,427.06 1,252.83 1,077.43 900.85 723.08 544.12 363.96 182.59 0.00
0
Related docs
Amortization Calculator Template
Views: 119  |  Downloads: 6
mortgage calculator amortization
Views: 28  |  Downloads: 1
Free Amortization Calculator
Views: 126  |  Downloads: 9
Amortization Calculator
Views: 49  |  Downloads: 1
Mortgage Amortization Calculator
Views: 45  |  Downloads: 5
Loan Amortization Calculator
Views: 172  |  Downloads: 14
Loan Amortization Calculator
Views: 130  |  Downloads: 8
Amortization Schedule Calculator
Views: 258  |  Downloads: 5
Loan Amortization Calculator
Views: 122  |  Downloads: 14
Yearly Amortization Calculator
Views: 125  |  Downloads: 13
Amortization Table Calculator
Views: 89  |  Downloads: 5
calculator mortgage amortization
Views: 11  |  Downloads: 0
calculator mortgage amortization
Views: 4  |  Downloads: 0
Mortgage Amortization Schedule Calculator
Views: 22  |  Downloads: 1
Simple Amortization
Views: 423  |  Downloads: 38
Other docs by Katrina Golden
20XX Tax Planning Opportunity template
Views: 209  |  Downloads: 9
Bylaws__Corporation__FIRM_FORM Template
Views: 161  |  Downloads: 11
Corporate_Bylaws Template
Views: 232  |  Downloads: 27
CORPORATION_RESOLUTION Template
Views: 196  |  Downloads: 18
BankLoanRequestforSmallBusiness Template
Views: 174  |  Downloads: 14
Work for Hire and proprietary Agreement template
Views: 221  |  Downloads: 9
Weekly Time Card Template[1]
Views: 241  |  Downloads: 5
Vacation_Master template
Views: 204  |  Downloads: 9
Travel_expense_report_with_mileage_due Template
Views: 264  |  Downloads: 17
Summary_of_PTO_and_Vacation_Time template
Views: 178  |  Downloads: 12