This recorded webinar will show you how to create monthly cash flow projections using Microsoft Excel.
Overview
This recorded webinar will show you how to create monthly cash flow projections using Microsoft Excel. These projections are calculated automatically based on the turnover, profit margins, expenses, working capital, capital expenditure and loan amounts that are specified.
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
Objectives
- Using a set of assumptions, project out 12 monthly periods and 4 annual periods
- Create a balance sheet and cash flow statement (income statement provided)
- Generate sensitivity analysis and change the cash flow projections based on average debtor/creditor days
- Work through the detailed tasks accompanying the webinar to test your knowledge
Audience
Professionals working in SME or Corporate entities in specialist or analyst and mid-level career roles working in job functions such as external reporting, financial control and management accounting.