how would you complete the excel file of the cash budget below given the following information:

minimum 10,000 cash balance 1% interest per month loans repaid at months end from excess cash.

$ July 10,300.00 $ 34,000.00 38,000.00 August 10,000.00 $ 41,000.00 39,000.00 September 10,000.00 45,000.00 43,000.00 Beginning cash balance Cash receipts Cash disbursements Interest paid Preliminary cash balance Loan Loan repayment Ending cash balance Ending loan balance 6,300.00 12,000.00 12,000.00 6,300.00 $ $