Cash The bank charges a 2% fee on card purchases (cash purchases) 5% of credit sales are collected in the month of the purchase 85% of credit sales are collected in the month following the month of purchase 9% of credit sales will be collected in the month following

A dividend of $4,000 is paid at the end of each quarter (3/31, 6/30, 9/30 and 12/31) Equipment of $20,000 will be purchased on May 15. The company must maintain a minimum cash balance of $5,000 per our debt covenant. The company has a line of credit for short-term borrowing. The interest rate on the line of credit is 5%. Interest will be paid monthly on the line of credit. Balance sheet information Accounts receivable on November 30 was $ 105,000 Accounts receivable on December 31 was $ 110,000 Cash on December 31 was $10,000

I am tasked with making a budget for this accounting project, and my question is How do I format this for my cash sheet? THis is what I currently have, and I need to add Receipts and Disbursements to get my ending balance which must be above 5,000. Any response is appreciated.