Creating a dynamic Cash Flow Forecast in a flash

7 Feb

2:00 pm

-

2:45 pm

Speakers

About the session

In this session, you will learn how to set up a robust cash flow forecast using the latest features in Excel.

• Setup and ingredients of a dynamic cash flow model

• Build a dynamic timeline by week

• Automatically allocate amounts based on different business rules

• Consolidate all data into a coherent and user friendly Cash Flow Report.

Understand how and when to use some of the most useful financial functions in Excel.

10:00 am

-

10:45 am

A demonstration of how to integrate a dynamic error checking system into a financial model.

11:00 am

-

11:45 am

Gašper shows you how to create a profit and loss statement in Power BI in less than one hour. Oh yeah…and then he does it in Excel.

1:00 pm

-

1:45 pm