Cash Projection Worksheet		The Cash Projection Worksheet contains the following information:
		(a) Cash Summary Section that summarizes all the estimated cash
Introduction		receipts and payments.
Sales Forecast Worksheet		(b) Basic Financial Information Section
Cash Payments Worksheet		(c) Sales and Payment information summarized and calculated
Weekly Forecast Worksheet		from the other two sheets - SalesForecast and CashPayments.
Charts Worksheet		(d) Estimated purchases and inventory calculations for businesses
		that buy and sell product.
		Instructions:
		Enter the number of periods that you want to prepare
		an estimate for from one to 12 months (1 - 12).
		Enter your basic financial information, collection and
		payment patterns, and beginning balances in
		the Basic Financial Information Section.
		Gray Highlighted Section
		Enter the number of weeks contained in each month
		that you want to estimate collections and payments for.
To Print the Main Worksheet select File and Print from the Menu.		All areas that require user input are highlighted in yellow.
Number Of Periods To Forecast	12
(Enter a number between 1-12.)
Cash Projection Summary	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
Enter Beginning Cash Amount
Beginning Cash	0	0	0	0	0	0	0	0	0	0	0	0	0
Plus:
Cash Collections
Accounts Receivable-Collections Prior Period	0	0	0	0	0	0	0	0	0	0	0	0	0
Accounts Receivable-Collections Current Periods	0	0	0	0	0	0	0	0	0	0	0	0	0
Cash Sales	0	0	0	0	0	0	0	0	0	0	0	0	0
Sale Of Equipment	0	0	0	0	0	0	0	0	0	0	0	0	0
Loans	0	0	0	0	0	0	0	0	0	0	0	0	0
Owner's Investments / Stock Sales	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Receipts and Collections	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Cash Collections	0	0	0	0	0	0	0	0	0	0	0	0	0
Less:
Cash Payments
Accounts Payable Payments-Prior Periods	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Amounts Owed Prior Period	0	0	0	0
Accounts Payable Payments-Current Periods	0	0	0	0	0	0	0	0	0	0	0	0	0
Cash Purchases	0	0	0	0	0	0	0	0	0	0	0	0	0
Payroll Expenses	0	0	0	0	0	0	0	0	0	0	0	0	0
Operating  Expense Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Sales Tax	0	0	0	0	0	0	0	0	0	0	0	0	0
Note Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Equipment Purchases	0	0	0	0	0	0	0	0	0	0	0	0	0
Owner's Draws / Dividends	0	0	0	0	0	0	0	0	0	0	0	0	0
Income and Other Taxes	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Miscellaneous Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Cash Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Ending Cash	0	0	0	0	0	0	0	0	0	0	0	0	0
Increase / <Decrease> For Period	0	0	0	0	0	0	0	0	0	0	0	0	0
Additional Cash Needed	0	0	0	0	0	0	0	0	0	0	0	0	0
Supplied By:
Short Term Borrowing Needs	0	0	0	0	0	0	0	0	0	0	0	0	0
Short Term Repayments	0		0	0	0	0	0	0	0	0	0	0	0
Current Loan Balance	0	0	0	0	0	0	0	0	0	0	0	0	0
Cash Including Short Term Loans	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Key Financial Information
Profit / Loss Information
Sales	0	0	0	0	0	0	0	0	0	0	0	0	0
Cost Of Sales	0	0	0	0	0	0	0	0	0	0	0	0	0
Gross Profit	0	0	0	0	0	0	0	0	0	0	0	0	0
Payroll Expenses	0	0	0	0	0	0	0	0	0	0	0	0	0
Operating Expenses	0	0	0	0	0	0	0	0	0	0	0	0	0
Estimated Profit / (Loss)	0	0	0	0	0	0	0	0	0	0	0	0	0
(Prior To Income Tax, Depreciation, Interest
and Business Taxes)
Owner Draws / Dividends	0	0	0	0	0	0	0	0	0	0	0	0	0
Key Balance Sheet Balances
Cash	0	0	0	0	0	0	0	0	0	0	0	0	0
Inventory Balance	0	0	0	0	0	0	0	0	0	0	0	0	0
Accounts Receivable Balance	0	0	0	0	0	0	0	0	0	0	0	0	0
Accounts Payable Balance	0	0	0	0	0	0	0	0	0	0	0	0	0
Sales Tax Payable	0	0	0	0	0	0	0	0	0	0	0	0	0
Short Term Borrowings	0	0	0	0	0	0	0	0	0	0	0	0	0
Basic Financial Input Information Needed
Collection & Payment Information
Enter Amounts Highlighted In Yellow
A/R and Cash Sales Collections as a % of Sales			Accounts Receivable
Cash Sales			Prior Yr					Totals
% of Cash Sales	0.0%		Beginning Accounts Receivable Net  Balance					0	Amounts Collected By Month
									Month 1	Month 2	Month 3	Month 4		Check Total
