Prepare a spreadsheet for cash budget by month as demonstrated in class and during the Saturday Collaborate review recording. Have the completed worksheet avalloable as you complete the exam to answer a few of the multiple choice questions on the exam 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: 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 hovember 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