Please fill this cash budget

Cash Budget Casel Corporation is preparing its master budget for the first quarter of 2019. The following data pertain to the company's operations Expected sales for the first three months of 2019 are as follows. Expected Sales January $ 80.000 February 90.000 March 110.000 Sales for November and December, 2018, amounted to $70,000 and $80,000, respectively. b. Sixty percent of its sales for cash: the remainder are on account. Twenty four percent of credit sales are collected in the month following the sale and fourteen percent collected in the second month following the sale. Two percent is considered uncollectible. c. Payments for direct materials (DM), direct labor (DL), and manufacturing overhead (MOH) estimated to be DM DL MOH January $34 000 $35.000 $ 8.000 February 26,000 36.000 10,000 March 27.000 31,000 9,000 d. Anticipated selling and administrative expenses are expected to be $10,000 in January and will increase by 3% per month c. In January, the company will purchase an equipment for $16,000. The company's January 1 cash balance is $6,000, and the company maintain a minimum balance of $5,000 at all times. Additional financing is available and the company can borrow and repay only in $1,000 multiples at 12% annual interest rate. Interest on the repaid principal, is paid at the time of repayment REQUIRED: Prepare a cash budget using the following format: Cash Budget Jan Cash balance beginning Add cash collections Total cash available Less cash payments Direct Material purchases Direct Labor Manufacturing overhead Selling and administrative Equipment Total cash payments Ending cash balance before financing Financing Borrowing Repayments Interest Cash balance, ending