Financial Planning and Growth

2.CashBudWorksheet.xls

CashBudget

	CASH BUDGET WORKSHEET
	Note: Fill in each light yellow cell
		FEB	MAR	APR	MAY	JUN	JUL
1	Cash Collections on Sales
									Note to students:
									All cells can be filled with either data from the MS Word doc problem or a formula derived from the problem.
	Collections	________	________	________	________	________	________
	Month of Sale (20%)	________	________	________	________	________
			________	________	________	________
				________	________	________
	Total Cash Collections			________	________	________
2	Raw Materials Payment
	Purchases		________	________	________	________
	Payment			________	________	________
3	Cash Budget
	Cash in from collection			________	________	________
	Cash Out
	a) Raw Material Purchases			________	________	________
	b) Rent, Insurance, and Other			________	________	________
	c) Wages			________	________	________
	Total Cash Out			________	________	________
	Cash gain (loss)			________	________	________
	Beginning Balance without outside financing			________	________	________
	Cumulative cash without outside financing			________	________	________
	Required minimum cash			________	________	________
								Hint for the last two line items:
	EXCESS CASH			________	________	________		There should ONLY be three entries in total for the last two lines; as an example, if you only had one of the years
	OR							that had excess cash, then the other two entries would be blank this would mean there would be two negative entries
	(CUMULATIVE LOAN NEEDS)			________	________	________		in the last line (cumulative loan needs) for the other two years.