2011-7-7贷款速算表

合集下载

很实用的银行贷款计算表

很实用的银行贷款计算表
21 41
61
270000.00 268875.00 267750.00 266625.00 265500.00 264375.00 263250.00 262125.00 261000.00 259875.00 258750.00 257625.00 256500.00 255375.00 254250.00 253125.00 252000.00 250875.00 249750.00 248625.00 247500.00 246375.00 245250.00
第 2 页,共 16 页
按揭贷款 27 利率 贷款额度 270000
月份 2015年8月1日 2015年9月1日 2015年10月1日 2015年11月1日 2015年12月1日 2016年1月1日 2016年2月1日 2016年3月1日 2016年4月1日 2016年5月1日 2016年6月1日 2016年7月1日 2016年8月1日 2016年9月1日 2016年10月1日 2016年11月1日 2016年12月1日 2017年1月1日 2017年2月1日 2017年3月1日 2017年4月1日 2017年5月1日 2017年6月1日
等额本息和等额本金还款对比分析 等额本息还款法 4.95% 合计偿付
月初本金
期限:1-30年 等额本金还款法 4.95% 本息和 期限 利息和 134206.88
利息
27 20 本金 270000
本金
495.00 本息和
期限 利息和
利率 贷款额度 270000
月份
20 本金 270000
本金
425863.5014 155863.501 月末偿还 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43 1774.43

EXCEL房贷计算表

EXCEL房贷计算表

