Metlock Corp.'s accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. - Beginning cash balance on October 1 is $22,300; minimum required balance is $20,000. - Budgeted MOH cost includes $12,000 of depreciation each month. - Budgeted SG\&A cost includes $14,100 of depreciation each month. - A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. - If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2. Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all). (a) Prepare Metlock's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. (a) Prepare Metlock's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. : : v: Additional Funds Available/(Needed) Beginning Balance Budgeted DM Purchases Budgeted DL and MOH Cost Budgeted SG\&A Cost Cash Available Cash Disbursements for Cash Receipts Cash Surplus/(Deficiency) Ending Cash Balance Interest Loan Balance Beginning of Month Loan Balance end of Month Loan Draws/(Payments) Minimum Balance Requirement Total Cash Disbursements Metlock Corp.'s accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. - Beginning cash balance on October 1 is $22,300; minimum required balance is $20,000. - Budgeted MOH cost includes $12,000 of depreciation each month. - Budgeted SG\&A cost includes $14,100 of depreciation each month. - A line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. - If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2. Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all). (a) Prepare Metlock's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. (a) Prepare Metlock's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. : : v: Additional Funds Available/(Needed) Beginning Balance Budgeted DM Purchases Budgeted DL and MOH Cost Budgeted SG\&A Cost Cash Available Cash Disbursements for Cash Receipts Cash Surplus/(Deficiency) Ending Cash Balance Interest Loan Balance Beginning of Month Loan Balance end of Month Loan Draws/(Payments) Minimum Balance Requirement Total Cash Disbursements