Amortization Calculator
With loan amount 420000 usd, annual interest rate 6.125 %, term 30 years, extra principal each month 0 usd, amortization comes to 30 yr — paid off in. It is reached in 11 steps, the last of which is months, and each one is printed on the page with its numbers filled in. The formula is the one published by US Consumer Financial Protection Bureau, not an approximation fitted to it.
Full payment schedule for a loan, with the option to pay biweekly or add extra each month and see what it saves.
Formula and sources checked · How we check
Loan amount 420000, Annual interest rate 6.125, Term 30 years, Payment schedule Monthly — 12 payments a year
30 yr
Paid off in for the example below. Editing a field recomputes the calculator below; this figure holds the answer the page was loaded with.
It is written into the HTML rather than drawn by a script, so a search engine reading this page without running JavaScript still finds an answer.
Paid off in
30 yr
- Scheduled monthly payment
420000 * 0.0051042 / (1 - pow(1 + 0.0051042, -360))2,551.964- Paid per year
2551.9643 * (12 * 1 + 13 * 0) + 0 * 1230,623.571- Effective monthly payment
30623.571 / 122,551.964- Extra principal per month
2551.9643 - 2551.96430- Total paid each month
2551.9643 + 02,551.964- Months to payoff
log(2551.9643 / (2551.9643 - 420000 * 0.0051042)) / log(1 + 0.0051042)360- Payoff time
360 months- Total paid
2551.9643 * 360918,707.136- Total interest
918707.14 - 420000$498,707- Interest saved against the plain schedule
max(0, 498707.14 - 498707.14)0- Months cut off the term
max(0, 360 - 360)0 months
Ask about this in the chatExtra Mortgage Payment Chart
Where the money goes
Payment schedule
Each row is one payment. Interest is charged on last month's balance, so the split moves toward principal only as the balance falls — which is why the first years barely move the needle.
| Year | Interest | Principal | Balance |
|---|---|---|---|
| Year 1 | $25,585.12 | $5,038.46 | $414,961.54 |
| Year 2 | $25,267.70 | $5,355.87 | $409,605.67 |
| Year 3 | $24,930.28 | $5,693.29 | $403,912.38 |
| Year 4 | $24,571.61 | $6,051.96 | $397,860.42 |
| Year 5 | $24,190.34 | $6,433.23 | $391,427.20 |
| Year 6 | $23,785.06 | $6,838.51 | $384,588.68 |
| Year 7 | $23,354.24 | $7,269.33 | $377,319.35 |
| Year 8 | $22,896.27 | $7,727.30 | $369,592.05 |
| Year 9 | $22,409.46 | $8,214.11 | $361,377.94 |
| Year 10 | $21,891.98 | $8,731.59 | $352,646.35 |
| Year 11 | $21,341.90 | $9,281.67 | $343,364.68 |
| Year 12 | $20,757.16 | $9,866.41 | $333,498.27 |
| Year 13 | $20,135.59 | $10,487.98 | $323,010.29 |
| Year 14 | $19,474.86 | $11,148.72 | $311,861.57 |
| Year 15 | $18,772.50 | $11,851.07 | $300,010.50 |
| Year 16 | $18,025.89 | $12,597.68 | $287,412.82 |
| Year 17 | $17,232.25 | $13,391.32 | $274,021.49 |
| Year 18 | $16,388.61 | $14,234.96 | $259,786.53 |
| Year 19 | $15,491.82 | $15,131.75 | $244,654.78 |
| Year 20 | $14,538.53 | $16,085.04 | $228,569.74 |
| Year 21 | $13,525.19 | $17,098.38 | $211,471.36 |
| Year 22 | $12,448.01 | $18,175.56 | $193,295.79 |
| Year 23 | $11,302.96 | $19,320.61 | $173,975.19 |
| Year 24 | $10,085.78 | $20,537.79 | $153,437.40 |
| Year 25 | $8,791.92 | $21,831.65 | $131,605.75 |
| Year 26 | $7,416.55 | $23,207.02 | $108,398.73 |
| Year 27 | $5,954.53 | $24,669.04 | $83,729.69 |
| Year 28 | $4,400.40 | $26,223.17 | $57,506.52 |
| Year 29 | $2,748.37 | $27,875.20 | $29,631.32 |
| Year 30 | $992.26 | $29,631.32 | $0.00 |
Show all 360 months
| Month | Interest | Principal | Balance |
|---|---|---|---|
| 1 | $2,143.75 | $408.21 | $419,591.79 |
| 2 | $2,141.67 | $410.30 | $419,181.49 |
| 3 | $2,139.57 | $412.39 | $418,769.10 |
| 4 | $2,137.47 | $414.50 | $418,354.60 |
| 5 | $2,135.35 | $416.61 | $417,937.99 |
| 6 | $2,133.23 | $418.74 | $417,519.25 |
| 7 | $2,131.09 | $420.88 | $417,098.37 |
| 8 | $2,128.94 | $423.02 | $416,675.35 |
| 9 | $2,126.78 | $425.18 | $416,250.16 |
| 10 | $2,124.61 | $427.35 | $415,822.81 |
| 11 | $2,122.43 | $429.54 | $415,393.27 |
| 12 | $2,120.24 | $431.73 | $414,961.54 |
| 13 | $2,118.03 | $433.93 | $414,527.61 |
| 14 | $2,115.82 | $436.15 | $414,091.47 |
| 15 | $2,113.59 | $438.37 | $413,653.09 |
| 16 | $2,111.35 | $440.61 | $413,212.48 |
| 17 | $2,109.11 | $442.86 | $412,769.63 |
| 18 | $2,106.84 | $445.12 | $412,324.51 |
| 19 | $2,104.57 | $447.39 | $411,877.12 |
| 20 | $2,102.29 | $449.67 | $411,427.44 |
| 21 | $2,099.99 | $451.97 | $410,975.47 |
| 22 | $2,097.69 | $454.28 | $410,521.19 |
| 23 | $2,095.37 | $456.60 | $410,064.60 |
| 24 | $2,093.04 | $458.93 | $409,605.67 |
| 25 | $2,090.70 | $461.27 | $409,144.40 |
| 26 | $2,088.34 | $463.62 | $408,680.78 |
| 27 | $2,085.97 | $465.99 | $408,214.79 |
| 28 | $2,083.60 | $468.37 | $407,746.42 |
| 29 | $2,081.21 | $470.76 | $407,275.66 |
| 30 | $2,078.80 | $473.16 | $406,802.50 |
| 31 | $2,076.39 | $475.58 | $406,326.93 |
| 32 | $2,073.96 | $478.00 | $405,848.92 |
| 33 | $2,071.52 | $480.44 | $405,368.48 |
| 34 | $2,069.07 | $482.90 | $404,885.58 |
| 35 | $2,066.60 | $485.36 | $404,400.22 |
| 36 | $2,064.13 | $487.84 | $403,912.38 |
| 37 | $2,061.64 | $490.33 | $403,422.06 |
| 38 | $2,059.13 | $492.83 | $402,929.22 |
| 39 | $2,056.62 | $495.35 | $402,433.88 |
| 40 | $2,054.09 | $497.87 | $401,936.00 |
| 41 | $2,051.55 | $500.42 | $401,435.59 |
| 42 | $2,048.99 | $502.97 | $400,932.62 |
| 43 | $2,046.43 | $505.54 | $400,427.08 |
| 44 | $2,043.85 | $508.12 | $399,918.96 |
| 45 | $2,041.25 | $510.71 | $399,408.25 |
| 46 | $2,038.65 | $513.32 | $398,894.93 |
| 47 | $2,036.03 | $515.94 | $398,379.00 |
| 48 | $2,033.39 | $518.57 | $397,860.42 |
| 49 | $2,030.75 | $521.22 | $397,339.21 |
| 50 | $2,028.09 | $523.88 | $396,815.33 |
| 51 | $2,025.41 | $526.55 | $396,288.77 |
| 52 | $2,022.72 | $529.24 | $395,759.53 |
| 53 | $2,020.02 | $531.94 | $395,227.59 |
| 54 | $2,017.31 | $534.66 | $394,692.94 |
| 55 | $2,014.58 | $537.39 | $394,155.55 |
| 56 | $2,011.84 | $540.13 | $393,615.42 |
| 57 | $2,009.08 | $542.89 | $393,072.54 |
| 58 | $2,006.31 | $545.66 | $392,526.88 |
| 59 | $2,003.52 | $548.44 | $391,978.44 |
| 60 | $2,000.72 | $551.24 | $391,427.20 |
| 61 | $1,997.91 | $554.05 | $390,873.14 |
| 62 | $1,995.08 | $556.88 | $390,316.26 |
| 63 | $1,992.24 | $559.73 | $389,756.53 |
| 64 | $1,989.38 | $562.58 | $389,193.95 |
| 65 | $1,986.51 | $565.45 | $388,628.50 |
| 66 | $1,983.62 | $568.34 | $388,060.16 |
| 67 | $1,980.72 | $571.24 | $387,488.92 |
| 68 | $1,977.81 | $574.16 | $386,914.76 |
| 69 | $1,974.88 | $577.09 | $386,337.68 |
| 70 | $1,971.93 | $580.03 | $385,757.64 |
| 71 | $1,968.97 | $582.99 | $385,174.65 |
| 72 | $1,966.00 | $585.97 | $384,588.68 |
| 73 | $1,963.00 | $588.96 | $383,999.72 |
| 74 | $1,960.00 | $591.97 | $383,407.76 |
| 75 | $1,956.98 | $594.99 | $382,812.77 |
| 76 | $1,953.94 | $598.02 | $382,214.74 |
| 77 | $1,950.89 | $601.08 | $381,613.67 |
| 78 | $1,947.82 | $604.14 | $381,009.52 |
| 79 | $1,944.74 | $607.23 | $380,402.30 |
| 80 | $1,941.64 | $610.33 | $379,791.97 |
| 81 | $1,938.52 | $613.44 | $379,178.53 |
| 82 | $1,935.39 | $616.57 | $378,561.95 |
| 83 | $1,932.24 | $619.72 | $377,942.23 |
| 84 | $1,929.08 | $622.88 | $377,319.35 |
| 85 | $1,925.90 | $626.06 | $376,693.28 |
| 86 | $1,922.71 | $629.26 | $376,064.02 |
| 87 | $1,919.49 | $632.47 | $375,431.55 |
| 88 | $1,916.27 | $635.70 | $374,795.85 |
| 89 | $1,913.02 | $638.94 | $374,156.91 |
| 90 | $1,909.76 | $642.21 | $373,514.71 |
| 91 | $1,906.48 | $645.48 | $372,869.22 |
| 92 | $1,903.19 | $648.78 | $372,220.44 |
| 93 | $1,899.88 | $652.09 | $371,568.36 |
| 94 | $1,896.55 | $655.42 | $370,912.94 |
| 95 | $1,893.20 | $658.76 | $370,254.18 |
| 96 | $1,889.84 | $662.13 | $369,592.05 |
| 97 | $1,886.46 | $665.50 | $368,926.55 |
| 98 | $1,883.06 | $668.90 | $368,257.64 |
| 99 | $1,879.65 | $672.32 | $367,585.33 |
| 100 | $1,876.22 | $675.75 | $366,909.58 |
| 101 | $1,872.77 | $679.20 | $366,230.38 |
| 102 | $1,869.30 | $682.66 | $365,547.72 |
| 103 | $1,865.82 | $686.15 | $364,861.57 |
| 104 | $1,862.31 | $689.65 | $364,171.92 |
| 105 | $1,858.79 | $693.17 | $363,478.75 |
| 106 | $1,855.26 | $696.71 | $362,782.04 |
| 107 | $1,851.70 | $700.26 | $362,081.78 |
| 108 | $1,848.13 | $703.84 | $361,377.94 |
| 109 | $1,844.53 | $707.43 | $360,670.51 |
| 110 | $1,840.92 | $711.04 | $359,959.47 |
| 111 | $1,837.29 | $714.67 | $359,244.80 |
| 112 | $1,833.65 | $718.32 | $358,526.48 |
| 113 | $1,829.98 | $721.99 | $357,804.49 |
| 114 | $1,826.29 | $725.67 | $357,078.82 |
| 115 | $1,822.59 | $729.37 | $356,349.45 |
| 116 | $1,818.87 | $733.10 | $355,616.35 |
| 117 | $1,815.13 | $736.84 | $354,879.51 |
| 118 | $1,811.36 | $740.60 | $354,138.91 |
| 119 | $1,807.58 | $744.38 | $353,394.53 |
| 120 | $1,803.78 | $748.18 | $352,646.35 |
| 121 | $1,799.97 | $752.00 | $351,894.35 |
| 122 | $1,796.13 | $755.84 | $351,138.52 |
| 123 | $1,792.27 | $759.69 | $350,378.82 |
| 124 | $1,788.39 | $763.57 | $349,615.25 |
| 125 | $1,784.49 | $767.47 | $348,847.78 |
| 126 | $1,780.58 | $771.39 | $348,076.39 |
| 127 | $1,776.64 | $775.32 | $347,301.07 |
| 128 | $1,772.68 | $779.28 | $346,521.79 |
| 129 | $1,768.70 | $783.26 | $345,738.53 |
| 130 | $1,764.71 | $787.26 | $344,951.27 |
| 131 | $1,760.69 | $791.28 | $344,159.99 |
| 132 | $1,756.65 | $795.31 | $343,364.68 |
| 133 | $1,752.59 | $799.37 | $342,565.31 |
| 134 | $1,748.51 | $803.45 | $341,761.85 |
| 135 | $1,744.41 | $807.55 | $340,954.30 |
| 136 | $1,740.29 | $811.68 | $340,142.62 |
| 137 | $1,736.14 | $815.82 | $339,326.80 |
| 138 | $1,731.98 | $819.98 | $338,506.82 |
| 139 | $1,727.80 | $824.17 | $337,682.65 |
| 140 | $1,723.59 | $828.38 | $336,854.27 |
| 141 | $1,719.36 | $832.60 | $336,021.67 |
| 142 | $1,715.11 | $836.85 | $335,184.82 |
| 143 | $1,710.84 | $841.13 | $334,343.69 |
| 144 | $1,706.55 | $845.42 | $333,498.27 |
| 145 | $1,702.23 | $849.73 | $332,648.54 |
| 146 | $1,697.89 | $854.07 | $331,794.47 |
| 147 | $1,693.53 | $858.43 | $330,936.04 |
| 148 | $1,689.15 | $862.81 | $330,073.23 |
| 149 | $1,684.75 | $867.22 | $329,206.01 |
| 150 | $1,680.32 | $871.64 | $328,334.37 |
| 151 | $1,675.87 | $876.09 | $327,458.28 |
| 152 | $1,671.40 | $880.56 | $326,577.71 |
| 153 | $1,666.91 | $885.06 | $325,692.66 |
| 154 | $1,662.39 | $889.57 | $324,803.08 |
| 155 | $1,657.85 | $894.12 | $323,908.97 |
| 156 | $1,653.29 | $898.68 | $323,010.29 |
| 157 | $1,648.70 | $903.27 | $322,107.02 |
| 158 | $1,644.09 | $907.88 | $321,199.15 |
| 159 | $1,639.45 | $912.51 | $320,286.64 |
| 160 | $1,634.80 | $917.17 | $319,369.47 |
| 161 | $1,630.11 | $921.85 | $318,447.62 |
| 162 | $1,625.41 | $926.55 | $317,521.06 |
| 163 | $1,620.68 | $931.28 | $316,589.78 |
| 164 | $1,615.93 | $936.04 | $315,653.74 |
| 165 | $1,611.15 | $940.81 | $314,712.93 |
| 166 | $1,606.35 | $945.62 | $313,767.31 |
| 167 | $1,601.52 | $950.44 | $312,816.87 |
| 168 | $1,596.67 | $955.29 | $311,861.57 |
| 169 | $1,591.79 | $960.17 | $310,901.40 |
| 170 | $1,586.89 | $965.07 | $309,936.33 |
| 171 | $1,581.97 | $970.00 | $308,966.33 |
| 172 | $1,577.02 | $974.95 | $307,991.38 |
| 173 | $1,572.04 | $979.92 | $307,011.46 |
| 174 | $1,567.04 | $984.93 | $306,026.53 |
| 175 | $1,562.01 | $989.95 | $305,036.58 |
| 176 | $1,556.96 | $995.01 | $304,041.57 |
| 177 | $1,551.88 | $1,000.09 | $303,041.49 |
| 178 | $1,546.77 | $1,005.19 | $302,036.30 |
| 179 | $1,541.64 | $1,010.32 | $301,025.98 |
| 180 | $1,536.49 | $1,015.48 | $300,010.50 |
| 181 | $1,531.30 | $1,020.66 | $298,989.84 |
| 182 | $1,526.09 | $1,025.87 | $297,963.97 |
| 183 | $1,520.86 | $1,031.11 | $296,932.86 |
| 184 | $1,515.59 | $1,036.37 | $295,896.49 |
| 185 | $1,510.31 | $1,041.66 | $294,854.83 |
| 186 | $1,504.99 | $1,046.98 | $293,807.86 |
| 187 | $1,499.64 | $1,052.32 | $292,755.54 |
| 188 | $1,494.27 | $1,057.69 | $291,697.85 |
| 189 | $1,488.87 | $1,063.09 | $290,634.76 |
| 190 | $1,483.45 | $1,068.52 | $289,566.24 |
| 191 | $1,477.99 | $1,073.97 | $288,492.27 |
| 192 | $1,472.51 | $1,079.45 | $287,412.82 |
| 193 | $1,467.00 | $1,084.96 | $286,327.86 |
| 194 | $1,461.47 | $1,090.50 | $285,237.36 |
| 195 | $1,455.90 | $1,096.07 | $284,141.29 |
| 196 | $1,450.30 | $1,101.66 | $283,039.63 |
| 197 | $1,444.68 | $1,107.28 | $281,932.35 |
| 198 | $1,439.03 | $1,112.93 | $280,819.42 |
| 199 | $1,433.35 | $1,118.62 | $279,700.80 |
| 200 | $1,427.64 | $1,124.32 | $278,576.48 |
| 201 | $1,421.90 | $1,130.06 | $277,446.41 |
| 202 | $1,416.13 | $1,135.83 | $276,310.58 |
| 203 | $1,410.34 | $1,141.63 | $275,168.95 |
| 204 | $1,404.51 | $1,147.46 | $274,021.49 |
| 205 | $1,398.65 | $1,153.31 | $272,868.18 |
| 206 | $1,392.76 | $1,159.20 | $271,708.98 |
| 207 | $1,386.85 | $1,165.12 | $270,543.87 |
| 208 | $1,380.90 | $1,171.06 | $269,372.80 |
| 209 | $1,374.92 | $1,177.04 | $268,195.76 |
| 210 | $1,368.92 | $1,183.05 | $267,012.71 |
| 211 | $1,362.88 | $1,189.09 | $265,823.63 |
| 212 | $1,356.81 | $1,195.16 | $264,628.47 |
| 213 | $1,350.71 | $1,201.26 | $263,427.21 |
| 214 | $1,344.58 | $1,207.39 | $262,219.83 |
| 215 | $1,338.41 | $1,213.55 | $261,006.28 |
| 216 | $1,332.22 | $1,219.74 | $259,786.53 |
| 217 | $1,325.99 | $1,225.97 | $258,560.56 |
| 218 | $1,319.74 | $1,232.23 | $257,328.33 |
| 219 | $1,313.45 | $1,238.52 | $256,089.82 |
| 220 | $1,307.13 | $1,244.84 | $254,844.98 |
| 221 | $1,300.77 | $1,251.19 | $253,593.78 |
| 222 | $1,294.38 | $1,257.58 | $252,336.20 |
| 223 | $1,287.97 | $1,264.00 | $251,072.21 |
| 224 | $1,281.51 | $1,270.45 | $249,801.76 |
| 225 | $1,275.03 | $1,276.93 | $248,524.82 |
| 226 | $1,268.51 | $1,283.45 | $247,241.37 |
| 227 | $1,261.96 | $1,290.00 | $245,951.37 |
| 228 | $1,255.38 | $1,296.59 | $244,654.78 |
| 229 | $1,248.76 | $1,303.21 | $243,351.57 |
| 230 | $1,242.11 | $1,309.86 | $242,041.72 |
| 231 | $1,235.42 | $1,316.54 | $240,725.17 |
| 232 | $1,228.70 | $1,323.26 | $239,401.91 |
| 233 | $1,221.95 | $1,330.02 | $238,071.89 |
| 234 | $1,215.16 | $1,336.81 | $236,735.09 |
| 235 | $1,208.34 | $1,343.63 | $235,391.46 |
| 236 | $1,201.48 | $1,350.49 | $234,040.97 |
| 237 | $1,194.58 | $1,357.38 | $232,683.59 |
| 238 | $1,187.66 | $1,364.31 | $231,319.28 |
| 239 | $1,180.69 | $1,371.27 | $229,948.01 |
| 240 | $1,173.69 | $1,378.27 | $228,569.74 |
| 241 | $1,166.66 | $1,385.31 | $227,184.43 |
| 242 | $1,159.59 | $1,392.38 | $225,792.06 |
| 243 | $1,152.48 | $1,399.48 | $224,392.57 |
| 244 | $1,145.34 | $1,406.63 | $222,985.94 |
| 245 | $1,138.16 | $1,413.81 | $221,572.14 |
| 246 | $1,130.94 | $1,421.02 | $220,151.11 |
| 247 | $1,123.69 | $1,428.28 | $218,722.84 |
| 248 | $1,116.40 | $1,435.57 | $217,287.27 |
| 249 | $1,109.07 | $1,442.89 | $215,844.38 |
| 250 | $1,101.71 | $1,450.26 | $214,394.12 |
| 251 | $1,094.30 | $1,457.66 | $212,936.46 |
| 252 | $1,086.86 | $1,465.10 | $211,471.36 |
| 253 | $1,079.39 | $1,472.58 | $209,998.78 |
| 254 | $1,071.87 | $1,480.10 | $208,518.68 |
| 255 | $1,064.31 | $1,487.65 | $207,031.03 |
| 256 | $1,056.72 | $1,495.24 | $205,535.79 |
| 257 | $1,049.09 | $1,502.88 | $204,032.91 |
| 258 | $1,041.42 | $1,510.55 | $202,522.37 |
| 259 | $1,033.71 | $1,518.26 | $201,004.11 |
| 260 | $1,025.96 | $1,526.01 | $199,478.11 |
| 261 | $1,018.17 | $1,533.79 | $197,944.31 |
| 262 | $1,010.34 | $1,541.62 | $196,402.69 |
| 263 | $1,002.47 | $1,549.49 | $194,853.19 |
| 264 | $994.56 | $1,557.40 | $193,295.79 |
| 265 | $986.61 | $1,565.35 | $191,730.44 |
| 266 | $978.62 | $1,573.34 | $190,157.10 |
| 267 | $970.59 | $1,581.37 | $188,575.73 |
| 268 | $962.52 | $1,589.44 | $186,986.29 |
| 269 | $954.41 | $1,597.56 | $185,388.74 |
| 270 | $946.26 | $1,605.71 | $183,783.03 |
| 271 | $938.06 | $1,613.91 | $182,169.12 |
| 272 | $929.82 | $1,622.14 | $180,546.98 |
| 273 | $921.54 | $1,630.42 | $178,916.56 |
| 274 | $913.22 | $1,638.74 | $177,277.81 |
| 275 | $904.86 | $1,647.11 | $175,630.70 |
| 276 | $896.45 | $1,655.52 | $173,975.19 |
| 277 | $888.00 | $1,663.97 | $172,311.22 |
| 278 | $879.51 | $1,672.46 | $170,638.76 |
| 279 | $870.97 | $1,681.00 | $168,957.77 |
| 280 | $862.39 | $1,689.58 | $167,268.19 |
| 281 | $853.76 | $1,698.20 | $165,569.99 |
| 282 | $845.10 | $1,706.87 | $163,863.12 |
| 283 | $836.38 | $1,715.58 | $162,147.54 |
| 284 | $827.63 | $1,724.34 | $160,423.21 |
| 285 | $818.83 | $1,733.14 | $158,690.07 |
| 286 | $809.98 | $1,741.98 | $156,948.09 |
| 287 | $801.09 | $1,750.88 | $155,197.21 |
| 288 | $792.15 | $1,759.81 | $153,437.40 |
| 289 | $783.17 | $1,768.79 | $151,668.61 |
| 290 | $774.14 | $1,777.82 | $149,890.78 |
| 291 | $765.07 | $1,786.90 | $148,103.89 |
| 292 | $755.95 | $1,796.02 | $146,307.87 |
| 293 | $746.78 | $1,805.18 | $144,502.68 |
| 294 | $737.57 | $1,814.40 | $142,688.29 |
| 295 | $728.30 | $1,823.66 | $140,864.63 |
| 296 | $719.00 | $1,832.97 | $139,031.66 |
| 297 | $709.64 | $1,842.32 | $137,189.34 |
| 298 | $700.24 | $1,851.73 | $135,337.61 |
| 299 | $690.79 | $1,861.18 | $133,476.43 |
| 300 | $681.29 | $1,870.68 | $131,605.75 |
| 301 | $671.74 | $1,880.23 | $129,725.52 |
| 302 | $662.14 | $1,889.82 | $127,835.70 |
| 303 | $652.49 | $1,899.47 | $125,936.23 |
| 304 | $642.80 | $1,909.16 | $124,027.07 |
| 305 | $633.05 | $1,918.91 | $122,108.16 |
| 306 | $623.26 | $1,928.70 | $120,179.45 |
| 307 | $613.42 | $1,938.55 | $118,240.91 |
| 308 | $603.52 | $1,948.44 | $116,292.46 |
| 309 | $593.58 | $1,958.39 | $114,334.07 |
| 310 | $583.58 | $1,968.38 | $112,365.69 |
| 311 | $573.53 | $1,978.43 | $110,387.26 |
| 312 | $563.43 | $1,988.53 | $108,398.73 |
| 313 | $553.29 | $1,998.68 | $106,400.05 |
| 314 | $543.08 | $2,008.88 | $104,391.17 |
| 315 | $532.83 | $2,019.13 | $102,372.04 |
| 316 | $522.52 | $2,029.44 | $100,342.60 |
| 317 | $512.17 | $2,039.80 | $98,302.80 |
| 318 | $501.75 | $2,050.21 | $96,252.59 |
| 319 | $491.29 | $2,060.68 | $94,191.91 |
| 320 | $480.77 | $2,071.19 | $92,120.72 |
| 321 | $470.20 | $2,081.76 | $90,038.95 |
| 322 | $459.57 | $2,092.39 | $87,946.56 |
| 323 | $448.89 | $2,103.07 | $85,843.49 |
| 324 | $438.16 | $2,113.80 | $83,729.69 |
| 325 | $427.37 | $2,124.59 | $81,605.09 |
| 326 | $416.53 | $2,135.44 | $79,469.66 |
| 327 | $405.63 | $2,146.34 | $77,323.32 |
| 328 | $394.67 | $2,157.29 | $75,166.02 |
| 329 | $383.66 | $2,168.30 | $72,997.72 |
| 330 | $372.59 | $2,179.37 | $70,818.35 |
| 331 | $361.47 | $2,190.50 | $68,627.85 |
| 332 | $350.29 | $2,201.68 | $66,426.18 |
| 333 | $339.05 | $2,212.91 | $64,213.26 |
| 334 | $327.76 | $2,224.21 | $61,989.05 |
| 335 | $316.40 | $2,235.56 | $59,753.49 |
| 336 | $304.99 | $2,246.97 | $57,506.52 |
| 337 | $293.52 | $2,258.44 | $55,248.08 |
| 338 | $282.00 | $2,269.97 | $52,978.11 |
| 339 | $270.41 | $2,281.56 | $50,696.55 |
| 340 | $258.76 | $2,293.20 | $48,403.35 |
| 341 | $247.06 | $2,304.91 | $46,098.45 |
| 342 | $235.29 | $2,316.67 | $43,781.78 |
| 343 | $223.47 | $2,328.49 | $41,453.28 |
| 344 | $211.58 | $2,340.38 | $39,112.90 |
| 345 | $199.64 | $2,352.33 | $36,760.58 |
| 346 | $187.63 | $2,364.33 | $34,396.24 |
| 347 | $175.56 | $2,376.40 | $32,019.84 |
| 348 | $163.43 | $2,388.53 | $29,631.32 |
| 349 | $151.24 | $2,400.72 | $27,230.59 |
| 350 | $138.99 | $2,412.97 | $24,817.62 |
| 351 | $126.67 | $2,425.29 | $22,392.33 |
| 352 | $114.29 | $2,437.67 | $19,954.66 |
| 353 | $101.85 | $2,450.11 | $17,504.55 |
| 354 | $89.35 | $2,462.62 | $15,041.93 |
| 355 | $76.78 | $2,475.19 | $12,566.74 |
| 356 | $64.14 | $2,487.82 | $10,078.92 |
| 357 | $51.44 | $2,500.52 | $7,578.40 |
| 358 | $38.68 | $2,513.28 | $5,065.12 |
| 359 | $25.85 | $2,526.11 | $2,539.00 |
| 360 | $12.96 | $2,539.00 | $0.00 |
Worked example
$420,000 at 6.125% over 30 years is $2,551.96 a month. Left alone it runs the full 360 payments and costs $498,707 in interest, more than the house. Adding $300 a month clears it in 22 years 10 months and saves $138,371.
How to work it out yourself
- 1.Enter the loan amount, the rate and the term. The scheduled payment is the one that clears the balance in exactly that many months.
- 2.Add extra principal, or switch to biweekly, to see the term shorten. Both do the same thing: they put more against principal each year.
- 3.Read the schedule. Interest is charged on the balance you carried into the month, so early payments are nearly all interest and the balance curve starts almost flat.
What extra principal each month buys
| Extra principal each month (usd) | Paid off in | Total interest | Months cut off the term |
|---|---|---|---|
| 0 | 30 yr | $498,707 | 0 months |
| 25 | 29 yr 2 mo | $482,555 | 9.76 months |
| 50 | 28 yr 5 mo | $467,572 | 18.88 months |
| 100 | 27 yr 1 mo | $440,595 | 35.49 months |
| 150 | 25 yr 10 mo | $416,932 | 50.25 months |
| 200 | 24 yr 9 mo | $395,961 | 63.5 months |
| 250 | 23 yr 9 mo | $377,216 | 75.48 months |
| 300 | 22 yr 10 mo | $360,336 | 86.39 months |
| 400 | 21 yr 2 mo | $331,097 | 105.56 months |
| 500 | 19 yr 10 mo | $306,582 | 121.93 months |
| 750 | 17 yr 2 mo | $259,461 | 154.23 months |
| 1000 | 15 yr 2 mo | $225,469 | 178.28 months |
Same loan, same rate, only the extra changed. The first $100 buys more than the fourth, because early principal removes the most future interest.
The formula
- Scheduled monthly payment
420000 * 0.0051042 / (1 - pow(1 + 0.0051042, -360)) - Paid per year
2551.9643 * (12 * 1 + 13 * 0) + 0 * 12 - Effective monthly payment
30623.571 / 12 - Extra principal per month
2551.9643 - 2551.9643 - Total paid each month
2551.9643 + 0 - Months to payoff
log(2551.9643 / (2551.9643 - 420000 * 0.0051042)) / log(1 + 0.0051042) - Payoff time
- Total paid
2551.9643 * 360 - Total interest
918707.14 - 420000 - Interest saved against the plain schedule
max(0, 498707.14 - 498707.14) - Months cut off the term
max(0, 360 - 360)
Source: US Consumer Financial Protection Bureau — how loan amortization works, US CFPB — biweekly mortgage payment programs
Questions people actually ask
- Does paying biweekly actually save money?
- Yes, but not for the reason it is usually sold. Half a payment every two weeks is 26 half-payments a year, which is 13 monthly payments rather than 12. The saving is that one extra payment going to principal — the same result you get by adding a twelfth of the payment each month, without a servicer fee for the privilege.
- Why is nearly all of an early payment interest?
- Because interest is charged on the balance you still owe, and at the start you owe almost everything. On this example the first payment is $2,143.75 of interest and $408.21 of principal. The split only moves as the balance falls, which is why the balance curve is flat for years and then steepens.
- How much does one extra payment a year save?
- On the example loan it takes 5 years 7 months off the term and saves $107,688, because every extra dollar removes all the future interest that dollar would have carried. Put your own numbers in the extra field: the interest-saved line compares against the plain schedule.
- Does the schedule below match the formula above?
- It has to. The payoff month is computed in closed form from the payment and the rate, and the table is built by charging interest and subtracting principal one row at a time. They are independent routes to the same number, and the build fails if they disagree — which is the check most amortization pages have no way to run.
Related
- Mortgage Payment CalculatorMonthly principal-and-interest payment on a fixed-rate mortgage, plus total interest paid over the full term.
- Loan Payment CalculatorMonthly payment and total interest on any fixed-rate instalment loan — car, personal or student.
- Compound Interest CalculatorFuture value of a starting balance plus monthly contributions, separating what you put in from what the interest earned.
- Payment CalculatorThe monthly payment on a loan, and how much sooner it clears if you pay a different amount instead.
- Refinance CalculatorWhat refinancing saves each month, what it costs to do, and how long you have to stay for it to have been worth it.
- Mortgage Payoff CalculatorWhen a mortgage clears if you pay extra each month, how many years that cuts off the term, and what the interest saved comes to.
Part of a job
- Taking out a mortgage — 6 pages, in the order the questions arrive
Put this calculator on your site
Free, no attribution required beyond the link.
<iframe src="https://rulecalculators.com/embed/amortization-schedule" width="100%" height="420" style="border:1px solid #e7e4de;border-radius:12px" title="Amortization Calculator"></iframe>Did this answer your question?