How to implement/calculate this function in object

问题:

CUMIPMT(Rate,NumberOfPayments,PresentValue,StartPeriod,EndPeriod,Type).? plz tell me a step by step guide how this formula works.

回答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

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 -

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

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.