赞
踩
我们在办理按揭贷款的时候,银行一定会问你等额本金还是等额本息的还款方式选哪一个。现在我们就定量的分析一下,这两个究竟有何差别。
假设银行年利率是R,则月利率为R/12,某人贷款总额为M,还款期为20年,240个月,则按照等额本息来计算,每月还款额该多少呢?
假设每月还款为X,每期剩余还款额为Q ,当贷款下来那一刻,你还没有开始还款,所以如下公式成立:
每期的剩余本金乘以月利率,就是当月的利息,利息和本金相加,就是总欠款。第一期还款后,总欠款额为:
第二期还款后,本金余额为:
第三期还款后,本金余额为:
递推得到如下公式(严格的说应该根据数学归纳法去证明),到达第k期还款后,剩余欠款总额为:
根据等比数列的求和公式:
当的时候,还款完毕,所以:
所以,等额本息情况下,每月还款金额为:
这个公式也就是大家常见到的等额本息还款计算方式的文字描述版:
用年利率表示就是下面的公式:
每月均还X元,这X元有多少本金和利息呢?第一个月的利息和剩余本金为:
依次计算,寻找规律:
。。。。。。
规律已经很明显了,总结归纳得到,经过k期后,下一期的本金额和利息额计算公式分别为:
并且,下面的公式永远成立:
以上是通过归纳看出来的,本着严谨至上的原则,我们还是来证明一把,就用数学归纳法。
假设K的时候等式成立
则k+1时:
带入上式:
简单的合并同类项:
所以,最终得到一样的形式:
上述经验总结公式得证.
对于等额本息的还款公式,总结如下:
每月还款额计算公式:
当月利息额计算公式:
当月本金额的计算公式:
以贷款100万,期限20年,年利率为4.6%来计算,套用如上公式,编程得到每月还款金额为6380.600586元,每月的利息和本金额打印所示,根据银行的计算器实际验证,是完全吻合的。
- #include <stdio.h>
- #include <stdlib.h>
- #include <math.h>
-
- int main(void)
- {
- int i = 1;
- float x = 1000000 *(0.046 / 12)*pow((0.046/12 + 1), 240)/(pow((0.046/12 + 1), 240) - 1);
-
- for(i = 1; i <= 240; i ++)
- {
- float sk = 1000000 * 0.046/12*pow((0.046/12 + 1), i-1) - x*pow((0.046/12 + 1), i-1) + x;
- float bk = x- sk;
-
- printf("NO[%3d]: sk = %f, bk = %f, sk + bk = %f, interst ratio %f.\n", i, sk, bk, sk+bk, sk/x);
- }
-
- return 0;
- }
- caozilong@caozilong-Vostro-3268:~/Workspace/yinhang$ ./a.out
- NO[001]: sk = 3833.333252, bk = 2547.267334, sk + bk = 6380.600586, interst ratio 0.600779.
- NO[002]: sk = 3823.568848, bk = 2557.031738, sk + bk = 6380.600586, interst ratio 0.599249.
- NO[003]: sk = 3813.766846, bk = 2566.833740, sk + bk = 6380.600586, interst ratio 0.597713.
- NO[004]: sk = 3803.927246, bk = 2576.673340, sk + bk = 6380.600586, interst ratio 0.596171.
- NO[005]: sk = 3794.050049, bk = 2586.550537, sk + bk = 6380.600586, interst ratio 0.594623.
- NO[006]: sk = 3784.135010, bk = 2596.465576, sk + bk = 6380.600586, interst ratio 0.593069.
- NO[007]: sk = 3774.181885, bk = 2606.418701, sk + bk = 6380.600586, interst ratio 0.591509.
- NO[008]: sk = 3764.190674, bk = 2616.409912, sk + bk = 6380.600586, interst ratio 0.589943.
- NO[009]: sk = 3754.160889, bk = 2626.439697, sk + bk = 6380.600586, interst ratio 0.588371.
- NO[010]: sk = 3744.093018, bk = 2636.507568, sk + bk = 6380.600586, interst ratio 0.586793.
- NO[011]: sk = 3733.986328, bk = 2646.614258, sk + bk = 6380.600586, interst ratio 0.585209.
- NO[012]: sk = 3723.841064, bk = 2656.759521, sk + bk = 6380.600586, interst ratio 0.583619.
- NO[013]: sk = 3713.656738, bk = 2666.943848, sk + bk = 6380.600586, interst ratio 0.582023.
- NO[014]: sk = 3703.433594, bk = 2677.166992, sk + bk = 6380.600586, interst ratio 0.580421.
- NO[015]: sk = 3693.170898, bk = 2687.429688, sk + bk = 6380.600586, interst ratio 0.578812.
- NO[016]: sk = 3682.869141, bk = 2697.731445, sk + bk = 6380.600586, interst ratio 0.577198.
- NO[017]: sk = 3672.527832, bk = 2708.072754, sk + bk = 6380.600586, interst ratio 0.575577.
- NO[018]: sk = 3662.146973, bk = 2718.453613, sk + bk = 6380.600586, interst ratio 0.573950.
- NO[019]: sk = 3651.726318, bk = 2728.874268, sk + bk = 6380.600586, interst ratio 0.572317.
- NO[020]: sk = 3641.265625, bk = 2739.334961, sk + bk = 6380.600586, interst ratio 0.570678.
- NO[021]: sk = 3630.764648, bk = 2749.835938, sk + bk = 6380.600586, interst ratio 0.569032.
- NO[022]: sk = 3620.223633, bk = 2760.376953, sk + bk = 6380.600586, interst ratio 0.567380.
- NO[023]: sk = 3609.642334, bk = 2770.958252, sk + bk = 6380.600586, interst ratio 0.565721.
- NO[024]: sk = 3599.020264, bk = 2781.580322, sk + bk = 6380.600586, interst ratio 0.564057.
- NO[025]: sk = 3588.357422, bk = 2792.243164, sk + bk = 6380.600586, interst ratio 0.562385.
- NO[026]: sk = 3577.654053, bk = 2802.946533, sk + bk = 6380.600586, interst ratio 0.560708.
- NO[027]: sk = 3566.909424, bk = 2813.691162, sk + bk = 6380.600586, interst ratio 0.559024.
- NO[028]: sk = 3556.123535, bk = 2824.477051, sk + bk = 6380.600586, interst ratio 0.557334.
- NO[029]: sk = 3545.296387, bk = 2835.304199, sk + bk = 6380.600586, interst ratio 0.555637.
- NO[030]: sk = 3534.427734, bk = 2846.172852, sk + bk = 6380.600586, interst ratio 0.553933.
- NO[031]: sk = 3523.517334, bk = 2857.083252, sk + bk = 6380.600586, interst ratio 0.552223.
- NO[032]: sk = 3512.565186, bk = 2868.035400, sk + bk = 6380.600586, interst ratio 0.550507.
- NO[033]: sk = 3501.571045, bk = 2879.029541, sk + bk = 6380.600586, interst ratio 0.548784.
- NO[034]: sk = 3490.534668, bk = 2890.065918, sk + bk = 6380.600586, interst ratio 0.547054.
- NO[035]: sk = 3479.456055, bk = 2901.144531, sk + bk = 6380.600586, interst ratio 0.545318.
- NO[036]: sk = 3468.335205, bk = 2912.265381, sk + bk = 6380.600586, interst ratio 0.543575.
- NO[037]: sk = 3457.171387, bk = 2923.429199, sk + bk = 6380.600586, interst ratio 0.541825.
- NO[038]: sk = 3445.964844, bk = 2934.635742, sk + bk = 6380.600586, interst ratio 0.540069.
- NO[039]: sk = 3434.715576, bk = 2945.885010, sk + bk = 6380.600586, interst ratio 0.538306.
- NO[040]: sk = 3423.422852, bk = 2957.177734, sk + bk = 6380.600586, interst ratio 0.536536.
- NO[041]: sk = 3412.087158, bk = 2968.513428, sk + bk = 6380.600586, interst ratio 0.534760.
- NO[042]: sk = 3400.707764, bk = 2979.892822, sk + bk = 6380.600586, interst ratio 0.532976.
- NO[043]: sk = 3389.284912, bk = 2991.315674, sk + bk = 6380.600586, interst ratio 0.531186.
- NO[044]: sk = 3377.818115, bk = 3002.782471, sk + bk = 6380.600586, interst ratio 0.529389.
- NO[045]: sk = 3366.307617, bk = 3014.292969, sk + bk = 6380.600586, interst ratio 0.527585.
- NO[046]: sk = 3354.752686, bk = 3025.847900, sk + bk = 6380.600586, interst ratio 0.525774.
- NO[047]: sk = 3343.153564, bk = 3037.447021, sk + bk = 6380.600586, interst ratio 0.523956.
- NO[048]: sk = 3331.510010, bk = 3049.090576, sk + bk = 6380.600586, interst ratio 0.522131.
- NO[049]: sk = 3319.822021, bk = 3060.778564, sk + bk = 6380.600586, interst ratio 0.520299.
- NO[050]: sk = 3308.088867, bk = 3072.511719, sk + bk = 6380.600586, interst ratio 0.518460.
- NO[051]: sk = 3296.311035, bk = 3084.289551, sk + bk = 6380.600586, interst ratio 0.516615.
- NO[052]: sk = 3284.487793, bk = 3096.112793, sk + bk = 6380.600586, interst ratio 0.514762.
- NO[053]: sk = 3272.619385, bk = 3107.981201, sk + bk = 6380.600586, interst ratio 0.512901.
- NO[054]: sk = 3260.705566, bk = 3119.895020, sk + bk = 6380.600586, interst ratio 0.511034.
- NO[055]: sk = 3248.745850, bk = 3131.854736, sk + bk = 6380.600586, interst ratio 0.509160.
- NO[056]: sk = 3236.740479, bk = 3143.860107, sk + bk = 6380.600586, interst ratio 0.507278.
- NO[057]: sk = 3224.688965, bk = 3155.911621, sk + bk = 6380.600586, interst ratio 0.505390.
- NO[058]: sk = 3212.591309, bk = 3168.009277, sk + bk = 6380.600586, interst ratio 0.503494.
- NO[059]: sk = 3200.447266, bk = 3180.153320, sk + bk = 6380.600586, interst ratio 0.501590.
- NO[060]: sk = 3188.256592, bk = 3192.343994, sk + bk = 6380.600586, interst ratio 0.499680.
- NO[061]: sk = 3176.019287, bk = 3204.581299, sk + bk = 6380.600586, interst ratio 0.497762.
- NO[062]: sk = 3163.735107, bk = 3216.865479, sk + bk = 6380.600586, interst ratio 0.495837.
- NO[063]: sk = 3151.403809, bk = 3229.196777, sk + bk = 6380.600586, interst ratio 0.493904.
- NO[064]: sk = 3139.025146, bk = 3241.575439, sk + bk = 6380.600586, interst ratio 0.491964.
- NO[065]: sk = 3126.599121, bk = 3254.001465, sk + bk = 6380.600586, interst ratio 0.490016.
- NO[066]: sk = 3114.125488, bk = 3266.475098, sk + bk = 6380.600586, interst ratio 0.488061.
- NO[067]: sk = 3101.604004, bk = 3278.996582, sk + bk = 6380.600586, interst ratio 0.486099.
- NO[068]: sk = 3089.034668, bk = 3291.565918, sk + bk = 6380.600586, interst ratio 0.484129.
- NO[069]: sk = 3076.416992, bk = 3304.183594, sk + bk = 6380.600586, interst ratio 0.482152.
- NO[070]: sk = 3063.750977, bk = 3316.849609, sk + bk = 6380.600586, interst ratio 0.480167.
- NO[071]: sk = 3051.036377, bk = 3329.564209, sk + bk = 6380.600586, interst ratio 0.478174.
- NO[072]: sk = 3038.272949, bk = 3342.327637, sk + bk = 6380.600586, interst ratio 0.476174.
- NO[073]: sk = 3025.460693, bk = 3355.139893, sk + bk = 6380.600586, interst ratio 0.474165.
- NO[074]: sk = 3012.599365, bk = 3368.001221, sk + bk = 6380.600586, interst ratio 0.472150.
- NO[075]: sk = 2999.688721, bk = 3380.911865, sk + bk = 6380.600586, interst ratio 0.470126.
- NO[076]: sk = 2986.728516, bk = 3393.872070, sk + bk = 6380.600586, interst ratio 0.468095.
- NO[077]: sk = 2973.718750, bk = 3406.881836, sk + bk = 6380.600586, interst ratio 0.466056.
- NO[078]: sk = 2960.658936, bk = 3419.941650, sk + bk = 6380.600586, interst ratio 0.464009.
- NO[079]: sk = 2947.549072, bk = 3433.051514, sk + bk = 6380.600586, interst ratio 0.461955.
- NO[080]: sk = 2934.389160, bk = 3446.211426, sk + bk = 6380.600586, interst ratio 0.459892.
- NO[081]: sk = 2921.178711, bk = 3459.421875, sk + bk = 6380.600586, interst ratio 0.457822.
- NO[082]: sk = 2907.917480, bk = 3472.683105, sk + bk = 6380.600586, interst ratio 0.455744.
- NO[083]: sk = 2894.605469, bk = 3485.995117, sk + bk = 6380.600586, interst ratio 0.453657.
- NO[084]: sk = 2881.242676, bk = 3499.357910, sk + bk = 6380.600586, interst ratio 0.451563.
- NO[085]: sk = 2867.828369, bk = 3512.772217, sk + bk = 6380.600586, interst ratio 0.449461.
- NO[086]: sk = 2854.362793, bk = 3526.237793, sk + bk = 6380.600586, interst ratio 0.447350.
- NO[087]: sk = 2840.845459, bk = 3539.755127, sk + bk = 6380.600586, interst ratio 0.445232.
- NO[088]: sk = 2827.276367, bk = 3553.324219, sk + bk = 6380.600586, interst ratio 0.443105.
- NO[089]: sk = 2813.655273, bk = 3566.945312, sk + bk = 6380.600586, interst ratio 0.440970.
- NO[090]: sk = 2799.982178, bk = 3580.618408, sk + bk = 6380.600586, interst ratio 0.438827.
- NO[091]: sk = 2786.256348, bk = 3594.344238, sk + bk = 6380.600586, interst ratio 0.436676.
- NO[092]: sk = 2772.478027, bk = 3608.122559, sk + bk = 6380.600586, interst ratio 0.434517.
- NO[093]: sk = 2758.646973, bk = 3621.953613, sk + bk = 6380.600586, interst ratio 0.432349.
- NO[094]: sk = 2744.762695, bk = 3635.837891, sk + bk = 6380.600586, interst ratio 0.430173.
- NO[095]: sk = 2730.825439, bk = 3649.775146, sk + bk = 6380.600586, interst ratio 0.427989.
- NO[096]: sk = 2716.834473, bk = 3663.766113, sk + bk = 6380.600586, interst ratio 0.425796.
- NO[097]: sk = 2702.790039, bk = 3677.810547, sk + bk = 6380.600586, interst ratio 0.423595.
- NO[098]: sk = 2688.691895, bk = 3691.908691, sk + bk = 6380.600586, interst ratio 0.421385.
- NO[099]: sk = 2674.539551, bk = 3706.061035, sk + bk = 6380.600586, interst ratio 0.419167.
- NO[100]: sk = 2660.333008, bk = 3720.267578, sk + bk = 6380.600586, interst ratio 0.416941.
- NO[101]: sk = 2646.072021, bk = 3734.528564, sk + bk = 6380.600586, interst ratio 0.414706.
- NO[102]: sk = 2631.756348, bk = 3748.844238, sk + bk = 6380.600586, interst ratio 0.412462.
- NO[103]: sk = 2617.385742, bk = 3763.214844, sk + bk = 6380.600586, interst ratio 0.410210.
- NO[104]: sk = 2602.959961, bk = 3777.640625, sk + bk = 6380.600586, interst ratio 0.407949.
- NO[105]: sk = 2588.479004, bk = 3792.121582, sk + bk = 6380.600586, interst ratio 0.405680.
- NO[106]: sk = 2573.942627, bk = 3806.657959, sk + bk = 6380.600586, interst ratio 0.403401.
- NO[107]: sk = 2559.350342, bk = 3821.250244, sk + bk = 6380.600586, interst ratio 0.401114.
- NO[108]: sk = 2544.702393, bk = 3835.898193, sk + bk = 6380.600586, interst ratio 0.398819.
- NO[109]: sk = 2529.998047, bk = 3850.602539, sk + bk = 6380.600586, interst ratio 0.396514.
- NO[110]: sk = 2515.237305, bk = 3865.363281, sk + bk = 6380.600586, interst ratio 0.394201.
- NO[111]: sk = 2500.420166, bk = 3880.180420, sk + bk = 6380.600586, interst ratio 0.391878.
- NO[112]: sk = 2485.546143, bk = 3895.054443, sk + bk = 6380.600586, interst ratio 0.389547.
- NO[113]: sk = 2470.614990, bk = 3909.985596, sk + bk = 6380.600586, interst ratio 0.387207.
- NO[114]: sk = 2455.626709, bk = 3924.973877, sk + bk = 6380.600586, interst ratio 0.384858.
- NO[115]: sk = 2440.581055, bk = 3940.019531, sk + bk = 6380.600586, interst ratio 0.382500.
- NO[116]: sk = 2425.477783, bk = 3955.122803, sk + bk = 6380.600586, interst ratio 0.380133.
- NO[117]: sk = 2410.316406, bk = 3970.284180, sk + bk = 6380.600586, interst ratio 0.377757.
- NO[118]: sk = 2395.096924, bk = 3985.503662, sk + bk = 6380.600586, interst ratio 0.375372.
- NO[119]: sk = 2379.819092, bk = 4000.781494, sk + bk = 6380.600586, interst ratio 0.372977.
- NO[120]: sk = 2364.482910, bk = 4016.117676, sk + bk = 6380.600586, interst ratio 0.370574.
- NO[121]: sk = 2349.087646, bk = 4031.512939, sk + bk = 6380.600586, interst ratio 0.368161.
- NO[122]: sk = 2333.633545, bk = 4046.967041, sk + bk = 6380.600586, interst ratio 0.365739.
- NO[123]: sk = 2318.120361, bk = 4062.480225, sk + bk = 6380.600586, interst ratio 0.363308.
- NO[124]: sk = 2302.547363, bk = 4078.053223, sk + bk = 6380.600586, interst ratio 0.360867.
- NO[125]: sk = 2286.914795, bk = 4093.685791, sk + bk = 6380.600586, interst ratio 0.358417.
- NO[126]: sk = 2271.222412, bk = 4109.377930, sk + bk = 6380.600586, interst ratio 0.355957.
- NO[127]: sk = 2255.469727, bk = 4125.130859, sk + bk = 6380.600586, interst ratio 0.353489.
- NO[128]: sk = 2239.656738, bk = 4140.943848, sk + bk = 6380.600586, interst ratio 0.351010.
- NO[129]: sk = 2223.783203, bk = 4156.817383, sk + bk = 6380.600586, interst ratio 0.348523.
- NO[130]: sk = 2207.848633, bk = 4172.751953, sk + bk = 6380.600586, interst ratio 0.346025.
- NO[131]: sk = 2191.853271, bk = 4188.747070, sk + bk = 6380.600586, interst ratio 0.343518.
- NO[132]: sk = 2175.796387, bk = 4204.804199, sk + bk = 6380.600586, interst ratio 0.341002.
- NO[133]: sk = 2159.677979, bk = 4220.922852, sk + bk = 6380.600586, interst ratio 0.338476.
- NO[134]: sk = 2143.497559, bk = 4237.103027, sk + bk = 6380.600586, interst ratio 0.335940.
- NO[135]: sk = 2127.255371, bk = 4253.345215, sk + bk = 6380.600586, interst ratio 0.333394.
- NO[136]: sk = 2110.950928, bk = 4269.649414, sk + bk = 6380.600586, interst ratio 0.330839.
- NO[137]: sk = 2094.583984, bk = 4286.016602, sk + bk = 6380.600586, interst ratio 0.328274.
- NO[138]: sk = 2078.154297, bk = 4302.446289, sk + bk = 6380.600586, interst ratio 0.325699.
- NO[139]: sk = 2061.661621, bk = 4318.938965, sk + bk = 6380.600586, interst ratio 0.323114.
- NO[140]: sk = 2045.105591, bk = 4335.495117, sk + bk = 6380.600586, interst ratio 0.320519.
- NO[141]: sk = 2028.486206, bk = 4352.114258, sk + bk = 6380.600586, interst ratio 0.317915.
- NO[142]: sk = 2011.803101, bk = 4368.797363, sk + bk = 6380.600586, interst ratio 0.315300.
- NO[143]: sk = 1995.056030, bk = 4385.544434, sk + bk = 6380.600586, interst ratio 0.312675.
- NO[144]: sk = 1978.244751, bk = 4402.355957, sk + bk = 6380.600586, interst ratio 0.310041.
- NO[145]: sk = 1961.369019, bk = 4419.231445, sk + bk = 6380.600586, interst ratio 0.307396.
- NO[146]: sk = 1944.428711, bk = 4436.171875, sk + bk = 6380.600586, interst ratio 0.304741.
- NO[147]: sk = 1927.423340, bk = 4453.177246, sk + bk = 6380.600586, interst ratio 0.302076.
- NO[148]: sk = 1910.352905, bk = 4470.247559, sk + bk = 6380.600586, interst ratio 0.299400.
- NO[149]: sk = 1893.216919, bk = 4487.383789, sk + bk = 6380.600586, interst ratio 0.296715.
- NO[150]: sk = 1876.015259, bk = 4504.585449, sk + bk = 6380.600586, interst ratio 0.294019.
- NO[151]: sk = 1858.747681, bk = 4521.853027, sk + bk = 6380.600586, interst ratio 0.291312.
- NO[152]: sk = 1841.413940, bk = 4539.186523, sk + bk = 6380.600586, interst ratio 0.288596.
- NO[153]: sk = 1824.013672, bk = 4556.586914, sk + bk = 6380.600586, interst ratio 0.285869.
- NO[154]: sk = 1806.546753, bk = 4574.053711, sk + bk = 6380.600586, interst ratio 0.283131.
- NO[155]: sk = 1789.012939, bk = 4591.587891, sk + bk = 6380.600586, interst ratio 0.280383.
- NO[156]: sk = 1771.411865, bk = 4609.188477, sk + bk = 6380.600586, interst ratio 0.277625.
- NO[157]: sk = 1753.743286, bk = 4626.857422, sk + bk = 6380.600586, interst ratio 0.274856.
- NO[158]: sk = 1736.006958, bk = 4644.593750, sk + bk = 6380.600586, interst ratio 0.272076.
- NO[159]: sk = 1718.202759, bk = 4662.397949, sk + bk = 6380.600586, interst ratio 0.269285.
- NO[160]: sk = 1700.330200, bk = 4680.270508, sk + bk = 6380.600586, interst ratio 0.266484.
- NO[161]: sk = 1682.389160, bk = 4698.211426, sk + bk = 6380.600586, interst ratio 0.263673.
- NO[162]: sk = 1664.379272, bk = 4716.221191, sk + bk = 6380.600586, interst ratio 0.260850.
- NO[163]: sk = 1646.300537, bk = 4734.299805, sk + bk = 6380.600586, interst ratio 0.258017.
- NO[164]: sk = 1628.152344, bk = 4752.448242, sk + bk = 6380.600586, interst ratio 0.255172.
- NO[165]: sk = 1609.934570, bk = 4770.666016, sk + bk = 6380.600586, interst ratio 0.252317.
- NO[166]: sk = 1591.647095, bk = 4788.953613, sk + bk = 6380.600586, interst ratio 0.249451.
- NO[167]: sk = 1573.289429, bk = 4807.311035, sk + bk = 6380.600586, interst ratio 0.246574.
- NO[168]: sk = 1554.861328, bk = 4825.739258, sk + bk = 6380.600586, interst ratio 0.243686.
- NO[169]: sk = 1536.362671, bk = 4844.237793, sk + bk = 6380.600586, interst ratio 0.240787.
- NO[170]: sk = 1517.793091, bk = 4862.807617, sk + bk = 6380.600586, interst ratio 0.237876.
- NO[171]: sk = 1499.152344, bk = 4881.448242, sk + bk = 6380.600586, interst ratio 0.234955.
- NO[172]: sk = 1480.440186, bk = 4900.160156, sk + bk = 6380.600586, interst ratio 0.232022.
- NO[173]: sk = 1461.656250, bk = 4918.944336, sk + bk = 6380.600586, interst ratio 0.229078.
- NO[174]: sk = 1442.800293, bk = 4937.800293, sk + bk = 6380.600586, interst ratio 0.226123.
- NO[175]: sk = 1423.872070, bk = 4956.728516, sk + bk = 6380.600586, interst ratio 0.223156.
- NO[176]: sk = 1404.871216, bk = 4975.729492, sk + bk = 6380.600586, interst ratio 0.220179.
- NO[177]: sk = 1385.797607, bk = 4994.802734, sk + bk = 6380.600586, interst ratio 0.217189.
- NO[178]: sk = 1366.650879, bk = 5013.949707, sk + bk = 6380.600586, interst ratio 0.214188.
- NO[179]: sk = 1347.430664, bk = 5033.169922, sk + bk = 6380.600586, interst ratio 0.211176.
- NO[180]: sk = 1328.136841, bk = 5052.463867, sk + bk = 6380.600586, interst ratio 0.208152.
- NO[181]: sk = 1308.769165, bk = 5071.831543, sk + bk = 6380.600586, interst ratio 0.205117.
- NO[182]: sk = 1289.327148, bk = 5091.273438, sk + bk = 6380.600586, interst ratio 0.202070.
- NO[183]: sk = 1269.810547, bk = 5110.790039, sk + bk = 6380.600586, interst ratio 0.199011.
- NO[184]: sk = 1250.219238, bk = 5130.381348, sk + bk = 6380.600586, interst ratio 0.195941.
- NO[185]: sk = 1230.552734, bk = 5150.047852, sk + bk = 6380.600586, interst ratio 0.192858.
- NO[186]: sk = 1210.810913, bk = 5169.789551, sk + bk = 6380.600586, interst ratio 0.189764.
- NO[187]: sk = 1190.993286, bk = 5189.607422, sk + bk = 6380.600586, interst ratio 0.186658.
- NO[188]: sk = 1171.099854, bk = 5209.500977, sk + bk = 6380.600586, interst ratio 0.183541.
- NO[189]: sk = 1151.130127, bk = 5229.470703, sk + bk = 6380.600586, interst ratio 0.180411.
- NO[190]: sk = 1131.083740, bk = 5249.516602, sk + bk = 6380.600586, interst ratio 0.177269.
- NO[191]: sk = 1110.960693, bk = 5269.639648, sk + bk = 6380.600586, interst ratio 0.174115.
- NO[192]: sk = 1090.760376, bk = 5289.840332, sk + bk = 6380.600586, interst ratio 0.170949.
- NO[193]: sk = 1070.482666, bk = 5310.118164, sk + bk = 6380.600586, interst ratio 0.167771.
- NO[194]: sk = 1050.127197, bk = 5330.473633, sk + bk = 6380.600586, interst ratio 0.164581.
- NO[195]: sk = 1029.693726, bk = 5350.906738, sk + bk = 6380.600586, interst ratio 0.161379.
- NO[196]: sk = 1009.181885, bk = 5371.418945, sk + bk = 6380.600586, interst ratio 0.158164.
- NO[197]: sk = 988.591431, bk = 5392.009277, sk + bk = 6380.600586, interst ratio 0.154937.
- NO[198]: sk = 967.922119, bk = 5412.678711, sk + bk = 6380.600586, interst ratio 0.151698.
- NO[199]: sk = 947.173462, bk = 5433.427246, sk + bk = 6380.600586, interst ratio 0.148446.
- NO[200]: sk = 926.345337, bk = 5454.255371, sk + bk = 6380.600586, interst ratio 0.145182.
- NO[201]: sk = 905.437378, bk = 5475.163086, sk + bk = 6380.600586, interst ratio 0.141905.
- NO[202]: sk = 884.449219, bk = 5496.151367, sk + bk = 6380.600586, interst ratio 0.138615.
- NO[203]: sk = 863.380676, bk = 5517.219727, sk + bk = 6380.600586, interst ratio 0.135313.
- NO[204]: sk = 842.231323, bk = 5538.369141, sk + bk = 6380.600586, interst ratio 0.131999.
- NO[205]: sk = 821.000916, bk = 5559.599609, sk + bk = 6380.600586, interst ratio 0.128671.
- NO[206]: sk = 799.689087, bk = 5580.911621, sk + bk = 6380.600586, interst ratio 0.125331.
- NO[207]: sk = 778.295593, bk = 5602.305176, sk + bk = 6380.600586, interst ratio 0.121978.
- NO[208]: sk = 756.820129, bk = 5623.780273, sk + bk = 6380.600586, interst ratio 0.118613.
- NO[209]: sk = 735.262268, bk = 5645.338379, sk + bk = 6380.600586, interst ratio 0.115234.
- NO[210]: sk = 713.621826, bk = 5666.978516, sk + bk = 6380.600586, interst ratio 0.111842.
- NO[211]: sk = 691.898438, bk = 5688.702148, sk + bk = 6380.600586, interst ratio 0.108438.
- NO[212]: sk = 670.091736, bk = 5710.508789, sk + bk = 6380.600586, interst ratio 0.105020.
- NO[213]: sk = 648.201416, bk = 5732.399414, sk + bk = 6380.600586, interst ratio 0.101589.
- NO[214]: sk = 626.227234, bk = 5754.373535, sk + bk = 6380.600586, interst ratio 0.098145.
- NO[215]: sk = 604.168823, bk = 5776.431641, sk + bk = 6380.600586, interst ratio 0.094688.
- NO[216]: sk = 582.025818, bk = 5798.574707, sk + bk = 6380.600586, interst ratio 0.091218.
- NO[217]: sk = 559.797974, bk = 5820.802734, sk + bk = 6380.600586, interst ratio 0.087734.
- NO[218]: sk = 537.484863, bk = 5843.115723, sk + bk = 6380.600586, interst ratio 0.084237.
- NO[219]: sk = 515.086243, bk = 5865.514160, sk + bk = 6380.600586, interst ratio 0.080727.
- NO[220]: sk = 492.601776, bk = 5887.999023, sk + bk = 6380.600586, interst ratio 0.077203.
- NO[221]: sk = 470.031128, bk = 5910.569336, sk + bk = 6380.600586, interst ratio 0.073666.
- NO[222]: sk = 447.373932, bk = 5933.226562, sk + bk = 6380.600586, interst ratio 0.070115.
- NO[223]: sk = 424.629913, bk = 5955.970703, sk + bk = 6380.600586, interst ratio 0.066550.
- NO[224]: sk = 401.798676, bk = 5978.801758, sk + bk = 6380.600586, interst ratio 0.062972.
- NO[225]: sk = 378.879944, bk = 6001.720703, sk + bk = 6380.600586, interst ratio 0.059380.
- NO[226]: sk = 355.873352, bk = 6024.727051, sk + bk = 6380.600586, interst ratio 0.055774.
- NO[227]: sk = 332.778564, bk = 6047.822266, sk + bk = 6380.600586, interst ratio 0.052155.
- NO[228]: sk = 309.595245, bk = 6071.005371, sk + bk = 6380.600586, interst ratio 0.048521.
- NO[229]: sk = 286.323059, bk = 6094.277344, sk + bk = 6380.600586, interst ratio 0.044874.
- NO[230]: sk = 262.961670, bk = 6117.638672, sk + bk = 6380.600586, interst ratio 0.041213.
- NO[231]: sk = 239.510712, bk = 6141.089844, sk + bk = 6380.600586, interst ratio 0.037537.
- NO[232]: sk = 215.969864, bk = 6164.630859, sk + bk = 6380.600586, interst ratio 0.033848.
- NO[233]: sk = 192.338776, bk = 6188.261719, sk + bk = 6380.600586, interst ratio 0.030144.
- NO[234]: sk = 168.617111, bk = 6211.983398, sk + bk = 6380.600586, interst ratio 0.026427.
- NO[235]: sk = 144.804504, bk = 6235.795898, sk + bk = 6380.600586, interst ratio 0.022694.
- NO[236]: sk = 120.900620, bk = 6259.700195, sk + bk = 6380.600586, interst ratio 0.018948.
- NO[237]: sk = 96.905106, bk = 6283.695312, sk + bk = 6380.600586, interst ratio 0.015187.
- NO[238]: sk = 72.817604, bk = 6307.783203, sk + bk = 6380.600586, interst ratio 0.011412.
- NO[239]: sk = 48.637772, bk = 6331.962891, sk + bk = 6380.600586, interst ratio 0.007623.
- NO[240]: sk = 24.365248, bk = 6356.235352, sk + bk = 6380.600586, interst ratio 0.003819.
总利息最好算了,在等额本息情况下,每月的还款额都是固定的。所以:
总利息=每月还款额* 还款月数 - 总贷款本金额.
也就是:
当然,实际场景中,年利率是浮动变化的,尤其是新的LPR基准利率施行后,每个月都会有一个新的LPR基准利率,但是无论利率如何变化,都是在新的利率的基础上调用上述公式,公式的形式是不会变化的。
计算利息总额,根据上面的公式,首先计算每月还款额X,贷款利率为4.6%
高次幂过于繁琐,这里编程实现:
得到每月还款额为6380.600586元。
所以总共利息为:
总支付利息与本金的比例为53.13%,也就是有相当于本金一半多的利息。
另外,通过公式
可以看到总的利息额和还款周期的关系,还款期越长,缴纳的利息越多。
等额本金的处理方式简单很多,还是以上面的条件为例,贷款总额M,按照每月固定本金还款,20年240个月,所以每月应还本金为:
比如一个人公积金贷款36万元,贷款利率3.2%,贷款周期240个月,采用等额本金方式还款,每个月固定还款总额便为1500元本金,这样看余款清单,每个月都是整数:
假设经过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个月附近本金情况,可以看到还款本金额在这里发生了交叉,具体可看文章后续表格。
韭菜疯涨的年代,每月的利息甚至超过了当月的本金额,但是由于利息在这个还款周期中是一个单调下降的曲线,所以在整个还款期内,一定有一个时间点,每月利息开始少于本金。
每期还款额:
每期还款本金:
列出不等式:
所以:
可以看到,边界月是总的还款月和年利息的函数,当总还款周期为K月,年利率为R时,从第
月开始,每月的本金开始大于利息。和贷款总额无关。
所以,如果你对每月还款的利息比本金还要多心理上过不去,在无法选择降低年利率的情况下,只能选择缩短还款周期。比如,以年利率3.6,30年等额本金还款说明,其k为360-12/0.036=27.从第27个月开始,本金大约利息,编程验证,得到的结果也是27:
如果选择贷款年年限小于12/0.036=333,约等于26年,则还款周期内不会出现利息高于本金的月份.作为韭菜,心理上会不会舒服一些?
等额本息:
等额本金:
绘图如下,可以看到,等额本息利息曲线和坐标轴围城的面积大于等额本金,所以等额本息的总利息高于等额本金。
综合分析如下图,注意等额本息的利息曲线和本金曲线恰好互补为一条斜率为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,但是随着时间推移,等额本金每月还款额度会减少。
其实,如果你选择的是等额本息的话,可以根据第一个月的利息计算出等额本金下第一个月应还款总额,计算方法是:
3833.33+1000000/240 = 8000
等额本金每月具体会少多少呢?根据前面计算的等差公式
也就是每个月少不到16块钱,对比一下实际数据即可确认这个规律, 并且,等额本金还款方式下,最后一个月的还款利息恰好就是一个本金还款额所产生的利息。
也就是,等额本金每月还款额的减少量符合如下公式:
这个公式很直观,理解起来也不难,因为固定本金还款,每月还款本金数量是一定的,相应减少的利息就是上个月本金产生的了。利息会陪伴你到还清本金的那一刻,等额本金最后一个还款月的利息就是这个差额,编程计算等额本金每月还款情况以及额度比例:
- #include <stdio.h>
- #include <stdlib.h>
- #include <math.h>
-
- #if 1
- #define M 1000000
- #define K 240
- #define R 0.046f
- #else
- #define M 1500000
- #define K 360
- #define R 0.036f
- #endif
-
- int main(void)
- {
- float x;
- int i;
-
- for(i = 0; i < K; i ++)
- {
- x = M * ((K - i) * R + 12)/ (K * 12);
- float sk = M / K;
- float bk = x- sk;
-
- printf("NO[%3d]: sk = %f, bk = %f, sk + bk = %f, interst ratio %f.\n", i, sk, bk, sk+bk, sk/x);
- }
-
- return 0;
- }
可以结合自身情况验证一下计算公式的正确性,等额本金每月还款额是一个等差数列:
等额本金每月利息偿还情况,也是等差数列
等额本金还款每月剩余本金情况,依然是等差数列。
等额本息每月还利息情况,可以看到这是一个曲线
等额本息每月偿还本金情况,可以看到,等额本息先还利息,在还本金,越往后,本金占比越大。
由于等额本息每月还款数额相同,所以上面两幅图是互补的。
等额本息剩余本金情况,可以看到,一开始本金下降速度比较慢,因为大部分的钱都用来还利息了。
以上就是对两种还款方式的简要分析,究竟选择那种方式要看本人情况而定.
利息有两种存在形式,分别是单利和复利, 它们的区别如下:
单利:是指按照固定的本金计算利息即本金固定。
复利:是指在计算第二次本金的时候里面要包括第一次产生的利息,所以又叫利滚利。
以本金x,月利率r,月数n为例,它们的账户金额变化情况为:
单利为:
复利为:
前者是一次函数,后者是底数大于1的指数函数,所以一定是复利的增长更快一些,两者的比例变化为:
以月利率0.3为例,变化规律为:
从图形上看,复利的优势到后期越明显。
复利是对未来的盈利增长统计,而计算历史过去的增长率叫做“复合增长率”,它的计算就是对上面的式子求逆:
假设某年的利润是x,n年后,利润增长到y,则年复合增长率为:
对于等额本息的情况,每月偿还本金额为:
则累积K月后,总的本金还款额为:
偿还利息的进度为:
所以,还款总利息额和还款总本金额随着还款期的变化趋势如下图示,看图说明,那前例来说,采用等额本息的还款模式,当你还完最后一笔本金的时候,已经还了大约53万的利息了。
我们有时会看到一些自媒体作者讲述自己购房的血泪经历,控诉银行贷款的高利率,比如说到还款三年有一半多的钱是在还利息,情况真的是这样么? 当我们绘制出总的利息额和总的还款额随时间变化的曲线的时候,很不幸地发现这些描述都是真实的。下图所示,可以看到还款第一个月,利息是本金的1.51倍,直到第115个月,还款利息都是大于本金的,本金占比在还款周期的后半程才后来居上,不过这已经占整个还款期的一半时间了,所以,如果你计划提前还款,建议你越早越好,晚了就没有多大意义了。
等额本金累计利息和本金还款额变化:
总计前N个月还款本息额为:
可以看到,等额本金还款情况下,本金还款总额是一条一次曲线,而累计利息还款总额是一条二次曲线,在240月达到最高点,也就是46万的时候偿还完所有的本息。相比另一种方式的利息总额531344元,节省了7万多。
对于当前投资回报率低的情况,未来的通胀预期强烈,很多人没有较好的投资渠道抵抗房贷的利息,所以与其将钱放在手上逐渐贬值,还不如提前还贷来的划算。也有一部分人是不喜欢欠钱的感觉,即便是债权人是银行也不可以。但是无论贷款属于上述哪种情况,都是从你提前还款的下个月的剩余本金中减去你的提前还款额,在此基础上再重新利用上面的公式计算剩余每个月的还款计划,不再分析。
等额本金的优劣分析:
1.还款额总和少于等额本息,主要原因是等额本金总利息少.
2.还款初期压力较大,还款末期压力较小。
如下图,两种方式利息的每月占比情况:
等额本息的优劣分析:
1.还款额总和大于等额本金,主要原因是等额本息情况下,还款前期利息比重大,末期才会体现出本金的比重.
2.每个还款期还款额度固定,便于提前安排家庭开支。
3.占用银行本金的能力强,对于善于理财投资的人来说,如果能够抵抗住多支付的利息,是个不错的选择。
4.如下图中所示,整个还款周期内,每个月利息所占还款金额的占比,等额本息都要比等额本金多。
本金占比变化,可以看到,固定本金即便还款达到94期的时间点,本金占比也仅仅只有总还款额的2/3,大家如果有贷款的话,可以和你的实际情况做个对比,和理论计算得到的曲线基上是对的上的,印度的剥削制度才是赤裸裸的。
两种方式都遵守的规则:还款周期越长,缴纳利息越多.
利息是由本金产生的,本金的变化率正比于利息的变化率,根据上面对两类还款方式的公式可以得到,等额本金情况下每月的利息是利率的一次函数,所以逐月利息构成一个等差数列逐渐减少,而等额本金下,由于每个月还款本金数量是不均匀的,所以每个月的利息数量和利率本身的关系比较复杂,利息按非线性规律变化。采用等额本金还款方式下,利息变化的影响直接而明显。
比如,当前珠海采用公积金贷款的利率是3.2,而商业贷款的利率是4.2贷款每降低一个点,按等额本金还款,你每月的还款压力就会少对应的比例,感受直接。
银行从放款那一天开始计算利息,购房借贷人可以自由选择每月的还款日,但是由于银行的放贷日和购房者确定的还款日可能不是同一天,所以首月的利息可能会和公式中按整月计算出的利息有所出入,所以造成首月还款额度和公式计算出来的并不一样。尽管如此,首月还款日的不对齐并不影响之后每月的还款额度,从第二个月开始,每个月的还款金额和公式计算得到的结果是完全一致的。
比如说,银行15日放贷,而你确定的还款日是这个月16日开始,那么首月还款总金额就包括当月的本金加上1天的利息,就会比公式计算出来的首月还款额少。但是如果你确定的还款从下个月16日开始,则首月还款本金不变,利息则为一天的利息再加上一个完整月的利息了。这样,首月还款额就会更多。
但是无论如何,首月承担了所有之后,从第二个还款月开始,还款额度和公式计算得到的就完全一致了。
无论等额本金还是等额本息,第一个月的利息额都是总贷款额产生的,但是由于等额本金情况下还款本金额度大,所以利息占比的起点相对较低,之后逐渐减少。
等额本金初始的利息占比:
等额本息初始利息占比:0.600779
题外话,我不太会同情那些高杠杆买房,拖家带口突然失业或者生病或者出意外,生活很拮据甚至走上绝路的人,完全没有危机意识,动不动贷款二三十年,几百万,动不动生二胎甚至三胎,谁能给你保证未来你一定有稳定收入呢?而且不稳定的概率还不小,即使贷款利率很高,他们认为用明天发生通货膨胀的钱来偿还今天用于购买房子,汽车的贷款是正确的做法,但是谁告诉你未来一定是通胀呢?成年人不考虑可能出现的不稳定因素,是自己的原因,因为你改变不了社会,只能自己控制风险。
个人贷款利率由LPR基础利率+基点共同决定,个人贷款应用的LPR基础利率一年一调, 签贷款合同的时候,可以选择贷款日调或者每年一月一日调整。这样的话,贷款利率就可以随行就市,随着市场变化,尤其是当前下行的趋势下,基点是负的,并且LPR逐年下调,选择一个合适的点上车就非常重要了。
虽然基点也是调控手段,但是对于个人来说,合同签订后,基点就固定了,就是你签合同时候的市场基点。但是你仍然可以享受LPR下调带来的好处。LPR基础利率是普惠大众的,而基点则精准定位,都是调控手段,只不过一个是粗调,一个是细调。
利用计算图计算公积金余额_papaofdoudou的博客-CSDN博客
Copyright © 2003-2013 www.wpsshop.cn 版权所有,并保留所有权利。