Sales On Account			Estimated Current Balances					0	0	0	0	0		0
% Collected Month of Sale	0.0%		Estimated 1-30 Days Late					0	0	0	0	0		0
% Collected One Month After Sale	0.0%		Estimated Over 30 Days Late					0	0	0	0	0		0
% Collected Two Months After Sale	0.0%
% Collected Three Months After Sale	0.0%		Check Total					0	0	0	0	0		0
% Uncollected	0.0%
Total Should Equal  100%	0.0%		Future Sales (Extra 3 Months)				Future 1	Future 2	Future 3
			Estimated Sales Additional 3 Months				0	0	0
Inventory and Cost Information			Calculated Future Sales				0	0	0
Actual Financial  Data if Available			Note:These months are used in the calculation of purchases
Actual Ending Inventory Prior Year	0		If no amounts are entered in the Estimated Sales Additional 3 Months
Actual Sales Prior Year	0		the months are automatically calculated for you.
Actual Cost Of Goods Sold Prior Year	0
			Accounts Payable Payments					Totals
Calculated Cost Of Goods % of Sales	0.00%		Beginning Accounts Payable  Balance					0	Amounts Paid By Month
Calculated Inventory Turnover	0.00								Month 1	Month 2	Month 3	Month 4		Check Total
			Estimated Current Balances					0	0	0	0	0		0
Calculated Number Of Months Sales in Inventory	0.00		Estimated 1-30 Days Late					0	0	0	0	0		0
			Estimated Over 30 Days Late					0	0	0	0	0		0
OR
Estimated Financial Data
(Use If No Actual Information Available OR			Check Total					0	0	0	0	0		0
you ancipitate an Increase or Decrease in the % )
Cost Of Goods Sold % (Cost Of Goods Sold / Sales)	0.00%
Inventory Turnover (Cost Of Goods Sold / Inventory)	0.00
			Other Financial Information
Payments on Purchases (%)			Beginning Inventory					0
Cash Purchase
Cash Purchases in the Current Month	0.0%		Sales Tax Owed					0
Purchases On Account			Sales Tax Rate (Percentage)					0.00%
% of Payments in the Month Of Purchase	0.0%		Percentage of Exempt Sales					0.00%
% of Payment One Month After Purchase	0.0%		Percentage of Taxable Sales					100.00%
% of Payment Two Months After Purchase	0.0%
% of Payment Three Months After Purchase	0.0%								Amounts Paid By Month
								Total	Month 1	Month 2	Month 3	Month 4		Check Total
Total Payments  Should Equal 100%	0.0%		Other Amounts Owed					0	0					0
Payroll Tax Rates
Social Security and Medicare % Rate	7.650%
Federal Unemployment % Rate	0.800%
State Unemployment  % Rate	2.700%
Cash Projection Calculations				Twelve Month Forecast
				or User Specified Number Of Periods
	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Next Year 1	Next Year 2	Next Year 3
Number Of Weeks In Month		5	4	4	5	4	4	5	4	4	5	4	4
Enter Number Of Weeks In Each Month Listed ( 4 or 5 )
Estimated Sales From Sales Forecast Worksheet	0	0	0	0	0	0	0	0	0	0	0	0	0
Future Sales (Used For Purchases Calculation)			0	0	0	0	0	0	0	0	0	0	0	0	0	0
Calculated Sales Tax	0	0	0	0	0	0	0	0	0	0	0	0	0
Sales Including Sales Tax	0	0	0	0	0	0	0	0	0	0	0	0	0
Collections	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
Accounts Recivable Collections Prior Period	0	0	0	0	0
Current Year Cash Sales
Cash Sales Including Tax	0	0	0	0	0	0	0	0	0	0	0	0	0
Current Year Sales On Account Collections
Collect Month Of Sale	0	0	0	0	0	0	0	0	0	0	0	0	0
Collect One Month after Sale	0		0	0	0	0	0	0	0	0	0	0	0
Collect Two months after Sale	0			0	0	0	0	0	0	0	0	0	0
Collect Three months after Sale	0				0	0	0	0	0	0	0	0	0
Total Current Accounts Receivable Collections	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Cash Collections on Sales and Accounts	0	0	0	0	0	0	0	0	0	0	0	0	0
Uncollectible Amounts	0	0	0	0	0	0	0	0	0	0	0	0	0
Number Of Periods Needing To Entered:	12
	Weeks	5	4	4	5	4	4	5	4	4	5	4	4
