Icon

Financial Analysis

16 workflows in this folder and its subfolders

ARR Analysis

This component provides three different ways for calculating and visualizing the ARR: calculating the total ARR in each month and visualizing it in a line plot calculating the total ARR in each month and year, and comparing the years in a line plot calculating the ARR in total and at a customer leve…

ARR and MRR by Time-based Cohort

This component shows the (cumulative) ARR or MRR by time and time-based cohort. Cohorts are used to group individual records by the characteristics that they share, which is their starting time in this case. Analysis of cohorts reveals trends and patterns that could not be identified from the indivi…

Asset prices to one-period (log) returns

Calculates one-period simple and log asset return series from asset price series. Each column selected in the configuration dialog is used to generate two new columns: one-period simple return series one-period log return series Required extensions: KNIME Expressions (https://hub.knime.com/knime/ext…

Calculate Recurring Values

This component formats data before analyzing recurring events, such as monthly or annually recurring revenue. In the input table, each record holds a time period, an ID, and some numeric value. These records could be, for example, contracts with different customers. In the formatted output table, ea…

Categories to Excel Sheets

This component creates the Excel file and writes the selected columns of the input table to the separate sheets of this file. Each sheet contains a subset of the data as defined by the categories in a selected column.

Customer Count and Churn Rate by Time-based Cohort

This component shows the (cumulative) customer count or churn rate by time and time-based cohort. Cohorts are used to group individual records by the characteristics that they share, which is their starting time in this case. Analysis of cohorts reveals trends and patterns that could not be identifi…

Extended Internal Rate of Return (XIRR)

November 2022 · This component computes the XIRR (Extended Internal Rate of Return) just like in spreadsheet tools like Microsoft Excel and Google Sheet. Adopt this component to track the profitability of one or more investment projects with non-periodic transactions/cash flows. The component adopts the Java librar…

Extended Net Present Value (XNPV)

November 2022 · This component computes the XNPV (Extended Net Present Value) just like in spreadsheet tools like Microsoft Excel and Google Sheet. Adopt this component to track the total value of one or more investment projects with non-periodic transactions/cash flows. The metric computation is implemented using…

Measure Fractional Years

October 2021 · This component computes the fraction of the year of the difference between two dates, similar to the YEARFRAC function in Microsoft Excel. The component outputs two columns: The "YEARFRAC" column contains the difference between the start date and the end date as a fraction, that is the number of who…