Please show each step of calculation with details

Hardin Fabrications is preparing its cash budget for the third quarter Cash balance on July 1$116,500 x of credit sales collected in the month of sale 20% x of credit sales collected in the following month 80% All expenses are paid for as they occur, with the exception of Direct Materials, which is all paid for with a revolving line of credit. Accounts Payable balance on July 1$95,000 of Accounts Payable pald in the following month 79% Amount of monthly overhead that is depreciation and amortization $15,000 1. Use the Open Excel in New Tab button to Jaunch this question A1 fx Accessibility tab summary: Information about Hardin Fabrications is provided in rows 2 to 20.5 d 8 c. D E 91. Cash budget 92 93 Beginning Balance Add: Cash Collections Less: Cash Disbursements End Balance July August September Total 95 96 End Balance