CUMIPMT(Rate,NumberOfPayments,PresentValue,StartPeriod,EndPeriod,Type).? plz tell me a step by step guide how this formula works.
CUMIPMT(利率,NumberOfPayments,现值,StartPeriod,EndPeriod,类型)。?请告诉我一步一步指导这个公式如何运作。
3 个解决方案
#1
I'm assuming that computes a basic compound interest formula. You can read more about compound interest all over the web, in particular at http://en.wikipedia.org/wiki/Compound_interest#Compound
我假设计算一个基本的复合利息公式。您可以在网上阅读有关复合兴趣的更多信息,特别是http://en.wikipedia.org/wiki/Compound_interest#Compound
The formula they give isn't the exact same form as above, but it's the same concept.
他们给出的公式与上面的公式不完全相同,但它的概念是相同的。
#2
That's the MS Excel compound interest formula -
这是MS Excel复利计算公式 -
Reference Here and here's a Short video of how it's used
参考这里和这里是一个关于它如何使用的简短视频
As to its actual implementation, the wikipedia link is the best guide I've found also.
至于它的实际实现,*链接是我发现的最好的指南。
#3
You can have a look at get_cumipmt(..) or AnalysisAddIn::getCumipmt(..) @ koders.com
你可以看看get_cumipmt(..)或AnalysisAddIn :: getCumipmt(..)@ koders.com
Please note that these are under LGPL and GPL, if you plan to copy it, but they can be good to look at when making an own implementation.
请注意,如果您打算复制它们,这些都在LGPL和GPL下,但是在制作自己的实现时可以很好地查看它们。
#1
I'm assuming that computes a basic compound interest formula. You can read more about compound interest all over the web, in particular at http://en.wikipedia.org/wiki/Compound_interest#Compound
我假设计算一个基本的复合利息公式。您可以在网上阅读有关复合兴趣的更多信息,特别是http://en.wikipedia.org/wiki/Compound_interest#Compound
The formula they give isn't the exact same form as above, but it's the same concept.
他们给出的公式与上面的公式不完全相同,但它的概念是相同的。
#2
That's the MS Excel compound interest formula -
这是MS Excel复利计算公式 -
Reference Here and here's a Short video of how it's used
参考这里和这里是一个关于它如何使用的简短视频
As to its actual implementation, the wikipedia link is the best guide I've found also.
至于它的实际实现,*链接是我发现的最好的指南。
#3
You can have a look at get_cumipmt(..) or AnalysisAddIn::getCumipmt(..) @ koders.com
你可以看看get_cumipmt(..)或AnalysisAddIn :: getCumipmt(..)@ koders.com
Please note that these are under LGPL and GPL, if you plan to copy it, but they can be good to look at when making an own implementation.
请注意,如果您打算复制它们,这些都在LGPL和GPL下,但是在制作自己的实现时可以很好地查看它们。