ホーム / お金

住宅ローン繰上げ返済計算機

毎月・毎年・一括の元金追加返済による住宅ローンの完済日と利息削減額を、返済予定表とともに確認できます。

住宅ローン繰上げ返済計算機: 通常の収入、年次ボーナス、一括のまとまった資金に合わせて、住宅ローンの追加返済を計画できます。返済期間を短縮した場合の完済予定と、残りの固定金利による返済スケジュールを比較し、毎月の元金と利息の返済額を確認できます。 サーバーへのファイルアップロードは一切なく、100%ブラウザ内でローカル実行します。

実行回数
ブラウザ内で
コスト
無料 · 登録不要
提供状況
すぐに使えます
住宅ローン完済プランナーローカル処理

完全にブラウザ内で実行します

追加額は予定支払額とともに元金に充当されます。毎年の追加額は12回目の支払いから始まります。完済後の一時的な追加支払いは効果がありません。通常の支払額は残高と残存期間から見積もります。リキャスト、エスクロー、期限前返済違約金は含みません。

新しい完済日
初回支払日を選択
節約できる利息($)
49,138.41
短縮できる月数
65
通常の月額元金・利息($)
1,199.10
新しい総利息($)
182,537.97
残りの支払い回数
295
返済予定表 — 295回の支払い
選択した追加額をすべて含む月額
支払い回数支払額($)元金($)利息($)残高($)
11,299.10299.101,000.00199,700.90
21,299.10300.60998.50199,400.30
31,299.10302.10997.00199,098.20
41,299.10303.61995.49198,794.59
51,299.10305.13993.97198,489.46
61,299.10306.65992.45198,182.81
71,299.10308.19990.91197,874.62
81,299.10309.73989.37197,564.90
91,299.10311.28987.82197,253.62
101,299.10312.83986.27196,940.79
111,299.10314.40984.70196,626.39
121,299.10315.97983.13196,310.42
131,299.10317.55981.55195,992.87
141,299.10319.14979.96195,673.73
151,299.10320.73978.37195,353.00
161,299.10322.34976.77195,030.67
171,299.10323.95975.15194,706.72
181,299.10325.57973.53194,381.15
191,299.10327.20971.91194,053.96
201,299.10328.83970.27193,725.12
211,299.10330.48968.63193,394.65
221,299.10332.13966.97193,062.52
231,299.10333.79965.31192,728.73
241,299.10335.46963.64192,393.28
251,299.10337.13961.97192,056.14
261,299.10338.82960.28191,717.32
271,299.10340.51958.59191,376.81
281,299.10342.22956.88191,034.59
291,299.10343.93955.17190,690.66
301,299.10345.65953.45190,345.01
311,299.10347.38951.73189,997.64
321,299.10349.11949.99189,648.52
331,299.10350.86948.24189,297.67
341,299.10352.61946.49188,945.05
351,299.10354.38944.73188,590.68
361,299.10356.15942.95188,234.53
371,299.10357.93941.17187,876.60
381,299.10359.72939.38187,516.88
391,299.10361.52937.58187,155.37
401,299.10363.32935.78186,792.04
411,299.10365.14933.96186,426.90
421,299.10366.97932.13186,059.94
431,299.10368.80930.30185,691.13
441,299.10370.65928.46185,320.49
451,299.10372.50926.60184,947.99
461,299.10374.36924.74184,573.63
471,299.10376.23922.87184,197.40
481,299.10378.11920.99183,819.28
491,299.10380.00919.10183,439.28
501,299.10381.90917.20183,057.37
511,299.10383.81915.29182,673.56
521,299.10385.73913.37182,287.82
531,299.10387.66911.44181,900.16
541,299.10389.60909.50181,510.56
551,299.10391.55907.55181,119.01
561,299.10393.51905.60180,725.51
571,299.10395.47903.63180,330.03
581,299.10397.45901.65179,932.58
591,299.10399.44899.66179,533.15
601,299.10401.44897.67179,131.71
611,299.10403.44895.66178,728.27
621,299.10405.46893.64178,322.81
631,299.10407.49891.61177,915.32
641,299.10409.52889.58177,505.80
651,299.10411.57887.53177,094.22
661,299.10413.63885.47176,680.59
671,299.10415.70883.40176,264.90
681,299.10417.78881.32175,847.12
691,299.10419.87879.24175,427.25
701,299.10421.96877.14175,005.29
711,299.10424.07875.03174,581.22
721,299.10426.19872.91174,155.02
731,299.10428.33870.78173,726.69
741,299.10430.47868.63173,296.23
751,299.10432.62866.48172,863.61
761,299.10434.78864.32172,428.82
771,299.10436.96862.14171,991.87
781,299.10439.14859.96171,552.73
791,299.10441.34857.76171,111.39
801,299.10443.54855.56170,667.84
811,299.10445.76853.34170,222.08
821,299.10447.99851.11169,774.09
831,299.10450.23848.87169,323.86
841,299.10452.48846.62168,871.38
851,299.10454.74844.36168,416.63
861,299.10457.02842.08167,959.62
871,299.10459.30839.80167,500.31
881,299.10461.60837.50167,038.71
891,299.10463.91835.19166,574.81
901,299.10466.23832.87166,108.58
911,299.10468.56830.54165,640.02
921,299.10470.90828.20165,169.12
931,299.10473.26825.85164,695.87
941,299.10475.62823.48164,220.24
951,299.10478.00821.10163,742.24
961,299.10480.39818.71163,261.85
971,299.10482.79816.31162,779.06
981,299.10485.21813.90162,293.86
991,299.10487.63811.47161,806.22
1001,299.10490.07809.03161,316.15
1011,299.10492.52806.58160,823.63
1021,299.10494.98804.12160,328.65
1031,299.10497.46801.64159,831.19
1041,299.10499.95799.16159,331.25
1051,299.10502.44796.66158,828.80
1061,299.10504.96794.14158,323.85
1071,299.10507.48791.62157,816.37
1081,299.10510.02789.08157,306.35
1091,299.10512.57786.53156,793.78
1101,299.10515.13783.97156,278.64
1111,299.10517.71781.39155,760.94
1121,299.10520.30778.80155,240.64
1131,299.10522.90776.20154,717.74
1141,299.10525.51773.59154,192.23
1151,299.10528.14770.96153,664.09
1161,299.10530.78768.32153,133.31
1171,299.10533.43765.67152,599.88
1181,299.10536.10763.00152,063.77
1191,299.10538.78760.32151,524.99
1201,299.10541.48757.62150,983.52
1211,299.10544.18754.92150,439.33
1221,299.10546.90752.20149,892.43
1231,299.10549.64749.46149,342.79
1241,299.10552.39746.71148,790.40
1251,299.10555.15743.95148,235.25
1261,299.10557.92741.18147,677.33
1271,299.10560.71738.39147,116.61
1281,299.10563.52735.58146,553.10
1291,299.10566.34732.77145,986.76
1301,299.10569.17729.93145,417.59
1311,299.10572.01727.09144,845.58
1321,299.10574.87724.23144,270.71
1331,299.10577.75721.35143,692.96
1341,299.10580.64718.46143,112.32
1351,299.10583.54715.56142,528.78
1361,299.10586.46712.64141,942.33
1371,299.10589.39709.71141,352.94
1381,299.10592.34706.76140,760.60
1391,299.10595.30703.80140,165.30
1401,299.10598.27700.83139,567.03
1411,299.10601.27697.84138,965.76
1421,299.10604.27694.83138,361.49
1431,299.10607.29691.81137,754.20
1441,299.10610.33688.77137,143.87
1451,299.10613.38685.72136,530.48
1461,299.10616.45682.65135,914.04
1471,299.10619.53679.57135,294.50
1481,299.10622.63676.47134,671.88
1491,299.10625.74673.36134,046.13
1501,299.10628.87670.23133,417.26
1511,299.10632.01667.09132,785.25
1521,299.10635.17663.93132,150.07
1531,299.10638.35660.75131,511.72
1541,299.10641.54657.56130,870.18
1551,299.10644.75654.35130,225.43
1561,299.10647.97651.13129,577.46
1571,299.10651.21647.89128,926.24
1581,299.10654.47644.63128,271.77
1591,299.10657.74641.36127,614.03
1601,299.10661.03638.07126,953.00
1611,299.10664.34634.77126,288.66
1621,299.10667.66631.44125,621.01
1631,299.10671.00628.11124,950.01
1641,299.10674.35624.75124,275.66
1651,299.10677.72621.38123,597.94
1661,299.10681.11617.99122,916.83
1671,299.10684.52614.58122,232.31
1681,299.10687.94611.16121,544.37
1691,299.10691.38607.72120,852.99
1701,299.10694.84604.26120,158.15
1711,299.10698.31600.79119,459.84
1721,299.10701.80597.30118,758.04
1731,299.10705.31593.79118,052.73
1741,299.10708.84590.26117,343.89
1751,299.10712.38586.72116,631.51
1761,299.10715.94583.16115,915.57
1771,299.10719.52579.58115,196.05
1781,299.10723.12575.98114,472.92
1791,299.10726.74572.36113,746.19
1801,299.10730.37568.73113,015.82
1811,299.10734.02565.08112,281.80
1821,299.10737.69561.41111,544.10
1831,299.10741.38557.72110,802.72
1841,299.10745.09554.01110,057.64
1851,299.10748.81550.29109,308.82
1861,299.10752.56546.54108,556.27
1871,299.10756.32542.78107,799.95
1881,299.10760.10539.00107,039.84
1891,299.10763.90535.20106,275.94
1901,299.10767.72531.38105,508.22
1911,299.10771.56527.54104,736.66
1921,299.10775.42523.68103,961.24
1931,299.10779.29519.81103,181.95
1941,299.10783.19515.91102,398.76
1951,299.10787.11511.99101,611.65
1961,299.10791.04508.06100,820.61
1971,299.10795.00504.10100,025.61
1981,299.10798.97500.1399,226.64
1991,299.10802.97496.1398,423.67
2001,299.10806.98492.1297,616.69
2011,299.10811.02488.0896,805.67
2021,299.10815.07484.0395,990.60
2031,299.10819.15479.9595,171.45
2041,299.10823.24475.8694,348.20
2051,299.10827.36471.7493,520.84
2061,299.10831.50467.6092,689.35
2071,299.10835.65463.4591,853.69
2081,299.10839.83459.2791,013.86
2091,299.10844.03455.0790,169.83
2101,299.10848.25450.8589,321.58
2111,299.10852.49446.6188,469.08
2121,299.10856.76442.3587,612.33
2131,299.10861.04438.0686,751.29
2141,299.10865.34433.7685,885.94
2151,299.10869.67429.4385,016.27
2161,299.10874.02425.0884,142.25
2171,299.10878.39420.7183,263.86
2181,299.10882.78416.3282,381.08
2191,299.10887.20411.9181,493.89
2201,299.10891.63407.4780,602.25
2211,299.10896.09403.0179,706.16
2221,299.10900.57398.5378,805.59
2231,299.10905.07394.0377,900.52
2241,299.10909.60389.5076,990.92
2251,299.10914.15384.9576,076.78
2261,299.10918.72380.3875,158.06
2271,299.10923.31375.7974,234.75
2281,299.10927.93371.1773,306.82
2291,299.10932.57366.5372,374.25
2301,299.10937.23361.8771,437.02
2311,299.10941.92357.1970,495.11
2321,299.10946.63352.4869,548.48
2331,299.10951.36347.7468,597.12
2341,299.10956.12342.9967,641.01
2351,299.10960.90338.2166,680.11
2361,299.10965.70333.4065,714.41
2371,299.10970.53328.5764,743.88
2381,299.10975.38323.7263,768.50
2391,299.10980.26318.8462,788.24
2401,299.10985.16313.9461,803.08
2411,299.10990.09309.0260,813.00
2421,299.10995.04304.0659,817.96
2431,299.101,000.01299.0958,817.95
2441,299.101,005.01294.0957,812.94
2451,299.101,010.04289.0656,802.90
2461,299.101,015.09284.0155,787.82
2471,299.101,020.16278.9454,767.65
2481,299.101,025.26273.8453,742.39
2491,299.101,030.39268.7152,712.00
2501,299.101,035.54263.5651,676.46
2511,299.101,040.72258.3850,635.74
2521,299.101,045.92253.1849,589.82
2531,299.101,051.15247.9548,538.67
2541,299.101,056.41242.6947,482.26
2551,299.101,061.69237.4146,420.57
2561,299.101,067.00232.1045,353.57
2571,299.101,072.33226.7744,281.24
2581,299.101,077.69221.4143,203.54
2591,299.101,083.08216.0242,120.46
2601,299.101,088.50210.6041,031.96
2611,299.101,093.94205.1639,938.02
2621,299.101,099.41199.6938,838.61
2631,299.101,104.91194.1937,733.70
2641,299.101,110.43188.6736,623.27
2651,299.101,115.98183.1235,507.28
2661,299.101,121.56177.5434,385.72
2671,299.101,127.17171.9333,258.55
2681,299.101,132.81166.2932,125.74
2691,299.101,138.47160.6330,987.27
2701,299.101,144.16154.9429,843.10
2711,299.101,149.89149.2228,693.22
2721,299.101,155.63143.4727,537.58
2731,299.101,161.41137.6926,376.17
2741,299.101,167.22131.8825,208.95
2751,299.101,173.06126.0424,035.89
2761,299.101,178.92120.1822,856.97
2771,299.101,184.82114.2821,672.15
2781,299.101,190.74108.3620,481.41
2791,299.101,196.69102.4119,284.72
2801,299.101,202.6896.4218,082.04
2811,299.101,208.6990.4116,873.35
2821,299.101,214.7384.3715,658.62
2831,299.101,220.8178.2914,437.81
2841,299.101,226.9172.1913,210.90
2851,299.101,233.0566.0511,977.85
2861,299.101,239.2159.8910,738.64
2871,299.101,245.4153.699,493.23
2881,299.101,251.6347.478,241.60
2891,299.101,257.8941.216,983.70
2901,299.101,264.1834.925,719.52
2911,299.101,270.5028.604,449.02
2921,299.101,276.8622.253,172.16
2931,299.101,283.2415.861,888.92
2941,299.101,289.669.44599.26
295602.26599.263.000.00