月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金14,591.473,415.981,175.49598,82524,591.473,409.291,182.18597,64234,591.473,402.561,188.91596,45344,591.473,395.791,195.68595,25854,591.473,388.981,202.49594,05564,591.473,382.131,209.34592,84674,591.473,375.251,216.22591,63084,591.473,368.321,223.15590,40794,591.473,361.361,230.11589,176104,591.473,354.361,237.11587,939114,591.473,347.311,244.16586,695124,591.473,340.231,251.24585,444134,591.473,333.111,258.36584,186144,591.473,325.941,265.53582,920154,591.473,318.741,272.73581,647164,591.473,311.491,279.98580,367174,591.473,304.201,287.27579,080184,591.473,296.881,294.59577,785194,591.473,289.501,301.97576,483204,591.473,282.091,309.38575,174214,591.473,274.641,316.83573,857224,591.473,267.141,324.33572,533234,591.473,259.601,331.87571,201244,591.473,252.021,339.45569,862254,591.473,244.391,347.08568,515264,591.473,236.721,354.75567,160274,591.473,229.011,362.46565,797284,591.473,221.251,370.22564,427294,591.473,213.451,378.02563,049304,591.473,205.611,385.86561,663314,591.473,197.721,393.75560,269324,591.473,189.781,401.69558,868334,591.473,181.801,409.67557,458344,591.473,173.781,417.69556,040354,591.473,165.701,425.77554,615364,591.473,157.591,433.88553,181374,591.473,149.421,442.05551,739384,591.473,141.211,450.26550,288394,591.473,132.961,458.51548,830404,591.473,124.651,466.82547,363414,591.473,116.301,475.17545,888424,591.473,107.901,483.57544,404434,591.473,099.461,492.01542,912444,591.473,090.961,500.51541,412454,591.473,082.421,509.05539,903464,591.473,073.831,517.64538,385474,591.473,065.191,526.28536,859484,591.473,056.501,534.97535,324494,591.473,047.761,543.71533,780504,591.473,038.971,552.50532,228月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金514,591.473,030.131,561.34530,666524,591.473,021.241,570.23529,096534,591.473,012.301,579.17527,517544,591.473,003.311,588.16525,929554,591.472,994.271,597.20524,332564,591.472,985.181,606.29522,725574,591.472,976.031,615.44521,110584,591.472,966.831,624.64519,485594,591.472,957.581,633.89517,851604,591.472,948.281,643.19516,208614,591.472,938.931,652.54514,556624,591.472,929.521,661.95512,894634,591.472,920.061,671.41511,222644,591.472,910.541,680.93509,541654,591.472,900.971,690.50507,851664,591.472,891.351,700.12506,151674,591.472,881.671,709.80504,441684,591.472,871.931,719.54502,721694,591.472,862.141,729.33500,992704,591.472,852.301,739.17499,253714,591.472,842.401,749.07497,504724,591.472,832.441,759.03495,745734,591.472,822.421,769.05493,976744,591.472,812.351,779.12492,197754,591.472,802.221,789.25490,407764,591.472,792.041,799.43488,608774,591.472,781.791,809.68486,798784,591.472,771.491,819.98484,978794,591.472,761.131,830.34483,148804,591.472,750.711,840.76481,307814,591.472,740.231,851.24479,456824,591.472,729.691,861.78477,594834,591.472,719.091,872.38475,722844,591.472,708.431,883.04473,839854,591.472,697.711,893.76471,945864,591.472,686.921,904.55470,040874,591.472,676.081,915.39468,125884,591.472,665.181,926.29466,199894,591.472,654.211,937.26464,262904,591.472,643.181,948.29462,313914,591.472,632.091,959.38460,354924,591.472,620.931,970.54458,383934,591.472,609.711,981.76456,402944,591.472,598.431,993.04454,408954,591.472,587.082,004.39452,404964,591.472,575.672,015.80450,388974,591.472,564.192,027.28448,361984,591.472,552.652,038.82446,322994,591.472,541.052,050.42444,2721004,591.472,529.372,062.10442,210月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金1014,591.472,517.632,073.84440,1361024,591.472,505.822,085.65438,0501034,591.472,493.952,097.52435,9531044,591.472,482.012,109.46433,8431054,591.472,470.002,121.47431,7221064,591.472,457.922,133.55429,5881074,591.472,445.772,145.70427,4421084,591.472,433.562,157.91425,2851094,591.472,421.272,170.20423,1141104,591.472,408.922,182.55420,9321114,591.472,396.492,194.98418,7371124,591.472,383.992,207.48416,5291134,591.472,371.432,220.04414,3091144,591.472,358.792,232.68412,0771154,591.472,346.082,245.39409,8311164,591.472,333.292,258.18407,5731174,591.472,320.432,271.04405,3021184,591.472,307.512,283.96403,0181194,591.472,294.502,296.97400,7211204,591.472,281.422,310.05398,4111214,591.472,268.272,323.20396,0881224,591.472,255.052,336.42393,7511234,591.472,241.742,349.73391,4021244,591.472,228.372,363.10389,0391254,591.472,214.912,376.56386,6621264,591.472,201.382,390.09384,2721274,591.472,187.772,403.70381,8681284,591.472,174.092,417.38379,4511294,591.472,160.332,431.14377,0201304,591.472,146.492,444.98374,5751314,591.472,132.572,458.90372,1161324,591.472,118.572,472.90369,6431334,591.472,104.492,486.98367,1561344,591.472,090.332,501.14364,6551354,591.472,076.092,515.38362,1391364,591.472,061.772,529.70359,6101374,591.472,047.372,544.10357,0661384,591.472,032.882,558.59354,5071394,591.472,018.312,573.16351,9341404,591.472,003.662,587.81349,3461414,591.471,988.932,602.54346,7441424,591.471,974.112,617.36344,1261434,591.471,959.212,632.26341,4941444,591.471,944.232,647.24338,8471454,591.471,929.162,662.31336,1841464,591.471,914.002,677.47333,5071474,591.471,898.752,692.72330,8141484,591.471,883.422,708.05328,1061494,591.471,868.012,723.46325,3831504,591.471,852.502,738.97322,644月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金1514,591.471,836.912,754.56319,8891524,591.471,821.222,770.25317,1191534,591.471,805.452,786.02314,3331544,591.471,789.592,801.88311,5311554,591.471,773.642,817.83308,7131564,591.471,757.602,833.87305,8791574,591.471,741.462,850.01303,0291584,591.471,725.242,866.23300,1631594,591.471,708.922,882.55297,2811604,591.471,692.512,898.96294,3821614,591.471,676.002,915.47291,4661624,591.471,659.402,932.07288,5341634,591.471,642.712,948.76285,5851644,591.471,625.922,965.55282,6201654,591.471,609.042,982.43279,6371664,591.471,592.062,999.41276,6381674,591.471,574.983,016.49273,6211684,591.471,557.813,033.66270,5881694,591.471,540.543,050.93267,5371704,591.471,523.173,068.30264,4681714,591.471,505.703,085.77261,3831724,591.471,488.133,103.34258,2791734,591.471,470.463,121.01255,1581744,591.471,452.693,138.78252,0201754,591.471,434.823,156.65248,8631764,591.471,416.853,174.62245,6881774,591.471,398.783,192.69242,4961784,591.471,380.603,210.87239,2851794,591.471,362.323,229.15236,0561804,591.471,343.933,247.54232,8081814,591.471,325.453,266.02229,5421824,591.471,306.853,284.62226,2571834,591.471,288.153,303.32222,9541844,591.471,269.343,322.13219,6321854,591.471,250.433,341.04216,2911864,591.471,231.413,360.06212,9311874,591.471,212.283,379.19209,5521884,591.471,193.043,398.43206,1531894,591.471,173.693,417.78202,7351904,591.471,154.233,437.24199,2981914,591.471,134.663,456.81195,8411924,591.471,114.983,476.49192,3651934,591.471,095.193,496.28188,8691944,591.471,075.293,516.18185,3521954,591.471,055.273,536.20181,8161964,591.471,035.133,556.34178,2601974,591.471,014.893,576.58174,6831984,591.47994.523,596.95171,0861994,591.47974.053,617.42167,4692004,591.47953.453,638.02163,831月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金2014,591.47932.743,658.73160,1722024,591.47911.913,679.56156,4932034,591.47890.963,700.51152,7922044,591.47869.893,721.58149,0712054,591.47848.703,742.77145,3282064,591.47827.393,764.08141,5642074,591.47805.963,785.51137,7782084,591.47784.413,807.06133,9712094,591.47762.743,828.73130,1422104,591.47740.943,850.53126,2922114,591.47719.023,872.45122,4192124,591.47696.973,894.50118,5252134,591.47674.803,916.67114,6082144,591.47652.503,938.97110,6692154,591.47630.073,961.40106,7082164,591.47607.523,983.95102,7242174,591.47584.844,006.6398,7172184,591.47562.034,029.4494,6882194,591.47539.094,052.3890,6362204,591.47516.024,075.4586,5602214,591.47492.814,098.6682,4612224,591.47469.484,121.9978,3392234,591.47446.014,145.4674,1942244,591.47422.414,169.0670,0252254,591.47398.674,192.8065,8322264,591.47374.804,216.6761,6152274,591.47350.804,240.6757,3752284,591.47326.654,264.8253,1102294,591.47302.374,289.1048,8212304,591.47277.954,313.5244,5072314,591.47253.394,338.0840,1692324,591.47228.704,362.7735,8062334,591.47203.864,387.6131,4192344,591.47178.884,412.5927,0062354,591.47153.754,437.7222,5692364,591.47128.494,462.9818,1062374,591.47103.084,488.3913,6172384,591.4777.534,513.949,1032394,591.4751.834,539.644,5642404,589.5825.984,563.60-241----242----243----244----245----246----247----248----249----250----月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金251----252----253----254----255----256----257----258----259----260----261----262----263----264----265----266----267----268----269----270----271----272----273----274----275----276----277----278----279----280----281----282----283----284----285----286----287----288----289----290----291----292----293----294----295----296----297----298----299----300----月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金301----302----303----304----305----306----307----308----309----310----311----312----313----314----315----316----317----318----319----320----321----322----323----324----325----326----327----328----329----330----331----332----333----334----335----336----337----338----339----340----341----342----343----344----345----346----347----348----349----350----月供4,591.47Modulus130.68表格的其它部分是保护的,要更改的话,取消保护还款总额1,101,951利息总额501,951期间月供利息归还本金剩余本金351----352----353----354----355----356----357----358----359----360----Total1,101,951501,951是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码是保护的,要更改的话,取消保护即可,无保护密码。

