今年最新版 等额本金 等额本息按揭贷款还款方式比较,哪个更划算,excel表格商业,公积金自动公式计算

1、按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 1 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7.

2、 .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金1100.000.540.430.121100.000.700.430.28299.880.540.430.12299.720.700.430.28399.760.540.430.12399.440.700.420.28499.650.540.430.12499.170.700.420.28599.530.540.420.12598.890.700.420.28699.410.540.420.12698

3、.610.700.420.28799.290.540.420.12798.330.700.420.28899.170.540.420.12898.060.700.420.28999.050.540.420.12997.780.690.420.281098.920.540.420.121097.500.690.420.281198.800.540.420.121197.220.690.410.281298.680.540.420.121296.940.690.410.281398.560.540.420.121396.670.690.410.281498.430.540.420.121496.3

4、90.690.410.281598.310.540.420.121596.110.690.410.281698.180.540.420.131695.830.690.410.281798.060.540.420.131795.560.690.410.281897.930.540.420.131895.280.680.410.281997.810.540.420.131995.000.680.410.282097.680.540.420.132094.720.680.400.282197.550.540.420.132194.440.680.400.282297.420.540.420.1322

5、94.170.680.400.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 2 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0.

6、.0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金2397.300.540.420.132393.890.680.400.282497.170.540.410.132493.610.680.400.282597.040.540.410.132593.330.680.400.282696.910.540.410.132693.060.670.400.282796.780.540.410.132792.780.670.40

7、0.282896.640.540.410.132892.500.670.390.282996.510.540.410.132992.220.670.390.283096.380.540.410.133091.940.670.390.283196.250.540.410.133191.670.670.390.283296.110.540.410.133291.390.670.390.283395.980.540.410.133391.110.670.390.283495.850.540.410.143490.830.670.390.283595.710.540.410.143590.560.66

8、0.390.283695.570.540.410.143690.280.660.390.283795.440.540.410.143790.000.660.380.283895.300.540.410.143889.720.660.380.283995.160.540.410.143989.440.660.380.284095.030.540.410.144089.170.660.380.284194.890.540.400.144188.890.660.380.284294.750.540.400.144288.610.660.380.284394.610.540.400.144388.33

9、0.650.380.284494.470.540.400.144488.060.650.380.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 3 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9

10、90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金4594.330.540.400.144587.780.650.370.284694.180.540.400.144687.500.650.370.284794.040.540.400.144787.220.650.370.284893.900.540.400.144886.940.650.370.284

11、993.750.540.400.144986.670.650.370.285093.610.540.400.145086.390.650.370.285193.470.540.400.155186.110.650.370.285293.320.540.400.155285.830.640.370.285393.170.540.400.155385.560.640.370.285493.030.540.400.155485.280.640.360.285592.880.540.400.155585.000.640.360.285692.730.540.400.155684.720.640.360

12、.285792.580.540.400.155784.440.640.360.285892.440.540.390.155884.170.640.360.285992.290.540.390.155983.890.640.360.286092.130.540.390.156083.610.630.360.286191.980.540.390.156183.330.630.360.286291.830.540.390.156283.060.630.350.286391.680.540.390.156382.780.630.350.286491.530.540.390.156482.500.630

13、.350.286591.370.540.390.156582.220.630.350.286691.220.540.390.156681.940.630.350.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 4 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0

14、00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金6791.060.540.390.166781.670.630.350.286890.910.540.390.166881.390.630.350.286990.750.540.390.166981.110.620.350.287090.5

15、90.540.390.167080.830.620.340.287190.440.540.390.167180.560.620.340.287290.280.540.390.167280.280.620.340.287390.120.540.380.167380.000.620.340.287489.960.540.380.167479.720.620.340.287589.800.540.380.167579.440.620.340.287689.640.540.380.167679.170.620.340.287789.480.540.380.167778.890.610.340.2878

16、89.310.540.380.167878.610.610.340.287989.150.540.380.167978.330.610.330.288088.990.540.380.168078.060.610.330.288188.820.540.380.178177.780.610.330.288288.660.540.380.178277.500.610.330.288388.490.540.380.178377.220.610.330.288488.330.540.380.178476.940.610.330.288588.160.540.380.178576.670.600.330.

