Cash flow forecast (13 weeks or 12 months)
==========================================

Cash flow forecast: [ORGANIZATION NAME]

Version: [13 WEEKS / 12 MONTHS]

Prepared by: [NAME], [ROLE], on [DATE]

Period covered: [START DATE] to [END DATE]

Cash floor set by the board: $[AMOUNT]

Forecast

Add a column for each week (13 in all) or each month (12 in all). The first three are shown.

| | [WEEK OR MONTH 1] | [WEEK OR MONTH 2] | [WEEK OR MONTH 3] |
|---|---|---|---|
| Opening unrestricted cash | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Cash in | | | |
| Individual gifts | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Grant payments received (unrestricted) | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Reimbursements received from funders | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Event income | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Program fees and sales | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Other cash in | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Total cash in | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Cash out | | | |
| Net payroll | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Payroll tax deposits (federal and state) | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Contractors | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Rent and utilities | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Program costs | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Costs paid now for reimbursement grants | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Insurance, registrations and other annual bills | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Estimated tax payments (if any) | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Loan repayments (if any) | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Other cash out | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Total cash out | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Net cash flow (in minus out) | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Closing unrestricted cash (opening plus net) | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] |
| Below the floor? | [YES / NO] | [YES / NO] | [YES / NO] |

The closing cash of one column is the opening cash of the next.

Restricted cash (shown separately)

| Fund | Opening balance | Received | Spent | Closing balance | Spend-by date |
|---|---|---|---|---|---|
| [NAME] | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] | [DATE] |

Assumptions

| Item | What we assumed | How confident | Source |
|---|---|---|---|
| [FOR EXAMPLE: SPRING GRANT PAYMENT] | [AMOUNT AND DATE] | [HIGH / MEDIUM / LOW] | [GRANT AGREEMENT, PAST YEARS, FUNDER EMAIL] |

Forecast against actual

| Period | Forecast closing cash | Actual closing cash | Difference | Why |
|---|---|---|---|---|
| [WEEK OR MONTH] | $[AMOUNT] | $[AMOUNT] | $[AMOUNT] | [EXPLANATION] |

Summary for the board

- Lowest closing balance in this forecast: $[AMOUNT], in [WEEK OR MONTH]
- Periods below the floor: [LIST, OR "NONE"]
- What we plan to do about it: [ACTIONS, OR "NONE NEEDED"]
- Decisions needed: [DECISION, OR "NONE"]

Checks

- [ ] Opening cash matches the reconciled bank statement
- [ ] Restricted cash is kept out of the available balance
- [ ] Payroll tax deposits and annual bills are in the right week or month
- [ ] Last period's forecast was compared with what actually happened