Question

March April June July August May 25,000 20,000 2 20,000 25,000 30,000 September October 45,000 35,000 November December 55,000 50,000 60,000 Net Sales Collections 70% month of sale 20% month follow 10% 2nd month Total Receipts 7 Net Purchases 30% next month sales 11 12 13 14 Payments 70% month of purchase 30% month follow 15 16 Total Disbursements for purchases

Using the method my professor taught on how to create worksheets for our start-up companies, what would the values for all the boxes be? If there's additional information required, please let me know and I'll fill it in (not too familiar with cash budgets and worksheets and am currently on a short deadline)

Answer 1

	Formula	March	April	May	June	July	August	September	October	November	December
Net Sales	Total Sales for the month	20,000	25,000	20,000	25,000	30,000	35,000	45,000	55,000	50,000	60,000
Collections
70% month of sale	70% x Current Net Sales	14,000	17,500	14,000	17,500	21,000	24,500	31,500	38,500	35,000	42,000
20% month follow	20% x Previous Month Net Sales	-	4,000	5,000	4,000	5,000	6,000	7,000	9,000	11,000	10,000
10% 2nd month	10% x Net Sales of Two Months Prior	-	-	2,000	2,500	2,000	2,500	3,000	3,500	4,500	5,500
Total Receipts		14,000	21,500	21,000	24,000	28,000	33,000	41,500	51,000	50,500	57,500
Net Purchases
30% next month sales	30% x Next Month Sales	7,500	6,000	7,500	9,000	10,500	13,500	16,500	15,000	18,000	-
Payments
70% month of purchase	70% x Current Net Purchases	5,250	4,200	5,250	6,300	7,350	9,450	11,550	10,500	12,600	-
30% month follow	30% x Previous Month Net Purchases	-	2,250	1,800	2,250	2,700	3,150	4,050	4,950	4,500	5,400
Total Disbursement for purchases		5,250	6,450	7,050	8,550	10,050	12,600	15,600	15,450	17,100	5,400