search

fsprojects / ExcelFinancialFunctions

.NET Standard library providing the full set of financial functions from Excel.
https://fsprojects.github.io/ExcelFinancialFunctions
Other
195 stars 66 forks source link

Implement CAGR/RRI #60

Closed jcoliz closed 2 years ago

jcoliz commented 2 years ago

Returns a compound annual growth (CAGR) or equivalent interest rate (RRI) for the growth of an investment.

As documented at https://www.investopedia.com/terms/c/cagr.asp

As found in https://github.com/DataExperts/dexih.transforms/blob/master/src/dexih.functions.financial/FinancialFunctions.cs

As tested in https://github.com/DataExperts/dexih.transforms/blob/master/test/dexih.functions.financial.tests/Financial.cs

jcoliz commented 2 years ago

This is RRI. Newly added to Excel since the library was originally written.

https://support.microsoft.com/en-us/office/rri-function-6f5822d8-7ef1-4233-944c-79e8172930f4

jcoliz commented 2 years ago

Implementation ready in feature/issue-60 branch.