Icon

FP&A

10 workflows in this folder and its subfolders

Icon
Annually Recurring Revenue Calculation and Analysis

January 2020 · This workflow calculates and visualizes the ARR from contracts data. The first step is to calculate the recurring values in each month based on the contract period and contract value. The second step is to calculate the ARR. The third step is to visualize and analyze it. This workflow demonstrates h…

Icon
ARR Analysis (Data App)

December 2018 · URL: Seeing the Forest for the Trees - Cohort Analysis http:///blog/seeing-the-forest-for-the-trees-cohort-analysis URL: Measure and Monitor ARR in Two Steps https://www.knime.com/blog/measure-and-monitor-arr-in-2-steps

Icon
Budget Monitoring Data App

January 2020 · This workflow creates a budget overview in a data app. 11 projects (with desert names). Each project with total money (in 1000) assigned and used in 2021, 2022, 2023. We calculate the remaining money for each project for each year. The "Budget Summary" component contains three components: one displa…

Icon
Calculate Net Profit

October 2021 · This workflow shows an example of the verified component "Measure Fractional Years". It calculates the fraction of the year represented by the whole numbers between two dates. It also shows how to use the "Invert Category Sign" component The workflow makes use of a simple example data of an ecommerc…

Icon
Calculating Annually Recurring Revenue

January 2020 · This workflow calculates the ARR from contracts data. The first step is to calculate the recurring values in each month based on the contract period and contract value. The second step is to calculate the ARR. The third step is to visualize it. Here we show three different ways for calculating and v…

Icon
Financial Metrics - IRR, MIRR & XIRR

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 differen…

Icon
Financial Metrics - NPV & XNPV

November 2022 · This is a business case example of the use of 2 financial metrics components in order to measure the value 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 projec…

Icon
Financial Variance Analysis

October 2020 · This workflow demonstrates a typical variance analysis report created by Finance teams. The process identifies corresponding Excel actions a user may take to perform the same task. Sample data represents raw Finance system accounting information, and budgets arranged in table formats. Following the…

Icon
Monthly and YTD Revenues

January 2017 · Comparing restaurant revenues month by month for 2022 and 2023, as monthly revenues and as YTD revenues. YTD = Year To Date means the sum of revenues up to the current month. Transactions from 2022 are saved in an Excel file, while transactions from 2023 are saved in a Google spreadsheet (which we m…

Icon
MRR and ARR of Customer Groups

January 2020 · This workflow shows the steps involved building a cohort chart. The first step is to split contracts data into recurring values. The second step is to build a cohort chart from the recurring values. In this example, the cohort charts show the annually recurring revenue (ARR) and customer count by ti…