Hub
Pricing About
WorkflowWorkflow

Financial Metrics - IRR, MIRR & XIRR

InvestmentPortfolioReturn RateComponentIRR
+4
knime profile image
Versionv2Latest, created on 
Jan 22, 2025 3:29 PM
Drag & drop
Like
Download workflow
Workflow preview
Financial Metrics Example: Investments' return rate

This is a business case example of the use of 3 financial metrics components in order to measure the profitability  of some investment projects.

The business case:
Imagine you are a firm that wants to invest in 3 different ways.
One way is to begin building an orchid, and for that you plan 3 different projects for which the costs and returns are not regular.
The second and third ways are different financial investments.
The second is in form of several regular monthly investments projects while the third one is in in the same form but you have the additional information of knowing the cost of the capital and at which rate the returns will be reinvested.

After getting the data of the investment projects, which stocked into different excel files, congregated into three different flows divided by type of investments as previously described we begin begin enriching it with the computation of the financial formulae.

In the end we have an overview of all the projects with the return rate for each of them and a visualization to have a ranking of which are the best investment opportunities for the firm in the case.

External resources

  • Check out the nodes and other workflows developed by Mydral
  • For more info and support, contact Mydral
Loading deploymentsLoading ad hoc jobs

Used extensions & nodes

Created with KNIME Analytics Platform version 5.4.0 Note: Not all extensions may be displayed.
  • Go to item
    KNIME Base nodesTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Column Expressions (legacy)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Excel SupportTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME ExpressionsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME File Handling CoreTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME JavasnippetTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Math Expression (JEP)Trusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME Quick FormsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME REST Client ExtensionTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime
  • Go to item
    KNIME ViewsTrusted extension

    KNIME AG, Zurich, Switzerland

    Version 5.4.0

    knime profile image
    knime

Legal

By using or downloading the workflow, you agree to our terms and conditions.

KNIME
Open for Innovation

KNIME AG
Talacker 50
8001 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • Courses + Certification
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more about KNIME Business Hub
© 2025 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Data Processing Agreement
  • Credits