Icon

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 […]

IconInternal 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 […]