Redian新闻
>
请问下如何计算IRR的值啊?
avatar
请问下如何计算IRR的值啊?# Accounting - 会计审计
O*a
1
头好晕啊,用excel里的IRR结果得不到值
JMS帮帮忙啊,谢拉?
avatar
l*z
2
怎么可能呢? 你是精简版的excel? 还是excel2003里面的那个add in没有加?
avatar
O*a
3
我用的是vista自带的那个版本
avatar
c*k
4
Write down your cashflows (A1: A5), use excel IRR function, you should be
able to calculate it. eg. =IRR(A1:A5,0.01)
Or, if you have financial calculator, you can use cf function.
Good luck.
avatar
k*n
5
if there are significant inflow/outflow of cash, IRR won't work for the
return performance calculation in the way below.
solution:
google time weighted return,
or use investment segment method in AIMR.

【在 c*********k 的大作中提到】
: Write down your cashflows (A1: A5), use excel IRR function, you should be
: able to calculate it. eg. =IRR(A1:A5,0.01)
: Or, if you have financial calculator, you can use cf function.
: Good luck.

相关阅读
logo
联系我们隐私协议©2024 redian.news
Redian新闻
Redian.news刊载任何文章,不代表同意其说法或描述,仅为提供更多信息,也不构成任何建议。文章信息的合法性及真实性由其作者负责,与Redian.news及其运营公司无关。欢迎投稿,如发现稿件侵权,或作者不愿在本网发表文章,请版权拥有者通知本网处理。