內(nèi)部收益率怎么算
佚名
鍐呴儴鏀剁泭鐜囨€庝箞綆楋細(xì)杞繪澗涓婃墜鎸囧崡
鍢匡紒澶у濂藉晩~ 浠婂ぉ鍜變滑鏉ヨ亰鑱婁竴涓惉璧鋒潵鎸洪珮澶т笂鐨勪笢瑗庫€斺€斺€滃唴閮ㄦ敹鐩婄巼鈥濓紙Internal Rate of Return, IRR錛夈€傚叾瀹炲惂錛岃繖鐜╂剰鍎垮茍娌℃湁閭ｄ箞闅炬噦錛岃€屼笖鍦ㄦ姇璧勯鍩熼噷鍙噸瑕佷簡鍛紒
浠€涔堟槸鍐呴儴鏀剁泭鐜囷紵
棣栧厛錛屾垜浠緱寮勬竻妤氬唴閮ㄦ敹鐩婄巼鍒板簳鏄釜鍟ャ€傜畝鍗曟潵璇達(dá)紝鍐呴儴鏀剁泭鐜囧氨鏄 閲忎竴欏規(guī)姇璧勬敹鐩婃儏鍐電殑涓€涓寚鏍囥€傚畠鑳藉府鎴戜滑璁＄畻鍑轟竴絎旈挶鎶曞嚭鍘諱箣鍚庯紝鍦ㄦ暣涓姇璧勫懆鏈熷唴騫沖潎姣忓勾鑳藉鑾峰緱澶氬皯鍥炴姤鐜囥€?/p>
鈻沖浘鐗囬槄瑙?/p>
璁＄畻鍓嶇殑灝忓噯澶?/p>
寮€濮嬩箣鍓嶏紝鍏堝仛鐐瑰噯澶囧伐浣滃搱錛?/p>
鐜伴噾嫻佹暟鎹細(xì)浣犻渶瑕佺煡閬撲綘榪欓」鎶曡祫鍦ㄦ湭鏉ユ瘡涓€騫撮璁′細(xì)緇欎綘甯︽潵澶氬皯閽便€?/p>
鍒濆鎶曡祫棰濓細(xì)鍒繕浜嗚褰曚竴涓嬫渶寮€濮嬫姇鍏ヤ簡澶氬皯閾跺瓙鍝︺€?/p>
濡備綍鎵嬪姩璁＄畻IRR錛燂紙鍏跺疄鏈夌偣澶嶆潅錛?/p>
濂戒簡錛屼笅闈㈠挶浠寮忓紑璁插暒锝炰笉榪囪瀹炶瘽錛屽鏋滅湡瑕佺敤鍏紡涓€姝ヤ竴姝ョ畻鍑烘潵錛岄偅榪樼湡涓嶆槸涓€浠跺鏄撶殑浜嬪効銆備絾鏃㈢劧鏉ヤ簡錛屽挶灝變竴璧鋒寫鎴樹竴涓嬪槢錛佽繖閲屾湁涓€涓熀鏈叕寮忎緵鍙傝€冿細(xì)
[
IRR = text{浣垮緱} sum_{t=1}^{T} frac{C_t}{(1+IRR)^t} + C_0 = 0 text{ 鐨?} IRR
]
鍏朵腑錛?/p>
- ( T ) 鏄€葷殑鏈熸暟錛?/p>
- ( C_t ) 琛ㄧず絎?( t ) 騫存湯鏀跺埌鎴栨敮浠樼殑鐜伴噾嫻侀噺錛?/p>
- ( C_0 ) 鍒欐槸浣犳渶鍒濈殑鎶曡祫棰濄€?/p>
鐪嬪埌榪欎釜鍏紡鏄笉鏄劅瑙夊ご澶т簡錛熷搱鍝堬紝鍒媴蹇冿紝鎺ヤ笅鏉ユ湁涓洿綆€鍗曠殑鍔炴硶銆?/p>
浣跨敤Excel鎴栧叾浠栧伐鍏峰揩閫熸悶瀹?/p>
瀵逛簬澶у鏁版湅鍙嬫潵璇達(dá)紝鐢‥xcel鎴栬€呭叾浠栬儲鍔¤蔣浠剁洿鎺ユ眰瑙ｅ唴閮ㄦ敹鐩婄巼鍙兘鏄渶鐪佷簨鍎跨殑鏂規(guī)硶浜嗐€傛瘮濡傚湪Excel涓緭鍏ヤ互涓嬪唴瀹瑰氨鑳藉緱鍒扮粨鏋滐細(xì)
1. 鎵撳紑涓€涓柊鐨凟xcel琛ㄦ牸銆?/p>
2. 鍦ˋ鍒椾緷嬈″垪鍑哄寘鎷垵濮嬫姇璧勫湪鍐呯殑鎵€鏈夌幇閲戞祦鏁版嵁銆傦紙璁板緱鍒濆鎶曡祫鏄礋鍊煎摝錛?/p>
3. 浣跨敤 `=IRR(A1:A5)` 榪欐牱鐨勬牸寮忚緭鍏RR鍑芥暟錛堝亣璁句綘鐨勭幇閲戞祦鍒嗗竷鍦ˋ1鍒癆5涔嬮棿錛夈€?/p>
4. 鎸変笅鍥炶濺閿紝絳旀绔嬮┈鐜拌韓錛?/p>
鐪嬪惂錛屽叾瀹炲彧瑕佹帉鎻′簡姝ｇ‘鏂規(guī)硶錛岃綆楀唴閮ㄦ敹鐩婄巼涔熸病閭ｄ箞鍥伴毦鍢涖€傚綋鐒跺暒錛屽疄闄呮搷浣滄椂榪橀渶瑕佺粨鍚堝叿浣撴儏鍐電伒媧昏繍鐢ㄣ€傚笇鏈涜繖綃囦粙緇嶅浣犳湁鎵€甯姪錛屼笅嬈℃姇璧勬椂涔熻兘媧句笂鐢ㄥ満鍛紒馃憢
---
鎬庝箞鏍鳳紝鐜板湪瀵瑰唴閮ㄦ敹鐩婄巼鏄笉鏄湁浜嗘洿娣辯殑鐞嗚В鍜岃璇嗭紵浠ュ悗鍐嶉亣鍒扮浉鍏抽棶棰樻椂錛屽氨鍙互鏇村姞浠庡涓嶈揩鍦板簲瀵瑰暒錛佸鏋滀綘榪樻湁鍏朵粬鐤戦棶鎴栬€呮兂浜嗚В鏇村鐩稿叧鍐呭錛岃闅忔椂鐣欒█鍛婅瘔鎴戝摝锝?鎴戜滑涓嬫瑙侊紒馃槈
鎵╁睍闃呰錛?/p>
鑲＄エ鐭ヨ瘑
涓栫晫鎶曡祫澶у笀
綺鵑€夎偂紲ㄧ煡璇嗗涔?/a>