Icon

Example Workflow - Goal Seek IRR

This Workflow determines the IRR for a list of project I analyse to determineits profitability.What I want to do is perform a goal seek that determines what the PurchasePrice column of a project must be in order to achieve a specific IRRFor example, in Project 1, the IRR is 20.1% at the purchase price of63,750,000. What would this purchase price need to be in order to get an IRRof say 25%. YOUR IRRCOMPONENTGOESHERE RemoveTransformCash FlowsCalculate InitialInvestmentArrangeCash FlowDatasetspecify range of valuesfor purchasevaluefind minimumirr_diff_from_targetset purchase valueto current "attempt"fro Parameter Opt LoopCompare IRR with0.25(irr_diff_from_target)makeirr_diff_from_targeta variableJust look at FIRST rowappend "seek_purchase_value" Column Filter Unpivoting Math Formula Column Resorter Table Creator Parameter OptimizationLoop Start ParameterOptimization Loop End Math Formula Math Formula Table Rowto Variable Row Filter Column Appender This Workflow determines the IRR for a list of project I analyse to determineits profitability.What I want to do is perform a goal seek that determines what the PurchasePrice column of a project must be in order to achieve a specific IRRFor example, in Project 1, the IRR is 20.1% at the purchase price of63,750,000. What would this purchase price need to be in order to get an IRRof say 25%. YOUR IRRCOMPONENTGOESHERE RemoveTransformCash FlowsCalculate InitialInvestmentArrangeCash FlowDatasetspecify range of valuesfor purchasevaluefind minimumirr_diff_from_targetset purchase valueto current "attempt"fro Parameter Opt LoopCompare IRR with0.25(irr_diff_from_target)makeirr_diff_from_targeta variableJust look at FIRST rowappend "seek_purchase_value"Column Filter Unpivoting Math Formula Column Resorter Table Creator Parameter OptimizationLoop Start ParameterOptimization Loop End Math Formula Math Formula Table Rowto Variable Row Filter Column Appender

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: jorda
Created at: 2023-06-16
On NodePit since: 2023-06-19
Last update: 2024-11-24
Created with KNIME version: v4.7.4

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!