月ごとの返済スケジュール

OpenStax:ローンの償却:https://openstax.org/books/principles-finance-2e/pages/8-3-loan-amortization では、定期的な返済によってローン残高が減る仕組みを説明しています。月利をr、返済回数をnとすると、返済額 = 元金 × r / (1 − (1 + r)^−n)です。利息が0の場合は、元金をnで割ります。

毎月、通常の返済額と追加返済額を適用する前に、期首残高に利息が加算されます。最終回の返済額は、未返済額を超えないように調整されます。金額は完全な精度で計算し、セント単位まで表示します。

日付と追加元金返済

最初の予定返済を返済1とします。その後の返済日は同じ日付となり、必要に応じて月末に調整されます。日付は、毎月の返済が中断なく行われることを前提としています。

CFPB:繰り上げ返済手数料:https://www.consumerfinance.gov/ask-cfpb/what-is-a-prepayment-penalty-en-1957/ では、早期返済時にローン条件が重要となる理由を説明しています。このモデルには、手数料、エスクロー、住宅ローンのリキャストは含まれていません。

使い方

  1. 住宅ローンの残高、金利、返済期間を入力します。
  2. 毎月・毎年・一括の追加返済額を入力し、初回の返済日を選びます。
  3. 新しい完済日を確認し、返済予定表を開きます。

プライバシーと制限事項

計算はすべてブラウザ上で実行されます。金融情報がアップロードされることはありません。

関連ツール

よくある質問

毎年の追加返済はいつ行われますか?

返済回数12回目、24回目、36回目、およびそれ以降の12の倍数の回に行われます。一括返済は入力した返済回数に行われます。

追加返済をすると、通常の返済額は下がりますか?

この計算では、通常の元金と利息の返済額は変えず、返済期間を短縮します。住宅ローンのリキャストは計算対象ではありません。

住宅ローンに繰上げ返済手数料がある場合はどうなりますか?

この試算では手数料を差し引きません。節約額を判断する前に、ローンの契約条件と、金融機関が追加元金をどのように適用するかを確認してください。

無料ツール · ブラウザ内で · アカウント不要