Theres one for feb as well

Yes Company has $12,500 in cash on hand on January 1 and has collected the following budget data: (Click the icon to view the budget data.) Assume Yes has cash payments for selling and administrative expenses including salaries of $60,000 plus commissions of 3% of sales, all paid in the month of sale. The company requires a minimum cash balance of $11,000. Prepare a cash budget for January and February. Will Yes need to borrow cash by the end of February? January Beginning cash balance A Data Table Cash receipts Cash available Cash payments: Purchases of merchandise Inventory Selling and administrative expenses Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing: Borrowing Principal repayments Total effects f financing January 1,380,000 S February 730.000 Sales $ 851,770 Cash recelpts from customers Cash payments for merchandise Inventory 872.000 532,393 561,000 Print Done Ending cash balance