按揭贷款还款计算器等额本金等额本息EXCEL.xls

1、按按揭揭贷贷款款还还款款法法 20142014年年9 9月月2222日日 接揭贷款还款法 等等额额本本金金法法 等等额额本本息息法法 等等额额本本息息每每 年年调调整整 退退出出系系统统 利利率率调调整整表表 比比较较 组组合合贷贷款款等等 额额本本息息法法 组组合合贷贷款款等等 额额本本金金法法 利利率率表表 星星期期一一 按按揭揭贷贷款款还还款款法法 接揭贷款还款法 退退出出系系统统 比比较较 利利率率表表 等等额额本本息息还还款款法法 种种类类年年利利率率贷贷款款本本金金( (元元) )期期限限( (月月) )首首期期还还款款额额 等等额额本本息息6.8760%6.8760%4 46 6

2、0 0, ,0 00 00 0. .0 00 03603603 3, ,0 02 22 2. .1 18 8 注注：1 1、此此表表仅仅供供参参考考 2 2、本本表表假假定定年年利利率率不不变变 期期数数应应还还本本金金应应付付利利息息月月还还款款额额贷贷款款余余额额 0460000.00 1386.382635.803022.18459613.62 2388.592633.593022.18459225.03 3390.822631.363022.18458834.21 4393.062629.123022.18458441.15 5395.312626.873022.18458045.84

3、 6397.582624.603022.18457648.26 7399.862622.323022.18457248.40 8402.152620.033022.18456846.25 9404.452617.733022.18456441.80 10406.772615.413022.18456035.03 11409.102613.083022.18455625.93 12411.442610.743022.18455214.49 13413.802608.383022.18454800.69 14416.172606.013022.18454384.52 15418.562603.62

4、3022.18453965.96 16420.962601.223022.18453545.00 17423.372598.813022.18453121.63 18425.792596.393022.18452695.84 19428.232593.953022.18452267.61 20430.692591.493022.18451836.92 21433.152589.033022.18451403.77 22435.642586.543022.18450968.13 23438.132584.053022.18450530.00 24440.642581.543022.1845008

5、9.36 25443.172579.013022.18449646.19 26445.712576.473022.18449200.48 27448.262573.923022.18448752.22 28450.832571.353022.18448301.39 29453.412568.773022.18447847.98 30456.012566.173022.18447391.97 31458.622563.563022.18446933.35 32461.252560.933022.18446472.10 33463.892558.293022.18446008.21 34466.5

6、52555.633022.18445541.66 35469.232552.953022.18445072.43 36471.912550.273022.18444600.52 37474.622547.563022.18444125.90 38477.342544.843022.18443648.56 39480.072542.113022.18443168.49 40482.822539.363022.18442685.67 41485.592536.593022.18442200.08 42488.372533.813022.18441711.71 43491.172531.013022

7、.18441220.54 44493.992528.193022.18440726.55 45496.822525.363022.18440229.73 46499.662522.523022.18439730.07 47502.532519.653022.18439227.54 48505.412516.773022.18438722.13 49508.302513.883022.18438213.83 50511.212510.973022.18437702.62 51514.142508.043022.18437188.48 52517.092505.093022.18436671.39

8、 53520.052502.133022.18436151.34 54523.032499.153022.18435628.31 55526.032496.153022.18435102.28 56529.042493.143022.18434573.24 57532.082490.103022.18434041.16 58535.122487.063022.18433506.04 59538.192483.993022.18432967.85 60541.272480.913022.18432426.58 61544.382477.803022.18431882.20 62547.49247

9、4.693022.18431334.71 63550.632471.553022.18430784.08 64553.792468.393022.18430230.29 65556.962465.223022.18429673.33 66560.152462.033022.18429113.18 67563.362458.823022.18428549.82 68566.592455.593022.18427983.23 69569.842452.343022.18427413.39 70573.102449.083022.18426840.29 71576.392445.793022.184

10、26263.90 72579.692442.493022.18425684.21 73583.012439.173022.18425101.20 74586.352435.833022.18424514.85 75589.712432.473022.18423925.14 76593.092429.093022.18423332.05 77596.492425.693022.18422735.56 78599.912422.273022.18422135.65 79603.342418.843022.18421532.31 80606.802415.383022.18420925.51 816

11、10.282411.903022.18420315.23 82613.772408.413022.18419701.46 83617.292404.893022.18419084.17 84620.832401.353022.18418463.34 85624.392397.793022.18417838.95 86627.962394.223022.18417210.99 87631.562390.623022.18416579.43 88635.182387.003022.18415944.25 89638.822383.363022.18415305.43 90642.482379.70

