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.
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
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
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.