17、288687.990.540.380.178676.390.600.330.288787.820.540.370.178776.110.600.320.288887.650.540.370.178875.830.600.320.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 5 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿

18、偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金8987.480.540.370.178975.560.600.320.289087.310.540.370.179075.280.600.320.289187.140.54

19、0.370.179175.000.600.320.289286.970.540.370.179274.720.600.320.289386.790.540.370.179374.440.600.320.289486.620.540.370.179474.170.590.320.289586.450.540.370.189573.890.590.320.289686.270.540.370.189673.610.590.310.289786.090.540.370.189773.330.590.310.289885.920.540.370.189873.060.590.310.289985.74

20、0.540.370.189972.780.590.310.2810085.560.540.370.1810072.500.590.310.2810185.380.540.360.1810172.220.590.310.2810285.200.540.360.1810271.940.580.310.2810385.020.540.360.1810371.670.580.310.2810484.840.540.360.1810471.390.580.300.2810584.660.540.360.1810571.110.580.300.2810684.470.540.360.1810670.830

21、.580.300.2810784.290.540.360.1810770.560.580.300.2810884.110.540.360.1910870.280.580.300.2810983.920.540.360.1910970.000.580.300.2811083.740.540.360.1911069.720.580.300.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 6 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款

22、款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金11183.550.540.360.1911169.440.57

23、0.300.2811283.360.540.360.1911269.170.570.300.2811383.170.540.350.1911368.890.570.290.2811482.980.540.350.1911468.610.570.290.2811582.790.540.350.1911568.330.570.290.2811682.600.540.350.1911668.060.570.290.2811782.410.540.350.1911767.780.570.290.2811882.220.540.350.1911867.500.570.290.2811982.020.54

24、0.350.1911967.220.560.290.2812081.830.540.350.2012066.940.560.290.2812181.630.540.350.2012166.670.560.280.2812281.440.540.350.2012266.390.560.280.2812381.240.540.350.2012366.110.560.280.2812481.040.540.350.2012465.830.560.280.2812580.850.540.340.2012565.560.560.280.2812680.650.540.340.2012665.280.56

25、0.280.2812780.450.540.340.2012765.000.560.280.2812880.250.540.340.2012864.720.550.280.2812980.040.540.340.2012964.440.550.270.2813079.840.540.340.2013064.170.550.270.2813179.640.540.340.2013163.890.550.270.2813279.430.540.340.2113263.610.550.270.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 7 页，共 17 页35等等额额本本息息还还款

26、款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金

27、金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金13379.230.540.340.2113363.330.550.270.2813479.020.540.340.2113463.060.550.270.2813578.820.540.340.2113562.780.550.270.2813678.610.540.340.2113662.500.540.270.2813778.400.540.330.2113762.220.540.270.2813878.190.540.330.2113861.940.540.260.2813977.980.540.3

28、30.2113961.670.540.260.2814077.770.540.330.2114061.390.540.260.2814177.550.540.330.2114161.110.540.260.2814277.340.540.330.2114260.830.540.260.2814377.130.540.330.2214360.560.540.260.2814476.910.540.330.2214460.280.530.260.2814576.700.540.330.2214560.000.530.260.2814676.480.540.330.2214659.720.530.2

29、50.2814776.260.540.330.2214759.440.530.250.2814876.040.540.320.2214859.170.530.250.2814975.820.540.320.2214958.890.530.250.2815075.600.540.320.2215058.610.530.250.2815175.380.540.320.2215158.330.530.250.2815275.160.540.320.2215258.060.530.250.2815374.930.540.320.2215357.780.520.250.2815474.710.540.3

30、20.2315457.500.520.250.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 8 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 1

31、0 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金15574.480.540.320.2315557.220.520.240.2815674.260.540.320.2315656.940.520.240.2815774.030.540.320.2315756.670.520.240.2815873.800.540.310.2315856.390.520.240.2815973.570.540.310.

32、2315956.110.520.240.2816073.340.540.310.2316055.830.520.240.2816173.110.540.310.2316155.560.510.240.2816272.880.540.310.2316255.280.510.240.2816372.650.540.310.2316355.000.510.230.2816472.410.540.310.2416454.720.510.230.2816572.180.540.310.2416554.440.510.230.2816671.940.540.310.2416654.170.510.230.