公积金贷款计算法

公积金贷款计算法

6,353.46
586.56
6,945.30
584.14
7,539.55
581.71
8,136.23
579.28
8,735.34
576.83
9,336.71.91
10,547.40
569.43
11,156.36
566.94
11,767.81
564.45
12,381.75
793.64 796.88 800.13 803.40 806.68 809.98 813.28 816.60 819.94 823.29 826.65 830.02 833.41 836.82 840.23 843.66 847.11 850.57 854.04 857.53 861.03 864.55 868.08 871.62 875.18 878.75 882.34 885.94
546.68 544.10 541.51 538.91 536.30 533.68 531.05 528.40 525.75 523.09 520.41 517.72 515.02 512.32 509.60 506.87 504.12 501.37 498.61 495.83 493.04 490.24 487.43 484.61 481.78 478.94 476.08 473.21
26 2012年06月
27 2012年07月
本金表 565.89 568.20 570.52 572.85 575.19 577.54 579.90 582.27 584.64 587.03 589.43 591.83 594.25 596.68 599.11 601.56 604.02 606.48 608.96 611.45 613.94 616.45 618.97 621.49 624.03 626.58 629.14

最新等额本息利率表(含公积金上浮10%)

最新等额本息利率表(含公积金上浮10%)
1-10-14
吴涛
商业贷款还款情况(万元)利率7 商业贷款还款情况(万元)利率7.5折 年 限 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 年利率 ) (%) 4.545 4.575 4.575 4.838 4.838 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 4.950 月利率 (‰) ) 3.8125 3.8125 4.0313 4.0313 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 4.1250 月还款额 (元) 436.81 297.80 229.56 187.97 160.82 141.10 126.36 114.93 105.82 98.40 92.24 87.05 82.63 78.82 75.50 72.60 70.03 67.75 65.72 63.89 62.25 60.76 59.40 58.17 57.04 56.01 55.06 54.18 53.38 总还款额 (元) 10454.50 10483.51 10720.96 11018.76 11278.13 11578.86 11852.76 12130.68 12412.62 12698.55 12988.46 13282.33 13580.13 13881.85 14187.45 14496.90 14810.19 15127.28 15448.13 15772.72 16101.01 16432.96 16768.54 17107.71 17450.42 17796.64 18146.32 18499.43 18855.91 19215.72 年限 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30

