ARM Calculator

Document Sample
ARM Calculator Powered By Docstoc
					Page 1 of 4

Adjustable Rate Mortgage (ARM) Calculator
Download from Vertex42.com

© 2005 Vertex42, LLC

v 1.1

Loan Information Loan amount Term (years) Starting interest rate First payment date Starting monthly payment $ 150,000 15 6.500% 1/1/2007

$160,000 $140,000

Loan Balance

Cumulative Principal
Cumulative Interest

$120,000
$100,000

$1,306.66

$80,000
$60,000

Rate Adjustments Rate remains fixed for Months between adjustments Expected adjustment Interest rate cap Est. Max rate Est. Max monthly payment Total payments Total interest Internal Rate of Return 3 years 12 0.250% 12.000%

$40,000

$20,000 Month
$0 10% 50 100 150 200

Interest Rate History

Interest Rate

9.50% $1,427.48 $247,007.26 $97,007.26 7.13%

8% 6% 4%
2% 0% 0 50 100 150 200

Month

No.
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Payment Date
1/1/2007 2/1/2007 3/1/2007 4/1/2007 5/1/2007 6/1/2007 7/1/2007 8/1/2007 9/1/2007 10/1/2007 11/1/2007 12/1/2007 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008 6/1/2008 7/1/2008 8/1/2008 9/1/2008 10/1/2008 11/1/2008 12/1/2008 1/1/2009 2/1/2009 3/1/2009 4/1/2009

Interest Rate
$ 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500%

Payment Additiona Due l Payment
(150,000) 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 0.00

Interest
812.50 809.82 807.13 804.43 801.71 798.97 796.22 793.46 790.68 787.88 785.07 782.25 779.41 776.55 773.68 770.79 767.89 764.97 762.04 759.09 756.12 753.14 750.14 747.12 744.09 741.05 737.98 734.90

Principal
$ 494.16 496.84 499.53 502.23 504.95 507.69 510.44 513.20 515.98 518.78 521.59 524.41 527.25 530.11 532.98 535.87 538.77 541.69 544.62 547.57 550.54 553.52 556.52 559.54 562.57 565.61 568.68 571.76

Balance
150,000 149,505.84 149,009.00 148,509.47 148,007.24 147,502.29 146,994.60 146,484.16 145,970.96 145,454.98 144,936.20 144,414.61 143,890.20 143,362.95 142,832.84 142,299.86 141,763.99 141,225.22 140,683.53 140,138.91 139,591.34 139,040.80 138,487.28 137,930.76 137,371.22 136,808.65 136,243.04 135,674.36 135,102.60

Cumulative Cumulative Interest Principal
812.50 1,622.32 2,429.45 3,233.88 4,035.59 4,834.56 5,630.78 6,424.24 7,214.92 8,002.80 8,787.87 9,570.12 10,349.53 11,126.08 11,899.76 12,670.55 13,438.44 14,203.41 14,965.45 15,724.54 16,480.66 17,233.80 17,983.94 18,731.06 19,475.15 20,216.20 20,954.18 21,689.08 494.16 991.00 1,490.53 1,992.76 2,497.71 3,005.40 3,515.84 4,029.04 4,545.02 5,063.80 5,585.39 6,109.80 6,637.05 7,167.16 7,700.14 8,236.01 8,774.78 9,316.47 9,861.09 10,408.66 10,959.20 11,512.72 12,069.24 12,628.78 13,191.35 13,756.96 14,325.64 14,897.40 © 2005 Vertex42 LLC

http://www.vertex42.com/ExcelTemplates/arm-calculator.html

