Mass Company has $13,500 in cash on hand on January 1 and has collected the following budget data: (Click the icon to view the budget data.) Assume Mass has cash payments for selling and administrative expenses including salaries of $48,000 plus commissions of 3% of sales, all paid in the month of sale. The company requires a minimum cash balance of $11,500. Prepare a cash budget for January and February. Will Mass need to borrow cash by the end of February? Cash Budget Two Months Ended January 31 and February 28 January Beginning cash balance Data Table Cash receipts Cash available Cash payments: Purchases of merchandise inventory Selling and administrative expenses February 690,000 $ Sales Cash receipts from customers Cash payments for merchandise inventory January 1,350,000 $ 851,880 561,400 871,200 532,163 Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess (deficiency) Financing Borrowing Print Done Principal repayments Total effects of financing Ending cash balance