Weekly Cash Forecast Worksheet
Used to prepare weekly cash forecasts
The Weekly Forecast Worksheet has been provided in order to enable you to break down a monthly forecast into weeks and compare your budgeted (estimated) amounts with your actual amounts. This may be helpful in cases were most of your receipts and collections arrive at the end of a month and a large percentage of your payments occur at the beginning of a month.
To use this worksheet, all you do is pick a month that you want to analyze and allocate (spread) either Automatically or Manually your monthly receipts and payments over the weeks that you estimate the receipts will be collected and the weeks that the payments will be made. If you also want to compare your estimated amounts to your actual amounts you need to enter your actual receipts and payments made during the weeks.
Sample Weekly Forecast Automatic Calculation
What's next ?
Charts & Graphs