Page 2 of 4
29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 5/1/2009 6/1/2009 7/1/2009 8/1/2009 9/1/2009 10/1/2009 11/1/2009 12/1/2009 1/1/2010 2/1/2010 3/1/2010 4/1/2010 5/1/2010 6/1/2010 7/1/2010 8/1/2010 9/1/2010 10/1/2010 11/1/2010 12/1/2010 1/1/2011 2/1/2011 3/1/2011 4/1/2011 5/1/2011 6/1/2011 7/1/2011 8/1/2011 9/1/2011 10/1/2011 11/1/2011 12/1/2011 1/1/2012 2/1/2012 3/1/2012 4/1/2012 5/1/2012 6/1/2012 7/1/2012 8/1/2012 9/1/2012 10/1/2012 11/1/2012 12/1/2012 1/1/2013 2/1/2013 3/1/2013 4/1/2013 5/1/2013 6/1/2013 7/1/2013 8/1/2013 9/1/2013 10/1/2013 11/1/2013 12/1/2013 1/1/2014 2/1/2014 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.500% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 6.750% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.000% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.250% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.500% 7.750% 7.750% 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,306.66 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,323.85 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,339.93 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,354.85 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,368.55 1,380.98 1,380.98 731.81 728.69 725.56 722.41 719.25 716.07 712.87 709.65 733.59 730.27 726.93 723.57 720.19 716.80 713.38 709.95 706.50 703.02 699.53 696.02 718.14 714.51 710.86 707.19 703.50 699.79 696.05 692.30 688.52 684.72 680.90 677.05 697.23 693.26 689.26 685.24 681.19 677.12 673.03 668.91 664.76 660.60 656.40 652.18 670.28 665.91 661.52 657.10 652.66 648.18 643.68 639.15 634.59 630.00 625.39 620.74 636.61 631.80 574.85 577.97 581.10 584.25 587.41 590.59 593.79 597.01 590.26 593.58 596.92 600.28 603.66 607.05 610.47 613.90 617.35 620.83 624.32 627.83 621.79 625.42 629.07 632.74 636.43 640.14 643.88 647.63 651.41 655.21 659.03 662.88 657.62 661.59 665.59 669.61 673.66 677.73 681.82 685.94 690.09 694.25 698.45 702.67 698.27 702.64 707.03 711.45 715.89 720.37 724.87 729.40 733.96 738.55 743.16 747.81 744.37 749.18 134,527.75 133,949.78 133,368.68 132,784.43 132,197.02 131,606.43 131,012.64 130,415.63 129,825.37 129,231.79 128,634.87 128,034.59 127,430.93 126,823.88 126,213.41 125,599.51 124,982.16 124,361.33 123,737.01 123,109.18 122,487.39 121,861.97 121,232.90 120,600.16 119,963.73 119,323.59 118,679.71 118,032.08 117,380.67 116,725.46 116,066.43 115,403.55 114,745.93 114,084.34 113,418.75 112,749.14 112,075.48 111,397.75 110,715.93 110,029.99 109,339.90 108,645.65 107,947.20 107,244.53 106,546.26 105,843.62 105,136.59 104,425.14 103,709.25 102,988.88 102,264.01 101,534.61 100,800.65 100,062.10 99,318.94 98,571.13 97,826.76 97,077.58 22,420.89 23,149.58 23,875.14 24,597.55 25,316.80 26,032.87 26,745.74 27,455.39 28,188.98 28,919.25 29,646.18 30,369.75 31,089.94 31,806.74 32,520.12 33,230.07 33,936.57 34,639.59 35,339.12 36,035.14 36,753.28 37,467.79 38,178.65 38,885.84 39,589.34 40,289.13 40,985.18 41,677.48 42,366.00 43,050.72 43,731.62 44,408.67 45,105.90 45,799.16 46,488.42 47,173.66 47,854.85 48,531.97 49,205.00 49,873.91 50,538.67 51,199.27 51,855.67 52,507.85 53,178.13 53,844.04 54,505.56 55,162.66 55,815.32 56,463.50 57,107.18 57,746.33 58,380.92 59,010.92 59,636.31 60,257.05 60,893.66 61,525.46 15,472.25 16,050.22 16,631.32 17,215.57 17,802.98 18,393.57 18,987.36 19,584.37 20,174.63 20,768.21 21,365.13 21,965.41 22,569.07 23,176.12 23,786.59 24,400.49 25,017.84 25,638.67 26,262.99 26,890.82 27,512.61 28,138.03 28,767.10 29,399.84 30,036.27 30,676.41 31,320.29 31,967.92 32,619.33 33,274.54 33,933.57 34,596.45 35,254.07 35,915.66 36,581.25 37,250.86 37,924.52 38,602.25 39,284.07 39,970.01 40,660.10 41,354.35 42,052.80 42,755.47 43,453.74 44,156.38 44,863.41 45,574.86 46,290.75 47,011.12 47,735.99 48,465.39 49,199.35 49,937.90 50,681.06 51,428.87 52,173.24 52,922.42 © 2005 Vertex42 LLC

http://www.vertex42.com/ExcelTemplates/arm-calculator.html