12、3022.18414662.95 91646.162376.023022.18414016.79 92649.862372.323022.18413366.93 93653.592368.593022.18412713.34 94657.332364.853022.18412056.01 95661.102361.083022.18411394.91 96664.892357.293022.18410730.02 97668.702353.483022.18410061.32 98672.532349.653022.18409388.79 99676.382345.803022.1840871

13、2.41 100680.262341.923022.18408032.15 101684.162338.023022.18407347.99 102688.082334.103022.18406659.91 103692.022330.163022.18405967.89 104695.982326.203022.18405271.91 105699.972322.213022.18404571.94 106703.982318.203022.18403867.96 107708.022314.163022.18403159.94 108712.072310.113022.18402447.8

14、7 109716.152306.033022.18401731.72 110720.262301.923022.18401011.46 111724.382297.803022.18400287.08 112728.542293.643022.18399558.54 113732.712289.473022.18398825.83 114736.912285.273022.18398088.92 115741.132281.053022.18397347.79 116745.382276.803022.18396602.41 117749.652272.533022.18395852.76 1

15、18753.942268.243022.18395098.82 119758.262263.923022.18394340.56 120762.612259.573022.18393577.95 121766.982255.203022.18392810.97 122771.372250.813022.18392039.60 123775.792246.393022.18391263.81 124780.242241.943022.18390483.57 125784.712237.473022.18389698.86 126789.212232.973022.18388909.65 1277

16、93.732228.453022.18388115.92 128798.282223.903022.18387317.64 129802.852219.333022.18386514.79 130807.452214.733022.18385707.34 131812.082210.103022.18384895.26 132816.732205.453022.18384078.53 133821.412200.773022.18383257.12 134826.122196.063022.18382431.00 135830.852191.333022.18381600.15 136835.

17、612186.573022.18380764.54 137840.402181.783022.18379924.14 138845.212176.973022.18379078.93 139850.062172.123022.18378228.87 140854.932167.253022.18377373.94 141859.832162.353022.18376514.11 142864.752157.433022.18375649.36 143869.712152.473022.18374779.65 144874.692147.493022.18373904.96 145879.702

18、142.483022.18373025.26 146884.752137.433022.18372140.51 147889.812132.373022.18371250.70 148894.912127.273022.18370355.79 149900.042122.143022.18369455.75 150905.202116.983022.18368550.55 151910.392111.793022.18367640.16 152915.602106.583022.18366724.56 153920.852101.333022.18365803.71 154926.122096

19、.063022.18364877.59 155931.432090.753022.18363946.16 156936.772085.413022.18363009.39 157942.142080.043022.18362067.25 158947.532074.653022.18361119.72 159952.962069.223022.18360166.76 160958.422063.763022.18359208.34 161963.922058.263022.18358244.42 162969.442052.743022.18357274.98 163974.992047.19

20、3022.18356299.99 164980.582041.603022.18355319.41 165986.202035.983022.18354333.21 166991.852030.333022.18353341.36 167997.532024.653022.18352343.83 1681003.252018.933022.18351340.58 1691009.002013.183022.18350331.58 1701014.782007.403022.18349316.80 1711020.592001.593022.18348296.21 1721026.441995.

21、743022.18347269.77 1731032.321989.863022.18346237.45 1741038.241983.943022.18345199.21 1751044.191977.993022.18344155.02 1761050.171972.013022.18343104.85 1771056.191965.993022.18342048.66 1781062.241959.943022.18340986.42 1791068.331953.853022.18339918.09 1801074.451947.733022.18338843.64 1811080.6

22、11941.573022.18337763.03 1821086.801935.383022.18336676.23 1831093.031929.153022.18335583.20 1841099.291922.893022.18334483.91 1851105.591916.593022.18333378.32 1861111.921910.263022.18332266.40 1871118.291903.893022.18331148.11 1881124.701897.483022.18330023.41 1891131.151891.033022.18328892.26 190

23、1137.631884.553022.18327754.63 1911144.151878.033022.18326610.48 1921150.701871.483022.18325459.78 1931157.301864.883022.18324302.48 1941163.931858.253022.18323138.55 1951170.601851.583022.18321967.95 1961177.301844.883022.18320790.65 1971184.051838.133022.18319606.60 1981190.831831.353022.18318415.

