贷款摊还表 计算器 (月度 / 年度)
输入本金、年利率、年限。返回月供、总利息、总还款额,以及逐月每期本金与利息分解、期末余额。可切换全部月份/年度摘要,支持 CSV 下载。
- 月供
- 1,199.1
- 总利息
- 231,676.38
- 总还款额
- 431,676.38
- 总月数
- 360
还款计划
点击某一年可展开该年每月的还款明细；CSV 导出包含全部月份。
月供本金利息余额
›第 1 年14,389.212,456.0211,933.19197,543.98
月 11,199.1199.11,000199,800.9
月 21,199.1200.1999199,600.8
月 31,199.1201.1998199,399.71
月 41,199.1202.1997199,197.6
月 51,199.1203.11995.99198,994.49
月 61,199.1204.13994.97198,790.36
月 71,199.1205.15993.95198,585.21
月 81,199.1206.17992.93198,379.04
月 91,199.1207.21991.9198,171.83
月 101,199.1208.24990.86197,963.59
月 111,199.1209.28989.82197,754.31
月 121,199.1210.33988.77197,543.98
›第 2 年14,389.212,607.5111,781.71194,936.47
月 131,199.1211.38987.72197,332.6
月 141,199.1212.44986.66197,120.16
月 151,199.1213.5985.6196,906.66
月 161,199.1214.57984.53196,692.09
月 171,199.1215.64983.46196,476.45
月 181,199.1216.72982.38196,259.73
月 191,199.1217.8981.3196,041.93
月 201,199.1218.89980.21195,823.04
月 211,199.1219.99979.12195,603.05
月 221,199.1221.09978.02195,381.96
月 231,199.1222.19976.91195,159.77
月 241,199.1223.3975.8194,936.47
›第 3 年14,389.212,768.3311,620.88192,168.14
月 251,199.1224.42974.68194,712.05
月 261,199.1225.54973.56194,486.51
月 271,199.1226.67972.43194,259.84
月 281,199.1227.8971.3194,032.04
月 291,199.1228.94970.16193,803.1
月 301,199.1230.09969.02193,573.01
月 311,199.1231.24967.87193,341.78
月 321,199.1232.39966.71193,109.39
月 331,199.1233.55965.55192,875.83
月 341,199.1234.72964.38192,641.11
月 351,199.1235.9963.21192,405.22
月 361,199.1237.07962.03192,168.14
›第 4 年14,389.212,939.0811,450.14189,229.06
月 371,199.1238.26960.84191,929.88
月 381,199.1239.45959.65191,690.43
月 391,199.1240.65958.45191,449.78
月 401,199.1241.85957.25191,207.93
月 411,199.1243.06956.04190,964.87
月 421,199.1244.28954.82190,720.59
月 431,199.1245.5953.6190,475.09
月 441,199.1246.73952.38190,228.37
月 451,199.1247.96951.14189,980.41
月 461,199.1249.2949.9189,731.21
月 471,199.1250.45948.66189,480.76
月 481,199.1251.7947.4189,229.06
›第 5 年14,389.213,120.3511,268.86186,108.71
月 491,199.1252.96946.15188,976.11
月 501,199.1254.22944.88188,721.89
月 511,199.1255.49943.61188,466.4
月 521,199.1256.77942.33188,209.63
月 531,199.1258.05941.05187,951.57
月 541,199.1259.34939.76187,692.23
月 551,199.1260.64938.46187,431.59
月 561,199.1261.94937.16187,169.65
月 571,199.1263.25935.85186,906.4
月 581,199.1264.57934.53186,641.83
月 591,199.1265.89933.21186,375.94
月 601,199.1267.22931.88186,108.71
›第 6 年14,389.213,312.8111,076.41182,795.91
月 611,199.1268.56930.54185,840.16
月 621,199.1269.9929.2185,570.26
月 631,199.1271.25927.85185,299.01
月 641,199.1272.61926.5185,026.4
月 651,199.1273.97925.13184,752.43
月 661,199.1275.34923.76184,477.09
月 671,199.1276.72922.39184,200.38
月 681,199.1278.1921183,922.28
月 691,199.1279.49919.61183,642.79
月 701,199.1280.89918.21183,361.9
月 711,199.1282.29916.81183,079.61
月 721,199.1283.7915.4182,795.91
›第 7 年14,389.213,517.1310,872.08179,278.77
月 731,199.1285.12913.98182,510.78
月 741,199.1286.55912.55182,224.24
月 751,199.1287.98911.12181,936.26
月 761,199.1289.42909.68181,646.84
月 771,199.1290.87908.23181,355.97
月 781,199.1292.32906.78181,063.65
月 791,199.1293.78905.32180,769.87
月 801,199.1295.25903.85180,474.62
月 811,199.1296.73902.37180,177.89
月 821,199.1298.21900.89179,879.68
月 831,199.1299.7899.4179,579.97
月 841,199.1301.2897.9179,278.77
›第 8 年14,389.213,734.0610,655.15175,544.71
月 851,199.1302.71896.39178,976.06
月 861,199.1304.22894.88178,671.84
月 871,199.1305.74893.36178,366.1
月 881,199.1307.27891.83178,058.83
月 891,199.1308.81890.29177,750.02
月 901,199.1310.35888.75177,439.67
月 911,199.1311.9887.2177,127.77
月 921,199.1313.46885.64176,814.31
月 931,199.1315.03884.07176,499.28
月 941,199.1316.6882.5176,182.67
月 951,199.1318.19880.91175,864.49
月 961,199.1319.78879.32175,544.71
›第 9 年14,389.213,964.3710,424.84171,580.34
月 971,199.1321.38877.72175,223.33
月 981,199.1322.98876.12174,900.35
月 991,199.1324.6874.5174,575.75
月 1001,199.1326.22872.88174,249.52
月 1011,199.1327.85871.25173,921.67
月 1021,199.1329.49869.61173,592.18
月 1031,199.1331.14867.96173,261.04
月 1041,199.1332.8866.31172,928.24
月 1051,199.1334.46864.64172,593.78
月 1061,199.1336.13862.97172,257.65
月 1071,199.1337.81861.29171,919.84
月 1081,199.1339.5859.6171,580.34
›第 10 年14,389.214,208.8910,180.33167,371.45
月 1091,199.1341.2857.9171,239.14
月 1101,199.1342.91856.2170,896.23
月 1111,199.1344.62854.48170,551.61
月 1121,199.1346.34852.76170,205.27
月 1131,199.1348.07851.03169,857.19
月 1141,199.1349.82849.29169,507.38
月 1151,199.1351.56847.54169,155.81
月 1161,199.1353.32845.78168,802.49
月 1171,199.1355.09844.01168,447.4
月 1181,199.1356.86842.24168,090.54
月 1191,199.1358.65840.45167,731.89
月 1201,199.1360.44838.66167,371.45
›第 11 年14,389.214,468.489,920.73162,902.97
月 1211,199.1362.24836.86167,009.21
月 1221,199.1364.06835.05166,645.15
月 1231,199.1365.88833.23166,279.28
月 1241,199.1367.7831.4165,911.57
月 1251,199.1369.54829.56165,542.03
月 1261,199.1371.39827.71165,170.64
月 1271,199.1373.25825.85164,797.39
月 1281,199.1375.11823.99164,422.28
月 1291,199.1376.99822.11164,045.29
月 1301,199.1378.87820.23163,666.41
月 1311,199.1380.77818.33163,285.64
月 1321,199.1382.67816.43162,902.97
›第 12 年14,389.214,744.099,645.13158,158.88
月 1331,199.1384.59814.51162,518.38
月 1341,199.1386.51812.59162,131.87
月 1351,199.1388.44810.66161,743.43
月 1361,199.1390.38808.72161,353.05
月 1371,199.1392.34806.77160,960.71
月 1381,199.1394.3804.8160,566.41
月 1391,199.1396.27802.83160,170.15
月 1401,199.1398.25800.85159,771.9
月 1411,199.1400.24798.86159,371.65
月 1421,199.1402.24796.86158,969.41
月 1431,199.1404.25794.85158,565.16
月 1441,199.1406.28792.83158,158.88
›第 13 年14,389.215,036.699,352.52153,122.19
月 1451,199.1408.31790.79157,750.58
月 1461,199.1410.35788.75157,340.23
月 1471,199.1412.4786.7156,927.83
月 1481,199.1414.46784.64156,513.37
月 1491,199.1416.53782.57156,096.83
月 1501,199.1418.62780.48155,678.21
月 1511,199.1420.71778.39155,257.5
月 1521,199.1422.81776.29154,834.69
月 1531,199.1424.93774.17154,409.76
月 1541,199.1427.05772.05153,982.71
月 1551,199.1429.19769.91153,553.52
月 1561,199.1431.33767.77153,122.19
›第 14 年14,389.215,347.349,041.87147,774.85
月 1571,199.1433.49765.61152,688.7
月 1581,199.1435.66763.44152,253.04
月 1591,199.1437.84761.27151,815.21
月 1601,199.1440.03759.08151,375.18
月 1611,199.1442.23756.88150,932.96
月 1621,199.1444.44754.66150,488.52
月 1631,199.1446.66752.44150,041.86
月 1641,199.1448.89750.21149,592.97
月 1651,199.1451.14747.96149,141.83
月 1661,199.1453.39745.71148,688.44
月 1671,199.1455.66743.44148,232.78
月 1681,199.1457.94741.16147,774.85
›第 15 年14,389.215,677.168,712.06142,097.69
月 1691,199.1460.23738.87147,314.62
月 1701,199.1462.53736.57146,852.09
月 1711,199.1464.84734.26146,387.25
月 1721,199.1467.16731.94145,920.09
月 1731,199.1469.5729.6145,450.58
月 1741,199.1471.85727.25144,978.74
月 1751,199.1474.21724.89144,504.53
月 1761,199.1476.58722.52144,027.95
月 1771,199.1478.96720.14143,548.99
月 1781,199.1481.36717.74143,067.63
月 1791,199.1483.76715.34142,583.87
月 1801,199.1486.18712.92142,097.69
›第 16 年14,389.216,027.318,361.9136,070.38
月 1811,199.1488.61710.49141,609.08
月 1821,199.1491.06708.05141,118.02
月 1831,199.1493.51705.59140,624.51
月 1841,199.1495.98703.12140,128.53
月 1851,199.1498.46700.64139,630.07
月 1861,199.1500.95698.15139,129.12
月 1871,199.1503.46695.65138,625.67
月 1881,199.1505.97693.13138,119.69
月 1891,199.1508.5690.6137,611.19
月 1901,199.1511.05688.06137,100.15
月 1911,199.1513.6685.5136,586.55
月 1921,199.1516.17682.93136,070.38
›第 17 年14,389.216,399.067,990.15129,671.31
月 1931,199.1518.75680.35135,551.63
月 1941,199.1521.34677.76135,030.29
月 1951,199.1523.95675.15134,506.34
月 1961,199.1526.57672.53133,979.77
月 1971,199.1529.2669.9133,450.56
月 1981,199.1531.85667.25132,918.72
月 1991,199.1534.51664.59132,384.21
月 2001,199.1537.18661.92131,847.03
月 2011,199.1539.87659.24131,307.16
月 2021,199.1542.57656.54130,764.6
月 2031,199.1545.28653.82130,219.32
月 2041,199.1548651.1129,671.31
›第 18 年14,389.216,793.747,595.47122,877.57
月 2051,199.1550.74648.36129,120.57
月 2061,199.1553.5645.6128,567.07
月 2071,199.1556.27642.84128,010.81
月 2081,199.1559.05640.05127,451.76
月 2091,199.1561.84637.26126,889.92
月 2101,199.1564.65634.45126,325.27
月 2111,199.1567.47631.63125,757.79
月 2121,199.1570.31628.79125,187.48
月 2131,199.1573.16625.94124,614.32
月 2141,199.1576.03623.07124,038.29
月 2151,199.1578.91620.19123,459.38
月 2161,199.1581.8617.3122,877.57
›第 19 年14,389.217,212.777,176.45115,664.81
月 2171,199.1584.71614.39122,292.86
月 2181,199.1587.64611.46121,705.22
月 2191,199.1590.57608.53121,114.65
月 2201,199.1593.53605.57120,521.12
月 2211,199.1596.5602.61119,924.62
月 2221,199.1599.48599.62119,325.15
月 2231,199.1602.48596.63118,722.67
月 2241,199.1605.49593.61118,117.18
月 2251,199.1608.52590.59117,508.67
月 2261,199.1611.56587.54116,897.11
月 2271,199.1614.62584.49116,282.49
月 2281,199.1617.69581.41115,664.81
›第 20 年14,389.217,657.636,731.58108,007.17
月 2291,199.1620.78578.32115,044.03
月 2301,199.1623.88575.22114,420.15
月 2311,199.1627572.1113,793.15
月 2321,199.1630.14568.97113,163.01
月 2331,199.1633.29565.82112,529.73
月 2341,199.1636.45562.65111,893.27
月 2351,199.1639.63559.47111,253.64
月 2361,199.1642.83556.27110,610.81
月 2371,199.1646.05553.05109,964.76
月 2381,199.1649.28549.82109,315.48
月 2391,199.1652.52546.58108,662.96
月 2401,199.1655.79543.31108,007.17
›第 21 年14,389.218,129.946,259.2799,877.23
月 2411,199.1659.07540.04107,348.11
月 2421,199.1662.36536.74106,685.75
月 2431,199.1665.67533.43106,020.07
月 2441,199.1669530.1105,351.07
月 2451,199.1672.35526.76104,678.73
月 2461,199.1675.71523.39104,003.02
月 2471,199.1679.09520.02103,323.93
月 2481,199.1682.48516.62102,641.45
月 2491,199.1685.89513.21101,955.56
月 2501,199.1689.32509.78101,266.24
月 2511,199.1692.77506.33100,573.47
月 2521,199.1696.23502.8799,877.23
›第 22 年14,389.218,631.385,757.8491,245.86
月 2531,199.1699.71499.3999,177.52
月 2541,199.1703.21495.8998,474.3
月 2551,199.1706.73492.3797,767.57
月 2561,199.1710.26488.8497,057.31
月 2571,199.1713.81485.2996,343.5
月 2581,199.1717.38481.7295,626.11
月 2591,199.1720.97478.1394,905.14
月 2601,199.1724.58474.5394,180.57
月 2611,199.1728.2470.993,452.37
月 2621,199.1731.84467.2692,720.53
月 2631,199.1735.5463.691,985.03
月 2641,199.1739.18459.9391,245.86
›第 23 年14,389.219,163.745,225.4782,082.12
月 2651,199.1742.87456.2390,502.98
月 2661,199.1746.59452.5189,756.4
月 2671,199.1750.32448.7889,006.08
月 2681,199.1754.07445.0388,252.01
月 2691,199.1757.84441.2687,494.17
月 2701,199.1761.63437.4786,732.54
月 2711,199.1765.44433.6685,967.1
月 2721,199.1769.27429.8485,197.83
月 2731,199.1773.11425.9984,424.72
月 2741,199.1776.98422.1283,647.74
月 2751,199.1780.86418.2482,866.88
月 2761,199.1784.77414.3382,082.12
›第 24 年14,389.219,728.944,660.2772,353.17
月 2771,199.1788.69410.4181,293.42
月 2781,199.1792.63406.4780,500.79
月 2791,199.1796.6402.579,704.19
月 2801,199.1800.58398.5278,903.61
月 2811,199.1804.58394.5278,099.03
月 2821,199.1808.61390.577,290.42
月 2831,199.1812.65386.4576,477.78
月 2841,199.1816.71382.3975,661.06
月 2851,199.1820.8378.3174,840.27
月 2861,199.1824.9374.274,015.37
月 2871,199.1829.02370.0873,186.34
月 2881,199.1833.17365.9372,353.17
›第 25 年14,389.2110,3294,060.2162,024.17
月 2891,199.1837.34361.7771,515.84
月 2901,199.1841.52357.5870,674.32
月 2911,199.1845.73353.3769,828.59
月 2921,199.1849.96349.1468,978.63
月 2931,199.1854.21344.8968,124.42
月 2941,199.1858.48340.6267,265.94
月 2951,199.1862.77336.3366,403.17
月 2961,199.1867.09332.0265,536.09
月 2971,199.1871.42327.6864,664.67
月 2981,199.1875.78323.3263,788.89
月 2991,199.1880.16318.9462,908.73
月 3001,199.1884.56314.5462,024.17
›第 26 年14,389.2110,966.073,423.1451,058.1
月 3011,199.1888.98310.1261,135.19
月 3021,199.1893.43305.6860,241.77
月 3031,199.1897.89301.2159,343.88
月 3041,199.1902.38296.7258,441.5
月 3051,199.1906.89292.2157,534.6
月 3061,199.1911.43287.6756,623.17
月 3071,199.1915.99283.1255,707.19
月 3081,199.1920.57278.5454,786.62
月 3091,199.1925.17273.9353,861.46
月 3101,199.1929.79269.3152,931.66
月 3111,199.1934.44264.6651,997.22
月 3121,199.1939.11259.9951,058.1
›第 27 年14,389.2111,642.432,746.7839,415.67
月 3131,199.1943.81255.2950,114.29
月 3141,199.1948.53250.5749,165.76
月 3151,199.1953.27245.8348,212.49
月 3161,199.1958.04241.0647,254.45
月 3171,199.1962.83236.2746,291.62
月 3181,199.1967.64231.4645,323.98
月 3191,199.1972.48226.6244,351.5
月 3201,199.1977.34221.7643,374.16
月 3211,199.1982.23216.8742,391.93
月 3221,199.1987.14211.9641,404.78
月 3231,199.1992.08207.0240,412.71
月 3241,199.1997.04202.0639,415.67
›第 28 年14,389.2112,360.512,028.727,055.16
月 3251,199.11,002.02197.0838,413.65
月 3261,199.11,007.03192.0737,406.61
月 3271,199.11,012.07187.0336,394.55
月 3281,199.11,017.13181.9735,377.42
月 3291,199.11,022.21176.8934,355.2
月 3301,199.11,027.33171.7833,327.88
月 3311,199.11,032.46166.6432,295.42
月 3321,199.11,037.62161.4831,257.79
月 3331,199.11,042.81156.2930,214.98
月 3341,199.11,048.03151.0729,166.96
月 3351,199.11,053.27145.8328,113.69
月 3361,199.11,058.53140.5727,055.16
›第 29 年14,389.2113,122.881,266.3313,932.27
月 3371,199.11,063.83135.2825,991.33
月 3381,199.11,069.14129.9624,922.19
月 3391,199.11,074.49124.6123,847.7
月 3401,199.11,079.86119.2422,767.83
月 3411,199.11,085.26113.8421,682.57
月 3421,199.11,090.69108.4120,591.88
月 3431,199.11,096.14102.9619,495.74
月 3441,199.11,101.6297.4818,394.12
月 3451,199.11,107.1391.9717,286.99
月 3461,199.11,112.6786.4316,174.32
月 3471,199.11,118.2380.8715,056.09
月 3481,199.11,123.8275.2813,932.27
›第 30 年14,389.2113,932.27456.940
月 3491,199.11,129.4469.6612,802.83
月 3501,199.11,135.0964.0111,667.75
月 3511,199.11,140.7658.3410,526.98
月 3521,199.11,146.4752.639,380.52
月 3531,199.11,152.246.98,228.32
月 3541,199.11,157.9641.147,070.36
月 3551,199.11,163.7535.355,906.61
月 3561,199.11,169.5729.534,737.04
月 3571,199.11,175.4223.693,561.63
月 3581,199.11,181.2917.812,380.33
月 3591,199.11,187.211.91,193.14
月 3601,199.11,193.145.970
相关工具
工作原理
摊还原理
每月固定月供拆分为利息 (按当前余额计) 和本金 (实际还款)。贷款初期余额高,月供大部分是利息。余额逐月减少,利息减少,更多月供归入本金 —— 最终几期几乎全为本金。
标准固定利率摊还公式: 月供 = P × r / (1 − (1+r)⁻ⁿ),P 为本金,r 为月利率 (年利率÷12),n 为月数。月供金额恒定,但本金/利息比例随余额变化。
为何摊还表重要
可清楚看到本金与利息的「交叉点」。30 年 6% 住房贷款约在第 13 年交叉 —— 即前 13 年大部分还款是利息而非积累净值。
长期贷款成本一目了然。同利率下 15 年贷款总利息可能仅为 30 年的一半。表格的最末余额行与总利息数清晰展示长期成本。
提前还款越早越省。前 5 年每月多还 1000 元的节省效果远大于 26-30 年每月多还 1000 元。摊还表让此一目了然。
局限
仅适用于固定利率。浮动利率每次调整需重新计算。
不含税费、保险、PMI、托管账户。本工具「月供」为纯本息。总住房支出还需另加税保等。
不模拟提前还款情景。如有提前还款,之后的计划不再准确。请按新余额重新计算。
复利: 假设月复利 (美国房贷标准)。某些产品采用日复利或单利,本工具结果为近似值。
计算公式与资料来源
每一行按递推方式计算：当月利息 = 剩余本金 ×（年利率 ÷ 12）；当月归还本金 = 固定月供 − 当月利息；新余额 = 上期余额 − 归还本金。固定月供本身来自等额本息公式 M = P × r ÷ (1 − (1 + r)⁻ⁿ)。
这是 Investopedia 和 CFPB 记载的标准摊还算法（见资料来源）。银行实际的还款计划表可能因舍入规则相差几分钱；若贷款按日计息或采用浮动利率，差异会更大。
常见问题
›为何银行账单数字不同?
实际贷款月供包含税费、保险、PMI、托管账户。本工具仅为纯本息 (P&I)。扣除附加项即可对应。
›每月利息如何计算?
月利息 = 当前余额 × 月利率。然后 本金 = 月供 − 利息。新余额 = 旧余额 − 本金。重复 n 月。
›为何初期还款似乎被利息「浪费」?
并非浪费 —— 这是为高余额时期支付的成本。余额 × 利率 = 利息,这数学是诚实的。余额下降利息也下降。
›1% 利率变动的影响?
月供约升降 12%,30 年贷款总利息约升降 25-35%。可能时锁定低利率。
›应该每月多还本金吗?
如无提前还款罚息 (美国房贷一般无),应该。即使每月多还 100 美元,早期也能省下数千。摊还表展示此影响。
›什么是气球贷款?
常规月供不能完全摊还,最末有大额「气球」尾款的贷款。商业地产常见,住宅少见。本工具不模拟气球贷款。
›为何 30 年比 15 年总利息高那么多?
复利不利于贷款人。同利率下 30 年贷款总利息约为 15 年的两倍,因为期限越短,高余额阶段越短。
›数据会上传吗?
不会。计算和 CSV 下载都在浏览器内完成。
来源与计算依据
本工具仅提供一般信息和估算，不构成金融、投资、税务或法律建议。做出重要决定前，请向合格的专业人士核实。