Beginning cash balance Cash receipts S 425,000 $ 493,030 S 427,833 Cash collections from credit sales 1127,542 284,705 1,273,805 S 1,352,542 S 1,777,735 S 1,701,640 Total cash available Cash disbursements S 681,012 S 765,480 890,160 Wages, taxes, and other expenses 29,900 29,900 Equipment purchases Total cash disbursements Ending cash balance Calculations and explanations: 1. Beginning cash balance for July $425,000. This has been given in the question. 2. Cash collections from credit sales for July-credit sales of July"35% + credit sales of Jun To automatically update the excel use the formula: cument month's credit sales*35%previo 3. Total cash available cash receipts+beginning cash balance. This formula will automate 4. cash disbursement for purchase previous month's purchase. his formala will automate th . Wages, taxes and other expenses will be considered as given 6. Interest will be considered as given 7. Equipment purchase will be considered as given 8. Total cash disbursements- 9. Ending cash balance beginning cash balance cash collection from credit sales-total casl The above formulas can be used to automate the excel memo. Please find attached the imag S 1059,512 S 1.349,900 $ 1,353,510 493,030 427,835 $ 348,130 Beginning cash balance Cash receipts S 425,000 $ 493,030 S 427,833 Cash collections from credit sales 1127,542 284,705 1,273,805 S 1,352,542 S 1,777,735 S 1,701,640 Total cash available Cash disbursements S 681,012 S 765,480 890,160 Wages, taxes, and other expenses 29,900 29,900 Equipment purchases Total cash disbursements Ending cash balance Calculations and explanations: 1. Beginning cash balance for July $425,000. This has been given in the question. 2. Cash collections from credit sales for July-credit sales of July"35% + credit sales of Jun To automatically update the excel use the formula: cument month's credit sales*35%previo 3. Total cash available cash receipts+beginning cash balance. This formula will automate 4. cash disbursement for purchase previous month's purchase. his formala will automate th . Wages, taxes and other expenses will be considered as given 6. Interest will be considered as given 7. Equipment purchase will be considered as given 8. Total cash disbursements- 9. Ending cash balance beginning cash balance cash collection from credit sales-total casl The above formulas can be used to automate the excel memo. Please find attached the imag S 1059,512 S 1.349,900 $ 1,353,510 493,030 427,835 $ 348,130