Cash-flow Forecasting...
(or why you should always keep an eye on your money)!

The Ins...

1. Download the above spreadsheet from Google Drive

2. Fill in row 8 (Total Receipts) by adding up all 'inflows' for each month

The Outs...

1. Add up your 'outflows' for each month

Work it all out!

1. In the 'Net Cash Flow' row, take 'total payments' away from 'total receipts' for that month

2. 'Opening balance' is basically the 'closing balance' from the previous month

3. Closing balance will be 'net cash flow' added to 'opening balance'!

This time, more difficult and on your own ('download as' excel)...

Fancy a tougher cashflow challenge?

Exam practice...