33、2816771.700.540.310.2416753.890.510.230.2816871.460.540.300.2416853.610.510.230.2816971.230.540.300.2416953.330.510.230.2817070.990.540.300.2417053.060.500.230.2817170.740.540.300.2417152.780.500.230.2817270.500.540.300.2417252.500.500.220.2817370.260.540.300.2417352.220.500.220.2817470.010.540.300.

34、2517451.940.500.220.2817569.770.540.300.2517551.670.500.220.2817669.520.540.300.2517651.390.500.220.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 9 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和

35、和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金17769.270.540.300.2517751.110.500.220.2817869.030.540.290.2517850.830.490.220.2817968.780.540.290.251

36、7950.560.490.220.2818068.530.540.290.2518050.280.490.210.2818168.270.540.290.2518150.000.490.210.2818268.020.540.290.2518249.720.490.210.2818367.770.540.290.2618349.440.490.210.2818467.510.540.290.2618449.170.490.210.2818567.260.540.290.2618548.890.490.210.2818667.000.540.290.2618648.610.490.210.281

37、8766.740.540.280.2618748.330.480.210.2818866.480.540.280.2618848.060.480.210.2818966.220.540.280.2618947.780.480.200.2819065.960.540.280.2619047.500.480.200.2819165.700.540.280.2619147.220.480.200.2819265.430.540.280.2719246.940.480.200.2819365.170.540.280.2719346.670.480.200.2819464.900.540.280.271

38、9446.390.480.200.2819564.630.540.280.2719546.110.470.200.2819664.360.540.270.2719645.830.470.200.2819764.100.540.270.2719745.560.470.190.2819863.820.540.270.2719845.280.470.190.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 10 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限

39、限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金19963.550.540.270.27199

40、45.000.470.190.2820063.280.540.270.2720044.720.470.190.2820163.010.540.270.2820144.440.470.190.2820262.730.540.270.2820244.170.470.190.2820362.450.540.270.2820343.890.470.190.2820462.180.540.270.2820443.610.460.190.2820561.900.540.260.2820543.330.460.180.2820661.620.540.260.2820643.060.460.180.28207

41、61.340.540.260.2820742.780.460.180.2820861.050.540.260.2820842.500.460.180.2820960.770.540.260.2820942.220.460.180.2821060.480.540.260.2921041.940.460.180.2821160.200.540.260.2921141.670.460.180.2821259.910.540.260.2921241.390.450.180.2821359.620.540.250.2921341.110.450.180.2821459.330.540.250.29214

42、40.830.450.170.2821559.040.540.250.2921540.560.450.170.2821658.750.540.250.2921640.280.450.170.2821758.460.540.250.2921740.000.450.170.2821858.160.540.250.3021839.720.450.170.2821957.870.540.250.3021939.440.450.170.2822057.570.540.250.3022039.170.440.170.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 11 页，共 17 页35等

43、等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月

44、月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金22157.270.540.240.3022138.890.440.170.2822256.970.540.240.3022238.610.440.160.2822356.670.540.240.3022338.330.440.160.2822456.370.540.240.3022438.060.440.160.2822556.060.540.240.3022537.780.440.160.2822655.760.540.240.3122637.500.440.160.2822755

45、.450.540.240.3122737.220.440.160.2822855.140.540.240.3122836.940.440.160.2822954.830.540.230.3122936.670.430.160.2823054.520.540.230.3123036.390.430.160.2823154.210.540.230.3123136.110.430.150.2823253.900.540.230.3123235.830.430.150.2823353.590.540.230.3223335.560.430.150.2823453.270.540.230.3223435

46、.280.430.150.2823552.950.540.230.3223535.000.430.150.2823652.640.540.220.3223634.720.430.150.2823752.320.540.220.3223734.440.420.150.2823851.990.540.220.3223834.170.420.150.2823951.670.540.220.3223933.890.420.140.2824051.350.540.220.3324033.610.420.140.2824151.020.540.220.3324133.330.420.140.2824250

47、.700.540.220.3324233.060.420.140.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 12 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0.