Other Cash Receipts (Input Required)	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
Sale Of Equipment	0	0	0	0	0	0	0	0	0	0	0	0	0
Loans	0	0	0	0	0	0	0	0	0	0	0	0	0
Owner Investments or Additional Equity Contributed	0	0	0	0	0	0	0	0	0	0	0	0	0
Other
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Other Cash Receipts	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Cash Receipts	0	0	0	0	0	0	0	0	0	0	0	0	0
Payments
Number Of Periods Needing To Entered:	12
	Weeks	5	4	4	5	4	4	5	4	4	5	4	4
Other Payments  (Input Required)	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
Note Payments (Principal & Interest)	0	0	0	0	0	0	0	0	0	0	0	0	0
Equipment Purchases	0	0	0	0	0	0	0	0	0	0	0	0	0
Owner's Draws / Dividends	0	0	0	0	0	0	0	0	0	0	0	0	0
Income and Other Business Taxes	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Miscellaneous Payments
	0
	0
	0
	0
	0
Total Other Cash Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Calculated Payments	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
Note: No User Input Required Below This Line
Sales Tax Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Amounts Owed Prior Period Payments	0	0	0	0
Total Sales Tax and Other Liability Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Accounts Payable Prior Period Payments	0	0	0	0	0
Cash Purchases Current Periods	0	0	0	0	0	0	0	0	0	0	0	0	0
Current Year Payments on  Purchases on Account
Payment in the Current Month	0	0	0	0	0	0	0	0	0	0	0	0	0
Payment One Month After Purchase	0		0	0	0	0	0	0	0	0	0	0	0
Payment Two Months After Purchase	0			0	0	0	0	0	0	0	0	0	0
Payment Three Months After Purchase	0				0	0	0	0	0	0	0	0	0
Accounts Payable Payments Current Periods	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Accounts Payable & Purchases Payments	0	0	0	0	0	0	0	0	0	0	0	0	0
Calculated Purchases and Inventory Needed :
	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12	Next Year 1	Next Year 2	Next Year 3
Beginning Inventory	0	0	0	0	0	0	0	0	0	0	0	0	0
Purchases Needed For Sales and Inventory	0	0	0	0	0	0	0	0	0	0	0	0	0
Cost Of Goods Sold	0	0	0	0	0	0	0	0	0	0	0	0	0
Ending Inventory	0	0	0	0	0	0	0	0	0	0	0	0	0
Future Cost Of Goods Sold			0	0	0	0	0	0	0	0	0	0	0	0	0	0
Cash Operating  Expense Payments	Weeks	5	4	4	5	4	4	5	4	4	5	4	4
From Cash Payments Worksheet	Totals	Month 1	Month 2	Month 3	Month 4	Month 5	Month 6	Month 7	Month 8	Month 9	Month 10	Month 11	Month 12
Note: The items in blue are automatically calculated
Salaries and Wages	0	0	0	0	0	0	0	0	0	0	0	0	0
Employee Benefits	0	0	0	0	0	0	0	0	0	0	0	0	0
Social Security & Medicare	0	0	0	0	0	0	0	0	0	0	0	0	0
Federal Unemployment	0	0	0	0	0	0	0	0	0	0	0	0	0
State Unemployment	0	0	0	0	0	0	0	0	0	0	0	0	0
Worker's Compensation	0	0	0	0	0	0	0	0	0	0	0	0	0
Rent-Property	0	0	0	0	0	0	0	0	0	0	0	0	0
Rent-Equipment	0	0	0	0	0	0	0	0	0	0	0	0	0
Utilities	0	0	0	0	0	0	0	0	0	0	0	0	0
Repairs and Maintenance	0	0	0	0	0	0	0	0	0	0	0	0	0
Insurance	0	0	0	0	0	0	0	0	0	0	0	0	0
Car & Truck Expenses	0	0	0	0	0	0	0	0	0	0	0	0	0
Travel	0	0	0	0	0	0	0	0	0	0	0	0	0
Entertainment	0	0	0	0	0	0	0	0	0	0	0	0	0
Telephone	0	0	0	0	0	0	0	0	0	0	0	0	0
Postage	0	0	0	0	0	0	0	0	0	0	0	0	0
Office Supplies	0	0	0	0	0	0	0	0	0	0	0	0	0
Advertising	0	0	0	0	0	0	0	0	0	0	0	0	0
Marketing/Promotion	0	0	0	0	0	0	0	0	0	0	0	0	0
Professional Fees	0	0	0	0	0	0	0	0	0	0	0	0	0
Training and Development	0	0	0	0	0	0	0	0	0	0	0	0	0
Bank Charges	0	0	0	0	0	0	0	0	0	0	0	0	0
Credit Card Fees	0	0	0	0	0	0	0	0	0	0	0	0	0
Miscellaneous	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
Total Cash Expense Payments	0	0	0	0	0	0	0	0	0	0	0	0	0