24、77 1991197.661824.523022.18317218.11 2001204.521817.663022.18316013.59 2011211.421810.763022.18314802.17 2021218.361803.823022.18313583.81 2031225.341796.843022.18312358.47 2041232.371789.813022.18311126.10 2051239.431782.753022.18309886.67 2061246.531775.653022.18308640.14 2071253.671768.513022.183

25、07386.47 2081260.861761.323022.18306125.61 2091268.081754.103022.18304857.53 2101275.351746.833022.18303582.18 2111282.651739.533022.18302299.53 2121290.001732.183022.18301009.53 2131297.401724.783022.18299712.13 2141304.831717.353022.18298407.30 2151312.311709.873022.18297094.99 2161319.831702.3530

26、22.18295775.16 2171327.391694.793022.18294447.77 2181334.991687.193022.18293112.78 2191342.641679.543022.18291770.14 2201350.341671.843022.18290419.80 2211358.071664.113022.18289061.73 2221365.861656.323022.18287695.87 2231373.681648.503022.18286322.19 2241381.551640.633022.18284940.64 2251389.47163

27、2.713022.18283551.17 2261397.431624.753022.18282153.74 2271405.441616.743022.18280748.30 2281413.491608.693022.18279334.81 2291421.591600.593022.18277913.22 2301429.741592.443022.18276483.48 2311437.931584.253022.18275045.55 2321446.171576.013022.18273599.38 2331454.461567.723022.18272144.92 2341462

28、.791559.393022.18270682.13 2351471.171551.013022.18269210.96 2361479.601542.583022.18267731.36 2371488.081534.103022.18266243.28 2381496.611525.573022.18264746.67 2391505.181517.003022.18263241.49 2401513.811508.373022.18261727.68 2411522.481499.703022.18260205.20 2421531.201490.983022.18258674.00 2

29、431539.981482.203022.18257134.02 2441548.801473.383022.18255585.22 2451557.681464.503022.18254027.54 2461566.601455.583022.18252460.94 2471575.581446.603022.18250885.36 2481584.611437.573022.18249300.75 2491593.691428.493022.18247707.06 2501602.821419.363022.18246104.24 2511612.001410.183022.1824449

30、2.24 2521621.241400.943022.18242871.00 2531630.531391.653022.18241240.47 2541639.871382.313022.18239600.60 2551649.271372.913022.18237951.33 2561658.721363.463022.18236292.61 2571668.221353.963022.18234624.39 2581677.781344.403022.18232946.61 2591687.401334.783022.18231259.21 2601697.061325.123022.1

31、8229562.15 2611706.791315.393022.18227855.36 2621716.571305.613022.18226138.79 2631726.401295.783022.18224412.39 2641736.301285.883022.18222676.09 2651746.251275.933022.18220929.84 2661756.251265.933022.18219173.59 2671766.321255.863022.18217407.27 2681776.441245.743022.18215630.83 2691786.621235.56

32、3022.18213844.21 2701796.851225.333022.18212047.36 2711807.151215.033022.18210240.21 2721817.501204.683022.18208422.71 2731827.921194.263022.18206594.79 2741838.391183.793022.18204756.40 2751848.931173.253022.18202907.47 2761859.521162.663022.18201047.95 2771870.181152.003022.18199177.77 2781880.891

33、141.293022.18197296.88 2791891.671130.513022.18195405.21 2801902.511119.673022.18193502.70 2811913.411108.773022.18191589.29 2821924.371097.813022.18189664.92 2831935.401086.783022.18187729.52 2841946.491075.693022.18185783.03 2851957.641064.543022.18183825.39 2861968.861053.323022.18181856.53 28719

34、80.141042.043022.18179876.39 2881991.491030.693022.18177884.90 2892002.901019.283022.18175882.00 2902014.381007.803022.18173867.62 2912025.92996.263022.18171841.70 2922037.53984.653022.18169804.17 2932049.20972.983022.18167754.97 2942060.94961.243022.18165694.03 2952072.75949.433022.18163621.28 2962

35、084.63937.553022.18161536.65 2972096.57925.613022.18159440.08 2982108.59913.593022.18157331.49 2992120.67901.513022.18155210.82 3002132.82889.363022.18153078.00 3012145.04877.143022.18150932.96 3022157.33864.853022.18148775.63 3032169.70852.483022.18146605.93 3042182.13840.053022.18144423.80 3052194

36、.63827.553022.18142229.17 3062207.21814.973022.18140021.96 3072219.85802.333022.18137802.11 3082232.57789.613022.18135569.54 3092245.37776.813022.18133324.17 3102258.23763.953022.18131065.94 3112271.17751.013022.18128794.77 3122284.19737.993022.18126510.58 3132297.27724.913022.18124213.31 3142310.44

