个人贷款还款计算器.xls

1、贷贷款款利利率率表表（20082008年年1010月月3030日日执执行行）期期限限浮浮动动值值 六六个个月月以以内内(含含)六六个个月月至至一一年年(含含)一一年年至至三三年年(含含)三三年年至至五五年年(含含)年年利利率率月月利利率率年年利利率率月月利利率率年年利利率率月月利利率率年年利利率率月月利利率率下降10%5.4274.52255.9944.9956.0755.06256.3185.265下降5%5.72854.773756.3275.27256.41255.343756.6695.5575基基准准利利率率6.036.035.0255.0256.666.665.555.556.75

2、6.755.6255.6257.027.025.855.85上浮5%6.33155.276256.9935.82757.08755.906257.3716.1425上浮10%6.6335.52757.3266.1057.4256.18757.7226.435上浮15%6.93455.778757.6596.38257.76256.468758.0736.7275上浮20%7.2366.037.9926.668.16.758.4247.02上浮25%7.53756.281258.3256.93758.43757.031258.7757.3125上浮30%7.8396.53258.6587.215

3、8.7757.31259.1267.605存存款款利利率率（20082008年年1010月月3030日日执执行行）年利率月利率年利率月利率活期0.72-协定存款1.53通知存款定期三个月半年一年二年三年2.883.243.64.144.77零存整取/整存零取/存本取息2.883.24住住房房公公积积贷贷款款 (2008年1027日执行)五年以下五年以上年利率月利率年利率月利率4.054.053.3753.3754.594.593.8253.825五五年年以以上上年年利利率率月月利利率率6.485.46.845.77.27.26 67.566.37.926.68.286.98.647.297.5

4、9.367.8一天七天1.171.71五年5.133.6制作：丁 政单位：交行官渡支行个个人人贷贷款款计计算算器器请请输输入入数数值值两两种种还还款款方方式式的的差差别别贷款总额￥150,000.00年利率1.1000%等额本息总利息￥8,469.89贷款期限(年)10必须是介于1到30(年)之间的整数。等额本金总利息￥8,318.75起贷日期2012/5/15差额￥151.14等等额额本本息息还还款款法法等等额额本本金金还还款款法法月还款￥1,320.58月还本￥1,250.00还款次数120月递减额￥1.15利息总计￥8,469.89利息总计￥8,318.75本息总计￥158,469.89

5、本息总计￥158,318.75编编号号还还款款日日期期期期初初余余额额还还款款额额本本金金利利息息期期末末余余额额期期初初余余额额还还款款额额本本金金利利息息期期末末余余额额12012/6/15150,000.001,320.581,183.08137.50148,816.92150,000.001,387.501,250.00137.50148,750.0022012/7/15148,816.921,320.581,184.17136.42147,632.75148,750.001,386.351,250.00136.35147,500.0032012/8/15147,632.751,320

6、.581,185.25135.33146,447.50147,500.001,385.211,250.00135.21146,250.0042012/9/15146,447.501,320.581,186.34134.24145,261.16146,250.001,384.061,250.00134.06145,000.0052012/10/15145,261.161,320.581,187.43133.16144,073.73145,000.001,382.921,250.00132.92143,750.0062012/11/15144,073.731,320.581,188.51132.0

7、7142,885.22143,750.001,381.771,250.00131.77142,500.0072012/12/15142,885.221,320.581,189.60130.98141,695.61142,500.001,380.631,250.00130.63141,250.0082013/1/15141,695.611,320.581,190.69129.89140,504.92141,250.001,379.481,250.00129.48140,000.0092013/2/15140,504.921,320.581,191.79128.80139,313.13140,00

8、0.001,378.331,250.00128.33138,750.00102013/3/15139,313.131,320.581,192.88127.70138,120.25138,750.001,377.191,250.00127.19137,500.00112013/4/15138,120.251,320.581,193.97126.61136,926.28137,500.001,376.041,250.00126.04136,250.00122013/5/15136,926.281,320.581,195.07125.52135,731.22136,250.001,374.901,2

9、50.00124.90135,000.00132013/6/15135,731.221,320.581,196.16124.42134,535.05135,000.001,373.751,250.00123.75133,750.00142013/7/15134,535.051,320.581,197.26123.32133,337.79133,750.001,372.601,250.00122.60132,500.00152013/8/15133,337.791,320.581,198.36122.23132,139.44132,500.001,371.461,250.00121.46131,

10、250.00162013/9/15132,139.441,320.581,199.45121.13130,939.98131,250.001,370.311,250.00120.31130,000.00172013/10/15130,939.981,320.581,200.55120.03129,739.43130,000.001,369.171,250.00119.17128,750.00182013/11/15129,739.431,320.581,201.65118.93128,537.78128,750.001,368.021,250.00118.02127,500.00192013/

11、12/15128,537.781,320.581,202.76117.83127,335.02127,500.001,366.881,250.00116.88126,250.00202014/1/15127,335.021,320.581,203.86116.72126,131.16126,250.001,365.731,250.00115.73125,000.00212014/2/15126,131.161,320.581,204.96115.62124,926.20125,000.001,364.581,250.00114.58123,750.00222014/3/15124,926.20

12、1,320.581,206.07114.52123,720.13123,750.001,363.441,250.00113.44122,500.00232014/4/15123,720.131,320.581,207.17113.41122,512.96122,500.001,362.291,250.00112.29121,250.00242014/5/15122,512.961,320.581,208.28112.30121,304.68121,250.001,361.151,250.00111.15120,000.00252014/6/15121,304.681,320.581,209.3

13、9111.20120,095.29120,000.001,360.001,250.00110.00118,750.00262014/7/15120,095.291,320.581,210.50110.09118,884.80118,750.001,358.851,250.00108.85117,500.00272014/8/15118,884.801,320.581,211.60108.98117,673.19117,500.001,357.711,250.00107.71116,250.00282014/9/15117,673.191,320.581,212.72107.87116,460.

14、48116,250.001,356.561,250.00106.56115,000.00292014/10/15116,460.481,320.581,213.83106.76115,246.65115,000.001,355.421,250.00105.42113,750.00302014/11/15115,246.651,320.581,214.94105.64114,031.71113,750.001,354.271,250.00104.27112,500.00312014/12/15114,031.711,320.581,216.05104.53112,815.66112,500.00

15、1,353.131,250.00103.13111,250.00322015/1/15112,815.661,320.581,217.17103.41111,598.49111,250.001,351.981,250.00101.98110,000.00332015/2/15111,598.491,320.581,218.28102.30110,380.21110,000.001,350.831,250.00100.83108,750.00342015/3/15110,380.211,320.581,219.40101.18109,160.81108,750.001,349.691,250.0

16、099.69107,500.00352015/4/15109,160.811,320.581,220.52100.06107,940.29107,500.001,348.541,250.0098.54106,250.00362015/5/15107,940.291,320.581,221.6498.95106,718.65106,250.001,347.401,250.0097.40105,000.00372015/6/15106,718.651,320.581,222.7697.83105,495.89105,000.001,346.251,250.0096.25103,750.00382015/7/15105,495.891,320.581,223.8896.70104,272.02103,750.001,345.101,250.0095.10102,500.00392015/8/15104,272.021,320.581,225.0095.58103,047.02102,500.001,343.961,250.0093.96101,250.00402015/9/15103,047