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.
		Gray 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
Total Cash Receipts	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
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)[84]	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)[85]	0	0	0	0	0	0	0	0	0	0	0	0	0
Equipment Purchases[86]	0	0	0	0	0	0	0	0	0	0	0	0	0
Owner's Draws / Dividends[87]	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 Business Taxes[88]	0	0	0	0	0	0	0	0	0	0	0	0	0
Other Miscellaneous Payments[89]
	0
	0
	0
	0
	0
Total Other Cash Payments	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
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	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
Other Amounts Owed Prior Period Payments	5,500	5,500	0	0
Total Sales Tax and Other Liability Payments	22,770	9,000	1,048	1,157	1,301	1,102	1,392	1,102	1,464	1,247	1,084	1,518	1,355
Accounts Payable Prior Period Payments	22,800	22,800	0	0	0
Cash Purchases Current Periods	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
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	220,373		16,343	19,383	19,361	19,201	21,065	17,196	23,248	20,132	20,350	22,555	21,539
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	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
Total Accounts Payable & Purchases Payments	270,489	24,616	18,497	21,534	21,494	21,542	22,976	19,779	25,485	22,393	22,856	24,948	24,369
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	21,000	21,000	20,890	22,268	21,102	23,223	22,375	22,269	22,587	23,223	26,935	25,538	25,847
Purchases Needed For Sales and Inventory	273,156	18,159	21,537	21,512	21,334	23,405	19,107	25,831	22,369	22,611	25,061	23,932	28,298
Cost Of Goods Sold	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
Ending Inventory	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
Future Cost Of Goods Sold			0	0	0	0	0	0	0	0	0	0	0	22,309	24,540	25,097
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	41,600	4,000	3,200	3,200	4,000	3,200	3,200	4,000	3,200	3,200	4,000	3,200	3,200
Employee Benefits	8,320	800	640	640	800	640	640	800	640	640	800	640	640
Social Security & Medicare	3,184	306	245	245	306	245	245	306	245	245	306	245	245
Federal Unemployment	336	32	26	26	32	26	26	32	26	26	32	26	26
State Unemployment	1,120	108	86	86	108	86	86	108	86	86	108	86	86
Worker's Compensation	1,508	145	116	116	145	116	116	145	116	116	145	116	116
Rent-Property	26,400	2,200	2,200	2,200	2,200	2,200	2,200	2,200	2,200	2,200	2,200	2,200	2,200
Rent-Equipment	0	0	0	0	0	0	0	0	0	0	0	0	0
Utilities	9,200	900	700	700	900	700	700	900	700	700	900	700	700
Repairs and Maintenance	6,486	439	484	545	462	583	462	613	522	454	636	568	719
Insurance	7,500	625	625	625	625	625	625	625	625	625	625	625	625
Car & Truck Expenses	4,600	450	350	350	450	350	350	450	350	350	450	350	350
Travel	0	0	0	0	0	0	0	0	0	0	0	0	0
Entertainment	6,486	439	484	545	462	583	462	613	522	454	636	568	719
Telephone	5,800	550	450	450	550	450	450	550	450	450	550	450	450
Postage	1,000	100	75	75	100	75	75	100	75	75	100	75	75
Office Supplies	1,180	115	90	90	115	90	90	115	90	90	115	90	90
Advertising	12,971	878	969	1,090	923	1,165	923	1,226	1,044	908	1,271	1,135	1,438
Marketing/Promotion	0	0	0	0	0	0	0	0	0	0	0	0	0
Professional Fees	6,200	600	475	475	600	475	475	600	475	475	600	475	475
Training and Development	3,600	300	300	300	300	300	300	300	300	300	300	300	300
Bank Charges	120	10	10	10	10	10	10	10	10	10	10	10	10
Credit Card Fees	1,646	111	123	138	117	148	117	156	132	115	161	144	182
Miscellaneous	0	0	0	0	0	0	0	0	0	0	0	0	0
Refinishing Supplies	7,599	514	567	638	541	683	541	718	612	532	745	665	842
Shipping & Packing Supplies	8,664	586	647	728	617	778	617	819	698	607	849	758	960
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	0	0	0	0	0	0	0	0	0	0	0
	0	0	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	165,518	14,209	12,863	13,272	14,362	13,528	12,709	15,386	13,119	12,658	15,539	13,426	14,449

---

[1]

Enter a number between 1 and 12.

[2]

Enter Beginning Cash Balance

[3]

Enter your estimated  percentage of your sales that you receive payment at the time of the sale.

[4]

Enter your  net balance for the amounts that your customers owe you for and haven't paid. Reduce this amount for any accounts that you have estimated as non collectible. Normally you would calculate this amount by taking your Accounts Receivable Balance and subtracting your Allwance For Uncollectibles Account.

[5]

This table must be filled in if you have entered any Beginning Accounts Receivable  in the Cell I73.

[6]

Enter The Amount of the amounts due from your customers (Accounts Receivable) that are Current. In other words. amounts that are not yet due to be paid by your customers. Normally this information is obtained from your Accounts Receivable Ageing Report as of the end of your prior year.

[7]

Enter the amount you expect to collect from your current balance
in Month 1.

[8]

Enter the amount you expect to collect from your current balance
in Month 2
.

[9]

Enter the amount you expect to collect from your current balance
in Month 3.

[10]

Enter the amount you expect to collect from your current balance
in Month 4.

[11]

Enter your estimated  percentage of your sales on credit that
you collect in the same month of the sale.

[12]

Enter The Amount of the amounts due from your customers (Accounts Receivable) that are 1-30 days late. Normally this information is obtained from your Accounts Receivable
Ageing Report as of the end of your prior year.

[13]

Enter the amount you expect to collect from your current balance
in Month 1.

