今年最新版 等額本金 等額本息按揭貸款還款方式比較,哪個(gè)更劃算,excel表格商業(yè),公積金自動(dòng)公式計(jì)算

1、按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 1 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 2 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 3 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 4 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 5 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償

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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 6 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款

22、款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 7 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款

26、款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 8 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 9 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和

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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 10 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限

39、限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 11 頁(yè)，共 17 頁(yè)35等

43、等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 12 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 13 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付

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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 14 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30

56、利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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按揭貸款等額本息和等額本金還款對(duì)比分析期限：1-30年第 15

60、 頁(yè)，共 17 頁(yè)35等等額額本本息息還還款款法法35.0035.00等等額額本本金金還還款款法法利利率率5.12%562.00期期限限( (月月) )30利利率率5.12%期期限限30.00貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本息和利利息息和和本本金金貸貸款款額額度度( (萬(wàn)萬(wàn)) )合合計(jì)計(jì)償償付付本本息息和和利利息息和和本本金金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