Time Sensitive! Prepare Company's Cash Budget...

Did I do this correctly?

Palmetto Inc. is preparing its cash budget for November. The budgeted beginning cash balance is $23,000. Budgeted cash receipts total $102,000 and budgeted cash disbursements total $97,000. The desired ending cash balance is $75,000. The company can borrow up to $110,000 at any time from a local bank, with interest not due until the following month.

Required:

Prepare the company's cash budget for November in good form. Make sure to indicate what borrowing, if any, would be needed to attain the desired ending cash balance.

Palmetto Inc. is preparing its cash budget for November. The budgeted beginning cash balance is $23,000 Budgeted cash receipts total $102,000 and budgeted cash disbursements total $97,000. The desired ending cash balance is $75,000. The company can borrow up to $110,000 at any time from a local bank, with interest not due until the following month. Required Prepare the company's cash budget for November in good form. Make sure to indicate what borrowing, if any, would be needed to attain the desired ending cash balance Cash balance, beginning Add cash receipts Total cash available Less cash disbursement Excess (deficiency) of cash available over disbursements Borrowings Cash balance, ending $ 23,000 102,000 125,000 97,000 28,000 47,000 $ 75,000