Ⅰ 杞﹁締璐缃鍒╂伅骞村埄鐜囨庝箞璁＄畻锛
涓銆佽溅杈嗚喘缃鍒╂伅骞村埄鐜囨庝箞璁＄畻锛
涔拌溅鏃剁殑鍒╂伅璁＄畻鍏寮忎负锛氳捶娆惧埄鎭=鏈閲懨楀埄鐜嚸楁湡闄愩備互鐜板湪甯歌佺殑骞村埄鐜5.15%鏉ヨ达紝杞﹀瓙浠锋牸鍗佷竾銆佽捶娆句笁骞达紝鍒╂伅鍒欎负15450鍏冦傝捶娆惧埄鐜囨牴鎹璐锋剧殑鏃堕棿闀跨煭鍙樺寲鑰屼笉鍚岋紝涓鑸鏉ヨ达紝杞﹁捶鏈闀挎椂闄愪负5骞淬
璐锋炬椂闂村湪1骞翠箣鍐呯殑锛堝惈1骞达級锛岃捶娆惧勾鍒╃巼涓4.35%锛涜捶娆炬椂闂村湪1骞村埌5骞翠箣闂寸殑锛屽埄鐜囧湪4.75%
浜屻佽溅璐峰埄鎭鏄鎬庝箞绠楃殑锛
璁＄畻鏈夎銆傜洰鍓5骞翠互涓婃苯杞︽秷璐硅捶娆惧勾鍒╃巼涓6.55%锛屽傛灉璐锋10涓囧厓銆佹湡闄5骞达紝鍒欐瘡鏈堜緵娆1958娆117537.46鍏冿紙鍏朵腑鏀浠樺埄鎭17537.46鍏冿級銆傝＄畻鏂规硶姣旇緝澶嶆潅锛屼笉璧樿堪銆傝︾粏鏁版嵁瑙佷笅琛ㄣ
鏈熸″伩杩樺埄鏈熸湀渚涘墿浣欐湰閲
1鏈5413.12鍏1958.96鍏98586.88鍏
2鏈538.12鍏142.96鍏97166.0
3鏈530.36鍏1428.59鍏1958.96鍏95737.44鍏
4鏈522.57鍏1436.39鍏1958.96鍏9
5鏈514.73鍏1444.23鍏1958.96鍏9285
6鏈506.84鍏1452.11鍏14.71鍏
7鏈498.92鍏146.96鍏89944.67鍏
8鏈490.95鍏1468.01鍏1958.96鍏88476.66鍏
9鏈482.94鍏1476.02鍏1958.964鍏
10鏈484.08鍏1958.96鍏85516.56鍏
11鏈466.78鍏1492.18鍏1958.96鍏84024.38鍏
12鏈4500.32鍏1958.96鍏82524.05鍏
13鏈450.44鍏1508.51鍏1958.96鍏81015.54鍏
14鏈442.21鍏1516.7579498.79鍏
15鏈433.93鍏1525.03鍏1958.96鍏77973.76鍏
11鍏1533.36鍏76440.41鍏
17鏈417.24鍏1541.72鍏1958.96鍏74898.69鍏
18鏈408.82鍏1550.14鍏1958.96鍏73348.56鍏
19鏈400.36鍏1558.60鍏1958.96鍏71789.96鍏
20鏈391.85鍏1567.10鍏1958.96鍏70222.86鍏
21鏈383.30鍏1575.66鍏1958.96鍏68647.20鍏
22鏈374.70鍏1584.26鍏1958.96鍏67062.94鍏
23鏈366.05鍏1592.91鍏1958.96鍏65470.03鍏
24鏈357.36鍏1601.60鍏1958.96鍏63868.43鍏
25鏈348.62鍏1610.34鍏1958.96鍏62258.09鍏
26鏈339.83鍏1619.13鍏1958.96鍏60638.96鍏
27鏈330.99鍏1627.97鍏1958.96鍏59010.99鍏
28鏈322.10鍏1636.86鍏1958.96鍏57374.13鍏
29鏈313.17鍏1645.79鍏1958.96鍏55728.34鍏
30鏈304.18鍏1654.77鍏1958.96鍏54073.57鍏
31鏈295.15鍏1663.81鍏1958.96鍏52409.76鍏
32鏈286.07鍏1672.89鍏1958.96鍏50736.88鍏
33鏈276.94鍏1682.02鍏1958.96鍏49054.86鍏
34鏈267.76鍏1691.20鍏1958.96鍏47363.66鍏
35鏈258.53鍏1700.43鍏1958.96鍏45663.23鍏
36鏈249.25鍏1709.71鍏1958.96鍏43953.51鍏
37鏈239.91鍏1719.04鍏1958.96鍏42234.47鍏
38鏈230.53鍏1728.43鍏1958.96鍏40506.04鍏
39鏈221.10鍏1737.86鍏1958.96鍏38768.18鍏
40鏈211.61鍏1747.35鍏1958.96鍏37020.83鍏
41鏈202.07鍏1756.89鍏1958.96鍏35263.94鍏
42鏈192.48鍏1766.48鍏1958.96鍏33497.47鍏
43鏈182.84鍏1776.12鍏1958.96鍏31721.35鍏
44鏈173.15鍏1785.81鍏1958.96鍏29935.54鍏
45鏈163.40鍏1795.56鍏1958.96鍏28139.98鍏
46鏈153.60鍏1805.36鍏1958.96鍏26334.62鍏
47鏈143.74鍏1815.21鍏1958.96鍏24519.41鍏
48鏈133.84鍏1825.12鍏1958.96鍏22694.28鍏
49鏈123.87鍏1835.08鍏1958.96鍏20859.20鍏
50鏈113.86鍏1845.10鍏1958.96鍏19014.10鍏
51鏈103.79鍏1855.17鍏1958.96鍏17158.92鍏
52鏈93.66鍏1865.30鍏1958.96鍏15293.63鍏
53鏈83.48鍏1875.48鍏1958.96鍏13418.15鍏
54鏈73.24鍏1885.72鍏1958.96鍏11532.43鍏
55鏈62.95鍏1896.01鍏1958.96鍏9636.42鍏
56鏈52.60鍏1906.36鍏1958.96鍏7730.06鍏
57鏈42.19鍏1916.76鍏1958.96鍏5813.30鍏
58鏈31.73鍏1927.23鍏1958.96鍏3886.07鍏
59鏈21.21鍏1937.75鍏1958.96鍏1948.32鍏
60鏈10.63鍏1948.32鍏1958.96鍏0.00鍏
浣犵殑杩欎釜鍋胯繕鍒╂伅鏄鎬庝箞绠楃殑锛
鏈鏈堝伩杩樺埄鎭锛濇湀鍒濇湰閲戜綑棰澝楁湀鍒╃巼銆傚勾鍒╃巼6.55%鍖栦负鏈堝埄鐜囦负5.4583鈥帮紙鍗6.55%梅12锛夈傜涓涓鏈堣繕鐨勫埄鎭涓猴細100000脳5.4583鈥帮紳545.83鍏冦佽繕鐨勬湰閲戞槸锛1958.96-545.83锛1413.12鍏冿紱绗浜屼釜鏈堣繕鐨勫埄鎭涓猴細98586.88脳5.4583鈥帮紳538.12鍏冦佽繕鐨勬湰閲戞槸锛1958.96-538.12锛1420.84鍏冦備互姝ょ被鎺ㄣ
涓夈佽喘杞﹀埄鎭鎬庝箞绠
鎴戞潵甯浣犵畻璐锋45000鍒嗘湡涓ゅ勾锛24涓鏈堬級锛屾湀杩樻湰閲戞槸1875鍏冦傝捶娆惧埄鎭鏄鍓╀綑璐锋句箻浠ュ埄鐜囷紝鐢变簬浣犳瘡鏈堥兘鍦ㄨ繕鏈閲戞墍浠ヤ綘璐锋惧埄鎭閫愭湀閫掑噺銆傝捶娆鹃濓紙璐锋炬婚-宸茶繕璐锋撅級鍒╃巼鏈堣繕鏈閲=姣忔湀杩樻炬婚濅綘绗涓涓鏈堢殑杩樻鹃濇槸鏈楂樼殑=鏈閲戯紙1875锛夎捶娆鹃濓紙45000锛屽洜涓轰綘杩樻病鏈夎繕杩囨撅級鍒╃巼绗浜屼釜鏈堢殑杩樻鹃=鏈閲戯紙1875锛夎捶娆鹃濓紙45000-1875锛屼互涓轰綘宸茬粡杩樿繃涓娆℃炬墍浠ヨ捶娆鹃濈浉搴斿噺灏戯級鍒╃巼绗涓変釜鏈堢殑杩樻鹃=鏈閲戯紙1875锛夎捶娆鹃濓紙45000-18752锛屽洜涓轰綘宸茬粡杩樿繃涓や釜鏈堟撅級鍒╃巼浠ユょ被鎺ㄥ彲鐭ユ瘡鏈堣繕娆鹃濓紙鎴戞病鏈夌畻姣忔湀鐨勭＄悊璐圭瓑绛夊叾浠栬垂鐢锛岄偅涓姣旇緝绠鍗曟ゼ涓昏嚜宸辩浉鍔犲氨鍙浠ヤ簡锛夛紝涓ゅ勾鐨勬诲埄鎭鏄2784.375鍏冦
鍥涖佷拱杞﹁捶娆剧殑鍒╂伅鎬庝箞绠楃殑锛
1銆18涓囩殑杞︿环棣栦粯20%灏辨槸3.6涓囧厓锛岃捶娆惧氨鏄14.4涓囧厓锛
2銆佺涓骞村勾鍒╂伅灏辨槸14.4涓囧厓0.0269骞村埄鐜=3873.6鍏冿紱
3銆佺涓涓鏈堣繕娆惧氨鏄3873.6鍏/12涓鏈=322.8鍏冿紱
6銆佺涓涓鏈堣捶娆炬湰閲14.4涓囧厓/36涓鏈=4000鍏冦
7銆佺涓涓鏈堣捶娆炬湰閲戝埄鎭灏辨槸4000鍏322.8鍏=4322.8鍏冦
娉ㄦ剰4322.8鍏冨簲璇ユ槸绗涓涓鏈堢殑鏈閲戝埄鎭锛岀敱浜庤捶娆炬湰閲戦愭湀鍑忓皯锛岃捶娆剧殑鍒╂伅涔熷搷搴斾細鍑忓皯锛岃蜂笌姹借溅閿鍞鍟嗘矡閫氾紒
Ⅱ 涔拌溅鍒╃巼璁＄畻鍏寮
涓銆佷拱杞﹀埄鐜囪＄畻鍏寮
涔拌溅鏃讹紝鍒╂伅璁＄畻鍏寮忎负:璐锋惧埄鎭=鏈閲懨楀埄鐜嚸楁湡闄愩傜洰鍓嶅父瑙佺殑骞村埄鐜5.15%锛岃溅浠10涓囷紝璐锋句笁骞达紝鍒╂伅15450鍏冦傝捶娆惧埄鐜囨牴鎹璐锋炬湡闄愮殑闀跨煭鑰屼笉鍚屻備竴鑸鏉ヨ达紝杞﹁捶鏈闀挎湡闄愭槸浜斿勾銆傝捶娆炬湡闄愬湪涓骞翠互鍐(鍚涓骞)鐨勶紝璐锋惧勾鍒╃巼涓4.35%锛涜捶娆炬湡闄愬湪涓骞磋嚦浜斿勾涔嬮棿鐨勶紝鍒╃巼涓4.75%銆備絾杩欎釜鍒╃巼鏄鍩哄噯鍒╃巼锛屽疄闄呮搷浣滀腑浼氫笂涓嬫诞鍔10%銆備箣鍚庡啀璇磋捶娆炬柟寮忋傛湁涓ょ:绛夐濇湰鎭鎴栧钩鍧囪祫鏈銆1.绛夐濇湰鎭杩樻炬硶鏄鍦ㄨ捶娆炬湡闄愬唴锛屾瘡鏈堢瓑棰濆伩杩樿捶娆炬湰鎭鐨勪竴绉嶆柟娉曘傛湀杩樻鹃濈殑鍏寮忎负:鏈堣繕娆鹃=璐锋炬湰閲懨楁湀鍒╃巼脳(1鏈堝埄鐜)脳杩樻炬湀鏁/[(1鏈堝埄鐜)杩樻炬湀鏁-1]銆2.骞冲潎璧勬湰鍋胯繕娉曟槸姣忔湀绛夐濆伩杩樿捶娆炬湰閲戠殑鏂规硶銆傝捶娆惧埄鎭闅忔湰閲戦愭湀閫掑噺銆傛湀杩樻鹃濈殑璁＄畻鍏寮忎负:鏈堣繕娆鹃=璐锋炬湰閲/璐锋炬湡闄愭湀鏁(鏈閲-宸茶繕鏈閲戠疮璁￠)脳鏈堝埄鐜囥傛渶鍚庤翠竴涓嬭溅璐锋椂闂:鐜拌屾斂绛栬勫畾锛屼竴鎵嬭喘杞﹁捶娆炬渶闀挎椂闂翠负浜斿勾锛屼簩鎵嬭溅璐锋炬渶闀挎椂闂翠负涓夊勾銆備絾閾惰屼細鑰冭檻鍚勭嶉庨櫓锛屾瘮濡傛苯杞﹀揩閫熻船鍊笺佽繕娆鹃庨櫓绛夛紝澶ч儴鍒嗚捶娆炬湡闄愪細鍦ㄥ師鏈夊熀纭涓婂噺灏戜竴骞淬傚彉鎴愪竴鎵嬭喘杞﹁捶娆4骞磋繕娓咃紝浜屾墜璐杞﹁捶娆2骞磋繕娓呫傜櫨涓囪喘杞﹁ˉ璐
浜屻佸府蹇欒＄畻涓嬭喘杞﹁捶娆剧殑鍒╃巼.
璐锋100涓囧厓锛岀幇浠12涓囧厓锛岀浉褰撲簬瀹為檯璐锋88涓囧厓锛屾瘡鏈堢瓑棰濊繕娆100/36=25/9涓囧厓
鍦╡xcel鐢靛瓙琛ㄦ牸浠绘剰涓鏍煎唴杈撳叆=rate(36,-25/9,88)
鍙寰楀埌鏈堝埄鐜囦负0.7079951%
骞村埄鐜=鏈堝埄鐜嚸12=8.49594%
杞﹁捶鏈堜緵鐨勮＄畻鍏寮:A=P{i(1i)^n/[(1i)^n锛1]}
A:姣忔湀渚涙
P:渚涙炬婚噾棰
i:鏈堝埄鐜(骞村埄/12)
n:渚涙炬绘湀鏁(骞疵12)
杞﹁捶鍒╃巼璁＄畻鍣ㄧ殑鎿嶄綔姝ラゅ備笅锛
绗1姝ワ細鎸夌収鎻愮ず瑕佹眰璇峰傚疄鐨勫～鍐欎俊鎭锛屾湁涓嬫媺妗嗙殑鍔犱互閫夋嫨銆
绗2姝ワ細鎻愪氦鍚庢苯杞﹁捶娆捐繕娆鹃噾棰濆強鍒╂伅灏嗕細娓呮氱殑璁＄畻鍑烘潵銆
鍏朵腑锛岄渶瑕佸～鍐欑殑淇℃伅鍖呮嫭锛氬湴鍖恒佽捶娆炬満鏋勭被鍒銆佽捶娆炬満鏋勩佽捶娆炬瘮渚嬨佽捶娆炬湡闄愩佽捶娆鹃噾棰濄佽捶娆惧勾鍒╃巼銆佽繕娆炬柟寮忋佸伩杩橀戠巼锛屾槸鍚︽樉绀鸿繕娆炬槑缁嗐傚綋鎮ㄥ～鍐欏ソ浠ヤ笂淇℃伅鍚庯紝鐐瑰嚮璁＄畻鎸夐挳锛屽氨浼氬緱鍒版偍鎯宠佽＄畻鐨勭粨鏋溿
涓夈佸府蹇欒＄畻涓嬭喘杞﹁捶娆剧殑鍒╃巼.
璐锋100涓囧厓锛岀幇浠12涓囧厓锛岀浉褰撲簬瀹為檯璐锋88涓囧厓锛屾瘡鏈堢瓑棰濊繕娆惧厓鍦╡xcel鐢靛瓙琛ㄦ牸浠-25/9,88)
鍙寰楀埌鏈堝埄鐜囦负0.7079
骞村埄鐜=鏈堝埄鐜嚸12=8.49594%
鍙鏄鎴戦氳繃璐锋捐℃暟鍣ㄥ緱鍒扮殑缁撴灉鏄:绛夐濇湰鎭,鍏变粯鍒╂伅:18020瀹為檯骞村埄鐜囷細13锛17锛呭疄闄呮湀鍒╃巼锛1锛097锛
鍥涖侀栦粯20%璐杞︽庝箞绠楀埄鎭锛
銆佽繖涓杞﹁捶鍒╃巼鐨勫氬皯锛屾槸娌℃湁涓涓纭鎬ц勫畾鐨勶紝閫氬父鎯呭喌涓嬶紝鍚勯摱琛岀殑杞﹁捶鍒╃巼鏄鎸夌収鍩哄噯鍒╃巼涓哄熀纭锛屽仛鍑轰竴瀹氱殑涓婃诞鎴栦笅娴璋冩暣锛
2銆佽屽叾浠栬捶娆炬満鏋勭殑杞﹁捶鍒╃巼锛屼篃鏄鍙傝冨熀鍑嗗埄鐜囪屽仛鍑轰竴瀹氬箙搴︾殑璋冩暣鐨勶紝閫氬父璋冩暣骞呭害涓10%鍒20%锛
3銆佸悓鏃堕摱琛岃捶娆惧埄鎭鍜岄摱琛屾斂绛栵紝浠ュ強鎮ㄤ釜浜虹殑璧勮川鏈夊叧鐨勶紝涔熷氨鏄鎮ㄧ殑鎵撳崱宸ヨ祫锛岀ぞ淇濇垨鍏绉閲戯紝鏈鍗曚綅宸ヤ綔骞撮檺锛屽緛淇¤礋鍊虹瓑锛屼竴鑸璧勮川瓒婂ソ銆傞摱琛岃捶娆剧殑鍒╂伅灏辫秺浣庛