Financial Analysis
This directory contains 16 workflows.
ARR Analysis
This component provides three different ways for calculating and visualizing the ARR: 1. calculating the total ARR in each month and visualizing it in a […]
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 […]
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 […]
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 […]
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 […]
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 […]
Extended Internal Rate of Return (XIRR)
This component computes the XIRR (Extended Internal Rate of Return) just like in spreadsheet tools like Microsoft Excel and Google Sheet. Adopt this […]
Extended Net Present Value (XNPV)
This component computes the XNPV (Extended Net Present Value) just like in spreadsheet tools like Microsoft Excel and Google Sheet. Adopt this component to […]
Internal Rate of Return (IRR)
This component computes the IRR (Internal Rate of Return) just like in spreadsheet tools like Microsoft Excel and Google Sheet. Adopt this component to […]
Measure Fractional Years
This component computes the fraction of the year of the difference between two dates, similar to the YEARFRAC function in Microsoft Excel. The component […]