37、711.743022.18121902.87 3152323.68698.503022.18119579.19 3162336.99685.193022.18117242.20 3172350.38671.803022.18114891.82 3182363.85658.333022.18112527.97 3192377.39644.793022.18110150.58 3202391.02631.163022.18107759.56 3212404.72617.463022.18105354.84 3222418.50603.683022.18102936.34 3232432.35589

38、.833022.18100503.99 3242446.29575.893022.1898057.70 3252460.31561.873022.1895597.39 3262474.41547.773022.1893122.98 3272488.59533.593022.1890634.39 3282502.84519.343022.1888131.55 3292517.19504.993022.1885614.36 3302531.61490.573022.1883082.75 3312546.12476.063022.1880536.63 3322560.71461.473022.187

39、7975.92 3332575.38446.803022.1875400.54 3342590.13432.053022.1872810.41 3352604.98417.203022.1870205.43 3362619.90402.283022.1867585.53 3372634.91387.273022.1864950.62 3382650.01372.173022.1862300.61 3392665.20356.983022.1859635.41 3402680.47341.713022.1856954.94 3412695.83326.353022.1854259.11 3422

40、711.28310.903022.1851547.83 3432726.81295.373022.1848821.02 3442742.44279.743022.1846078.58 3452758.15264.033022.1843320.43 3462773.95248.233022.1840546.48 3472789.85232.333022.1837756.63 3482805.83216.353022.1834950.80 3492821.91200.273022.1832128.89 3502838.08184.103022.1829290.81 3512854.34167.84

41、3022.1826436.47 3522870.70151.483022.1823565.77 3532887.15135.033022.1820678.62 3542903.69118.493022.1817774.93 3552920.33101.853022.1814854.60 3562937.0685.123022.1811917.54 3572953.8968.293022.188963.65 3582970.8251.363022.185992.83 3592987.8434.343022.183004.99 3603004.9917.223022.210.00 627984.8

42、3 等等额额本本金金还还款款法法 种种类类年年利利率率贷贷款款本本金金( (元元) )期期限限( (月月) )每每期期还还本本额额 等等额额本本金金6.8760%6.8760%4 46 60 0, ,0 00 00 0. .0 00 03603601 1, ,2 27 77 7. .7 78 8 注注：1 1、此此表表仅仅供供参参考考 2 2、本本表表假假定定年年利利率率不不变变 期期数数应应还还本本金金应应付付利利息息月月还还款款额额贷贷款款余余额额 0460000.00 11277.782635.803913.58458722.22 21277.782628.483906.26457444

43、.44 31277.782621.163898.94456166.66 41277.782613.833891.61454888.88 51277.782606.513884.29453611.10 61277.782599.193876.97452333.32 71277.782591.873869.65451055.54 81277.782584.553862.33449777.76 91277.782577.233855.01448499.98 101277.782569.903847.68447222.20 111277.782562.583840.36445944.42 121277

44、.782555.263833.04444666.64 131277.782547.943825.72443388.86 141277.782540.623818.40442111.08 151277.782533.303811.08440833.30 161277.782525.973803.75439555.52 171277.782518.653796.43438277.74 181277.782511.333789.11436999.96 191277.782504.013781.79435722.18 201277.782496.693774.47434444.40 211277.78

45、2489.373767.15433166.62 221277.782482.043759.82431888.84 231277.782474.723752.50430611.06 241277.782467.403745.18429333.28 251277.782460.083737.86428055.50 261277.782452.763730.54426777.72 271277.782445.443723.22425499.94 281277.782438.113715.89424222.16 291277.782430.793708.57422944.38 301277.78242

46、3.473701.25421666.60 311277.782416.153693.93420388.82 321277.782408.833686.61419111.04 331277.782401.513679.29417833.26 341277.782394.183671.96416555.48 351277.782386.863664.64415277.70 361277.782379.543657.32413999.92 371277.782372.223650.00412722.14 381277.782364.903642.68411444.36 391277.782357.5

47、83635.36410166.58 401277.782350.253628.03408888.80 411277.782342.933620.71407611.02 421277.782335.613613.39406333.24 431277.782328.293606.07405055.46 441277.782320.973598.75403777.68 451277.782313.653591.43402499.90 461277.782306.323584.10401222.12 471277.782299.003576.78399944.34 481277.782291.6835

