Workflow created for the KNIME forum ...
https://forum.knime.com/t/irr-calculation-with-knime/36981
https://forum.knime.com/t/r-script-calculate-npv-irr-and-xnpv-xirr-workflows/37634
DESCRIPTION:
The challenge in this project was to calculate in KNIME, NPV and IRR for regularly spaced cash flows.
R Script is the approach selected for this challenge, by using the R jrvFinance packace's algorithms. The code is not sensitive to column names (neither for the year values and formats); however Time has to be placed in the first column.
"This R package implements the basic financial analysis functions similar to (but not identical to) what is available in most spreadsheet software." (Jayanth Varma @ https://github.com/jrvarma/jrvFinance)
For any comment or bug realted to the workflow, please do not hesitate to leave your comment.
DISCLAIMER:
The sharing of knowledge in KNIME Hub by using these examples and models, have only demonstration purposes in the advantage of the KNIME community.
These are meant to clarify theoretical background of mentioned subjects in caption.
I will not be held responsibility for any damages arising from the use of these models in your investment/valuation related work, without taking formal advise.
Workflow
Financial _ R Script _ NPV - IRR Calculation
External resources
Used extensions & nodes
Created with KNIME Analytics Platform version 4.4.2
Legal
By using or downloading the workflow, you agree to our terms and conditions.