QS $20-23($Algo$)$ Cash budget LO P$2$

Santos Company is preparing a cash budget for February. The company has $$16,000$ cash at the beginning of February and budgets $$67,000$ in cash receipts from sales and $$114,000$ in cash payments during February. Prepare the cash budget for February assuming the company maintains a $$5,000$ minimum cash balance and will take a loan if necessary to maintain this balance. The company has no loans outstanding on February $1.$

Note: Negative cash balances, if any, should be indicated with minus sign.

$\backslash$table$[[$SANTOS COMPANY$],[$Cash Budget$],[,$February$],[$Beginning cash balance,$$,16,000],[$Add: Cash receipts from sales,,$67,000],[$Total cash available,,$83,000],[$Less: Cash payments,,$114,000],[$Preliminary cash balance,,$],[$Loan activity,,$],[$Additional loan,,$],[$Ending cash balance$],[$Loan balance, end of month,,$]]$