Prepare a spreadsheet for cash budget by month,

Lake Corporation wishes to prepare a cash budget for November and December 2018. Sales, purchases, and expenses for October (actual) and November and December (estimated) are as follows:

	Sales	Purchases	Expenses
October	$48,000	$35,000	$14,000
November	40,000	30,000	11,000
December	45,000	22,000	9,500

Sales: All sales are on credit, and the company's experience shows that, on an average, 80 percent of sales are collected in the month of sale and the balance in the following month.

Purchases: The company pays 60 percent of purchases in the month of purchase and the balance in the following month. The company is allowed an average discount of 1 percent on payments made in the month of purchase.

Expenses:The monthly expenses for November and December include adjusting entries for depreciation expense of $1,000 and prepaid expenses of $100. All other Expenses are paid in the month incurred.

Other:On September 1, 2018, a new machine will be purchased for $5,000. A down payment of $500 will be made in September and it was agreed that the balance would be paid in equal installments in the following three months.