FXEA365 — 免費MT5自動交易EA
Sponsored本站同一團隊開發的MT5智能交易系統：公開多年回測數據，強制硬停損，提供免費版本。
查看免費EA →貸款攤還表 計算器 (月度 / 年度)
輸入本金、年利率、年限。返回月供、總利息、總還款額,以及逐月每期本金與利息分解、期末餘額。可切換全部月份/年度摘要,支援 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 下載都在瀏覽器內完成。
來源與計算依據
推薦服務
廣告說明Fiverr
SponsoredHire freelancers for design, writing, dev, and marketing — or sell your own services. Millions of gigs at every budget.
Browse Fiverr →NordVPN
SponsoredStrict no-logs VPN with 6,400+ servers in 111 countries. Threat Protection blocks ads, trackers, and malware while you work online.
Get NordVPN →
本工具僅提供一般資訊與估算，不構成金融、投資、稅務或法律建議。做出重要決定前，請向合格的專業人士確認。