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

Santos Company is preparing a cash budget for February. The company has $$17,000$ cash at the beginning of February and budgets $$70,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.($Negative cash balances, if any, should be indicated with minus sign.$)$

$\backslash$table$[[$SANTOS COMPANY$],[$Cash Budget$],[$Beginning cash balance,$],[,],[$Total cash available,$],[,],[$Preliminary cash balance,$],[$Loan activity,$],[,],[$Ending cash balance,$],[$Loan balance, end of month,$]]$