Test: The Cash Book and Petty Cash Book Section 1 - Preparation of the Cash Book. (65pts) Use an Excel Spreadsheet to prepare the Cash Book of Doc Rivers for the month of October 2012. Oct 1 - Started business with $3,000 cash and $15,000 in the bank. Oct 2 - Paid rent in cash $1,500 Oct 3 Bought cleaning supplies using cash $120 Oct 5 - Bought goods paying by cheque $11, 200 Oct 7 Cash Sales paid direct into the bank $28,000 Oct 18 - Salaries paid by cheque $2,000 Oct 18-Drawings by cheque $4,000 Oct 20 - Advertising expense paid in cash $1,600 Oct 21 - Cash sales $10, 450 Oct 21 - We paid the following accounts by cheque, in each case deducting a 5% cash discount: L. James $5,000; T. Parker $1,000; M. Ginobli $8,000; and D. Wade $3,500. Oct 23 Paid $5, 400 cash into bank account Oct 25 - K.Garnett paid his account of $4, 400 by cheque $4, 200, deducting $200 cash discount. Oct 28 - Cash withdrawn from the bank $650 for business use Oct 30 - Purchased equipment paying by cheque $20,000 You are required to: 1) Prepare the three column Cash Book and record the above transactions. 2) Balance the Cash Book at the end of the month