Monthly cash flow projections using Excel (126378166) - Recorded webinar

Description

In this recorded webinar, you will learn how to use Microsoft Excel to create monthly cash flow projections. The projections will be automatically calculated based on turnover, profit margins, expenses, working capital, capital expenditure, and loan amounts. You will understand the significance of cash flow projections for businesses and discover how to create a flexible model to measure and manage cash. The webinar will cover topics like anticipating cash shortfalls, paying creditors and employees, analysing trade debtor payments, financial planning, and collaborating with external stakeholders, such as banks.

Using a practical exercise and segmented into short lessons for ease of learning, this webinar will help you develop and enhance the technology skills that are important for financial professionals.

Key topics:

• Overview of the source data provided - what it contains and how the assumptions have been put together
• Create a balance sheet from a set of assumptions in the assumptions page and income statement
• Create a cash flow report which draws its source data from both the balance sheet and income statement

As part of this webinar you will receive,

• Downloadable worksheets with practical tasks to embed the knowledge
• A learning manual with step-by-step instructions

This recorded webinar is delivered by Excel expert and trainer, Marcus Small. Click here for Marcus' biography.

Course updated: May 2023

Learning objectives

• Describe the importance of cash flow projections and how to create a flexible model to measure and manage cash
• Use Microsoft Excel to automate monthly cash flow projections
• Anticipate potential cash shortfalls, analyse trade debtor payments, and plan finances to ensure adequate cash flow
• Apply collaboration skills with external stakeholders to manage cash flow effectively

Audience