All Collections
Cash Flow Management
Forecast Planning
P&L to cash feature
P&L and scenarios: test a hypothesis on my cashflow
P&L and scenarios: test a hypothesis on my cashflow
Judith Emonot avatar
Written by Judith Emonot
Updated over a week ago

You have learned:

In this article, we'll teach you how to:

  • Import different scenarios of your P&L to compare them

  • Make different assumptions about payment delays, to see their impact on your cash flow

1️⃣Import different versions of my income statement

💡 Do you have an optimistic and a pessimistic version of your P&L? Or do you simply have several versions and want to visualize the impact on your cash flow?

To import different versions of your P&L in order to make several scenarios, you need to:

  1. Create the scenario

    1. To do this, click on Main scenario

    2. Then create scenario

    3. Name it as you wish. In our example, pessimistic hypothesis 09042023.

  2. Import the P&L for this scenario

    1. Click on P&L conversion

    2. Import new

    3. Choose the version of the income statement you wish to compare. In our example, this is a pessimistic version of the budget.

    4. Agicap then lets you change the scenario on which you're importing. Select the scenario previously created, by clicking on Main scenario and selecting the other scenario. In our example, this is the pessimistic scenario 09042023.

    5. Click on Update

Go back to your cash flow plan and compare the different scenarios:

  1. Click on main scenario

  2. Click on the eye next to the scenario you wish to compare with

2️⃣Make different assumptions about payment delays

💡 Do you need to make assumptions and see the impact on your cash flow of a change in payment delays? For example, by reducing a delay or increasing them?

To test different hypothesis on payment delays, you must :

  1. Create a scenario to host your hypothesis

    1. Click on Main scenario

    2. Create scenario

    3. Name your scenario

  2. Import a new version of the P&L, or click on convert if the version displayed on the screen is the one you wish to use.

  3. Modify payment deadlines directly in part 2. Delays and due dates. Here, in our example for German inflows, we have chosen an optimistic hypothesis: a reduction of payment delays for this category: from 3 to 2 months on the one hand, and from 45 days to 30 days on the other.

  4. Select the newly created scenario. Here, in our example, modification payment delays.

Return to your cash flow plan and compare the different scenarios:

  1. Click on main scenario

  2. Click on the eye next to the scenario you wish to compare with

⚠️ Agicap does not store the different versions of the P&Ls you import. If you wish to do so, please click here.

⚠️ ⚠️ Agicap displays the latest version of the payment delays you have modified. You must be careful, the next time you import your P&L, that the delays (and the files) are indeed those you wish to use for the new conversion.

💡 You now have the option of assigning payment delays in bulk action, to ease your modifications!

Click on the squares to the left of the categories in part 2. Delays and due dates. Select the categories you wish to modify in bulk.

Then click on Add delay or due date.

Modify as required and validate.

💡 Do you have any questions? Don't hesitate to contact us on the chat!

Did this answer your question?