首先注意,New investment at the BEGINNING of the year
T=0,投入2500,记CF0= -2500
T=1, 第一年末,第两年初,return 为 -20%, 记(-500),同时又是第二年初,Investment为1500,记现金流 - 1500,所以, T=1时刻,CF1=-1500, Balance 2000
T=2,return 为 65%, Gain = (2500-500+1500)*65%=2275,withdraw 500 ,Investement -1000, CF2=500-1000=-500, Balance= 5275
T=3, return -25%, Loss=[ (2500-500+1500)*.165 - 500 + 1000]* (-25%)= -1568.75 Withdraw 500, Investment 0, CF3= 500-0 = 500 Balance = 4206.25
T=4, Return 10% Gain= 4206.25 *10%=402.625 所有Balance全部取出 CF4=4206.25+402.625 = 4626.88
用计算器算IRR
CF0= -2500CF1= -1500
CF2=500-1000= -500
CF3= 500-0 = 500
CF4= 4626.88
IRR=3.9648%
PS: 现金流就是你投入和取出的净值,投入多,就是负的,取出多,就是正的
每年的Gain和Loss不要记入现金流,只需要往后面算,在最后一期全部取出就行了