arm calculator

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 $1,306.66 $160,000 $140,000 $120,000 $100,000 $80,000 $60,000 $40,000 $20,000 Loan Balance Cumulative Principal Cumulative Interest 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% Month $0 10% 50 100 150 200 Interest Rate Interest Rate History 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 Additional Due 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 http://www.vertex42.com/ExcelTemplates/arm-calculator.html © 2005 Vertex42 LLC 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 http://www.vertex42.com/ExcelTemplates/arm-calculator.html © 2005 Vertex42 LLC 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 http://www.vertex42.com/ExcelTemplates/arm-calculator.html © 2005 Vertex42 LLC 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