Page 3 of 4
87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 3/1/2014 4/1/2014 5/1/2014 6/1/2014 7/1/2014 8/1/2014 9/1/2014 10/1/2014 11/1/2014 12/1/2014 1/1/2015 2/1/2015 3/1/2015 4/1/2015 5/1/2015 6/1/2015 7/1/2015 8/1/2015 9/1/2015 10/1/2015 11/1/2015 12/1/2015 1/1/2016 2/1/2016 3/1/2016 4/1/2016 5/1/2016 6/1/2016 7/1/2016 8/1/2016 9/1/2016 10/1/2016 11/1/2016 12/1/2016 1/1/2017 2/1/2017 3/1/2017 4/1/2017 5/1/2017 6/1/2017 7/1/2017 8/1/2017 9/1/2017 10/1/2017 11/1/2017 12/1/2017 1/1/2018 2/1/2018 3/1/2018 4/1/2018 5/1/2018 6/1/2018 7/1/2018 8/1/2018 9/1/2018 10/1/2018 11/1/2018 12/1/2018 7.750% 7.750% 7.750% 7.750% 7.750% 7.750% 7.750% 7.750% 7.750% 7.750% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.000% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.250% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.500% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 8.750% 1,380.98 1,380.98 1,380.98 1,380.98 1,380.98 1,380.98 1,380.98 1,380.98 1,380.98 1,380.98 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,392.07 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,401.79 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,410.05 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 1,416.81 626.96 622.09 617.19 612.26 607.29 602.29 597.27 592.20 587.11 581.98 595.43 590.12 584.77 579.39 573.97 568.52 563.03 557.50 551.94 546.34 540.70 535.02 545.85 539.97 534.04 528.07 522.07 516.02 509.93 503.80 497.62 491.41 485.15 478.85 486.82 480.28 473.70 467.06 460.38 453.66 446.88 440.06 433.19 426.27 419.30 412.28 417.13 409.84 402.50 395.11 387.66 380.15 372.59 364.98 357.31 349.58 341.80 333.96 754.02 758.89 763.79 768.72 773.69 778.69 783.71 788.78 793.87 799.00 796.64 801.95 807.30 812.68 818.10 823.55 829.04 834.57 840.13 845.73 851.37 857.05 855.94 861.82 867.75 873.72 879.72 885.77 891.86 897.99 904.17 910.38 916.64 922.94 923.23 929.77 936.35 942.99 949.67 956.39 963.17 969.99 976.86 983.78 990.75 997.77 999.68 1,006.97 1,014.31 1,021.70 1,029.15 1,036.66 1,044.22 1,051.83 1,059.50 1,067.23 1,075.01 1,082.85 96,323.56 95,564.67 94,800.88 94,032.16 93,258.47 92,479.78 91,696.07 90,907.29 90,113.42 89,314.42 88,517.78 87,715.83 86,908.53 86,095.85 85,277.75 84,454.20 83,625.16 82,790.59 81,950.46 81,104.73 80,253.36 79,396.31 78,540.37 77,678.55 76,810.80 75,937.08 75,057.36 74,171.59 73,279.73 72,381.74 71,477.57 70,567.19 69,650.55 68,727.61 67,804.38 66,874.61 65,938.26 64,995.27 64,045.60 63,089.21 62,126.04 61,156.05 60,179.19 59,195.41 58,204.66 57,206.89 56,207.21 55,200.24 54,185.93 53,164.23 52,135.08 51,098.42 50,054.20 49,002.37 47,942.87 46,875.64 45,800.63 44,717.78 62,152.42 62,774.51 63,391.70 64,003.96 64,611.25 65,213.54 65,810.81 66,403.01 66,990.12 67,572.10 68,167.53 68,757.65 69,342.42 69,921.81 70,495.78 71,064.30 71,627.33 72,184.83 72,736.77 73,283.11 73,823.81 74,358.83 74,904.68 75,444.65 75,978.69 76,506.76 77,028.83 77,544.85 78,054.78 78,558.58 79,056.20 79,547.61 80,032.76 80,511.61 80,998.43 81,478.71 81,952.41 82,419.47 82,879.85 83,333.51 83,780.39 84,220.45 84,653.64 85,079.91 85,499.21 85,911.49 86,328.62 86,738.46 87,140.96 87,536.07 87,923.73 88,303.88 88,676.47 89,041.45 89,398.76 89,748.34 90,090.14 90,424.10 53,676.44 54,435.33 55,199.12 55,967.84 56,741.53 57,520.22 58,303.93 59,092.71 59,886.58 60,685.58 61,482.22 62,284.17 63,091.47 63,904.15 64,722.25 65,545.80 66,374.84 67,209.41 68,049.54 68,895.27 69,746.64 70,603.69 71,459.63 72,321.45 73,189.20 74,062.92 74,942.64 75,828.41 76,720.27 77,618.26 78,522.43 79,432.81 80,349.45 81,272.39 82,195.62 83,125.39 84,061.74 85,004.73 85,954.40 86,910.79 87,873.96 88,843.95 89,820.81 90,804.59 91,795.34 92,793.11 93,792.79 94,799.76 95,814.07 96,835.77 97,864.92 98,901.58 99,945.80 100,997.63 102,057.13 103,124.36 104,199.37 105,282.22 © 2005 Vertex42 LLC

