Madison Company's cash ledger reports the following for the month ending March 31. oate Deposits: Date 3/4 $1,200 3/11 1,160 3/18 3,76 3/25 3,360 3/26 3/31 2.600 $ 11,900 NO. Cucks! 541 542 543 544 545 Arout $ 5,200 Bog 2,86 1. 360 3/2 3/8 3/12 3/19 3/27 3/28 3/30 Cash receipts: 546 58 $ S. 1,200 $13.100 Balance on March 1 Heceipts Disbursements Balance on March 31 21.000 (13.160) $ 4.500 Information from March's bank statement and company records reveals the following additional Information a. The ending cash balance recorded in the bank statement is 55.962 b. Cash receipts of $2600 from 326-3:31 are outstanding. c. Checks 545 and 547 are outstanding d. The deposit on 3/11 Included a customer's check for $470 that old not clear the bank (NSF checki e Check 543 was written for 53.400 for office supplies in March. The bank properly recorded the check for this amount tan automatic withdrawal for March rent was made on March 4 for $1.500. 9. Madison's checking account eams interest based on the average caly balance. The amount of Interest earned for Maren is 550 h. Last year, one of Madison's top executives borrowed 54.350 from Madison. On March 24. the executive paid $4.560 (34.350 borrowed amount plus $210 Interest directy to the bank in payment for the borrowing. The bank charged the following service fees: 530 for NS check $19 for automatic withdrawal for rent payment and 521 for collection of the loan amount from the executive 1. Prepare a bank reconcitation for March 31 (Amounts to be deducted should be indicated with a minus sign) MADISON COMPANY Bank Rosentation Maroh 31 Banks Can Salamos Company's Cach Balance