48、 .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金24350.370.540.210.3324332.780.420.140.2824450.040.540.210.3324432.500.420.140.2824549.710.540.210.3324532.220.420.140.2824649.380.540.210.3324631.940.410.140.2824749.0

49、40.540.210.3324731.670.410.140.2824848.710.540.210.3424831.390.410.130.2824948.370.540.210.3424931.110.410.130.2825048.030.540.200.3425030.830.410.130.2825147.700.540.200.3425130.560.410.130.2825247.350.540.200.3425230.280.410.130.2825347.010.540.200.3425330.000.410.130.2825446.670.540.200.3525429.7

50、20.400.130.2825546.320.540.200.3525529.440.400.130.2825645.980.540.200.3525629.170.400.120.2825745.630.540.190.3525728.890.400.120.2825845.280.540.190.3525828.610.400.120.2825944.930.540.190.3525928.330.400.120.2826044.580.540.190.3526028.060.400.120.2826144.220.540.190.3626127.780.400.120.2826243.8

51、70.540.190.3626227.500.400.120.2826343.510.540.190.3626327.220.390.120.2826443.150.540.180.3626426.940.390.110.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 13 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付

52、付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金26542.790.540.180.3626526.670.390.110.2826642.430.540.180.3626626.390.390.110.2826742.070

53、.540.180.3626726.110.390.110.2826841.700.540.180.3726825.830.390.110.2826941.340.540.180.3726925.560.390.110.2827040.970.540.170.3727025.280.390.110.2827140.600.540.170.3727125.000.380.110.2827240.230.540.170.3727224.720.380.110.2827339.850.540.170.3727324.440.380.100.2827439.480.540.170.3827424.170

54、.380.100.2827539.100.540.170.3827523.890.380.100.2827638.730.540.170.3827623.610.380.100.2827738.350.540.160.3827723.330.380.100.2827837.970.540.160.3827823.060.380.100.2827937.590.540.160.3827922.780.370.100.2828037.200.540.160.3928022.500.370.100.2828136.820.540.160.3928122.220.370.090.2828236.430

55、.540.160.3928221.940.370.090.2828336.040.540.150.3928321.670.370.090.2828435.650.540.150.3928421.390.370.090.2828535.260.540.150.3928521.110.370.090.2828634.860.540.150.4028620.830.370.090.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 14 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30

56、利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00 0. .0 00 0月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金月月份份月月初初本本金金月月末末偿偿还还利利息息本本金金28734.470.5

57、40.150.4028720.560.370.090.2828834.070.540.150.4028820.280.360.090.2828933.670.540.140.4028920.000.360.090.2829033.270.540.140.4029019.720.360.080.2829132.870.540.140.4029119.440.360.080.2829232.470.540.140.4129219.170.360.080.2829332.060.540.140.4129318.890.360.080.2829431.650.540.140.4129418.610.3

58、60.080.2829531.240.540.130.4129518.330.360.080.2829630.830.540.130.4129618.060.350.080.2829730.420.540.130.4129717.780.350.080.2829830.010.540.130.4229817.500.350.070.2829929.590.540.130.4229917.220.350.070.2830029.170.540.120.4230016.940.350.070.2830128.750.540.120.4230116.670.350.070.2830228.330.5

59、40.120.4230216.390.350.070.2830327.910.540.120.4330316.110.350.070.2830427.480.540.120.4330415.830.350.070.2830527.060.540.120.4330515.560.340.070.2830626.630.540.110.4330615.280.340.070.2830726.200.540.110.4330715.000.340.060.2830825.760.540.110.4330814.720.340.060.28按揭贷款等额本息和等额本金还款对比分析期限：1-30年第 15

60、 页，共 17 页35等等额额本本息息还还款款法法35.0035.00等等额额本本金金还还款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00贷贷款款额额度度( (万万) )合合计计偿偿付付本息和利利息息和和本本金金贷贷款款额额度度( (万万) )合合计计偿偿付付本本息息和和利利息息和和本本金金1 10 00 0. .0 00 01 19 95 5. .9 90 09 95 5. .9 90 01 10 00 0. .0 00 01 10 00 0. .0 00 01 17 77 7. .0 01 17 77 7. .0 01 11 10 00