http://www.vertex42.com/ExcelTemplates/arm-calculator.html

Page 4 of 4
145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 1/1/2019 2/1/2019 3/1/2019 4/1/2019 5/1/2019 6/1/2019 7/1/2019 8/1/2019 9/1/2019 10/1/2019 11/1/2019 12/1/2019 1/1/2020 2/1/2020 3/1/2020 4/1/2020 5/1/2020 6/1/2020 7/1/2020 8/1/2020 9/1/2020 10/1/2020 11/1/2020 12/1/2020 1/1/2021 2/1/2021 3/1/2021 4/1/2021 5/1/2021 6/1/2021 7/1/2021 8/1/2021 9/1/2021 10/1/2021 11/1/2021 12/1/2021 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.000% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.250% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 9.500% 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,422.01 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,425.59 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.48 1,427.46 335.38 327.23 319.02 310.75 302.42 294.02 285.56 277.04 268.45 259.80 251.08 242.30 239.94 230.80 221.59 212.30 202.95 193.53 184.03 174.46 164.82 155.10 145.30 135.44 128.88 118.60 108.24 97.80 87.27 76.66 65.97 55.19 44.32 33.37 22.34 11.21 1,086.63 1,094.78 1,102.99 1,111.26 1,119.59 1,127.99 1,136.45 1,144.97 1,153.56 1,162.21 1,170.93 1,179.71 1,185.65 1,194.79 1,204.00 1,213.29 1,222.64 1,232.06 1,241.56 1,251.13 1,260.77 1,270.49 1,280.29 1,290.15 1,298.60 1,308.88 1,319.24 1,329.68 1,340.21 1,350.82 1,361.51 1,372.29 1,383.16 1,394.11 1,405.14 1,416.25 43,631.15 42,536.37 41,433.38 40,322.12 39,202.53 38,074.54 36,938.09 35,793.12 34,639.56 33,477.35 32,306.42 31,126.71 29,941.06 28,746.27 27,542.27 26,328.98 25,106.34 23,874.28 22,632.72 21,381.59 20,120.82 18,850.33 17,570.04 16,279.89 14,981.29 13,672.41 12,353.17 11,023.49 9,683.28 8,332.46 6,970.95 5,598.66 4,215.50 2,821.39 1,416.25 0.00 90,759.48 91,086.71 91,405.73 91,716.48 92,018.90 92,312.92 92,598.48 92,875.52 93,143.97 93,403.77 93,654.85 93,897.15 94,137.09 94,367.89 94,589.48 94,801.78 95,004.73 95,198.26 95,382.29 95,556.75 95,721.57 95,876.67 96,021.97 96,157.41 96,286.29 96,404.89 96,513.13 96,610.93 96,698.20 96,774.86 96,840.83 96,896.02 96,940.34 96,973.71 96,996.05 97,007.26 106,368.85 107,463.63 108,566.62 109,677.88 110,797.47 111,925.46 113,061.91 114,206.88 115,360.44 116,522.65 117,693.58 118,873.29 120,058.94 121,253.73 122,457.73 123,671.02 124,893.66 126,125.72 127,367.28 128,618.41 129,879.18 131,149.67 132,429.96 133,720.11 135,018.71 136,327.59 137,646.83 138,976.51 140,316.72 141,667.54 143,029.05 144,401.34 145,784.50 147,178.61 148,583.75 150,000.00

http://www.vertex42.com/ExcelTemplates/arm-calculator.html

© 2005 Vertex42 LLC


				
DOCUMENT INFO
Shared By:
Tags: excel, template
Stats:
views:287
posted:1/3/2008
language:English
pages:4
Jeff Sperry Jeff Sperry
About