budgeting assignment

copy_of_project_1_excel_template.xlsx

Project 1 Excel Template

PROJECT 1 - Excel Template
Student Name:
SALES BUDGET:
	October	November	December	Quarter
Budgeted unit sales
Selling price per unit
Total sales
SCHEDULE OF EXPECTED CASH COLLECTIONS:
	October	November	December	Quarter
August sales
September sales
October sales
November sales
December sales
Total cash collections
				cabot: check figure: $2,156,000	MERCHANDISE PURCHASES BUDGET:
	October	November	December	Quarter
Budgeted unit sales
Add desired ending inventory
Total needs
Less beginning inventory
Required purchases
Cost of purchases @ $4 per unit
BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES:
	October	November	December	Quarter
September purchases
October purchases
November purchases
December purchases
Total cash payments
LBJ COMPANY
CASH BUDGET
FOR THE 3 MONTHS ENDING DECEMBER 31
	October	November	December	Quarter
Cash balance
Add collections from customers
Total cash available
Less disbursements
Merchandise purchases
Advertising
Rent
Salaries
Commissions
Utilities
Equipment purchases
Dividends paid
Total disbursements
Excess (deficiency) of receipts
over disbursements
Financing:
Borrowings
Repayments
Interest
Total financing
Cash balance, ending
				cabot: check figure: $53,920	cabot: check figure: $900,000