mc Assetpilot

Financial forecasts

Last modified:

Manage forecasts to track the progress of your assets according to your financial models.

You can apply financial forecasts to each asset level separately. At each level, the desired forecast model must be active.

Financial models and financial forecasts

A financial model is some sort of a basic framework for the financial forecasts you create at the asset levels. The financial model does not contain any specific values, but only variables and placeholder parameters. The real data – which is individually different depending on your asset – is only entered later when you create a financial forecast based on the model. This eliminates the need for multiple spreadsheets for each asset.

The basic workflow for financial models, financial forecasts, and the comparison with the actual cashflow is as follows: The basis of every financial model are general parameter variables, such as site size, or income tax rate. With these parameters, you build calculations. The results of these calculations are assigned to different categories. When using a financial model for an asset’s forecast you enter actual values for the respective parameters, so that the calculations also result in actual forecast values which you can compare with actual cashflow values in the different categories. See image below.

Basic workflow for financial models, financial forecasts, and the comparison with the actual cashflow
Basic workflow for financial models, financial forecasts, and the comparison with the actual cashflow


Views of the financial forecasts domain

Enter the financial forecasts domain in platform view, by selecting the dedicated domain tab for image-20250305-150402.png Forecasts at every asset level. Display your financial forecasts in three different views: overview, quick view, and detailed view.

Overview

In the overview, you see a list of all financial forecasts divided into the Active financial forecast and possibly multiple Inactive financial forecasts. There can only be one active financial forecast per asset level.

Note

Financial forecasts are not consolidated to higher asset levels. You must navigate to a specific asset to view and manage its forecasts.

Overview of the financial forecasts domain
Overview of the financial forecasts domain

Quick view

Select a financial forecast to display a quick view of its details in a side panel with reduced information. When a forecast is completed, the following key performance indicators (KPIs) are calculated and displayed:

  • Total investment costs

  • Total running costs

  • Break-even date

  • Total return on investment (ROI)

  • Internal rate of return (IRR)

  • Net present value (NPV)

Detailed view

Select Go to detailed view in the quick view to open the financial forecast’s details on a separate page. There, you also see the parameters of the general financial model and their specific values for the selected financial forecast in the area Model parameters. A image-20241127-123126.png Checkmark indicates that you already entered a value for a parameter. A image-20241128-054701.png Clock indicates that some values are missing in that input group.

Note

Currently, the financial forecast will only display periods rather than commas (for example 25.0 vs. 25,0).

Detailed view of a financial forecast
Detailed view of a financial forecast

Create a financial forecast

Note

  • Financial forecasts can only be created for assets, not for your whole organization.

  • For production assets in conceptual stage, you can only create a maximum of 10 financial forecasts. See Conceptual stage for production assets.

Prerequisites for the whole process

0) Enter basic data

Steps
  1. In platform view, navigate to the asset level at which you want to create the financial forecast and select the domain tab image-20250305-150402.png Forecasts.

  2. Select +New financial forecast.

  3. Select a Financial model to be used to generate the forecast. See Create a financial model.

  4. Give the forecast a Start date and a Name.

  5. Enter a value between 0 and 20 for the Discount rate. This represents the time value of money and is used to calculate the net present value (NPV).

  6. You can also add a Description if desired. Tags are also optional but highly recommended. See also Tags for optimized search.

  7. Select Proceed to parameters.

Further actions

If you select Save and continue later, you can save the basic forecast data. The financial forecast will only become active when all the parameters of the selected financial model are filled in.


Enter basic data


1) Enter data for project phases

Steps

  1. Fill in the start and end months for each of the project phases you created in your financial model.

Note

  • Phases can be active simultaneously, for example if planning and construction overlap. The earliest start and latest end date define the project's lifetime.

  • If one phase of your project takes longer, you can adjust the dates without the need to adjust your financial model.
    Example: If the construction phase needs to be extended, for example due to missing parts, documents, certifications, etc., all subsequent phases (operations, decommissioning, etc.) will be automatically moved with the model.

  1. Select Next.

Enter phases


2) Enter data for parameters

Steps

  1. Fill in the parameter values that apply for this asset, respectively, that you forecast for this asset.

Note

Depending on the financial model you selected, there will be different parameters to fill in.

  1. Select Next if there are several input groups with parameter details to be filled. These are the same input groups you created when adding parameters to the financial model.

  2. Select Finish when you are done with all the parameter inputs.

Enter data for parameters

The financial forecast now appears in the list of financial forecasts and all KPIs are calculated accordingly.


Further actions

  • Download a financial forecast by selecting image-20241127-102437.png More options > download_24dp_000000_FILL0_wght400_GRAD0_opsz24.png Download JSON or download_24dp_000000_FILL0_wght400_GRAD0_opsz24.png Download CSV.

Manage existing financial forecasts

Set an active financial forecast

The active financial forecast is the basis for comparison with the actual cashflow. If you have more than one forecast on your asset level, you can change the active financial forecast.

Notes

  • There can only be one active financial forecast on each asset level.

  • Only completed financial forecasts can be set as active. For incomplete forecasts, this function will be enabled.

Steps

  1. Navigate to the Asset level of your financial forecast and select the domain tab image-20250305-150402.png Forecasts.

  2. For the forecast that should be active, select Set as active financial forecast.

The financial forecast is active now. The active forecast will be taken as basis for the comparison with the actual cashflow.

Duplicate a financial forecast

📗

Example

Duplicate a financial forecast if you only want to change one specific parameter, for example, different feed-in remuneration or increased maintenance costs.

Steps

  1. Navigate to the Asset level of your financial forecast and select the domain tab image-20250305-150402.png Forecasts.

  2. For the forecast you want to duplicate, select image-20241127-102437.png More options > image-20241127-105924.png Duplicate.

  3. The financial forecast is duplicated in the forecasts list.

  4. For the new forecast, select image-20241127-102437.png More options > image-20241128-061444.png Edit parameters and edit the necessary parameters.

Further actions

  • Change the active financial forecast if you want your duplicated forecast to be displayed and to be the basis for all cashflow comparisons. See Set an active financial forecast.

Edit a financial forecast

Note

You can not image-20250303-164035.png Edit parameters of the active financial forecast.

Steps

  1. Navigate to the Asset level of your financial forecast and select the domain tab image-20250305-150402.png Forecasts.

  2. You have two options to edit the desired forecast:

    • In the forecasts list and for the forecast you want to duplicate, select image-20241127-102437.png More options > image-20250303-164116.png Edit basic data or image-20250303-164035.png Edit parameters. Make your adjustments and select Save forecast.

    • In the financial forecast’s detailed view, you can also edit the parameters. Scroll to the area Model parameters and select image-20250303-164035.png Edit to make your adjustments. Or expand a parameter group, hover over a specific parameter, and image-20250303-164116.png Edit it directly.

Delete a financial forecast

Note

You can not delete the active financial forecast.

Steps

  1. Navigate to the asset level of your financial forecast and select the domain tab image-20250305-150402.png Forecasts.

  2. For the financial forecast you want to delete, select image-20241127-102437.png More options > image-20241127-101820.png Delete.

The financial forecast is now permanently deleted from the list of forecasts.

Monitor financial forecasts on the dashboard

To help you work efficiently, financial forecasts are evaluated in the following widgets on the dashboard: