HCS 380 RANK Motivated Minds/hcs380rank.com HCS 380 RANK Motivated Minds/hcs380rank.com | Page 36

Chapter 7 - Excel Assignment (E7-14: Cash Budget) Exercise 7-8 The following information pertains to Joyce Company. 1. Cash balance per bank, July 31, $7,419. 2. July bank service charge not recorded by the depositor $57. 3. Cash balance per books, July 31, $7,455. 4. Deposits in transit, July 31, $2,791. 5. Note for $2,091 collected for Joyce Company in July by the bank, plus interest $55 less fee $39. The collection has not been recorded by Joyce Company, and no interest has been accrued. 6.