Use the following to answer questions 21 - 25 TIM Company's cash ledger reports the following for the month ending October 31, 20XE. 1157 Deposits Checks Date Amount No. Date Amount 3-Oct $17,500 1151 4-Oct $12,000 10-Oct 33,250 1152 6-Oct 8,500 17-Oct 39,500 1153 15-Oct 42,900 24-Oct 22,400 1154 16-Oct 9,800 Cash receipts 10/26 -10/31 29,500 1155 20-Oct 17,700 $142,150 1156 22-Oct 14,900 29-Oct 27,250 Balance on October 1 $23,800 $133,050 Receipts 142,150 Disbursements 133,050 Balance on October 31 $32,900 Information from October's bank statement and company records reveals the following additional information: a) The ending cash balance shown on the bank statement is $46,798. b) Cash receipts of $29,500 from 10/26-10/31 are outstanding, c) Checks 1156 and 1157 are outstanding. d) The deposit on 10/24 includes a customer's check for $400 that did not clear the bank (NSF check). e) Check 1154 was actually written for $9,080 for equipment purchased in October. The bank properly recorded the check for this amount. 1 An automatic withdrawal for October rent was made on October 4 for $2,400. & The company's checking account earns interest based on the average daily balance. The amount of interest cared for October is $5. h) Last year, one of the company's customers requested their A/R be converted to a Note Receivable (they owed 20to the manyl, On October 29th, the customer paid $3,350 ($3,200 note amount plus $150 interest) Balance on October 31 $32,900 Information from October's bank statement and company records reveals the following additional information: a) The ending cash balance shown on the bank statement is $46,798. b) Cash receipts of $29,500 from 10/26-10/31 are outstanding. c) Checks 1156 and 1157 are outstanding. d) The deposit on 10/24 includes a customer's check for $400 that did not clear the bank (NSF check). e) Check 1154 was actually written for $9,080 for equipment purchased in October. The bank properly recorded the check for this amount 4) An automatic withdrawal for October rent was made on October 4 for $2,400. B) The company's checking account earns interest based on the average daily balance. The amount of interest earned for October is $5 h) Last year, one of the company's customers requested their A/R be converted to a Note Receivable (they owed $3,200 to the company). On October 29th, the customer paid $3,350 ($3,200 note amount plus $150 interest) directly to the bank in payment for the amount they owed the company. 3) The bank charged the following service fees: $25 for NSF check, $1 for automatic withdrawal for rent payment, and $1 for collection of the loan amount from the customer 21. $ _Of the total checks written during the month, what amount should be deducted from the bank balance during reconciling the bank account? Page 4-3 Chapter 4 22. $ of the cash receipts, what amount should be added to the bank balance during reconciling the bank account? 23. When performing the bank reconciliation, how should the company treat check 11547 (add $720 to the company cash account, subtract $720 from company cash account, add $720 to bank statement balance, subtract $720 from bank statement balance) 245 The total amount of subtractions from the company cash account during the reconciliation (DO NOT INCLUDE THE ADDITIONS, also do not make the answer negative): 25. 5 What is the company's cash balance after the reconciliation