I need formulas for below? how do i do that

PROJECT 1 - Excel Template
SALES BUDGET:
			October	November	December	Quarter
Budgeted unit sales			70,000	110,000	60,000	240,000
Selling price per unit			10	10	10	10
Total sales			700,000	1,100,000	600,000	2,400,000
SCHEDULE OF EXPECTED CASH COLLECTIONS:
			October	November	December	Quarter
August sales
September sales
October sales			140,000	220,000	120,000	480,000
November sales			280,000	490,000	770,000	1,540,000
December sales			26,000	40,000	70,000	136,000
Total cash collections			446,000	750,000	960,000	2,156,000
MERCHANDISE PURCHASES BUDGET:
			October	November	December	Quarter
Budgeted unit sales			44,000	24,000	12,000	80,000
Add desired ending inventory			70,000	110,000	60,000	240,000
Total needs			114,000	134,000	72,000	320,000
Less beginning inventory			28,000	44,000	24,000	96,000
Required purchases			86,000	90,000	48,000	224,000
Cost of purchases @ $4 per unit			344,000	360,000	192,000	896,000
BUDGETED CASH DISBURSEMENTS FOR MERCHANDISE PURCHASES:
			October	November	December	Quarter
September purchases
October purchases
November purchases			172,000	180,000	96,000	448,000
December purchases			100,000	172,000	180,000	452,000
Total cash payments			272,000	352,000	276,000	900,000
LBJ COMPANY
CASH BUDGET
FOR THE 3 MONTHS ENDING DECEMBER 31
			October	November	December	Quarter
Cash balance			74,000	50,000		124,000
Add collections from customers			446,000	750,000	960,000	2,156,000
Total cash available			520,000	800,000	960,000	2,280,000
Less disbursements
Merchandise purchases			272,000	352,000	276,000	900,000
Advertising			220,000	220,000	220,000	660,000
Rent			20,000	20,000	20,000	60,000
Salaries			110,000	110,000	110,000	330,000
Commissions			28,000	44,000	24,000	96,000
Utilities			10,000	10,000	10,000	30,000
Equipment purchases			22,000	50,000		72,000
Dividends paid			20,000			20,000
Total disbursements			702,000	806,000	660,000	1,508,000
Excess (deficiency) of receipts
over disbursements
Financing:
Borrowings
Repayments
Interest					293,200	293,200
Total financing			702,000	806,000	953,200	2,461,200
Cash balance, ending			50,000	50,000	56,800	156,800