投融资成本与收益分析070915(2)
发布时间:2021-06-06
发布时间:2021-06-06
工程量快速计算方法
鑸槸ci Date: input:DMY Fix:灏忔暟鐐瑰悗浣嶆暟锛?
6
鍗曞埄璁$畻 Simple Interest 澶嶅埄璁$畻 Compound Interest 鐜伴噾娴侀噺(鎶曡祫璇勪及) 锛戙€佸噣鐜板€硷紙NPV锛?锛掋€佸噣缁堝€硷紙NFV锛?
骞撮檺鎽婇攢 Amortization 澶╂暟璁$畻 Day
鎴愭湰锛屽敭浠凤紝姣涘埄鐨勮绠?
锛撱€佸唴閮ㄦ敹鐩婄巼锛圛RR锛?Cost锛孲elling price锛孧argin 锛斻€佸洖鏀舵湡锛圥BP锛?
1.缁堝€?
鍗曞埄simple interest:鍙互鍘熷鎶?璧勮澈鍙栧埄鎭紝姣忔湡鍒╂伅鏀跺叆閮介€€鍑?鎶曡祫銆?澶嶅埄compound interest:闄ゅ師濮嬫姇 璧勶紝姣忓勾鎵€鑾峰埄鎭篃鍔犲叆鎶曡祫骞惰禋 鍙栧埄鎭€?缁堝€硷紙future value锛?浠ュ鍒╄绠?鐨勬姇璧勬湡鏈€讳环鍊笺€?
8
1.2 鍗曞埄涓庡鍒╂瘮杈?
9
1.3 缁堝€?
$100鐨勭粓鍊硷紙FV锛?$100鐨勭粓鍊硷紙FV锛?
FV = $100 脳 (1 + r )
t
浠庝互涓婂崟鍒╀笌澶嶅埄璁$畻鐨勭粨鏋滃彲瑙侊紝鐢变簬鈥滃埄鐢熷埄鈥?鐨勬晥鏋滐紝澶嶅埄璁$畻涓嬬殑鍒╂伅鏀跺叆楂樹簬鍗曞埄璁$畻
涓嬬殑 鍒╂伅鏀跺叆銆?
10
1.3.1 缁堝€间笌鍒╃巼鐨勫叧绯?
$100鐨勭祩鍊?7000 6000 5000 4000 3000 2000 1000 0
鍒╃巼
0% 5% 10% 15%
鏃堕棿瓒婇暱锛岀粓鍊艰秺澶э紱 鍒╃巼瓒婇珮锛岀粓鍊艰秺楂橈紱
0
2
4
6
8
10
12
14
骞存暩
11
16
18
20
22
24
28
26
30
鍗曞埄璁$畻妯″紡鐨勫熀鏈洜瀛?
鈼廠ET锛?涓€骞翠腑鐨勫ぉ鏁?鈼廌AYS锛氬埄鎭懆鏈熷ぉ鏁?鈼廔%锛氬勾鍒╃巼 鈼廝V锛氭湰閲戯紙鐜板€硷級 鈼廠I锛氬埄鐜囬鐨勭畝鍗曠粓鍊?鈼廠FV锛氭湡鏈湰鎭綑棰濈殑缁堝€?鈼廇LL锛氬悎骞惰绠?
1.4.1 鍗曞埄璁$畻
妗堜緥 鈥?鍗曞埄 鏈噾$100锛屽湪 6%鍒╃巼鍗曞埄璁$畻涔嬩笅锛?骞撮棿璧?寰楃殑鍒╂伅鍜屾姇璧勬湡鐨勬€讳环鍊笺€?鎸夐敭锛歋MPL锛圫IMPLE锛?杈撳叆锛歞ys=365X5 EXE I%=6 EXE PV=-100 EXE SFV:SOLVE SFV=130
13
澶嶅埄璁$畻妯″紡鐨勫熀鏈洜瀛?
鈼廠ET锛?浠樻鏈?鈼廚锛氬鍒╄绠楀懆鏈熸暟 鈼廔%锛氬埄鐜?鈼廝V锛氱幇鍊?鈼廝MT锛氭瘡鏈熶粯娆鹃 鈼廎V锛氱粓鍊兼垨鏈€缁堜粯娆鹃 鈼廝/Y锛氬勾浠樻鏁?鏈?鈼廋/Y锛氬勾澶嶅埄鏁?
1.4.2 澶嶅埄璁$畻涓句緥
妗堜緥 鈥?澶嶅埄 鏈噾$100锛屽湪 6%鍒╃巼澶嶅埄璁$畻涔嬩笅锛?骞撮棿鏈殑鎬讳环 鍊笺€?鎸夐敭锛欳MPD 锛圕OMPOUND锛?杈撳叆锛?N=5 EX
E I%=6 EXE PV=-100 EXE PMT=0 EXE P/Y=1 (姣忓勾鏀粯娆℃暟) C/Y=1 锛堟瘡骞村鍒╄绠楁鏁帮級 FV:SOLVE FV=133.8226
15
1.4.3 鏇煎搱椤垮矝鍗栦究瀹滀簡锛?
Peter Minuit鍏堢敓鍦?