点击看李开复的成功经验分享
-----------------公积金贷款利率表---------------
个人住房公积金贷款调整对照表
自2007年12月21日起执行 单位:年利率%
按央行有关政策,调息前已办理的房贷,次年 1 月 1 日起开始执行新利率,调息后新办理的房贷,直接按新利率执行 |
公积金贷款等额本息还款对照表
(公积金贷款现行利率为中国人民银行2007年12月21日公布)
-calculated by Neosun using Excel,only for reference.
贷款 年限 | 年利率% | 月利率‰ | 贷1万元 月还款额 |
1 | 4.77 | 3.975 | |
2 | 4.77 | 3.975 | 437.68 |
3 | 4.77 | 3.975 | 298.68 |
4 | 4.77 | 3.975 | 229.25 |
5 | 4.77 | 3.975 | 187.66 |
6 | 5.22 | 4.35 | 162.07 |
7 | 5.22 | 4.35 | 142.38 |
8 | 5.22 | 4.35 | 127.65 |
9 | 5.22 | 4.35 | 116.24 |
10 | 5.22 | 4.35 | 107.14 |
11 | 5.22 | 4.35 | 99.74 |
12 | 5.22 | 4.35 | 93.60 |
13 | 5.22 | 4.35 | 88.43 |
14 | 5.22 | 4.35 | 84.02 |
15 | 5.22 | 4.35 | 80.23 |
16 | 5.22 | 4.35 | 76.93 |
17 | 5.22 | 4.35 | 74.04 |
18 | 5.22 | 4.35 | 71.50 |
19 | 5.22 | 4.35 | 69.24 |
20 | 5.22 | 4.35 | 67.22 |
21 | 5.22 | 4.35 | 65.41 |
22 | 5.22 | 4.35 | 63.78 |
23 | 5.22 | 4.35 | 62.30 |
24 | 5.22 | 4.35 | 60.97 |
25 | 5.22 | 4.35 | 59.75 |
26 | 5.22 | 4.35 | 58.64 |
27 | 5.22 | 4.35 | 57.62 |
28 | 5.22 | 4.35 | 56.68 |
29 | 5.22 | 4.35 | 55.83 |
30 | 5.22 | 4.35 | 55.03 |
年限 | 年利率(%) | 月利率(‰) | 月还款额(元) | 总还款额(元) |
6月 | 4.770 | 到期一次还本付息 | 10238.500 | |
1 | 4.770 | 10477.000 | ||
2 | 4.770 | 3.975 | 437.685 | 10504.430 |
3 | 4.770 | 3.975 | 298.677 | 10752.387 |
4 | 4.770 | 3.975 | 229.253 | 11004.121 |
5 | 4.770 | 3.975 | 187.660 | 11259.625 |
6 | 5.220 | 4.350 | 162.072 | 11669.170 |
7 | 5.220 | 4.350 | 142.375 | 11959.512 |
8 | 5.220 | 4.350 | 127.649 | 12254.326 |
9 | 5.220 | 4.350 | 116.237 | 12553.593 |
10 | 5.220 | 4.350 | 107.144 | 12857.294 |
11 | 5.220 | 4.350 | 99.738 | 13165.405 |
12 | 5.220 | 4.350 | 93.597 | 13477.901 |
13 | 5.220 | 4.350 | 88.428 | 13794.756 |
14 | 5.220 | 4.350 | 84.023 | 14115.940 |
15 | 5.220 | 4.350 | 80.230 | 14441.421 |
16 | 5.220 | 4.350 | 76.933 | 14771.168 |
17 | 5.220 | 4.350 | 74.045 | 15105.143 |
18 | 5.220 | 4.350 | 71.497 | 15443.311 |
19 | 5.220 | 4.350 | 69.235 | 15785.631 |
20 | 5.220 | 4.350 | 67.217 | 16132.064 |
21 | 5.220 | 4.350 | 65.407 | 16482.567 |
22 | 5.220 | 4.350 | 63.777 | 16837.096 |
23 | 5.220 | 4.350 | 62.303 | 17195.605 |
24 | 5.220 | 4.350 | 60.965 | 17558.047 |
25 | 5.220 | 4.350 | 59.748 | 17924.374 |
26 | 5.220 | 4.350 | 58.636 | 18294.535 |
27 | 5.220 | 4.350 | 57.619 | 18668.481 |
28 | 5.220 | 4.350 | 56.685 | 19046.158 |
29 | 5.220 | 4.350 | 55.826 | 19427.513 |
30 | 5.220 | 4.350 | 55.035 | 19812.493 |
------------------------------ --商业贷款利率表-- --------------------------------
人民币贷款利率表 |
请选择时间2007-12-212007-09-152007-08-222007-07-212007-05-192007-03-182006-08-192006-04-282004-10-292002-02-211999-06-101998-12-071998-07-011998-03-251997-10-231996-08-231996-05-01 以查看对应利率 |
日期:2007-12-21
|
种类 项目 | ||
年利率% | ||
一、短期贷款
| ||
六个月(含) | 6.57 | |
六个月至一年(含) | 7.47 | |
二、中长期贷款 | ||
一至三年(含) | 7.56 | |
三至五年(含) | 7.74 | |
五年以上 | 7.83 | |
三、贴 现 | 在再贴现利率基础上,按不超过同期贷款利率(含浮动)加点 |
人民币存款利率表
以查看对应利率 |
日期:2007-12-21
|
项目 | ||
年利率% | ||
一、城乡居民及单位存款 | ||
(一)活期
| 0.72 | |
(二)定期 | ||
1.整存整取
| ||
三个月 | 3.33 | |
半年 | 3.78 | |
一年 | 4.14 | |
二年 | 4.68 | |
三年 | 5.40 | |
五年 | 5.85 | |
2.零存整取、整存零取、存本取息
| ||
一年 | 3.33 | |
三年 | 3.78 | |
五年 | 4.14 | |
3.定活两便
| 按一年以内定期整存整取同档次利率打6折 | |
二、协定存款 | 1.53 | |
三、通知存款
| . | |
一天
| 1.17 | |
七天
| 1.71 |
注:人民银行历次存款利息调整对照表
|
-------------------------------------------商业贷款等额本息还款对照表(1版)-------------------------------------------
(商业贷款现行利率为中国人民银行2007年12月21日公布)
-calculated by Neosun using Excel,only for reference.
贷款期限 | 利率 | 期间因子 | 求和因子 | P月供 | 总计 | S利息 |
1 | 7.56% | 12 | 867.8512033 | 10414.21444 | 414.2144393 | |
2 | 7.56% | 24 | 450.2688034 | 10806.45128 | 806.4512814 | |
3 | 7.56% | 36 | 311.3378169 | 11208.16141 | 1208.161408 | |
4 | 7.74% | 48 | 242.9106177 | 11659.70965 | 1659.709647 | |
5 | 7.74% | 60 | 201.5219117 | 12091.3147 | 2091.314703 | |
6 | 7.83% | 72 | 174.5035048 | 12564.25234 | 2564.252343 | |
7 | 7.83% | 84 | 155.0165307 | 13021.38858 | 3021.388578 | |
8 | 7.83% | 96 | 140.5042728 | 13488.41019 | 3488.410185 | |
9 | 7.83% | 108 | 129.3076654 | 13965.22786 | 3965.227859 | |
10 | 7.83% | 120 | 120.4311796 | 14451.74155 | 4451.741547 | |
11 | 7.83% | 132 | 113.2412186 | 14947.84086 | 4947.840859 | |
12 | 7.83% | 144 | 107.3153161 | 15453.40552 | 5453.405519 | |
13 | 7.83% | 156 | 102.3609349 | 15968.30585 | 5968.305848 | |
14 | 7.83% | 168 | 98.16906714 | 16492.40328 | 6492.40328 | |
15 | 7.83% | 180 | 94.58639387 | 17025.5509 | 7025.550896 | |
16 | 7.83% | 192 | 91.49788536 | 17567.59399 | 7567.59399 | |
17 | 7.83% | 204 | 88.81554238 | 18118.37065 | 8118.370645 | |
18 | 7.83% | 216 | 86.47089041 | 18677.71233 | 8677.712328 | |
19 | 7.83% | 228 | 84.40984425 | 19245.44449 | 9245.444489 | |
20 | 7.83% | 240 | 82.58911322 | 19821.38717 | 9821.387173 | |
21 | 7.83% | 252 | 80.97363344 | 20405.35563 | 10405.35563 | |
22 | 7.83% | 264 | 79.53470043 | 20997.16091 | 10997.16091 | |
23 | 7.83% | 276 | 78.24858879 | 21596.61051 | 11596.61051 | |
24 | 7.83% | 288 | 77.095517 | 22203.5089 | 12203.5089 | |
25 | 7.83% | 300 | 76.05886056 | 22817.65817 | 12817.65817 | |
26 | 7.83% | 312 | 75.12454669 | 23438.85857 | 13438.85857 | |
27 | 7.83% | 324 | 74.28058353 | 24066.90906 | 14066.90906 | |
28 | 7.83% | 336 | 73.5166901 | 24701.60787 | 14701.60787 | |
29 | 7.83% | 348 | 72.82400281 | 25342.75298 | 15342.75298 | |
30 | 7.83% | 360 | 72.19484058 | 25990.14261 | 15990.14261 |
--提供excel 计算模板,需要者请留言。