个人住房公积金贷款每万元(等额本息)还款金额表

个人住房公积金贷款每万元(等额本息)还款金额表

个人住房公积金贷款每万元(等额本息)还款金额表个人住房公积金贷款每万元(等额本息)还款金额表年限年利率(%) 月利率(%) 月还款额(元) 本息总额(元) 6个月 4.5 到期一次还本付息10225.00001 4.5 10450.00002 4.5 3.7500 436.4781 10475.47483 4.5 3.7500 297.4692 10708.89284 4.5 3.7500228.0349 10945.67335 4.5 3.7500186.4302 11185.81156 4.95 4.1250 160.8175 11578.86007 4.95 4.1250 141.1043 11852.75858 4.95 4.1250 126.3613 12130.68399 4.95 4.1250 114.9317 12412.621410 4.95 4.1250 105.8213 12698.554411 4.95 4.1250 98.3975 12988.464712 4.95 4.1250 92.2384 13282.331913 4.95 4.1250 87.0521 13580.134114 4.95 4.1250 82.6300 13881.847415 4.95 4.1250 78.8191 14187.446516 4.95 4.1250 75.5047 14496.904217 4.95 4.1250 72.5990 14810.191718 4.95 4.1250 70.0337 15127.278719 4.95 4.1250 67.7550 15448.133320 4.95 4.1250 65.7197 15772.722321 4.95 4.1250 63.8929 16101.010822 4.95 4.1250 62.2461 16432.962723 4.95 4.1250 60.7556 16768.540624 4.95 4.1250 59.4018 17107.705825 4.95 4.1250 58.1681 17450.418526 4.95 4.1250 57.0405 17796.637427 4.95 4.1250 56.0072 18146.320728 4.95 4.1250 55.0578 18499.425029 4.95 4.1250 54.1836 18855.906430 4.95 4.1250 53.3770 19215.7199 商业性个人住房贷款月还款额测算表(按一万元计)年份年利率(%) 月利率(‰)月还款额总还款额(元) 6个月 4.97 到期一次还本付息10,248.631 5.58 10,558.452 5.74 4.78 442.02 10,608.583 5.74 4.78 303.03 10,909.134 5.89 4.91 234.35 11,248.735 5.89 4.91 192.82 11,569.166 6.12 5.10 166.30 11,973.317 6.12 5.10 146.66 12,319.578 6.12 5.10 132.00 12,671.949 6.12 5.10 120.65 13,030.3910 6.12 5.10 111.62 13,394.8911 6.12 5.10 104.28 13,765.3812 6.12 5.10 98.21 14,141.8313 6.12 5.10 93.10 14,524.1814 6.12 5.10 88.76 14,912.3815 6.12 5.10 85.04 15,306.3716 6.12 5.10 81.80 15,706.0817 6.12 5.10 78.98 16,111.4718 6.12 5.10 76.49 16,522.4519 6.12 5.10 74.29 16,938.9520 6.12 5.10 72.34 17,360.9121 6.12 5.10 70.59 17,788.2422 6.12 5.10 69.02 18,220.8723 6.12 5.10 67.60 18,658.7124 6.12 5.10 66.33 19,101.6825 6.12 5.10 65.17 19,549.7026 6.12 5.10 64.11 20,002.6727 6.12 5.10 63.15 20,460.5228 6.12 5.10 62.27 20,923.1429 6.12 5.10 61.47 21,390.4430 6.12 5.10 60.73 21,862.34 门市商业贷款月还款测算表(按一万元计)公积金额度:月缴额/(单位缴存比例%+个人缴存比例%)×贷款年限×12×(系数+个人缴存比例%)注意:(1)评估值与成交值低值的70%。