[14]

Enter the amount you expect to collect from your current balance
in Month 2.

[15]

Enter the amount you expect to collect from your current balance
in Month 3.

[16]

Enter the amount you expect to collect from your current balance
in Month 4.

[17]

Enter your estimated  percentage of your sales on credit that
you collect one month after the sale.

[18]

Enter The Amount of the amounts due from your customers (Accounts Receivable) that are over-30 days late. Normally this information is obtained from your Accounts Receivable
Ageing Report as of the end of your prior year.

[19]

Enter the amount you expect to collect from your current balance
in Month 1.

[20]

Enter the amount you expect to collect from your current balance
in Month 2.

[21]

Enter the amount you expect to collect from your current balance
in Month 3.

[22]

Enter the amount you expect to collect from your current balance
in Month 4.

[23]

Enter your estimated  percentage of your sales on credit that
you collect two months after the sale.

[24]

This total should be
be equal to the check
total to the left in Column I.

[25]

Enter your estimated  percentage of your sales on credit that
you collect three months after the sale.

[26]

Enter a percentage that represents the estimated uncollectible amount of your sales.

[27]

This total should be
100 %

[28]

Enter your Actual Ending Inventory from Prior Year Balance Sheet.

[29]

Enter Actual Sales from Prior Year Income Statement.

[30]

Enter Cost Of Goods Sold from Prior Year Income Statement.

[31]

Enter the beginnin  balance for the amounts that you owe your suppliers and haven't paid.

[32]

This table must be filled in if you have entered any Beginning Accounts Payable  in the Cell I93.

[33]

Enter The Amount of the amounts you owe your suppliers (Accounts Payable that are Current. In other words. amounts that are not yet due to be paid. Normally this information is obtained from your Accounts Payable Ageing Report as of the end of your prior year.

[34]

Enter the amount you expect to pay on your current balance amount
in Month 1.

[35]

Enter the amount you expect to pay on your current balance amount
in Month 2.

[36]

Enter the amount you expect to pay on your current balance amount
in Month 3.

[37]

Enter the amount you expect to pay on your current balance amount
in Month 4.

[38]

Enter The Amount of the amounts you owe your suppliers (Accounts Payable) that are 1-30 days late. Normally this information is obtained from your Accounts Payable
Ageing Report as of the end of your prior year.

[39]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 1.

[40]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 2.

[41]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 3.

[42]

Enter the amount you expect to pay on your 1-30 days late balance amount in Month 4.

[43]

Enter The Amount of the amounts you owe your suppliers (Accounts Payable) that are over-30 days late. Normally this information is obtained from your Accounts Payable
Ageing Report as of the end of your prior year.

[44]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 1.

[45]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 2.

[46]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 3.

[47]

Enter the amount you expect to pay on your over 30 days late balance amount in Month 4.

[48]

This total should be
be equal to the check
total to the left in Column I.

[49]

Enter an Estimated Cost Of Goods Sold as a percentage of Sales if
actual financial data is not available.

[50]

Enter an Estimated Inventory Turnover Rate  if actual financial data is not available.
Example: Enter a 12 if your inventory turns over 12 times a year.

[51]

Enter Beginning Inventory Balance as of the begiining month of your projrction.

[52]

Enter your estimated  percentage of your purchases that you  pay at the time of the purchase.

[53]

Enter the beginning amount of sales tax that is owed.

[54]

Enter your Sales Tax Rate as a percentage.

[55]

Enter your estimated  percentage of your purchases on credit that
you pay in the same month of the purchase.

[56]

Enter the percentage of your Sales that are exempt from Sales Tax.

[57]

Enter your estimated  percentage of your purchases on credit that
you pay one month after the purchase.

[58]

Enter your estimated  percentage of your purchases on credit that
you pay two months after the purchase.

[59]

Enter your estimated  percentage of your purchases on credit that you pay three months after the purchase.

[60]

This table must be filled in if you have entered any Beginning Accounts Payable  in the Cell I58.

[61]

Enter the beginning amount of other amounts  owed.

[62]

This total should be
be equal to the check
total to the left in Column I.

[63]

Enter Current Social Security and Mediacre Tax Rate a a percentage.

[64]

Enter Current Federal Unemployment Tax Rate as a percentage.

[65]

Enter Your Current State Unemployment Tax Rate as a percentage.

[66]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area to the right below each month to identify whether a month has 4 or 5 weeks. This is required information.

[67]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[68]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[69]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[70]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[71]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[72]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[73]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[74]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[75]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[76]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[77]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[78]

This allows you to identify periods during the year that have more than 4 weeks. Enter a 4 or 5 in the yellow area  to identify whether a month has 4 or 5 weeks. This is required information.

[79]

Enter Other Cash Receipts in the yellow highlighted area to the right -> for each month that you anticipate receiving cash from the sources listed. You may also add uo to five other cash receiots categories.

[80]

Enter Cash Received from the sale of any equipment in the  period
the cash is estimated to be received.

[81]

Enter Cash Received from additional loans needed in the  period
the cash is estimated to be received.

[82]

Enter Cash Received from additional cash contributed to the business from owners or the sale of stock  in the  period the cash is estimated to be received.

[83]

Enter Other Miscellaneous Cash Received from other sources below:

[84]

Enter Other Cash Payments in the yellow highlighted area to the right -> for each month that you anticipate paying cash to the categories (sources) listed.

[85]

Estimate and enter any additional notes or financing needed for the
period.

[86]

Enter any needed equipment purchases. Enter the equipment's total cost.

[87]

Enter estimated owners draws or distributions
 of profits or if a corporation any planned dividend payments.

[88]

Enter estimated income or business taxes applicable to your type of business.
 

[89]

Enter Other Miscellaneous Payments Below: