Hello! My professor gave us 10 questions to practice on prior to our final exam. He told us if we can figure out these 10 questions it would greatly improve our ability to do well on the exam. I have now figured out 9 of them but this one question I am struggling with. I am wondering if you could help me with it.

Here is the problem:

Selling and administrative expenses are expected to total $120,000 each month. One half of these expenses will be paid in the month in which they are incurred and the balance

will be paid in the following month. There is no depreciation. Accounts payable at September 30 totaled $290,000.

Cash at September 30 totaled $80,000. A payment of $300,000 for purchase of equipment is scheduled for November, and a dividend of $200,000 is to be paid in December.

Here are my questions:

I am trying to figure out how to design a schedule of expected cash collections for each of the months of October, November, and December.

Also, I am struggling with trying to make a schedule showing expected cash disbursements for merchandise purchases and selling and administrative expenses for each of the months October, November, and December.

Finally, I am struggling with creating a cash budget for each of the months October, November, and December. There is no minimum required ending cash balance.

Thank you for helping me with this kerfunkle.