Cash flow projection of unrestricted funds

All unrestricted income and expenditure from that income is depicted in a Cash Flow Projection. This is used to model likely outcomes from different scenarios of income and expenditure. It is a spreadsheet usually showing the next 6 - 9 months by month. Insert link here to spreadsheet It shows the likely amounts and degrees of certainty of :

1) income from monthly regular giving : fairly certain as most is from standing orders,

2) income from additional monthly donations from rebellion fundraising: v uncertain,

3) any other income such as grants from UMI : v certain,

4) regular costs, or "keeping the lights on" e.g. software licences, servers, Zoom accounts, warehouse rent, warehouse rates tax, accountancy : mostly v certain (rates uncertain as at 3/10/21),

5) movement costs : uncertain before a rebellion or action, v certain after a rebellion,

6) rebellion costs: initially around 40% of extra fundraising but finalised in the 2 months leading to a rebellion or action,

7) petty cash, to be used for ad hoc or unforeseen expenses : certain, agreed by IBG,

8) reserve for future unknown or speculative projects : fairly certain but the projects themselves are uncertain.

The cash flow should run for a rolling 6 - 9 months. Each month, the actual balance of unrestricted funds up to the end of the previous month and advised by Finance around the 7th - 10th of the current month, is entered. This becomes the brought forward amount and is the only actual, known figure, others being less certain the further forward in time they are. Then the column with the previous month’s details is hidden and a new month added at end. At no time should the balance carried forward be below 0. Some entries will have been agreed and the rest are an estimate as follows :

Each row of expenditure in the cash flow excluding regular costs represents a chunk of funding to be granted to a section of the movement :

1. 12 Nations and Regions

2. 6 Critical central circles (or shared services)

3. Non-critical central circles from Hive, Operations and Sys & Cul

4. XR Youth

5. Global Support

6. Strategy Assembly

7. MOV (Marginalised and Oppressed Voices) - fixed monthly payments into a reserve from which a budget has to be agreed

8. ISN - agreed through an agreement for a fixed monthly amount and increased if any monthly income exceeds a threshold, can only be changed with 6 months notice. Stephen - please can you add here the calculation for when ISN gets extra?