urgent pleasr

To BUDGET De Od SALE WS DOCERE NO The The 1.000 10 MacBook Pro 4 7 w E A 1 D F G H Z Z C V B N M 30 Command The following information is also known: The actual cash balance on September 30 was 560,000 Cash collected from customers during the month of October is 5575,000 Time left 1:04:51 The September 30 accounts payable balance is $105,000. Purchases are paid 70% in the month incurred, and 30% in the following month Rent payments are paid quarterly in advance. The most recent rent payment was made on July 1. Lease payments are also paid quarterly in advance. The most recent lease payment was September 1. All other cash expenses are paid in the month incurred. Bank financing Information: All loans taken are taken at the beginning of a month and all loans repaid are repaid at the end of a month. The bank charges interest on all repayments at a rate of 9% per year. The bank will only give loans and accept repayments of loans in $1,000 increments. As at September 30, Simco has a loan outstanding of $100,000 taken on September 1. Simco must repay as much of the loan as possible whenever there is excess cash available. As part of Simco's loan agreement the bank insists that Simco keep a minimum cash balance of $20,000 at the end of each month Questione . Prepare Simco's cash budget for October in good form. (15 marks) 7 A BIO Item Amount To BUDGET De Od SALE WS DOCERE NO The The 1.000 10 MacBook Pro 4 7 w E A 1 D F G H Z Z C V B N M 30 Command The following information is also known: The actual cash balance on September 30 was 560,000 Cash collected from customers during the month of October is 5575,000 Time left 1:04:51 The September 30 accounts payable balance is $105,000. Purchases are paid 70% in the month incurred, and 30% in the following month Rent payments are paid quarterly in advance. The most recent rent payment was made on July 1. Lease payments are also paid quarterly in advance. The most recent lease payment was September 1. All other cash expenses are paid in the month incurred. Bank financing Information: All loans taken are taken at the beginning of a month and all loans repaid are repaid at the end of a month. The bank charges interest on all repayments at a rate of 9% per year. The bank will only give loans and accept repayments of loans in $1,000 increments. As at September 30, Simco has a loan outstanding of $100,000 taken on September 1. Simco must repay as much of the loan as possible whenever there is excess cash available. As part of Simco's loan agreement the bank insists that Simco keep a minimum cash balance of $20,000 at the end of each month Questione . Prepare Simco's cash budget for October in good form. (15 marks) 7 A BIO Item Amount