Configuring cash flows

Edit online

Many financial investment projects rely on capturing cash flow for financial formulas. You can capture cash flow adjustments in Sustainability Program Tracking and use these values in your calculations.

Before you begin

Before you request that cash flow feature to be enabled in your environment, identify which fields you will use to capture cash flow, the cash flow period, and the financial formulas your cash flow values will feed into. Provide the following information:
  • The action fields that capture implementation costs.
  • The action fields that capture financial savings.
  • Any corporate wide discount rate percentage to use and whether this can be modified for specific programs.
  • The list of financial formulas that you want to produce, for example, net present value (NPV).
  • The cash flow period, for example, by year or by month.
  • The start period of the cash flow calculation, for example, when the project completes.
  • The end period of the cash flow calculation, for example, 5 years after the project completes.
Work with the Envizi team to configure and enable the cash flow feature.

About this task

The following financial formulas are calculated automatically by the system based on the cash flow inputs you provide:
  • Net present value (NPV)
  • IRR
  • Discounted benefit-to-cost ratio
  • Discounted payback period
  • Simple pay back period
You can work with the Envizi team to extends these financial formulas and to include them in the module.

Procedure

  1. From the main menu, click Optimize > Programs to open the Programs grid.
  2. Click Actions > Acton to open the Actions grid.
  3. Click Actions > Acton timeline.
    The list of cash flow fields are displayed.
  4. Capture the cash flow values for each field and click Save.
  5. Click The Export icon to export the cash flow values to a CSV file.

Results

The predefined financial formulas are recalculated and the output values are saved in the action fields of related programs.