http://docs.scipy.org/doc/numpy-1.10.0/reference/generated/numpy.irr.html
上面的链接仅在薪资期限和复合期限为年时才对我有用。如果他们几个月或一个季度,我不知道如何使用它。
如果您对IRR,现值,未来值等有所了解,您将理解我的意思。
IRR(年)的答案是298.88%,而我得到12.22%
A栏中的时间以年为单位
EXCEL FILE IMAGE:
Excel File image
import xlrd
import numpy
fileWorkspace = 'C://Users/jod/Desktop/'
wb1 = xlrd.open_workbook(fileWorkspace + 'Project3.xls')
sh1 = wb1.sheet_by_index(0)
time,amount,category = [],[],[]
for a in range(2,sh1.nrows):
time.append(int(sh1.cell(a,0).value))
amount.append(float(sh1.cell(a,1).value))
category.append(str(sh1.cell(a,2).value))
#print(time)
#print(amount)
#print(category)
print('\n')
p_p2 = str(sh1.cell(0,1))
p_p1 = p_p2.replace("text:'","")
pp = p_p1.replace("'","")
#print(pp)
c_p2 = str(sh1.cell(1,1))
c_p1 = c_p2.replace("text:'","")
cp = c_p1.replace("'","")
#print(cp)
netflow = 0
outflow = 0
inflow = 0
flow = 0
if pp == "Months" and cp == "Months":
IRR = numpy.irr(amount) * 100
print ("IRR:", round(IRR, 2), '%', '\n')
for i in time:
flow = amount[i] / numpy.power((1 + (IRR/100)), time[i])
if flow>0:
inflow = inflow + flow
if flow<0:
outflow = outflow + flow
#print ('Present Value (P) is:', round(flow,0), '\n')
netflow = outflow + inflow
print("In 2016")
print("-------")
print ('Outflow is: ', round(outflow,0))
print ('Inflow is: ', round(inflow,0))
print ('Netflow is: ', round(netflow,0), '\n')
outflow2 = (round(outflow,0))*(1+(IRR/100))**(9)
inflow2 = (round(inflow,0))*(1+(IRR/100))**(9)
netflow2 = outflow2 + inflow2
print("In 2025")
print("-------")
print ('Outflow is: ', round(outflow2,0))
print ('Inflow is: ', round(inflow2,0))
print ('Netflow is: ', round(netflow2,0), '\n')
最佳答案
让我们假设我们有一个月流量,例如:
flow = [-1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1.4]
x = np.irr(flow)
x
0.0284361557263606
要计算IRR,您需要使用以下公式:
内部收益率=(1 + x)** 12-1
(1 + x) ** 12 - 1
0.39999999999998925
如果您有季度流量,请相应地使用公式:
内部收益率=(1 + np.irr(季度流量))** 4-1
关于python - IRR库只有在支付期限和复利期限以年为单位的情况下才是好的(工程经济),我们在Stack Overflow上找到一个类似的问题:https://stackoverflow.com/questions/35713992/