我们在办理按揭贷款的时候,银行一定会问你等额本金还是等额本息的还款方式选哪一个。现在我们就定量的分析一下,这两个究竟有何差别。
假设银行年利率是R,则月利率为R/12,某人贷款总额为M,还款期为20年,240个月,则按照等额本息来计算,每月还款额该多少呢?
假设每月还款为X,每期剩余还款额为Q ,当贷款下来那一刻,你还没有开始还款,所以如下公式成立:
第一期还款后,欠款总额为:
第二期还款后,欠款总额为:
第三期还款后,欠款总额为:
递推得到如下公式(严格的说应该根据数学归纳法去证明),到达第k期还款后,剩余欠款总额为:
根据等比数列的求和公式:
当的时候,还款完毕,所以:
所以,等额本息情况下,每月还款金额为:
这个公式也就是大家常见到的等额本金还款计算方式的文字描述版:
用年利率表示:
每月均还X元,这X元有多少本金和利息呢?
第一个月的利息和剩余本金为:
依次计算,寻找规律:
。。。。。。
规律已经很明显了,总结归纳得到,经过k期后,下一期的本金额和利息额计算公式分别为:
并且,下面的公式永远成立:
以上是通过归纳看出来的,本着严谨至上的原则,我们还是来证明一把,就用数学归纳法。
假设K的时候等式成立
则k+1时:
带入上式:
简单的合并同类项:
所以,最终得到一样的形式:
上述经验总结公式得证.
对于等额本息的还款公式,总结如下:
每月还款额计算公式:
当月利息额计算公式:
当月本金额的计算公式:
以贷款100万,期限20年,年利率为4.6%来计算,套用如上公式,编程得到每月还款金额为6380.600586元,每月的利息和本金额打印所示,根据银行的计算器实际验证,是完全吻合的。
总利息最好算了,在等额本息情况下,每月的还款额都是固定的。所以:
总利息=每月还款额* 还款月数 - 总贷款本金额.
也就是:
当然,实际场景中,年利率是浮动变化的,尤其是新的LPR基准利率施行后,每个月都会有一个新的LPR基准利率,但是无论利率如何变化,都是在新的利率的基础上调用上述公式,公式的形式是不会变化的。
计算利息总额,根据上面的公式,首先计算每月还款额X,贷款利率为4.6%
高次幂过于繁琐,这里编程实现:
得到每月还款额为6380.600586元。
所以总共利息为
总支付利息与本金的比例为53.13%,也就是有相当于本金一半多的利息。
另外,通过公式
可以看到总的利息额和还款周期的关系,还款期越长,缴纳的利息越多。
等额本金的处理方式简单很多,还是以上面的条件为例,贷款总额M,按照每月固定本金还款,20年240个月,所以每月应还本金为:
假设经过K个月的还款,则下一个月的还款利息为:
共计当月总还款额为:
等额本金还款方式支付的利息总和:
其实通过上面的推导出的公式也可以看出,对于任意一个还款期限n月,其宗的利息为
从公式可以看出,利息总额和还款周期月数成正比。
M=1000000情况下,贷款年利率k为4.6%时,还款20年,共计利息为:1000000*0.046/12*120.5=461916.666667 元。与本金的比例为46.2%,利息量约占本金的不到一半。
对比之前等额本息的还款方式需要支付的利息数531344.14064
则,采用等额本金的还款方式后,可以节省利息为:
也就是,固定本金大约可以节省7万元利息。既然可以节省这么多的利息,是不是说明固定本金要好于固定本息呢?不一定,原因有两点:
1.等额本息每个月还款一样,还款前期的压力不会太大,开始的月供要小于固定本金.
2.相对于固定本金,固定本息持有本金的时间更长(最后才开始大规模还本金),对于善于投资的,可能投资赚到的钱高于多支付的利息,借的越多越久,对自己越有利。
关于第二点,我们可以证明:
第n期后,剩余本金为
等额本金的剩余余额:
绘图如下,不用计算积分,肉眼可以明显看到等额本息曲线下与坐标轴围城的面积大于等额本金下的面积,这说明等额本息情况下,对银行贷款资金的占用能力更强(单位为元*月),对于善于理财投资高的手来说,可以将这部分资金转化为收益,如果收益大于多支付的利息,可以选择这种。
还有一个疑问,等额本息一开始还款本金额小于等额本金,从上图中可以看到很明显了,但是能否证明以下呢?
前面推导得知,等额本溪每月还款本金额为:
而等额本金每月偿还本金额为:
要证明前者比后者大,还是作图吧:
从图中可以看出,等额本息的还款方式每月还款本金是低开高走,本金额度逐月增加,但是等额本金下,每月还款本金额度不变,并且两条曲线一定存在交点,表示在在整个还款周期,一定存在一个时间点,在这个时间点下,等额本金和等额本息下,当前还款本金额度是相同的。在下面的例子中,这个时间点发生在第130个还款月。
第129-130个月附近本金情况,可以看到还款本金额在这里发生了交叉,具体可看文章后续表格。
等额本息:
等额本金:
绘图如下,可以看到,等额本息利息曲线和坐标轴围城的面积大于等额本金,所以等额本息的总利息高于等额本金。
综合分析如下图,注意等额本息的利息曲线和本金曲线恰好互补为一条斜率为0的直线,等额本息嘛,而等额本金则是一条一次曲线,斜率为,也就是每月还款减少额,它等于每期本金产生的利息。
有了以上推导出来的公式,我们就可以分别制定两种方式下的还款计划表了,如下:
等额本金还款方式 | 等额本息还款方式 | |||||||
贷款期次 | 偿还本息 | 偿还利息 | 偿还本金 | 剩余本金 | 偿还本息 | 偿还利息 | 偿还本金 | 剩余本金 |
1 | 8,000.00 | 3,833.33 | 4,166.67 | 995,833.33 | 6,380.60 | 3,833.33 | 2,547.27 | 997,452.73 |
2 | 7,984.03 | 3,817.36 | 4,166.67 | 991,666.67 | 6,380.60 | 3,823.57 | 2,557.03 | 994,895.70 |
3 | 7,968.06 | 3,801.39 | 4,166.67 | 987,500.00 | 6,380.60 | 3,813.77 | 2,566.83 | 992,328.87 |
4 | 7,952.08 | 3,785.42 | 4,166.67 | 983,333.33 | 6,380.60 | 3,803.93 | 2,576.67 | 989,752.19 |
5 | 7,936.11 | 3,769.44 | 4,166.67 | 979,166.67 | 6,380.60 | 3,794.05 | 2,586.55 | 987,165.64 |
6 | 7,920.14 | 3,753.47 | 4,166.67 | 975,000.00 | 6,380.60 | 3,784.13 | 2,596.47 | 984,569.18 |
7 | 7,904.17 | 3,737.50 | 4,166.67 | 970,833.33 | 6,380.60 | 3,774.18 | 2,606.42 | 981,962.76 |
8 | 7,888.19 | 3,721.53 | 4,166.67 | 966,666.67 | 6,380.60 | 3,764.19 | 2,616.41 | 979,346.35 |
9 | 7,872.22 | 3,705.56 | 4,166.67 | 962,500.00 | 6,380.60 | 3,754.16 | 2,626.44 | 976,719.91 |
10 | 7,856.25 | 3,689.58 | 4,166.67 | 958,333.33 | 6,380.60 | 3,744.09 | 2,636.51 | 974,083.40 |
11 | 7,840.28 | 3,673.61 | 4,166.67 | 954,166.67 | 6,380.60 | 3,733.99 | 2,646.61 | 971,436.79 |
12 | 7,824.31 | 3,657.64 | 4,166.67 | 950,000.00 | 6,380.60 | 3,723.84 | 2,656.76 | 968,780.03 |
13 | 7,808.33 | 3,641.67 | 4,166.67 | 945,833.33 | 6,380.60 | 3,713.66 | 2,666.94 | 966,113.09 |
14 | 7,792.36 | 3,625.69 | 4,166.67 | 941,666.67 | 6,380.60 | 3,703.43 | 2,677.17 | 963,435.92 |
15 | 7,776.39 | 3,609.72 | 4,166.67 | 937,500.00 | 6,380.60 | 3,693.17 | 2,687.43 | 960,748.49 |
16 | 7,760.42 | 3,593.75 | 4,166.67 | 933,333.33 | 6,380.60 | 3,682.87 | 2,697.73 | 958,050.76 |
17 | 7,744.44 | 3,577.78 | 4,166.67 | 929,166.67 | 6,380.60 | 3,672.53 | 2,708.07 | 955,342.69 |
18 | 7,728.47 | 3,561.81 | 4,166.67 | 925,000.00 | 6,380.60 | 3,662.15 | 2,718.45 | 952,624.23 |
19 | 7,712.50 | 3,545.83 | 4,166.67 | 920,833.33 | 6,380.60 | 3,651.73 | 2,728.87 | 949,895.36 |
20 | 7,696.53 | 3,529.86 | 4,166.67 | 916,666.67 | 6,380.60 | 3,641.27 | 2,739.33 | 947,156.02 |
21 | 7,680.56 | 3,513.89 | 4,166.67 | 912,500.00 | 6,380.60 | 3,630.76 | 2,749.84 | 944,406.19 |
22 | 7,664.58 | 3,497.92 | 4,166.67 | 908,333.33 | 6,380.60 | 3,620.22 | 2,760.38 | 941,645.81 |
23 | 7,648.61 | 3,481.94 | 4,166.67 | 904,166.67 | 6,380.60 | 3,609.64 | 2,770.96 | 938,874.85 |
24 | 7,632.64 | 3,465.97 | 4,166.67 | 900,000.00 | 6,380.60 | 3,599.02 | 2,781.58 | 936,093.27 |
25 | 7,616.67 | 3,450.00 | 4,166.67 | 895,833.33 | 6,380.60 | 3,588.36 | 2,792.24 | 933,301.03 |
26 | 7,600.69 | 3,434.03 | 4,166.67 | 891,666.67 | 6,380.60 | 3,577.65 | 2,802.95 | 930,498.09 |
27 | 7,584.72 | 3,418.06 | 4,166.67 | 887,500.00 | 6,380.60 | 3,566.91 | 2,813.69 | 927,684.39 |
28 | 7,568.75 | 3,402.08 | 4,166.67 | 883,333.33 | 6,380.60 | 3,556.12 | 2,824.48 | 924,859.92 |
29 | 7,552.78 | 3,386.11 | 4,166.67 | 879,166.67 | 6,380.60 | 3,545.30 | 2,835.30 | 922,024.61 |
30 | 7,536.81 | 3,370.14 | 4,166.67 | 875,000.00 | 6,380.60 | 3,534.43 | 2,846.17 | 919,178.44 |
31 | 7,520.83 | 3,354.17 | 4,166.67 | 870,833.33 | 6,380.60 | 3,523.52 | 2,857.08 | 916,321.36 |
32 | 7,504.86 | 3,338.19 | 4,166.67 | 866,666.67 | 6,380.60 | 3,512.57 | 2,868.04 | 913,453.32 |
33 | 7,488.89 | 3,322.22 | 4,166.67 | 862,500.00 | 6,380.60 | 3,501.57 | 2,879.03 | 910,574.29 |
34 | 7,472.92 | 3,306.25 | 4,166.67 | 858,333.33 | 6,380.60 | 3,490.53 | 2,890.07 | 907,684.23 |
35 | 7,456.94 | 3,290.28 | 4,166.67 | 854,166.67 | 6,380.60 | 3,479.46 | 2,901.14 | 904,783.08 |
36 | 7,440.97 | 3,274.31 | 4,166.67 | 850,000.00 | 6,380.60 | 3,468.34 | 2,912.27 | 901,870.82 |
37 | 7,425.00 | 3,258.33 | 4,166.67 | 845,833.33 | 6,380.60 | 3,457.17 | 2,923.43 | 898,947.39 |
38 | 7,409.03 | 3,242.36 | 4,166.67 | 841,666.67 | 6,380.60 | 3,445.96 | 2,934.64 | 896,012.75 |
39 | 7,393.06 | 3,226.39 | 4,166.67 | 837,500.00 | 6,380.60 | 3,434.72 | 2,945.88 | 893,066.87 |
40 | 7,377.08 | 3,210.42 | 4,166.67 | 833,333.33 | 6,380.60 | 3,423.42 | 2,957.18 | 890,109.69 |
41 | 7,361.11 | 3,194.44 | 4,166.67 | 829,166.67 | 6,380.60 | 3,412.09 | 2,968.51 | 887,141.18 |
42 | 7,345.14 | 3,178.47 | 4,166.67 | 825,000.00 | 6,380.60 | 3,400.71 | 2,979.89 | 884,161.29 |
43 | 7,329.17 | 3,162.50 | 4,166.67 | 820,833.33 | 6,380.60 | 3,389.28 | 2,991.32 | 881,169.97 |
44 | 7,313.19 | 3,146.53 | 4,166.67 | 816,666.67 | 6,380.60 | 3,377.82 | 3,002.78 | 878,167.19 |
45 | 7,297.22 | 3,130.56 | 4,166.67 | 812,500.00 | 6,380.60 | 3,366.31 | 3,014.29 | 875,152.90 |
46 | 7,281.25 | 3,114.58 | 4,166.67 | 808,333.33 | 6,380.60 | 3,354.75 | 3,025.85 | 872,127.05 |
47 | 7,265.28 | 3,098.61 | 4,166.67 | 804,166.67 | 6,380.60 | 3,343.15 | 3,037.45 | 869,089.60 |
48 | 7,249.31 | 3,082.64 | 4,166.67 | 800,000.00 | 6,380.60 | 3,331.51 | 3,049.09 | 866,040.51 |
49 | 7,233.33 | 3,066.67 | 4,166.67 | 795,833.33 | 6,380.60 | 3,319.82 | 3,060.78 | 862,979.73 |
50 | 7,217.36 | 3,050.69 | 4,166.67 | 791,666.67 | 6,380.60 | 3,308.09 | 3,072.51 | 859,907.22 |
51 | 7,201.39 | 3,034.72 | 4,166.67 | 787,500.00 | 6,380.60 | 3,296.31 | 3,084.29 | 856,822.93 |
52 | 7,185.42 | 3,018.75 | 4,166.67 | 783,333.33 | 6,380.60 | 3,284.49 | 3,096.11 | 853,726.82 |
53 | 7,169.44 | 3,002.78 | 4,166.67 | 779,166.67 | 6,380.60 | 3,272.62 | 3,107.98 | 850,618.84 |
54 | 7,153.47 | 2,986.81 | 4,166.67 | 775,000.00 | 6,380.60 | 3,260.71 | 3,119.89 | 847,498.94 |
55 | 7,137.50 | 2,970.83 | 4,166.67 | 770,833.33 | 6,380.60 | 3,248.75 | 3,131.85 | 844,367.09 |
56 | 7,121.53 | 2,954.86 | 4,166.67 | 766,666.67 | 6,380.60 | 3,236.74 | 3,143.86 | 841,223.23 |
57 | 7,105.56 | 2,938.89 | 4,166.67 | 762,500.00 | 6,380.60 | 3,224.69 | 3,155.91 | 838,067.32 |
58 | 7,089.58 | 2,922.92 | 4,166.67 | 758,333.33 | 6,380.60 | 3,212.59 | 3,168.01 | 834,899.31 |
59 | 7,073.61 | 2,906.94 | 4,166.67 | 754,166.67 | 6,380.60 | 3,200.45 | 3,180.15 | 831,719.16 |
60 | 7,057.64 | 2,890.97 | 4,166.67 | 750,000.00 | 6,380.60 | 3,188.26 | 3,192.34 | 828,526.81 |
61 | 7,041.67 | 2,875.00 | 4,166.67 | 745,833.33 | 6,380.60 | 3,176.02 | 3,204.58 | 825,322.23 |
62 | 7,025.69 | 2,859.03 | 4,166.67 | 741,666.67 | 6,380.60 | 3,163.74 | 3,216.87 | 822,105.37 |
63 | 7,009.72 | 2,843.06 | 4,166.67 | 737,500.00 | 6,380.60 | 3,151.40 | 3,229.20 | 818,876.17 |
64 | 6,993.75 | 2,827.08 | 4,166.67 | 733,333.33 | 6,380.60 | 3,139.03 | 3,241.58 | 815,634.59 |
65 | 6,977.78 | 2,811.11 | 4,166.67 | 729,166.67 | 6,380.60 | 3,126.60 | 3,254.00 | 812,380.59 |
66 | 6,961.81 | 2,795.14 | 4,166.67 | 725,000.00 | 6,380.60 | 3,114.13 | 3,266.47 | 809,114.12 |
67 | 6,945.83 | 2,779.17 | 4,166.67 | 720,833.33 | 6,380.60 | 3,101.60 | 3,279.00 | 805,835.12 |
68 | 6,929.86 | 2,763.19 | 4,166.67 | 716,666.67 | 6,380.60 | 3,089.03 | 3,291.57 | 802,543.56 |
69 | 6,913.89 | 2,747.22 | 4,166.67 | 712,500.00 | 6,380.60 | 3,076.42 | 3,304.18 | 799,239.37 |
70 | 6,897.92 | 2,731.25 | 4,166.67 | 708,333.33 | 6,380.60 | 3,063.75 | 3,316.85 | 795,922.52 |
71 | 6,881.94 | 2,715.28 | 4,166.67 | 704,166.67 | 6,380.60 | 3,051.04 | 3,329.56 | 792,592.96 |
72 | 6,865.97 | 2,699.31 | 4,166.67 | 700,000.00 | 6,380.60 | 3,038.27 | 3,342.33 | 789,250.63 |
73 | 6,850.00 | 2,683.33 | 4,166.67 | 695,833.33 | 6,380.60 | 3,025.46 | 3,355.14 | 785,895.49 |
74 | 6,834.03 | 2,667.36 | 4,166.67 | 691,666.67 | 6,380.60 | 3,012.60 | 3,368.00 | 782,527.49 |
75 | 6,818.06 | 2,651.39 | 4,166.67 | 687,500.00 | 6,380.60 | 2,999.69 | 3,380.91 | 779,146.58 |
76 | 6,802.08 | 2,635.42 | 4,166.67 | 683,333.33 | 6,380.60 | 2,986.73 | 3,393.87 | 775,752.71 |
77 | 6,786.11 | 2,619.44 | 4,166.67 | 679,166.67 | 6,380.60 | 2,973.72 | 3,406.88 | 772,345.83 |
78 | 6,770.14 | 2,603.47 | 4,166.67 | 675,000.00 | 6,380.60 | 2,960.66 | 3,419.94 | 768,925.89 |
79 | 6,754.17 | 2,587.50 | 4,166.67 | 670,833.33 | 6,380.60 | 2,947.55 | 3,433.05 | 765,492.83 |
80 | 6,738.19 | 2,571.53 | 4,166.67 | 666,666.67 | 6,380.60 | 2,934.39 | 3,446.21 | 762,046.62 |
81 | 6,722.22 | 2,555.56 | 4,166.67 | 662,500.00 | 6,380.60 | 2,921.18 | 3,459.42 | 758,587.20 |
82 | 6,706.25 | 2,539.58 | 4,166.67 | 658,333.33 | 6,380.60 | 2,907.92 | 3,472.68 | 755,114.52 |
83 | 6,690.28 | 2,523.61 | 4,166.67 | 654,166.67 | 6,380.60 | 2,894.61 | 3,485.99 | 751,628.52 |
84 | 6,674.31 | 2,507.64 | 4,166.67 | 650,000.00 | 6,380.60 | 2,881.24 | 3,499.36 | 748,129.17 |
85 | 6,658.33 | 2,491.67 | 4,166.67 | 645,833.33 | 6,380.60 | 2,867.83 | 3,512.77 | 744,616.39 |
86 | 6,642.36 | 2,475.69 | 4,166.67 | 641,666.67 | 6,380.60 | 2,854.36 | 3,526.24 | 741,090.16 |
87 | 6,626.39 | 2,459.72 | 4,166.67 | 637,500.00 | 6,380.60 | 2,840.85 | 3,539.75 | 737,550.40 |
88 | 6,610.42 | 2,443.75 | 4,166.67 | 633,333.33 | 6,380.60 | 2,827.28 | 3,553.32 | 733,997.08 |
89 | 6,594.44 | 2,427.78 | 4,166.67 | 629,166.67 | 6,380.60 | 2,813.66 | 3,566.94 | 730,430.13 |
90 | 6,578.47 | 2,411.81 | 4,166.67 | 625,000.00 | 6,380.60 | 2,799.98 | 3,580.62 | 726,849.52 |
91 | 6,562.50 | 2,395.83 | 4,166.67 | 620,833.33 | 6,380.60 | 2,786.26 | 3,594.34 | 723,255.17 |
92 | 6,546.53 | 2,379.86 | 4,166.67 | 616,666.67 | 6,380.60 | 2,772.48 | 3,608.12 | 719,647.05 |
93 | 6,530.56 | 2,363.89 | 4,166.67 | 612,500.00 | 6,380.60 | 2,758.65 | 3,621.95 | 716,025.10 |
94 | 6,514.58 | 2,347.92 | 4,166.67 | 608,333.33 | 6,380.60 | 2,744.76 | 3,635.84 | 712,389.26 |
95 | 6,498.61 | 2,331.94 | 4,166.67 | 604,166.67 | 6,380.60 | 2,730.83 | 3,649.77 | 708,739.48 |
96 | 6,482.64 | 2,315.97 | 4,166.67 | 600,000.00 | 6,380.60 | 2,716.83 | 3,663.77 | 705,075.72 |
97 | 6,466.67 | 2,300.00 | 4,166.67 | 595,833.33 | 6,380.60 | 2,702.79 | 3,677.81 | 701,397.91 |
98 | 6,450.69 | 2,284.03 | 4,166.67 | 591,666.67 | 6,380.60 | 2,688.69 | 3,691.91 | 697,706.00 |
99 | 6,434.72 | 2,268.06 | 4,166.67 | 587,500.00 | 6,380.60 | 2,674.54 | 3,706.06 | 693,999.94 |
100 | 6,418.75 | 2,252.08 | 4,166.67 | 583,333.33 | 6,380.60 | 2,660.33 | 3,720.27 | 690,279.67 |
101 | 6,402.78 | 2,236.11 | 4,166.67 | 579,166.67 | 6,380.60 | 2,646.07 | 3,734.53 | 686,545.14 |
102 | 6,386.81 | 2,220.14 | 4,166.67 | 575,000.00 | 6,380.60 | 2,631.76 | 3,748.84 | 682,796.30 |
103 | 6,370.83 | 2,204.17 | 4,166.67 | 570,833.33 | 6,380.60 | 2,617.39 | 3,763.21 | 679,033.08 |
104 | 6,354.86 | 2,188.19 | 4,166.67 | 566,666.67 | 6,380.60 | 2,602.96 | 3,777.64 | 675,255.44 |
105 | 6,338.89 | 2,172.22 | 4,166.67 | 562,500.00 | 6,380.60 | 2,588.48 | 3,792.12 | 671,463.32 |
106 | 6,322.92 | 2,156.25 | 4,166.67 | 558,333.33 | 6,380.60 | 2,573.94 | 3,806.66 | 667,656.67 |
107 | 6,306.94 | 2,140.28 | 4,166.67 | 554,166.67 | 6,380.60 | 2,559.35 | 3,821.25 | 663,835.42 |
108 | 6,290.97 | 2,124.31 | 4,166.67 | 550,000.00 | 6,380.60 | 2,544.70 | 3,835.90 | 659,999.52 |
109 | 6,275.00 | 2,108.33 | 4,166.67 | 545,833.33 | 6,380.60 | 2,530.00 | 3,850.60 | 656,148.92 |
110 | 6,259.03 | 2,092.36 | 4,166.67 | 541,666.67 | 6,380.60 | 2,515.24 | 3,865.36 | 652,283.55 |
111 | 6,243.06 | 2,076.39 | 4,166.67 | 537,500.00 | 6,380.60 | 2,500.42 | 3,880.18 | 648,403.37 |
112 | 6,227.08 | 2,060.42 | 4,166.67 | 533,333.33 | 6,380.60 | 2,485.55 | 3,895.05 | 644,508.32 |
113 | 6,211.11 | 2,044.44 | 4,166.67 | 529,166.67 | 6,380.60 | 2,470.62 | 3,909.99 | 640,598.33 |
114 | 6,195.14 | 2,028.47 | 4,166.67 | 525,000.00 | 6,380.60 | 2,455.63 | 3,924.97 | 636,673.36 |
115 | 6,179.17 | 2,012.50 | 4,166.67 | 520,833.33 | 6,380.60 | 2,440.58 | 3,940.02 | 632,733.34 |
116 | 6,163.19 | 1,996.53 | 4,166.67 | 516,666.67 | 6,380.60 | 2,425.48 | 3,955.12 | 628,778.22 |
117 | 6,147.22 | 1,980.56 | 4,166.67 | 512,500.00 | 6,380.60 | 2,410.32 | 3,970.28 | 624,807.93 |
118 | 6,131.25 | 1,964.58 | 4,166.67 | 508,333.33 | 6,380.60 | 2,395.10 | 3,985.50 | 620,822.43 |
119 | 6,115.28 | 1,948.61 | 4,166.67 | 504,166.67 | 6,380.60 | 2,379.82 | 4,000.78 | 616,821.65 |
120 | 6,099.31 | 1,932.64 | 4,166.67 | 500,000.00 | 6,380.60 | 2,364.48 | 4,016.12 | 612,805.53 |
121 | 6,083.33 | 1,916.67 | 4,166.67 | 495,833.33 | 6,380.60 | 2,349.09 | 4,031.51 | 608,774.02 |
122 | 6,067.36 | 1,900.69 | 4,166.67 | 491,666.67 | 6,380.60 | 2,333.63 | 4,046.97 | 604,727.05 |
123 | 6,051.39 | 1,884.72 | 4,166.67 | 487,500.00 | 6,380.60 | 2,318.12 | 4,062.48 | 600,664.57 |
124 | 6,035.42 | 1,868.75 | 4,166.67 | 483,333.33 | 6,380.60 | 2,302.55 | 4,078.05 | 596,586.52 |
125 | 6,019.44 | 1,852.78 | 4,166.67 | 479,166.67 | 6,380.60 | 2,286.91 | 4,093.69 | 592,492.84 |
126 | 6,003.47 | 1,836.81 | 4,166.67 | 475,000.00 | 6,380.60 | 2,271.22 | 4,109.38 | 588,383.46 |
127 | 5,987.50 | 1,820.83 | 4,166.67 | 470,833.33 | 6,380.60 | 2,255.47 | 4,125.13 | 584,258.33 |
128 | 5,971.53 | 1,804.86 | 4,166.67 | 466,666.67 | 6,380.60 | 2,239.66 | 4,140.94 | 580,117.38 |
129 | 5,955.56 | 1,788.89 | 4,166.67 | 462,500.00 | 6,380.60 | 2,223.78 | 4,156.82 | 575,960.57 |
130 | 5,939.58 | 1,772.92 | 4,166.67 | 458,333.33 | 6,380.60 | 2,207.85 | 4,172.75 | 571,787.81 |
131 | 5,923.61 | 1,756.94 | 4,166.67 | 454,166.67 | 6,380.60 | 2,191.85 | 4,188.75 | 567,599.07 |
132 | 5,907.64 | 1,740.97 | 4,166.67 | 450,000.00 | 6,380.60 | 2,175.80 | 4,204.80 | 563,394.26 |
133 | 5,891.67 | 1,725.00 | 4,166.67 | 445,833.33 | 6,380.60 | 2,159.68 | 4,220.92 | 559,173.34 |
134 | 5,875.69 | 1,709.03 | 4,166.67 | 441,666.67 | 6,380.60 | 2,143.50 | 4,237.10 | 554,936.24 |
135 | 5,859.72 | 1,693.06 | 4,166.67 | 437,500.00 | 6,380.60 | 2,127.26 | 4,253.34 | 550,682.89 |
136 | 5,843.75 | 1,677.08 | 4,166.67 | 433,333.33 | 6,380.60 | 2,110.95 | 4,269.65 | 546,413.24 |
137 | 5,827.78 | 1,661.11 | 4,166.67 | 429,166.67 | 6,380.60 | 2,094.58 | 4,286.02 | 542,127.23 |
138 | 5,811.81 | 1,645.14 | 4,166.67 | 425,000.00 | 6,380.60 | 2,078.15 | 4,302.45 | 537,824.78 |
139 | 5,795.83 | 1,629.17 | 4,166.67 | 420,833.33 | 6,380.60 | 2,061.66 | 4,318.94 | 533,505.84 |
140 | 5,779.86 | 1,613.19 | 4,166.67 | 416,666.67 | 6,380.60 | 2,045.11 | 4,335.49 | 529,170.35 |
141 | 5,763.89 | 1,597.22 | 4,166.67 | 412,500.00 | 6,380.60 | 2,028.49 | 4,352.11 | 524,818.24 |
142 | 5,747.92 | 1,581.25 | 4,166.67 | 408,333.33 | 6,380.60 | 2,011.80 | 4,368.80 | 520,449.44 |
143 | 5,731.94 | 1,565.28 | 4,166.67 | 404,166.67 | 6,380.60 | 1,995.06 | 4,385.54 | 516,063.89 |
144 | 5,715.97 | 1,549.31 | 4,166.67 | 400,000.00 | 6,380.60 | 1,978.24 | 4,402.36 | 511,661.54 |
145 | 5,700.00 | 1,533.33 | 4,166.67 | 395,833.33 | 6,380.60 | 1,961.37 | 4,419.23 | 507,242.31 |
146 | 5,684.03 | 1,517.36 | 4,166.67 | 391,666.67 | 6,380.60 | 1,944.43 | 4,436.17 | 502,806.14 |
147 | 5,668.06 | 1,501.39 | 4,166.67 | 387,500.00 | 6,380.60 | 1,927.42 | 4,453.18 | 498,352.96 |
148 | 5,652.08 | 1,485.42 | 4,166.67 | 383,333.33 | 6,380.60 | 1,910.35 | 4,470.25 | 493,882.71 |
149 | 5,636.11 | 1,469.44 | 4,166.67 | 379,166.67 | 6,380.60 | 1,893.22 | 4,487.38 | 489,395.33 |
150 | 5,620.14 | 1,453.47 | 4,166.67 | 375,000.00 | 6,380.60 | 1,876.02 | 4,504.58 | 484,890.74 |
151 | 5,604.17 | 1,437.50 | 4,166.67 | 370,833.33 | 6,380.60 | 1,858.75 | 4,521.85 | 480,368.89 |
152 | 5,588.19 | 1,421.53 | 4,166.67 | 366,666.67 | 6,380.60 | 1,841.41 | 4,539.19 | 475,829.70 |
153 | 5,572.22 | 1,405.56 | 4,166.67 | 362,500.00 | 6,380.60 | 1,824.01 | 4,556.59 | 471,273.12 |
154 | 5,556.25 | 1,389.58 | 4,166.67 | 358,333.33 | 6,380.60 | 1,806.55 | 4,574.05 | 466,699.06 |
155 | 5,540.28 | 1,373.61 | 4,166.67 | 354,166.67 | 6,380.60 | 1,789.01 | 4,591.59 | 462,107.48 |
156 | 5,524.31 | 1,357.64 | 4,166.67 | 350,000.00 | 6,380.60 | 1,771.41 | 4,609.19 | 457,498.29 |
157 | 5,508.33 | 1,341.67 | 4,166.67 | 345,833.33 | 6,380.60 | 1,753.74 | 4,626.86 | 452,871.43 |
158 | 5,492.36 | 1,325.69 | 4,166.67 | 341,666.67 | 6,380.60 | 1,736.01 | 4,644.59 | 448,226.84 |
159 | 5,476.39 | 1,309.72 | 4,166.67 | 337,500.00 | 6,380.60 | 1,718.20 | 4,662.40 | 443,564.44 |
160 | 5,460.42 | 1,293.75 | 4,166.67 | 333,333.33 | 6,380.60 | 1,700.33 | 4,680.27 | 438,884.17 |
161 | 5,444.44 | 1,277.78 | 4,166.67 | 329,166.67 | 6,380.60 | 1,682.39 | 4,698.21 | 434,185.96 |
162 | 5,428.47 | 1,261.81 | 4,166.67 | 325,000.00 | 6,380.60 | 1,664.38 | 4,716.22 | 429,469.74 |
163 | 5,412.50 | 1,245.83 | 4,166.67 | 320,833.33 | 6,380.60 | 1,646.30 | 4,734.30 | 424,735.44 |
164 | 5,396.53 | 1,229.86 | 4,166.67 | 316,666.67 | 6,380.60 | 1,628.15 | 4,752.45 | 419,982.99 |
165 | 5,380.56 | 1,213.89 | 4,166.67 | 312,500.00 | 6,380.60 | 1,609.93 | 4,770.67 | 415,212.33 |
166 | 5,364.58 | 1,197.92 | 4,166.67 | 308,333.33 | 6,380.60 | 1,591.65 | 4,788.95 | 410,423.37 |
167 | 5,348.61 | 1,181.94 | 4,166.67 | 304,166.67 | 6,380.60 | 1,573.29 | 4,807.31 | 405,616.06 |
168 | 5,332.64 | 1,165.97 | 4,166.67 | 300,000.00 | 6,380.60 | 1,554.86 | 4,825.74 | 400,790.32 |
169 | 5,316.67 | 1,150.00 | 4,166.67 | 295,833.33 | 6,380.60 | 1,536.36 | 4,844.24 | 395,946.09 |
170 | 5,300.69 | 1,134.03 | 4,166.67 | 291,666.67 | 6,380.60 | 1,517.79 | 4,862.81 | 391,083.28 |
171 | 5,284.72 | 1,118.06 | 4,166.67 | 287,500.00 | 6,380.60 | 1,499.15 | 4,881.45 | 386,201.83 |
172 | 5,268.75 | 1,102.08 | 4,166.67 | 283,333.33 | 6,380.60 | 1,480.44 | 4,900.16 | 381,301.67 |
173 | 5,252.78 | 1,086.11 | 4,166.67 | 279,166.67 | 6,380.60 | 1,461.66 | 4,918.94 | 376,382.73 |
174 | 5,236.81 | 1,070.14 | 4,166.67 | 275,000.00 | 6,380.60 | 1,442.80 | 4,937.80 | 371,444.93 |
175 | 5,220.83 | 1,054.17 | 4,166.67 | 270,833.33 | 6,380.60 | 1,423.87 | 4,956.73 | 366,488.20 |
176 | 5,204.86 | 1,038.19 | 4,166.67 | 266,666.67 | 6,380.60 | 1,404.87 | 4,975.73 | 361,512.47 |
177 | 5,188.89 | 1,022.22 | 4,166.67 | 262,500.00 | 6,380.60 | 1,385.80 | 4,994.80 | 356,517.67 |
178 | 5,172.92 | 1,006.25 | 4,166.67 | 258,333.33 | 6,380.60 | 1,366.65 | 5,013.95 | 351,503.72 |
179 | 5,156.94 | 990.28 | 4,166.67 | 254,166.67 | 6,380.60 | 1,347.43 | 5,033.17 | 346,470.55 |
180 | 5,140.97 | 974.31 | 4,166.67 | 250,000.00 | 6,380.60 | 1,328.14 | 5,052.46 | 341,418.09 |
181 | 5,125.00 | 958.33 | 4,166.67 | 245,833.33 | 6,380.60 | 1,308.77 | 5,071.83 | 336,346.25 |
182 | 5,109.03 | 942.36 | 4,166.67 | 241,666.67 | 6,380.60 | 1,289.33 | 5,091.27 | 331,254.98 |
183 | 5,093.06 | 926.39 | 4,166.67 | 237,500.00 | 6,380.60 | 1,269.81 | 5,110.79 | 326,144.19 |
184 | 5,077.08 | 910.42 | 4,166.67 | 233,333.33 | 6,380.60 | 1,250.22 | 5,130.38 | 321,013.81 |
185 | 5,061.11 | 894.44 | 4,166.67 | 229,166.67 | 6,380.60 | 1,230.55 | 5,150.05 | 315,863.76 |
186 | 5,045.14 | 878.47 | 4,166.67 | 225,000.00 | 6,380.60 | 1,210.81 | 5,169.79 | 310,693.97 |
187 | 5,029.17 | 862.50 | 4,166.67 | 220,833.33 | 6,380.60 | 1,190.99 | 5,189.61 | 305,504.37 |
188 | 5,013.19 | 846.53 | 4,166.67 | 216,666.67 | 6,380.60 | 1,171.10 | 5,209.50 | 300,294.87 |
189 | 4,997.22 | 830.56 | 4,166.67 | 212,500.00 | 6,380.60 | 1,151.13 | 5,229.47 | 295,065.40 |
190 | 4,981.25 | 814.58 | 4,166.67 | 208,333.33 | 6,380.60 | 1,131.08 | 5,249.52 | 289,815.88 |
191 | 4,965.28 | 798.61 | 4,166.67 | 204,166.67 | 6,380.60 | 1,110.96 | 5,269.64 | 284,546.24 |
192 | 4,949.31 | 782.64 | 4,166.67 | 200,000.00 | 6,380.60 | 1,090.76 | 5,289.84 | 279,256.40 |
193 | 4,933.33 | 766.67 | 4,166.67 | 195,833.33 | 6,380.60 | 1,070.48 | 5,310.12 | 273,946.28 |
194 | 4,917.36 | 750.69 | 4,166.67 | 191,666.67 | 6,380.60 | 1,050.13 | 5,330.47 | 268,615.81 |
195 | 4,901.39 | 734.72 | 4,166.67 | 187,500.00 | 6,380.60 | 1,029.69 | 5,350.91 | 263,264.90 |
196 | 4,885.42 | 718.75 | 4,166.67 | 183,333.33 | 6,380.60 | 1,009.18 | 5,371.42 | 257,893.49 |
197 | 4,869.44 | 702.78 | 4,166.67 | 179,166.67 | 6,380.60 | 988.59 | 5,392.01 | 252,501.48 |
198 | 4,853.47 | 686.81 | 4,166.67 | 175,000.00 | 6,380.60 | 967.92 | 5,412.68 | 247,088.80 |
199 | 4,837.50 | 670.83 | 4,166.67 | 170,833.33 | 6,380.60 | 947.17 | 5,433.43 | 241,655.37 |
200 | 4,821.53 | 654.86 | 4,166.67 | 166,666.67 | 6,380.60 | 926.35 | 5,454.25 | 236,201.12 |
201 | 4,805.56 | 638.89 | 4,166.67 | 162,500.00 | 6,380.60 | 905.44 | 5,475.16 | 230,725.96 |
202 | 4,789.58 | 622.92 | 4,166.67 | 158,333.33 | 6,380.60 | 884.45 | 5,496.15 | 225,229.80 |
203 | 4,773.61 | 606.94 | 4,166.67 | 154,166.67 | 6,380.60 | 863.38 | 5,517.22 | 219,712.59 |
204 | 4,757.64 | 590.97 | 4,166.67 | 150,000.00 | 6,380.60 | 842.23 | 5,538.37 | 214,174.22 |
205 | 4,741.67 | 575.00 | 4,166.67 | 145,833.33 | 6,380.60 | 821.00 | 5,559.60 | 208,614.62 |
206 | 4,725.69 | 559.03 | 4,166.67 | 141,666.67 | 6,380.60 | 799.69 | 5,580.91 | 203,033.71 |
207 | 4,709.72 | 543.06 | 4,166.67 | 137,500.00 | 6,380.60 | 778.30 | 5,602.30 | 197,431.40 |
208 | 4,693.75 | 527.08 | 4,166.67 | 133,333.33 | 6,380.60 | 756.82 | 5,623.78 | 191,807.62 |
209 | 4,677.78 | 511.11 | 4,166.67 | 129,166.67 | 6,380.60 | 735.26 | 5,645.34 | 186,162.28 |
210 | 4,661.81 | 495.14 | 4,166.67 | 125,000.00 | 6,380.60 | 713.62 | 5,666.98 | 180,495.31 |
211 | 4,645.83 | 479.17 | 4,166.67 | 120,833.33 | 6,380.60 | 691.90 | 5,688.70 | 174,806.60 |
212 | 4,629.86 | 463.19 | 4,166.67 | 116,666.67 | 6,380.60 | 670.09 | 5,710.51 | 169,096.10 |
213 | 4,613.89 | 447.22 | 4,166.67 | 112,500.00 | 6,380.60 | 648.20 | 5,732.40 | 163,363.70 |
214 | 4,597.92 | 431.25 | 4,166.67 | 108,333.33 | 6,380.60 | 626.23 | 5,754.37 | 157,609.32 |
215 | 4,581.94 | 415.28 | 4,166.67 | 104,166.67 | 6,380.60 | 604.17 | 5,776.43 | 151,832.89 |
216 | 4,565.97 | 399.31 | 4,166.67 | 100,000.00 | 6,380.60 | 582.03 | 5,798.57 | 146,034.32 |
217 | 4,550.00 | 383.33 | 4,166.67 | 95,833.33 | 6,380.60 | 559.80 | 5,820.80 | 140,213.52 |
218 | 4,534.03 | 367.36 | 4,166.67 | 91,666.67 | 6,380.60 | 537.49 | 5,843.12 | 134,370.40 |
219 | 4,518.06 | 351.39 | 4,166.67 | 87,500.00 | 6,380.60 | 515.09 | 5,865.51 | 128,504.89 |
220 | 4,502.08 | 335.42 | 4,166.67 | 83,333.33 | 6,380.60 | 492.60 | 5,888.00 | 122,616.89 |
221 | 4,486.11 | 319.44 | 4,166.67 | 79,166.67 | 6,380.60 | 470.03 | 5,910.57 | 116,706.32 |
222 | 4,470.14 | 303.47 | 4,166.67 | 75,000.00 | 6,380.60 | 447.37 | 5,933.23 | 110,773.09 |
223 | 4,454.17 | 287.50 | 4,166.67 | 70,833.33 | 6,380.60 | 424.63 | 5,955.97 | 104,817.12 |
224 | 4,438.19 | 271.53 | 4,166.67 | 66,666.67 | 6,380.60 | 401.80 | 5,978.80 | 98,838.32 |
225 | 4,422.22 | 255.56 | 4,166.67 | 62,500.00 | 6,380.60 | 378.88 | 6,001.72 | 92,836.60 |
226 | 4,406.25 | 239.58 | 4,166.67 | 58,333.33 | 6,380.60 | 355.87 | 6,024.73 | 86,811.88 |
227 | 4,390.28 | 223.61 | 4,166.67 | 54,166.67 | 6,380.60 | 332.78 | 6,047.82 | 80,764.05 |
228 | 4,374.31 | 207.64 | 4,166.67 | 50,000.00 | 6,380.60 | 309.60 | 6,071.00 | 74,693.05 |
229 | 4,358.33 | 191.67 | 4,166.67 | 45,833.33 | 6,380.60 | 286.32 | 6,094.28 | 68,598.77 |
230 | 4,342.36 | 175.69 | 4,166.67 | 41,666.67 | 6,380.60 | 262.96 | 6,117.64 | 62,481.13 |
231 | 4,326.39 | 159.72 | 4,166.67 | 37,500.00 | 6,380.60 | 239.51 | 6,141.09 | 56,340.04 |
232 | 4,310.42 | 143.75 | 4,166.67 | 33,333.33 | 6,380.60 | 215.97 | 6,164.63 | 50,175.41 |
233 | 4,294.44 | 127.78 | 4,166.67 | 29,166.67 | 6,380.60 | 192.34 | 6,188.26 | 43,987.15 |
234 | 4,278.47 | 111.81 | 4,166.67 | 25,000.00 | 6,380.60 | 168.62 | 6,211.98 | 37,775.17 |
235 | 4,262.50 | 95.83 | 4,166.67 | 20,833.33 | 6,380.60 | 144.80 | 6,235.80 | 31,539.37 |
236 | 4,246.53 | 79.86 | 4,166.67 | 16,666.67 | 6,380.60 | 120.90 | 6,259.70 | 25,279.67 |
237 | 4,230.56 | 63.89 | 4,166.67 | 12,500.00 | 6,380.60 | 96.91 | 6,283.69 | 18,995.98 |
238 | 4,214.58 | 47.92 | 4,166.67 | 8,333.33 | 6,380.60 | 72.82 | 6,307.78 | 12,688.20 |
239 | 4,198.61 | 31.94 | 4,166.67 | 4,166.67 | 6,380.60 | 48.64 | 6,331.96 | 6,356.23 |
240 | 4,182.64 | 15.97 | 4,166.67 | 0.00 | 6,380.60 | 24.37 | 6,356.23 | 0.00 |
总和 | 1461916.67 | 461916.66 | 1000000.8 | / | 1531344 | 531344.12 | 999999.94 | / |
分析
无论等额本金还是等额本息,它们第一个月的利息数是相通的,都是3833.33元,原因很显然,首月来讲,两种方式对记息的影响还没有体现,都是总贷款额的利息。但是由于等额本金每月还款的本金多余等额本息,所以等额本金第一个月的还款额高于等额本息,表现为8000和6380.6,但是随着时间推移,等额本金每月还款额度会减少。
等额本金每月具体会少多少呢?根据前面计算的等差公式
也就是每个月少不到16块钱,对比一下实际数据即可确认这个规律:
也就是,等额本金每月还款额的减少量符合如下公式:
这个公式很直观,也很容易理解,因为固定本金还款,每月还款本金数量是一定的,相应减少的利息就是上个月本金产生的了。
大家如果有按照等额本金还款的,可以验证一下这个公式是否正确。
等额本金每月还款额是一个等差数列
等额本金每月利息偿还情况,也是等差数列
等额本金还款每月剩余本金情况,依然是等差数列。
等额本息每月还利息情况,可以看到这是一个曲线
等额本息每月偿还本金情况,可以看到,等额本息先还利息,在还本金,越往后,本金占比越大。
由于等额本息每月还款数额相同,所以上面两幅图是互补的。
等额本息剩余本金情况,可以看到,一开始本金下降速度比较慢,因为大部分的钱都用来还利息了。
以上就是对两种还款方式的简要分析,究竟选择那种方式要看本人情况而定.
对于当前投资回报率低的情况,未来的通胀预期强烈,很多人没有较好的投资渠道抵抗房贷的利息,所以与其将钱放在手上逐渐贬值,还不如提前还贷来的划算。也有一部分人是不喜欢欠钱的感觉,即便是债权人是银行也不可以。但是无论贷款属于上述哪种情况,都是从你提前还款的下个月的剩余本金中减去你的提前还款额,在此基础上再重新利用上面的公式计算剩余每个月的还款计划的,不再赘述。
等额本金的优劣分析:
1.还款额总和少于等额本金,主要原因是等额本金情况下,总利息少.
2.还款初期压力较大,还款末期压力较小。
等额本息的优劣分析:
1.还款额总和大于等额本金,主要原因是等额本息情况下,还款前期利息比重大,末期才会体现出本金的比重.
2.每个还款期还款额度固定,便于提前安排家庭开支。
3.占用银行本金的能力强,对于善于理财投资的人来说,如果能够抵抗住多支付的利息,是个不错的选择。
两种方式都遵守的规则:
1.还款周期越长,缴纳利息越多.
题外话,我不太会同情那些高杠杆买房,拖家带口突然失业或者生病或者出意外,生活很拮据甚至走上绝路的人,完全没有危机意识,动不动贷款二三十年,几百万,动不动生二胎甚至三胎,谁能给你保证未来你一定有稳定收入呢?而且不稳定的概率还不小,成年人不考虑可能出现的不稳定因素,是自己的原因,因为你改变不了社会,只能自己控制风险。