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

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

• 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