The Cash Projection Worksheet contains the following information:
		(a) Cash Summary Section that summarizes all the estimated cash
		receipts and payments.
		(b) Basic Financial Information Section
		(c) Sales and Payment information summarized and calculated
		from the other two sheets - SalesForecast and CashPayments.
		(d) Estimated purchases and inventory calculations for businesses
Cash Projection Worksheet		that buy and sell product.
		Instructions:
Introduction
Sales Forecast Worksheet		Enter the number of periods that you want to prepare
Cash Payments Worksheet		an estimate for from one to 12 months (1 - 12).
Weekly Forecast Worksheet
Charts Worksheet		Enter your basic financial information, collection and
		payment patterns, and beginning balances in
		the Basic Financial Information Section.
		Blue Highlighted Section
To Print the Main Worksheet select File and Print from the Menu.
		Enter the number of weeks contained in each month
		that you want to estimate collections and payments for.
		All areas that require user input are highlighted in yellow.
Number Of Periods To Forecast	12[1]
(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	6,322 [2]	6,322	(6,890)	(3,154)	(4,196)	(4,429)	(6,310)	(4,247)	(5,663)	(3,699)	(4,541)	(9,193)	(4,886)
Plus:
Cash Collections
Accounts Receivable-Collections Prior Period	35,000	30,000	5,000	0	0	0	0	0	0	0	0	0	0
Accounts Receivable-Collections Current Periods	407,459	4,733	30,913	34,225	36,870	33,303	39,085	33,629	41,510	35,459	33,431	43,328	40,973
Cash Sales	49,948	3,380	3,730	4,196	3,555	4,488	3,555	4,721	4,022	3,497	4,896	4,371	5,537
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	492,407	38,113	39,643	38,421	40,425	37,791	42,640	38,350	45,532	38,956	38,327	47,699	46,510
Less:
Cash Payments
Accounts Payable Payments-Prior Periods	22,800	22,800	0	0	0	0	0	0	0	0	0	0	0
Other Amounts Owed Prior Period	5,500	5,500	0	0
Accounts Payable Payments-Current Periods	220,373	0	16,343	19,383	19,361	19,201	21,065	17,196	23,248	20,132	20,350	22,555	21,539
Cash Purchases	27,316	1,816	2,154	2,151	2,133	2,341	1,911	2,583	2,237	2,261	2,506	2,393	2,830
Payroll Expenses	56,068	5,391	4,313	4,313	5,391	4,313	4,313	5,391	4,313	4,313	5,391	4,313	4,313
Operating  Expense Payments	109,450	8,818	8,550	8,959	8,971	9,215	8,396	9,995	8,806	8,345	10,148	9,113	10,136
Sales Tax	17,270	3,500	1,048	1,157	1,301	1,102	1,392	1,102	1,464	1,247	1,084	1,518	1,355
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	42,000	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500
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	500,777	51,325	35,908	39,463	40,657	39,672	40,577	39,767	43,568	39,798	42,979	43,392	43,673
Ending Cash	(2,048)	(6,890)	(3,154)	(4,196)	(4,429)	(6,310)	(4,247)	(5,663)	(3,699)	(4,541)	(9,193)	(4,886)	(2,048)
Increase / <Decrease> For Period	(8,370)	(13,212)	3,735	(1,042)	(232)	(1,881)	2,063	(1,417)	1,964	(842)	(4,652)	4,307	2,837
Additional Cash Needed	41,222	6,890	0	4,196	4,429	6,310	0	5,663	0	4,541	9,193	0	0
Supplied By:
Short Term Borrowing Needs	16,956	6,890	0	1,042	232	1,881	0	1,417	0	842	4,652	0	0
Short Term Repayments	14,907		3,735	0	0	0	2,063	0	1,964	0	0	4,307	2,837
Current Loan Balance	2,048	6,890	3,154	4,196	4,429	6,310	4,247	5,663	3,699	4,541	9,193	4,886	2,048
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	484,000	32,756	36,145	40,663	34,450	43,487	34,450	45,746	38,968	33,886	47,440	42,357	53,652
Cost Of Sales	269,934	18,269	20,159	22,678	19,213	24,253	19,213	25,513	21,733	18,899	26,458	23,623	29,923
Gross Profit	214,066	14,487	15,986	17,985	15,237	19,234	15,237	20,233	17,235	14,987	20,982	18,734	23,729
Payroll Expenses	56,068	5,391	4,313	4,313	5,391	4,313	4,313	5,391	4,313	4,313	5,391	4,313	4,313
Operating Expenses	109,450	8,818	8,550	8,959	8,971	9,215	8,396	9,995	8,806	8,345	10,148	9,113	10,136
Estimated Profit / (Loss)	48,548	278	3,123	4,713	875	5,706	2,528	4,847	4,116	2,329	5,443	5,308	9,280
(Prior To Income Tax, Depreciation, Interest
and Business Taxes)
Owner Draws / Dividends	42,000	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500	3,500
Key Balance Sheet Balances
Cash	0	0	0	0	0	0	0	0	0	0	0	0	0
Inventory Balance	24,222	20,890	22,268	21,102	23,223	22,375	22,269	22,587	23,223	26,935	25,538	25,847	24,222
Accounts Receivable Balance	42,080	30,691	28,350	31,893	27,020	34,108	27,020	35,880	30,563	26,577	37,208	33,221	42,080
Accounts Payable Balance	25,467	16,343	19,383	19,361	19,201	21,064	17,195	23,247	20,131	20,349	22,554	21,538	25,467
Sales Tax Payable	1,717	1,048	1,157	1,301	1,102	1,392	1,102	1,464	1,247	1,084	1,518	1,355	1,717
Short Term Borrowings	2,048	6,890	3,154	4,196	4,429	6,310	4,247	5,663	3,699	4,541	9,193	4,886	2,048
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	10.0%[3]		Beginning Accounts Receivable Net  Balance					35000[4]	Amounts Collected By Month[5]
									Month 1	Month 2	Month 3	Month 4		Check Total
Sales On Account			Estimated Current Balances					26000[6]	21000[7]	5000[8]	0[9]	0[10]		26000
% Collected Month of Sale	14.0%[11]		Estimated 1-30 Days Late					5000[12]	5000[13]	0[14]	0[15]	0[16]		5000
% Collected One Month After Sale	76.0%[17]		Estimated Over 30 Days Late					4000[18]	4000[19]	0[20]	0[21]	0[22]		4000
	0.0%
% Collected Two Months After Sale	0.0%[23]		Check Total					35000	30000	5000	0	0		35000 [24]
% Collected Three Months After Sale	0.0%[25]
% Uncollected	0.0%[26]
Total Should Equal  100%	100.0%[27]		Future Sales (Extra 3 Months)				Future 1	Future 2	Future 3
			Estimated Sales Additional 3 Months				40000	44000	45000
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	21,000 [28]		If no amounts are entered in the Estimated Sales Additional 3 Months
Actual Sales Prior Year	447,000 [29]		the months are automatically calculated for you.
Actual Cost Of Goods Sold Prior Year	249,300 [30]
			Accounts Payable Payments					Totals
Calculated Cost Of Goods % of Sales	55.77%		Beginning Accounts Payable  Balance					22800[31]	Amounts Paid By Month[32]
Calculated Inventory Turnover	11.87								Month 1	Month 2	Month 3	Month 4		Check Total
			Estimated Current Balances					22800[33]	22800[34]	0[35]	0[36]	0[37]		22,800
Calculated Number Of Months Sales in Inventory	1.01		Estimated 1-30 Days Late					0[38]	0[39]	0[40]	0[41]	0[42]		0
			Estimated Over 30 Days Late					0[43]	0[44]	0[45]	0[46]	0[47]		0
OR
Estimated Financial Data
(Use If No Actual Information Available OR			Check Total					22800	22800	0	0	0		22,800[48]
you ancipitate an Increase or Decrease in the % )
Cost Of Goods Sold % (Cost Of Goods Sold / Sales)[49]	0.00%
Inventory Turnover (Cost Of Goods Sold / Inventory)[50]	0.00
			Other Financial Information
Payments on Purchases (%)			Beginning Inventory					21000[51]
Cash Purchase
Cash Purchases in the Current Month	10.0%[52]		Sales Tax Owed					3500[53]
Purchases On Account			Sales Tax Rate (Percentage)					8.00%[54]
% of Payments in the Month Of Purchase	0.0%[55]		Percentage of Exempt Sales					60.00%[56]
% of Payment One Month After Purchase	90.0%[57]		Percentage of Taxable Sales					40.00%
% of Payment Two Months After Purchase	0.0%[58]
% of Payment Three Months After Purchase	0.0%[59]								Amounts Paid By Month[60]
								Total	Month 1	Month 2	Month 3	Month 4		Check Total
Total Payments  Should Equal 100%	100.0%		Other Amounts Owed					5500[61]	5500					5,500 [62]
Payroll Tax Rates
Social Security and Medicare % Rate	7.650%[63]
Federal Unemployment % Rate	0.800%[64]
State Unemployment  % Rate	2.700%[65]
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[66]		5[67]	4[68]	4[69]	5[70]	4[71]	4[72]	5[73]	4[74]	4[75]	5[76]	4[77]	4[78]
Enter Number Of Weeks In Each Month Listed ( 4 or 5 )
Estimated Sales From Sales Forecast Worksheet	484,000	32,756	36,145	40,663	34,450	43,487	34,450	45,746	38,968	33,886	47,440	42,357	53,652
Future Sales (Used For Purchases Calculation)			0	0	0	0	0	0	0	0	0	0	0	40000	44000	45000
Calculated Sales Tax	15,487	1,048	1,157	1,301	1,102	1,392	1,102	1,464	1,247	1,084	1,518	1,355	1,717
Sales Including Sales Tax	499,487	33,804	37,302	41,964	35,552	44,879	35,552	47,210	40,215	34,970	48,958	43,712	55,369
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	35,000	30,000	5,000	0	0
Current Year Cash Sales
Cash Sales Including Tax	49,948	3,380	3,730	4,196	3,555	4,488	3,555	4,721	4,022	3,497	4,896	4,371	5,537
Current Year Sales On Account Collections
Collect Month Of Sale	69,928	4,733	5,222	5,875	4,977	6,283	4,977	6,609	5,630	4,896	6,854	6,120	7,752
Collect One Month after Sale	337,531		25,691	28,350	31,893	27,020	34,108	27,020	35,880	30,563	26,577	37,208	33,221
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	407,459	4,733	30,913	34,225	36,870	33,303	39,085	33,629	41,510	35,459	33,431	43,328	40,973
Total Cash Collections on Sales and Accounts	492,407	38,113	39,643	38,421	40,425	37,791	42,640	38,350	45,532	38,956	38,327	47,699	46,510
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)[79]	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[80]	0	0	0	0	0	0	0	0	0	0	0	0	0
Loans[81]	0	0	0	0	0	0	0	0	0	0	0	0	0
Owner Investments or Additional Equity Contributed[82]	0	0	0	0	0	0	0	0	0	0	0	0	0
Other[83]
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	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