20117房贷利率调整表及相关政策

20117房贷利率调整表及相关政策

2011年7月最新房贷利率调整表一、公积金贷款利率调整表二、商业银行贷款利率调整表三、商业银行贷款优惠利率调整表四、个人住房人民币贷款基准利率--历年调整表近十年的个人贷款五年以上基准利率走势图2011最新银行存款贷款利率表百万房贷增央行今年第三度加息0.25% 自去年10月以来5次加息使存款基准利率由2.25%升至3.5%。

房贷政策一、首套房贷政策首套房贷:指借款人第一次利用贷款所购买用于自住的房屋。

房贷政策:首套房贷最低可享受7折基准利率优惠,最低首付20%。

现行情况:2011年,各大银行陆续取消了首套房贷的利率优惠,目前仅有个别银行对优质客户有少量利率优惠,大部分银行对首套房贷执行基准利率,一些银行甚至上调了首套房贷利率。

大部分银行对首套房贷要求首付30%。

二、二套房贷政策二套房贷:指已利用银行贷款购买住房的家庭,再次向商业银行申请贷款时,均应按第二套房贷政策执行。

二套房贷认定标准:商业性个人住房贷款中居民家庭住房套数,依据拟购房家庭(包括借款人、配偶及未成年子女)成员名下实际拥有成套住房数量认定。

三部委(中华人民共和国住房和城乡建设部、中国人民银行、银监会)个人房贷二套房认定标准原文:有下列情形之一的,贷款人应对借款人执行第二套(及以上)差别化住房信贷政策:(一)借款人首次申请利用贷款购买住房,如在拟购房所在地房屋登记信息系统(含预售合同登记备案系统,下同)中其家庭已登记有一套(及以上)成套住房的;(二)借款人已利用贷款购买过一套(及以上)住房,又申请贷款购买住房的;(三)贷款人通过查询征信记录、面测、面谈(必要时居访)等形式的尽责调查,确信借款人家庭已有一套(及以上)住房的。

四、对能提供1年以上当地纳税证明或社会保险缴纳证明的非本地居民申请住房贷款的,贷款人按本通知第三条执行差别化住房信贷政策。

对不能提供1年以上当地纳税证明或社会保险缴纳证明的非本地居民申请住房贷款的,贷款人按第二套(及以上)的差别化住房信贷政策执行。

  1. 1、下载文档前请自行甄别文档内容的完整性,平台不提供额外的编辑、内容补充、找答案等附加服务。
  2. 2、"仅部分预览"的文档,不可在线预览部分如存在完整性等问题,可反馈申请退款(可完整预览的文档不适用该条件!)。
  3. 3、如文档侵犯您的权益,请联系客服反馈,我们会尽快为您处理(人工客服工作时间:9:00-18:30)。
相关文档
最新文档