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