Weekly Cash Forecast Worksheet
	Instructions
	This worksheet is where you can pick a month and estimate
	your cash flow by each week within the month.
	Once again , the yellow highlighted area is where you enter
	information.
	You need to enter the number of the period that you want
	to see and analyze by week. If you want to work with period 1
	enter a 1, period 2 enter a 2, and so on.
	You can enter your actual cash balance or the estimated cash
	balance that is shown in the line- Cash Estimated in Worksheet.
The Automatic Calculation uses all the information that you have previously entered and spreads the monthly amount evenly
to each of the weeks.
The Manual Calculation allows the user to specify the monthly amounts that are spread or allocated to each week,
I have provided you with two options. You can either (1) enter a percentage to use to spread the month's total amount or you can
(2) enter an actual dollar amount. Only use one of the options either the percentage method or the dollar input method
for each of the  categories. You can use a different method for each of the categories but don’t enter a percentage and
also a dollar amount for the same category.
You need to enter a percentage or dollar amount (but not both) if you use the manual method to allocate
your weekly receipts and payments.
Introduction
Cash Projection Worksheet
Sales Forecast Worksheet
Cash Payments Worksheet
Charts Worksheet
Cash Forecast For Specified Period
Enter Monthly Period (1,2,3, etc)	2[1]
Number Of Weeks in Period	4
Number of Weeks in the Period are automatically
displayed based on the period you enter above.
Enter a Capital  M to use the Manual Budget	A
Calculated Amounts or a Capital  A to use
the Automatic Budget Calculations.
Automatic Cash Forecast
This Cash Estimate is automatically calculated for you based on the data
you have already entered earlier. The only amount the user is allowed to change is the
Beginning Cash Balance. The Beginning Cash Balance calculated for the month is
displayed.You can enter this amount, or if known, enter your Actual Beginning
Cash Balance for the period. The calculated amounts used in this schedule
are contained in the Automatic Calculation and Allocation section of this worksheet.
The automatic calculation spreads the receipts and payments equally over
the number of weeks in the period.
	Month
Cash Summary	2
Automatic	Total	Week 1	Week 2	Week 3	Week 4
Enter Beginning Cash Amount
(6,890)	(6,890)[2]	(6,890)	(5,957)	(5,024)	(4,091)
Plus:
Cash Collections
Accounts Receivable-Collections	35,913	8,978	8,978	8,978	8,979
Cash Sales	3,730	933	933	933	931
Other Receipts and Collections
Total Cash Collections	39,643	9,911	9,911	9,911	9,910
Less:
Cash Payments
Accounts Payable Payments	16,343	4,086	4,086	4,086	4,085
Other Amounts Owed Prior Period
Cash Purchases	2,154	539	539	539	537
Payroll Expenses	4,313	1,078	1,078	1,078	1,079
Cash Operating Expenses	8,550	2,138	2,138	2,138	2,136
Sales Tax	1,048	262	262	262	262
Note Payments
Equipment Purchases
Owner's Draws / Dividends	3,500	875	875	875	875
Income and Other Taxes
Other Payments
Total Cash Payments	35,908	8,978	8,978	8,978	8,974
Ending Cash	(3,155)	(5,957)	(5,024)	(4,091)	(3,155)
Increase / <Decrease> For Period	3,735	933	933	933	936
Manual Cash Forecast
The Beginning Cash Balance calculated for the month is displayed. You can
enter this amount,  or if known, enter your Actual Beginning Cash Balance
for the period. The calculated amounts used  in this schedule are
contained in the Manual Allocation section of this worksheet.
	Month
Cash Summary	2
Manual	Total	Week 1	Week 2	Week 3	Week 4
Enter Beginning Cash Amount
(6,890)	[3]
Plus:
Cash Collections
Accounts Receivable-Collections
Cash Sales
Other Receipts and Collections
Total Cash Collections
Less:
Cash Payments
Accounts Payable Payments
Other Amounts Owed Prior Period
Cash Purchases
Payroll Expenses
Cash Operating Expenses
Sales Tax
Note Payments
Equipment Purchases
Owner's Draws / Dividends
Income and Other Taxes
Other Payments
Total Cash Payments
Ending Cash
Increase / <Decrease> For Period
Actual Cash and Budget Comparison
Enter your actual collections and payments
for each weekly period in the yellow highlighted cells.
	Month
	2	Totals		Week 1	Week 1		Week 2	Week 2		Week 3	Week 3		Week 4	Week 4
	Budget	Actual	Difference	Budget	Actual	Difference	Budget	Actual	Difference	Budget	Actual	Difference	Budget	Actual	Difference
Beginning Cash	(6,890)	(6,890)		(6,890)	(6,890)		(5,957)	(6,890)	933	(5,024)	(6,890)	1,866	(4,091)	(6,890)	2,799		(6,890)	6,890
Plus:
Cash Collections	39,643		39,643	9,911		9,911	9,911		9,911	9,911		9,911	9,910		9,910
Less:
Cash Payments	35,908		35,908	8,978		8,978	8,978		8,978	8,978		8,978	8,974		8,974
Ending Cash	(3,155)	(6,890)	3,735	(5,957)	(6,890)	933	(5,024)	(6,890)	1,866	(4,091)	(6,890)	2,799	(3,155)	(6,890)	3,735		(6,890)	6,890
Increase / <Decrease> For Period	3,735		3,735	933		933	933		933	933		933	936		936
Calculations and Allocations
Automatic Calculation and Allocation
This calculation is done automatically and spreads the totals for the month
evenly between the weeks. In other words each week's receipts and
payments are assumed to be the same. These figures are the weekly amounts
used in the Automatic Cash Forecast.
	Total	Week 1	Week 2	Week 3	Week 4
Cash Collections
Accounts Receivable-Collections Prior Period	5000	1250	1250	1250	1250
Accounts Receivable-Collections Current Periods	30913	7728	7728	7728	7729
Cash Sales	3730	933	933	933	931
Other Receipts and Collections
Total Cash Collections	39643	9911	9911	9911	9910
Cash Payments
Accounts Payable Payments-Prior Periods
Accounts Payable Payments-Current Periods	16343	4086	4086	4086	4085
Other Amounts Owed Prior Period
Cash Purchases	2154	539	539	539	537
Payroll Expenses	4313	1078	1078	1078	1079
Cash Operating Expenses	8550	2138	2138