Cash Flow Projection.xlsx

	A	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	AR	AS	AT	AU	AV	AW	AX	AY	AZ	BA	BH	BI	BJ	BN	BO	BP	BQ	BR	BS	BT	BU	BV	BW	BX	BY	BZ	CA	CB
1	#NAME?
2		CASH FLOW PROJECTION
3
4				Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
5			Initial	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	2024	Total
6		Cash on hand (beginning of the month)	0	0	0	0	0	0	0	0	0	0	0	0	0	0
7
8		Cash receipts
9		Cash sales														0
10		Returns and allowances														0
11		Collections on accounts receivable														0
12		Interest, other income														0
13		Loan proceeds														0
14		Owner contributions														0
15		Total cash receipts		0	0	0	0	0	0	0	0	0	0	0	0	0
16		Total cash available (before cash out)		0	0	0	0	0	0	0	0	0	0	0	0	0
17
18		Cash paid out																									Purchases	#DIV/0!	#DIV/0!	0
19		Purchases (Merchandise)														0	0	Purchases	0	Purchases	0	Purchases	0	Purchases	0	Purchases	Purchases	#DIV/0!	#DIV/0!	0
20		Gross wages (exludes withdrawals)														0	0	Wages	0	Wages	0	Wages	0	Wages	0	Wages	Purchases	#DIV/0!	#DIV/0!	0		Initial	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec
21		Payroll expenses (taxes etc.)														0	0	Payroll	0	Payroll	0	Payroll	0	Payroll	0	Payroll	Purchases	#DIV/0!	#DIV/0!	0	Inflows	0	0	0	0	0	0	0	0	0	0	0	0	0
22		Outside services														0	0	Outside Serv.	0	Outside Serv.	0	Outside Serv.	0	Outside Serv.	0	Outside Serv.	Purchases	#DIV/0!	#DIV/0!	0	Outflow	0	0	0	0	0	0	0	0	0	0	0	0	0
23		Supplies (office and operating)														0	0	Supplies	0	Supplies	0	Supplies	0	Supplies	0	Supplies	Others	#DIV/0!	#DIV/0!	0	Ava.Cash	0	0	0	0	0	0	0	0	0	0	0	0	0
24		Repairs and maintenance														0	0	Repairs	0	Repairs	0	Repairs	0	Repairs	0	Repairs					.	0	0	0	0	0	0	0	0	0	0	0	0	0
25		Advertising														0	0	Advertising	0	Advertising	0	Advertising	0	Advertising	0	Advertising
26		Auto, delivery and travel														0	0	Auto,	0	Auto,	0	Auto,	0	Auto,	0	Auto,
27		Accounting and legal														0	0	Accounting	0	Accounting	0	Accounting	0	Accounting	0	Accounting
28		Rent														0	0	Rent	0	Rent	0	Rent	0	Rent	0	Rent
29		Telephone														0	0	Telephone	0	Telephone	0	Telephone	0	Telephone	0	Telephone
30		Utilities														0	0	Utilities	0	Utilities	0	Utilities	0	Utilities	0	Utilities
31		Insurance														0	0	Insurance	0	Insurance	0	Insurance	0	Insurance	0	Insurance
32		Taxes (real estate, etc.)														0	0	Taxes	0	Taxes	0	Taxes	0	Taxes	0	Taxes
33		Interest														0	0	Interest	0	Interest	0	Interest	0	Interest	0	Interest
34		Other expenses 1														0	0	Other 1	0	Other 1	0	Other 1	0	Other 1	0	Other 1
35		Other expenses 2														0	0	Other 2	0	Other 2	0	Other 2	0	Other 2	0	Other 2
36		Other expenses 3														0	0	Other 3	0	Other 3	0	Other 3	0	Other 3	0	Other 3
37		Miscellaneous (unspecified)														0	0	Misc.	0	Misc.	0	Misc.	0	Misc.	0	Misc.
38		Subtotal		0	0	0	0	0	0	0	0	0	0	0	0	0	0	Subtotal	0	Subtotal	0	Subtotal	0	Subtotal	0	Subtotal
39		Loan principle payment														0	0	Loan	0	Loan	0	Loan	0	Loan	0	Loan
40		Capital purchases														0	0	Cap.Purch.	0	Cap.Purch.	0	Cap.Purch.	0	Cap.Purch.	0	Cap.Purch.
41		Other start-up costs														0	0	Other start-up	0	Other start-up	0	Other start-up	0	Other start-up	0	Other start-up
42		Reserve and/or escrow														0	0	Reserve	0	Reserve	0	Reserve	0	Reserve	0	Reserve
43		Owner's withdrawal														0	0	Withdrawal	0	Withdrawal	0	Withdrawal	0	Withdrawal	0	Withdrawal
44		Total cash paid out		0	0	0	0	0	0	0	0	0	0	0	0	0
45		Cash on hand (at the end of the month)		0	0	0	0	0	0	0	0	0	0	0	0	0
46
47		Essential Operating Data
48		Sales volume (dollars)														0
49		Accounts receivable (end of the month)														0
50		Bad debt (end of the month)														0
51		Inventory on hand (end of the month)														0
52		Accounts payable (end of the month)														0
53		Depreciation														0
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100