48、69.46398666.56 491277.782284.363562.14397388.78 501277.782277.043554.82396111.00 511277.782269.723547.50394833.22 521277.782262.393540.17393555.44 531277.782255.073532.85392277.66 541277.782247.753525.53390999.88 551277.782240.433518.21389722.10 561277.782233.113510.89388444.32 571277.782225.793503.

49、57387166.54 581277.782218.463496.24385888.76 591277.782211.143488.92384610.98 601277.782203.823481.60383333.20 611277.782196.503474.28382055.42 621277.782189.183466.96380777.64 631277.782181.863459.64379499.86 641277.782174.533452.31378222.08 651277.782167.213444.99376944.30 661277.782159.893437.673

50、75666.52 671277.782152.573430.35374388.74 681277.782145.253423.03373110.96 691277.782137.933415.71371833.18 701277.782130.603408.38370555.40 711277.782123.283401.06369277.62 721277.782115.963393.74367999.84 731277.782108.643386.42366722.06 741277.782101.323379.10365444.28 751277.782094.003371.783641

51、66.50 761277.782086.673364.45362888.72 771277.782079.353357.13361610.94 781277.782072.033349.81360333.16 791277.782064.713342.49359055.38 801277.782057.393335.17357777.60 811277.782050.073327.85356499.82 821277.782042.743320.52355222.04 831277.782035.423313.20353944.26 841277.782028.103305.88352666.

52、48 851277.782020.783298.56351388.70 861277.782013.463291.24350110.92 871277.782006.143283.92348833.14 881277.781998.813276.59347555.36 891277.781991.493269.27346277.58 901277.781984.173261.95344999.80 911277.781976.853254.63343722.02 921277.781969.533247.31342444.24 931277.781962.213239.99341166.46

53、941277.781954.883232.66339888.68 951277.781947.563225.34338610.90 961277.781940.243218.02337333.12 971277.781932.923210.70336055.34 981277.781925.603203.38334777.56 991277.781918.283196.06333499.78 1001277.781910.953188.73332222.00 1011277.781903.633181.41330944.22 1021277.781896.313174.09329666.44

54、1031277.781888.993166.77328388.66 1041277.781881.673159.45327110.88 1051277.781874.353152.13325833.10 1061277.781867.023144.80324555.32 1071277.781859.703137.48323277.54 1081277.781852.383130.16321999.76 1091277.781845.063122.84320721.98 1101277.781837.743115.52319444.20 1111277.781830.423108.203181

55、66.42 1121277.781823.093100.87316888.64 1131277.781815.773093.55315610.86 1141277.781808.453086.23314333.08 1151277.781801.133078.91313055.30 1161277.781793.813071.59311777.52 1171277.781786.493064.27310499.74 1181277.781779.163056.94309221.96 1191277.781771.843049.62307944.18 1201277.781764.523042.

56、30306666.40 1211277.781757.203034.98305388.62 1221277.781749.883027.66304110.84 1231277.781742.563020.34302833.06 1241277.781735.233013.01301555.28 1251277.781727.913005.69300277.50 1261277.781720.592998.37298999.72 1271277.781713.272991.05297721.94 1281277.781705.952983.73296444.16 1291277.781698.6

57、32976.41295166.38 1301277.781691.302969.08293888.60 1311277.781683.982961.76292610.82 1321277.781676.662954.44291333.04 1331277.781669.342947.12290055.26 1341277.781662.022939.80288777.48 1351277.781654.692932.47287499.70 1361277.781647.372925.15286221.92 1371277.781640.052917.83284944.14 1381277.78

58、1632.732910.51283666.36 1391277.781625.412903.19282388.58 1401277.781618.092895.87281110.80 1411277.781610.762888.54279833.02 1421277.781603.442881.22278555.24 1431277.781596.122873.90277277.46 1441277.781588.802866.58275999.68 1451277.781581.482859.26274721.90 1461277.781574.162851.94273444.12 1471

59、277.781566.832844.61272166.34 1481277.781559.512837.29270888.56 1491277.781552.192829.97269610.78 1501277.781544.872822.65268333.00 1511277.781537.552815.33267055.22 1521277.781530.232808.01265777.44 1531277.781522.902800.68264499.66 1541277.781515.582793.36263221.88 1551277.781508.262786.04261944.10 1561277.781500.942778.72260666.32 1571277.781493.622771.40259388.54 1581277.781486.302764.08258110.76 1591277.781478.972756.75256832.98 1601277.781471.652749.43255555.20 1611277.781464.332742.11254277.42 1621277.781457.012734.79252999.64 1631277.